rman incomplete recovery

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 13 Dec 2005 08:55:48 -0600
Message-ID: <BAY107-F72CE7F04A59315480753997390@phx.gbl>

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

Received on Tue Dec 13 2005 - 08:57:19 CST