RE: How to restore only archives from RMAN catalog

From: Bort, Guillermo <guillermo.bort_at_eds.com>
Date: Mon, 27 Oct 2008 08:33:48 -0500
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC009EFAF7@usplm201.amer.corp.eds.com>

run {
allocate auxiliary channel ch1 type disk; set until time "to_date('Oct 12 2008 09:00:00','Mon DD YYYY HH24:MI:SS')";

*RESTORE DATABASE*
recover clone database *until time here is not needed as you used set until time before*

duplicate target database to <TEST_DB_NAME>;
}

hth

Guillermo Alan Bort

DBA / DBA Main Team  

EDS, an HP company  

From: Shastry(DBA) [mailto:shastry17_at_gmail.com] Sent: Monday, October 27, 2008 11:30 AM
To: Bort, Guillermo
Cc: Jan-Hendrik.Boll_at_dataport.de; oracle-l_at_freelists.org Subject: Re: How to restore only archives from RMAN catalog  

Hi all,

Thanks in first for your valuable responses. When I try to run the below script, I am getting the following error,

connect catalog ****
connect target ****
connect auxiliary /
run {
allocate auxiliary channel ch1 type disk; set until time "to_date('Oct 12 2008 09:00:00','Mon DD YYYY HH24:MI:SS')";
recover clone database until time "to_date('OCT 17 2008 16:00:00','Mon DD YYYY HH24:MI:SS')";
duplicate target database to <TEST_DB_NAME>;
}

allocated channel: ch1
channel ch1: sid=500 devtype=DISK

Starting recover at 27-10-2008 06:09:15
released channel: ch1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 10/27/2008 06:09:16 RMAN-06555: datafile 1 must be restored from backup created before 17-10-2008 16:00:00

Recovery Manager complete.
 Please correct if I am wrong, I am new to RMAN and needs your input if anything is wrong. For your information, i could restore and recover the database only for 12th as I have LEVEL 0 12th backup directory. Is it correct that unless we have incremental LEVEL 1 backup associated to 12 Level 0 backup, the above command wont work?

Thanks,
Ann

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

Received on Mon Oct 27 2008 - 08:33:48 CDT