Tuesday, September 25, 2018

Until sequence command

RMAN> RUN {

set until sequence 67988 thread 1;

recover database;

}

2> 3> 4>

executing command: SET until clause

 

Starting recover at 15-MAY-18

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=376 device type=DISK

 

starting media recovery

 

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=67985

channel ORA_DISK_1: reading from backup piece /TJPSB004_BACKUP/TJTG1213/DB/TJTG_Arch_L og976084309_43448_1

channel ORA_DISK_1: errors found reading piece handle=/TJPSB004_BACKUP/TJTG1213/DB/TJTG_Arch_Log976084309_43448_1

channel ORA_DISK_1: failover to piece handle=/GSTDB/rmanbkp/TJTG_Arch_Log976084309_43448_1 tag=TAG20180514T063148

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:35

archived log file name=/ORADB/oradata/UAT/archive/1_67985_868558149.dbf thread=1 sequence=67985

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=67986

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=67987

channel ORA_DISK_1: reading from backup piece /TJPSB004_BACKUP/TJTG1213/DB/TJTG_Arch_Log976084309_43449_1

channel ORA_DISK_1: errors found reading piece handle=/TJPSB004_BACKUP/TJTG1213/DB/TJTG_Arch_Log976084309_43449_1

channel ORA_DISK_1: failover to piece handle=/GSTDB/rmanbkp/TJTG_Arch_Log976084309_43449_1 tag=TAG20180514T063148

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

archived log file name=/ORADB/oradata/UAT/archive/1_67986_868558149.dbf thread=1 sequence=67986

archived log file name=/ORADB/oradata/UAT/archive/1_67987_868558149.dbf thread=1 sequence=67987

media recovery complete, elapsed time: 00:00:06

Finished recover at 15-MAY-18

 

 

No comments:

Post a Comment

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files. I got the issue below wh...