Re: How to restore only archives from RMAN catalog

From: Shastry(DBA) <shastry17_at_gmail.com>
Date: Mon, 27 Oct 2008 19:00:15 +0530
Message-ID: <5b294dab0810270630q46910e8fp2a72535b37b712ef@mail.gmail.com>

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

On Mon, Oct 27, 2008 at 6:45 PM, Bort, Guillermo <guillermo.bort_at_eds.com>wrote:

> I am not certain as to the exact name of the env variable, however an
> alternative that works well is
>
>
>
> Run {
>
> Sql 'alter session set nls_date_formate '''dd-mm-yyyy hh24:mi:ss'''';
>
> …
>
> }
>
>
>
> regards
>
> *Guillermo Alan Bort*
>
> DBA / DBA Main Team
>
>
>
> *EDS*, an HP company
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jan-Hendrik.Boll_at_dataport.de
> *Sent:* Monday, October 27, 2008 11:11 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* WG: How to restore only archives from RMAN catalog
>
>
>
> There is no need to use the to_date() function as the date-format has been
> exported.
>
>
> ------------------------------
>
> *Von:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> *Im Auftrag von *Syed Jaffar Hussain
> *Gesendet:* Montag, 27. Oktober 2008 13:36
> *An:* guillermo.bort_at_eds.com
> *Cc:* usn_at_usn-it.de; shastry17_at_gmail.com; oracle-l
> *Betreff:* Re: How to restore only archives from RMAN catalog
>
> >>Set until time '17-10-2008 00:00:00';"
>
> *I doubt it will work correctly. *
>
> *If I am not wrong, you should use "**to_date*('17-10-2008 00:00:00',
> 'DD-MM-YYYY HH:MI:SS')"
>
>
>
>
>
> On Mon, Oct 27, 2008 at 3:30 PM, Bort, Guillermo <guillermo.bort_at_eds.com>
> wrote:
>
> Something like
>
> Export NLS_DATE='dd-mm-yyyy hh24:mi:ss'
> Rman target /
> Run {
> Set until time '17-10-2008 00:00:00';
> Restore database;
> Recover database;
> Alter database open resetlogs;
> }
>
> *Should* work
>
> Guillermo Alan Bort
> DBA / DBA Main Team
>
> EDS, an HP company
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Klier
> Sent: Monday, October 27, 2008 10:22 AM
> To: shastry17_at_gmail.com
> Cc: oracle-l
> Subject: Re: How to restore only archives from RMAN catalog
>
> Hi,
>
> you can give RMAN a regular date/time point-in-time for recovery, or a
> SCN, or a log sequence number, just look up the RMAN documentation.
>
> Example:
> RMAN> recover database until time 'sysdate -3';
>
> Regards
> Martin Klier
>
> Shastry(DBA) schrieb:
> > 2PM(in my case) in test environment. Please advice if there is a
> chance
> > to restore only archives to the test server on some mount and then
> apply
> > archives manually till the requested time, if suppose it is possible
> can
> > we mention the specific location to restore the required archives ( i
> > believe we need to mention the SCN number to restore).
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> Best Regards,
>
> Syed Jaffar Hussain
> Oracle Certified Master (10g)
> http://www.oracle.com/technology/ocm/shussain.html
> Oracle ACE
> http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126
> OCP 8i,9i & 10g DBA
> RAC Certified Expert
> Official Oracle RAC SIG Representative for Saudi Arabian region (
> http://www.oracleracsig.org/)
> I blog at
> http://jaffardba.blogspot.com/
> --------------------
> "Winners don't do different things. They do things differently."
>

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

Received on Mon Oct 27 2008 - 08:30:15 CDT