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

[Dave Walley]

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

[Yogeeraj_1]

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

[Dave Walley]

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

[Jean-Luc Oudart]

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

[Dave Walley]

Thanks for your help.

[Dave Walley]

I have enough to go on. Bye