channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete,elapsed time: 00:05:45
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
Finished recover at 13-MAY-15? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
RMAN>?
?
后台alert日志输出为:
Using STANDBY_ARCHIVE_DEST parameterdefault value as /data/oracle/oradgdata/standby_archive
Wed May 13 20:54:42 2015
Incremental restore complete of datafile 4/home/oradata/powerdes/users01.dbf
checkpoint is 11134253054
last deallocation scn is 10905979642
Wed May 13 20:54:53 2015
Incremental restore complete of datafile 8/home/oradata/powerdes/help01.dbf
checkpoint is 11134253054
last deallocation scn is 9881798870
Wed May 13 20:55:08 2015
Incremental restore complete of datafile 9/home/oradata/powerdes/adobelc01.dbf
checkpoint is 11134253054
Wed May 13 20:55:21 2015
Incremental restore complete of datafile 10/home/oradata/powerdes/sms01.dbf
checkpoint is 11134253054
Wed May 13 20:55:34 2015
Incremental restore complete of datafile 11/home/oradata/powerdes/plcrm01.dbf
checkpoint is 11134253054
Incremental restore complete of datafile 7/home/oradata/powerdes/pl01.dbf
checkpoint is 11134253054
last deallocation scn is 10905470965
Wed May 13 20:56:24 2015
db_recovery_file_dest_size of 15360 MB is0.00% used. This is a
user-specified limit on the amount of spacethat will be used by this
database for recovery-related files, anddoes not reflect the amount of
space available in the underlyingfilesystem or ASM diskgroup.
Wed May 13 20:56:26 2015
Incremental restore complete of datafile 2/home/oradata/powerdes/sysaux01.dbf
checkpoint is 11134253054
last deallocation scn is 10906515871
Wed May 13 20:56:43 2015
Incremental restore complete of datafile 1/home/oradata/powerdes/system01.dbf
checkpoint is 11134253054
last deallocation scn is 10825889348
Incremental restore complete of datafile 6/home/oradata/powerdes/plas01.dbf
checkpoint is 11134253054
last deallocation scn is 10905977986
Incremental restore complete of datafile 3/home/oradata/powerdes/undotbs01.dbf
checkpoint is 11134253054
last deallocation scn is 10908635608
Wed May 13 20:59:58 2015
Incremental restore complete of datafile 5/home/oradata/powerdes/powerdesk01.dbf
checkpoint is 11134253054
last deallocation scn is 10906663694
12,备库上重新启动应用日志
?ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION;
? ? ? ? SQL>ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION;? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
Databasealtered.
? ? ? ? SQL>?
? 后台alert日志输出为:
?ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION
Attemptto start background Managed Standby Recovery process (powerdes)
WedMay 13 21:04:41 2015
MRP0started with pid=19, OS id=23729
MRP0:Background Managed Standby Recovery process started (powerdes)
started logmerger process
WedMay 13 21:04:46 2015
ManagedStandby Recovery not using Real Time Apply
ParallelMedia Recovery started with 16 slaves
Waitingfor all non-current ORLs to be archived...
Allnon-current ORLs have been archived.
MediaRecovery Waiting for thread 1 sequence 32510
Completed:ALTER DATABASE recover managed standby DATABASE disconnect