Unsolved
This post is more than 5 years old
2 Intern
•
360 Posts
0
980
May 26th, 2008 07:00
Is it possible recovering controlfile from networker?
Dear All,
I tried to use RMAN to restore the controlfile and get following error:
1. Can not Restore Controlfile
RMAN> restore controlfile;
Starting restore at 23-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/23/2008 23:03:13
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
It inidcated that I must restore it from the "AutoBackup".
Is it possible recovering the controlfile from savesets?
I tried to use RMAN to restore the controlfile and get following error:
1. Can not Restore Controlfile
RMAN> restore controlfile;
Starting restore at 23-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/23/2008 23:03:13
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
It inidcated that I must restore it from the "AutoBackup".
Is it possible recovering the controlfile from savesets?
0 events found
No Events found!
dpinink_silva
2 Intern
•
724 Posts
0
May 26th, 2008 10:00
This is an error from RMAN, not related to Networker itself, you may have to work a bit on your rman restore script. I don't know if you have tried to search about this RMAN error, but this is what I found:
==============================
Oracle Error :: RMAN-06563
control file or SPFILE must be restored using FROM AUTOBACKUP
Cause
RESTORE CONTROLFILE or RESTORE SPFILE was specified without the FROM AUTOBACKUP option when RMAN is not connected to the recovery catalog.
Action
If the recovery catalog is available, connect to the recovery catalog and retry the restore. If the recovery catalog in not available, following is the procedure to restore control file or SPFILE:
1. Specify the DBID of the database with the SET DBID command.
2. If the autobackup was created with non-default autobackup format, then specify the autobackup format using the SET CONTROLFILE AUTOBACKUP FORMAT command.
3. If the backup was created with SBT device, then allocate an SBT channel using the ALLOCATE CHANNEL command.
4. Restore control file or SPFILE by starting the RESTORE ... FROM AUTOBACKUP command.
==============================
See if this helps.
sarpydog
2 Intern
•
360 Posts
0
May 28th, 2008 05:00
Thanks for your help.
Dennis Dai