今天搞了一个有意思的事情,就是把升级到12的数据库退回到11。
升级之前做了restorepoint.
升级之后的恢复:
注意我们的升级是out of place的就是有两个oracle home
一个是11的一个是12的。
如果 现在设置成11的。因为已经升级上去了。
所以rman是进不去的。
那我设置成12的oracle home开始闪回。
RMAN> STARTUP MOUNT
Oracle instance started
database mounted
Total System Global Area 224412041216 bytes
Fixed Size 7659016 bytes
Variable Size 40218628600 bytes
Database Buffers 184146722816 bytes
Redo Buffers 39030784 bytes
RMAN> FLASHBACK DATABASE TO RESTORE POINT "BEFORE_DBUPG";
Starting flashback at 01-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10857 instance=pajuf1 device type=DISK
starting media recovery
media recovery complete, elapsed time: 00:01:45
Finished flashback at 01-MAR-17
RMAN> ALTER DATABASE OPEN RESETLOGS; 发现打不开发了??
RMAN> alter database open resetlogs;
RMAN-00571: ===================================
升级之前做了restorepoint.
升级之后的恢复:
注意我们的升级是out of place的就是有两个oracle home
一个是11的一个是12的。
如果 现在设置成11的。因为已经升级上去了。
所以rman是进不去的。
那我设置成12的oracle home开始闪回。
RMAN> STARTUP MOUNT
Oracle instance started
database mounted
Total System Global Area 224412041216 bytes
Fixed Size 7659016 bytes
Variable Size 40218628600 bytes
Database Buffers 184146722816 bytes
Redo Buffers 39030784 bytes
RMAN> FLASHBACK DATABASE TO RESTORE POINT "BEFORE_DBUPG";
Starting flashback at 01-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10857 instance=pajuf1 device type=DISK
starting media recovery
media recovery complete, elapsed time: 00:01:45
Finished flashback at 01-MAR-17
RMAN> ALTER DATABASE OPEN RESETLOGS; 发现打不开发了??
RMAN> alter database open resetlogs;
RMAN-00571: ===================================