RE: RMAN without a repository

Sorry... I misread the question...  

Use the "copy controlfile" and mount that. Once mounted, your instance will "know" where to look for the backupsets. (RMAN> restore database; RMAN> recover database;).  

From: Pal, Raj
Sent: Tuesday, April 10, 2007 2:11 PM
To: 'ryan_gaffuri_at_comcast.net'; oracle-l_at_freelists.org Subject: RE: RMAN without a repository  

Ryan,  

"Redundancy = 4" should ensure that your controlfile retains metadata knowledge of 4 backups of the specified type. If you want to ensure that you don't lose this info though, I would strongly recommend that you use a catalog database (just in case you lose your controlfile(s)... and should be used if your instance is mission critical). Since it doesn't sound like you are using a catalog db, I also suggest that you use "controlfile copy" versus controlfile backups (or in addition to at a minimum).  

Regardless of catalog database usage... make lots of controlfile copies on different disks... often. And... be sure that you have enough mountpoint space for your expandable controlfiles. If control_file_record_keep_time > 0, it will expand when needed. And if you're asking your controlfiles to retain 4 backups worth of knowledge, depending on db size, backup frequency, amount of redo, etc... these controlfiles may get large.  

Raj.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Tuesday, April 10, 2007 1:40 PM
To: oracle-l_at_freelists.org
Subject: RMAN without a repository  

If I am making tape backups and I am using redundancy 4. How do I restore older backups after the controlfile recycles? Or do I set control_file_record_keep_time to a sufficiently large number?  

do I have to write down the DBID and use that to restore an older copy?

--
http://www.freelists.org/webpage/oracle-l