Re: RMAN without a repository and a total site loss

In my system recovery internal docs I have this page bookmarked:

http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov004.htm#sthref734

But yes you'll definitely want controlfile autobackup on.

Don.

On 4/17/07, GovindanK <gkatteri@xxxxxxxxxxx> wrote:




Ryan

Lot of ideas have been given about this thread. Autobackup is one good
concept. It is preferred you put the dbid as part of the media handle or
wherever you can plug that in.

If you have the logfile, you can restore the control file as

rman nocatalog , connect target, set dbid , restore controlfile from
'cf_respective_handle';

This will give you a good starting point. Then  etc and restore the db.

Optionally you can backup/restore your spfile too

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta46.htm#93304

If you do not have backup of the init.ora /spfile you would need to create
one.

HTH

GovindanK

On Tue, 17 Apr 2007 20:42:39 +0000, ryan_gaffuri@xxxxxxxxxxx said:

I am using RMAN without the repository. I want to plan in case we have a
total site loss and all I have left are my tape backups which are all
compressed backupsets.

So my control files with my catalog are gone. What do you recommend as the
best way to recover if this happens? Should I backup my control files
seperately on top of the backupset? Should I do backup controlfile to trace?



--
Don Seiler
oracle: http://seilerwerks.blogspot.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Other related posts: