RE: rman incomplete recovery
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>, <joe_dba@xxxxxxxxxxx>
- Date: Tue, 13 Dec 2005 10:41:39 -0500
If you have controlfile autobackup on you don't need to specify the control
file. The controlfile you need cannot be the one you take right before
restoring the database. Rman knows by the set until time which one to use
from your controlfile autobackup destination. Here are the steps I would
use:
1. in the OS, export the NLS_DATE_FORMAT as yyyy-mm-dd:hh24:mi:ss
2. in sqlplus, shutdown the database and open it nomount
3. >rman, connect target, connet rcvcat
4. in a run block:
run {
set until time 'your until time in the NLS_DATE_FORMAT' above
allocate the channels if you don't have them preconfigured
restore database;
recovery database;
}
This should take care of everything for you. The format for the snapshot
controlfile is not usable by recovery, as far as I know. I preconfigure
everything, here is a sample script for accomplishing this. This is for a
database named rptcacs2. You can adjust the format specs to your particular
needs.
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/orasys/control/rptcacs2/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK DEBUG 5;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p';
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p';
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/usr/oracle/9i/dbs/snapcf_rptcacs2.f';
If you have any concerns or questions about this, please don't hesitate to
contact me off list.
Good luck,
Ruth
rgramolini@xxxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Joe Smith
Sent: Tuesday, December 13, 2005 9:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: rman incomplete recovery
List,
I am trying to do an incomplete recovery of my 9iRel2 db on Solaris 8. I am
in archive log mode.
This is a test environment.
I autobackup my control file and snapshot the control file.
The basis of the backup is:
backup database plus archivelog delete all input;
My RMAN backup script works fine, it has been running on multiple boxes for
months now.
I have tested different situations and now working on a new one.
I can do an incomplete recovery with the current control file and redo logs.
I am trying to simulate the situation of losing my controlfiles and redo
logs.
When I try to do an incomplete recovery with a backup controlfile and no
redo logs I get an RMAN error.
So, I rename my controlfiles and redo logs and try to recover to a time
before my redo logs.
I am using this run block:
run
{
set controlfile autobackup format for device type disk to
?/backup/location/control_%F';
set until time "to_date(?12-12-05 19:00:00?,?MM-DD-YY HH24:MI:SI?)";
restore controlfile from autobackup;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}
I get an RMAN error about database not mounted. I don't think that is the
whole problem.
Any help is highly appreicated.
thanks.
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
