commvault.com commvault.com
Solved

restore out of place oracle RCA in redirect

  • 30 March 2022
  • 4 replies
  • 497 views
Mohamed Ramadan
Badge +4

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;
 ]
 

icon

Best answer by Mahender Reddy 31 March 2022, 17:49

View original
1 Attachment
BR ,,,
If you have a question or comment, please create a topic

4 replies

Edd Rimmer
Rank
Userlevel 4
Badge +7

Hey Mohamed,

To be able to give you the best answers here we’d need more info please…

  • By RCA do you actually mean RAC?
  • What procedure in our documentation are you following?
  • Did you choose to restore the control file?
Of all the things I've lost, I miss my mind the most
Mohamed Ramadan
Badge +4

hello @Edd Rimmer 

thank you for your reply , i hope you have a great day 

yes sorry i mean RAC ,i was follow Advanced Restore - Oracle RAC iDataAgent online book  , also i choose to restore the control file and sp file and another try without sp file  ,the restoration her out of place with redirect file 

BR ,,,
G
Rank
Userlevel 4
Badge +13

Hi @Mohamed Ramadan ,

 

The restore failed as it could not find archive logs sequence 30747 thread 1 

 

channel 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=30748

 

At this point you may try to recover the database manually by connect to the destination database

 

Recover database using backup controlfile until cancel 

 

alter database open resetlogs

 

The cause for this issue could be due to the point in time provide may be beyond the controlfile backup time

In case if you want to redo the restore

Clear the destination database, remove all the datafile, controlfile & logs 

Make 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

 

M
Rank
Userlevel 3
Badge +5

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

Terms & ConditionsCookie settings