RE: RMAN without a repository
- From: "Pal, Raj" <Raj.Pal@xxxxxxxxxxxx>
- To: <ryan_gaffuri@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Apr 2007 14:13:18 -0600
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@xxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
ryan_gaffuri@xxxxxxxxxxx
Sent: Tuesday, April 10, 2007 1:40 PM
To: oracle-l@xxxxxxxxxxxxx
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?
Other related posts:
