It's not a trick - its a fully documented, fully supported method of recoveryQuote:
Originally Posted by hrishy
Printable View
It's not a trick - its a fully documented, fully supported method of recoveryQuote:
Originally Posted by hrishy
ahh the english language :-)Quote:
Originally Posted by davey23uk
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?Quote:
Originally Posted by hrishy
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.
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.
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
Hi
We usually put the rman logfile along with the backup to the tape.
In the logfile look for something like
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.Code:copying current controlfile
output filename=/backup/SID_xxx_.back
If you are on 10g you can also
Code:set DBID=<
>
run
{
allocate channel cht_t1 device type sbt tape;
restore controlfile
from
'/backup/SID_xxx_.back'
}
regards
Hrishy
Hi Ebrian,Quote:
Originally Posted by ebrian
I think your note is the most REMARKABLE here :cool:
So, am I justified if I continue my backup system with nocatalog mode?
Would it make be still a good DBA?:o
Thanks a lot
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?
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