AW: How to restore only archives from RMAN catalog
- From: <Jan-Hendrik.Boll@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Oct 2008 14:38:46 +0100
Hi,
Do you want to duplicate the database or restore/recover?
The duplicate should look like this:
connect catalog ****
connect target ****
connect auxiliary /
run {
allocate auxiliary channel ch1 type disk;
set until time "to_date('OCT 17 2008 16:00:00','Mon DD YYYY
HH24:MI:SS')";
duplicate target database to <TEST_DB_NAME>;
}
regards
________________________________
Von: Shastry(DBA) [mailto:shastry17@xxxxxxxxx]
Gesendet: Montag, 27. Oktober 2008 14:36
An: Bort, Guillermo
Cc: Boll, Jan-Hendrik; oracle-l@xxxxxxxxxxxxx
Betreff: Re: How to restore only archives from RMAN catalog
Thank you soo much Guillermo !! Let me try and revert back in few mins.
On Mon, Oct 27, 2008 at 7:03 PM, Bort, Guillermo
<guillermo.bort@xxxxxxx> wrote:
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@xxxxxxxxx]
Sent: Monday, October 27, 2008 11:30 AM
To: Bort, Guillermo
Cc: Jan-Hendrik.Boll@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
Other related posts:
- » AW: How to restore only archives from RMAN catalog
