Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Using rman to create auxiliary database from not the most recent backup.

Dave Walley
Frequent Advisor

Using rman to create auxiliary database from not the most recent backup.

Good morning.

Being new to rman I have been requested to create an auxiliary (clone) database and to use an old backup (ie not the most recent). I have created an auxiliary but by default it picked up the most recent backup. Can anybody tell me how I specifically identify a cold backup from 1 month ago for instance?

Thanking you in advance.

Dave
why do i do this to myself
5 REPLIES
Yogeeraj_1
Honored Contributor

Re: Using rman to create auxiliary database from not the most recent backup.

hi dave,

you cannot do this unless you have the old backups and old catalogue image available.

This is what Oracle says:

Recover the duplicate database to the current point in time. RMAN recovers the duplicate database up to or before the most recent available archived redo log. If the duplication is to another host, then you must make the archived redo logs available in the expected location in the new host.


for more information, please read:
http://download-east.oracle.com/docs/cd/A81042_01/DOC/server.816/a76990/dupdb.htm#441628

the "Obeying Restrictions" section

hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Dave Walley
Frequent Advisor

Re: Using rman to create auxiliary database from not the most recent backup.

Thank you for your reply. I do have all backup tapes available to me, what I really need is the ability to say restore to a specific cold backup. I know I can use set until time '31-AUG-1999 11:08:00';. I would ideally like to say restore to a particular cold backup. Any ideas or comments.

Thanks once again
why do i do this to myself
Jean-Luc Oudart
Honored Contributor

Re: Using rman to create auxiliary database from not the most recent backup.

Hi Dave,

from Oracle documentation
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmdupdb.htm#1006085

example :
Creating Duplicate of the Database at a Past Point in Time: Example
This duplication example assumes the following:

The target database trgt and duplicate database dupdb are on different hosts but have exactly the same directory structure.
You want to name the duplicate database files the same as the target files.
You are not using a recovery catalog.
You are using automatic channels for disk and sbt, which are already configured.
You want to recover the duplicate database to one week ago in order to view the data in prod1 as it appeared at that time.
CONNECT TARGET SYS/oracle@trgt
CONNECT AUXILIARY SYS/oracle@dupdb

DUPLICATE TARGET DATABASE TO dupdb
NOFILENAMECHECK UNTIL TIME 'SYSDATE-7';


Regards
Jean-Luc
fiat lux
Dave Walley
Frequent Advisor

Re: Using rman to create auxiliary database from not the most recent backup.

Thanks for your help.
why do i do this to myself
Dave Walley
Frequent Advisor

Re: Using rman to create auxiliary database from not the most recent backup.

I have enough to go on. Bye
why do i do this to myself