RE: rman incomplete recovery

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 13 Dec 2005 10:41:39 -0500
Message-ID: <010d01c5fffb$b551ac70$bb59000a@vttaxnet.tax.state.vt.us>

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:

in the OS, export the NLS_DATE_FORMAT as yyyy-mm-dd:hh24:mi:ss
in sqlplus, shutdown the database and open it nomount
>rman, connect target, connet rcvcat
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_at_tax.state.vt.us

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joe Smith Sent: Tuesday, December 13, 2005 9:56 AM To: oracle-l_at_freelists.org
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/

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


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

Received on Tue Dec 13 2005 - 09:41:52 CST