Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

no autobackup of control file for rman

joecbcOct 5 2012 — edited Oct 5 2012
This is what I used for a backup of database. I do not have controlfile autobackup set, I back it up using rman commands. Backup is made to a third party media manager.

I tried to restore and it cannot startup mount the database, it can only nomount the database. I am assumming this is because it cannot find the control file.

Is it possible to recover the controlfile if autobackup not on ? I did make a backup current controlfile with the rman script below .. Is it possible to get back the database at all ..

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 1286066176 bytes
Fixed Size 2221160 bytes
Variable Size 805309336 bytes
Database Buffers 469762048 bytes
Redo Buffers 8773632 bytes
ORA-00205: error in identifying control file, check alert log for more info

This is the backup script.

rman target xxx/xxx nocatalog << eof
run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(tdpo_optfile=xxxxxxxxxxxx)';
backup as compressed backupset database plus archivelog delete input;
release channel t1;
}
quit
eof
rman target xxxx/xxxx nocatalog << eof
run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(tdpo_optfile=xxxxxxxxxxxxx)';
backup current controlfile;
release channel t1;
}
quit
eof


CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2012
Added on Oct 5 2012
9 comments
2,893 views