RMAN nocatalog

[davey23uk]

Hi

The trick is to know the dbid and restore the controlfile from your tape backups

It's not a trick - its a fully documented, fully supported method of recovery

[hrishy]

It's not a trick - its a fully documented, fully supported method of recovery

ahh the english language :-)

regards
Hrishy

[BV1963]

Hi

The trick is to know the dbid and restore the controlfile from your tape backups

rman target /
set dbid 
startup nomount;
run
{
allocate channel ch1sbt_tape type sbt;
set controlfile autobackup format for device type sbt to
'path_to_controlfile/%F'; 
restore controlfile from autobackup;
release channel ch1_tape;
}

You need to store the dbid somewhere otherwise i am afraid you are lost.

regards
Hrishy

Just curios,assuming that sbt channel is just a tape deivce and not a tape management system, how would rman know which file to request base on just a dbid? It got to be stored somewhere, but where?

[BV1963]

I think I may know an answer for my own question. RMAN probably generate an unique backup control file name based on dbid and therefore if it knows dbid it can generate this name and request backup file from the tape.

[ebrian]

Regardless if AUTOBACKUP is set to ON or not, if you are doing a full database backup, the controlfile is going to be backed up.

Now assuming you are in nocatalog mode and simply loose the backed up controlfile, you can still recover from a backup with the help of the DBMS_BACKUP_RESTORE package.

[aaryaan]

Right. There was one unpublised document available in metalink. Get hold of support they can help you out on this.

Regards,
Satheesh Babu S
http://satheeshbabus.blogspot.com

[hrishy]

Hi

We usually put the rman logfile along with the backup to the tape.
In the logfile look for something like

copying current controlfile
output filename=/backup/SID_xxx_.back

You can just copy the controlfile to the location in the place as indicated by init.ora and try to bring up the database to mountstate.

If you are on 10g you can also

set DBID=<>
run 
{
allocate channel cht_t1 device type sbt tape;
restore controlfile
from 
'/backup/SID_xxx_.back'
}

regards
Hrishy

[reeshe]

Regardless if AUTOBACKUP is set to ON or not, if you are doing a full database backup, the controlfile is going to be backed up.

Now assuming you are in nocatalog mode and simply loose the backed up controlfile, you can still recover from a backup with the help of the DBMS_BACKUP_RESTORE package.

Hi Ebrian,

I think your note is the most REMARKABLE here
So, am I justified if I continue my backup system with nocatalog mode?
Would it make be still a good DBA?


Thanks a lot

[BV1963]

It is actually up to you, I see no reason not to use a catalog even alternative ways to restore your database do exist.
Let me ask you a question, why not to use it? What are you trying to save?

[aaryaan]

Hi,
If number of DB to be backed up is more in your shop, then it make sense to use Catalog DB. Otherwise use nocatalog.

Regards,
Satheesh Babu S
http://satheeshbabus.blogspot.com