Re: How to restore only archives from RMAN catalog
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- Date: Mon, 27 Oct 2008 19:06:09 +0530
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:
