restore out of place oracle RCA in redirect

Question

if face issue when i try Out-of-place restore and send RMAN log , this will be great if someone can help !!

Rman Log:[
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Mar 30 15:23:05 2022
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: IXCPRD (DBID=2549889068, not open)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20>
allocated channel: ch1
channel ch1: SID=3202 device type=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ch2
channel ch2: SID=3299 device type=SBT_TAPE
channel ch2: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ch3
channel ch3: SID=3396 device type=SBT_TAPE
channel ch3: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ch4
channel ch4: SID=3493 device type=SBT_TAPE
channel ch4: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ch5
channel ch5: SID=3590 device type=SBT_TAPE
channel ch5: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
sent command to channel: ch5
Starting recover at Mar 30 2022 15:23:11
starting media recovery
archived log for thread 2 with sequence 30649 is already on disk as file /cbio6/oradata/IXCPRD/IXCPRD/archivelog/2_30649_954345004.dbf
archived log for thread 3 with sequence 30587 is already on disk as file /cbio6/oradata/IXCPRD/IXCPRD/archivelog/3_30587_954345004.dbf
unable to find archived log
archived log thread=1 sequence=30748
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 recover command at 03/30/2022 15:23:14
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 30748 and starting SCN of 13626799752295
RMAN>
Recovery Manager complete.
]
Executing SQL script [ ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/cbio6/oradata/IXCPRD/';
ALTER SYSTEM SET log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';
exit;
]

Best answer by Mahender Reddy

Hi @Mohamed Ramadan

The control is missing backup information of the log sequence 30748.

The point in time you selected for recovery, is it from the same backup from where the control file was restored?

Also, did you select backup end time or backup completion time in recovery section?

What is your restore requirement?

Is it to restore to a particular point in time or until end of any particular backup?

If it is until end of any particular backup, try the below steps:-

Restore control file from the control file auto backup pieces generated in the backup(you can see this info in the job details)
Select the Smallest SCN as the recovery point(you can also find this in the job details)

Please let us know in case of any questions.

--
Mahender

View original

Mahender Reddy · Accepted Answer

Hi @Mohamed RamadanThe control is missing backup information of the log sequence 30748.The point in time you selected for recovery, is it from the same backup from where the control file was restored?Also, did you select backup end time or backup completion time in recovery section?What is your restore requirement?Is it to restore to a particular point in time or until end of any particular backup?If it is until end of any particular backup, try the below steps:-Restore control file from the control file auto backup pieces generated in the backup(you can see this info in the job details)Select the Smallest SCN as the recovery point(you can also find this in the job details)Please let us know in case of any questions.--Mahender

Gowri Shankar · Answer

Hi @Mohamed Ramadan,The restore failed as it could not find archive logs sequence 30747 thread 1channel ch4: restore complete, elapsed time: 00:00:03archived log file name=/cbio6/oradata/IXCPRD/IXCPRD/archivelog/1_30747_954345004.dbf thread=1 sequence=30747channel default: deleting archived log(s)archived log file name=/cbio6/oradata/IXCPRD/IXCPRD/archivelog/1_30747_954345004.dbf RECID=90749 STAMP=1100701223unable to find archived logarchived log thread=1 sequence=30748At this point you may try to recover the database manually by connect to the destination databaseRecover database using backup controlfile until cancelalter database open resetlogsThe cause for this issue could be due to the point in time provide may be beyondthe controlfile backup timeIn case if you want to redo the restoreClear the destination database, remove all the datafile, controlfile & logsMake a note of the SCN number lowest SCN from the job details of the backup(This is a RAC and the job details will show 3 SCN with a prefix of the thread number )Rerun the restore and provide the lowest SCN noted from the backup job detail

restore out of place oracle RCA in redirect

4 replies

Most helpful members this week

Cookie policy

Cookie settings

Related topics

Oracle Out-of-place restore from Command Center with Temp tablespace redirecticon

Restore Oracle DB Out of Place - Temp Table Spaceicon

Oracle restore out of place failedicon

Restoring an oracle RAC DB to another RAC failingicon

How to restore Oracle DB when block change tracking enabled using commvaulticon

Most helpful members this week

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings