restore archivelog

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

restore archivelog

Roshan
Hi Erman,

I am restoring archivelog from tape. The archivelog backup with sequence 9221 is on tape. However, upon restore, RMAN cannot find it.
Should I catalog the backup from tape? if yes, please advise



recovery is giving the output
Starting restore at 10-JUN-17

released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
released channel: CH5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/10/2017 11:27:25
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 9221 and starting SCN of 170546394203 found to restore

RMAN> **end-of-file**


However, backup of archivelop is found on tape.
RMAN> list backup of archivelog sequence 9221;


List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2028 40.13G SBT_TAPE 01:04:44 10-JUN-17
BP Key: 2028 Status: AVAILABLE Compressed: NO Tag: TAG20170610T044712
Handle: 0ss6drqk_1_1 Media: Nice_Vol_Prod

List of Archived Logs in backup set 2028
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 9221 170546394203 09-JUN-17 170546785825 09-JUN-17




 
 
Reply | Threaded
Open this post in threaded view
|

Re: restore archivelog

ErmanArslansOracleBlog
Administrator
You may need to catalog that yes..
But there are different cases.

Check this document, it will help you ->

Resolving RMAN-06023 or RMAN-06025 (Doc ID 2038119.1)