AW: How to restore only archives from RMAN catalog

From: <Jan-Hendrik.Boll_at_dataport.de>
Date: Mon, 27 Oct 2008 14:38:46 +0100
Message-ID: <0FCF70745FD57F4F8259112EC5E800A50117EA18@wscxpr18.fhhnet.stadt.hamburg.de>

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_at_gmail.com] Gesendet: Montag, 27. Oktober 2008 14:36 An: Bort, Guillermo
Cc: Boll, Jan-Hendrik; oracle-l_at_freelists.org 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_at_eds.com> 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_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:38:46 CDT