Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN and Standby
Hi Jeff,
You can use restore until time to_date(<>,fmt) to restore a previous = backup and you have to do a incomplete recovery (recover until scn or = recover until time) and open the auxiliary instance. Refer to Oracle 9i = RMAN backup and recovery guide (Oracle Press)for a step by step approach = for creating a auxiliary instance. Its authored by one of our list = members Robert Freeman.
Best Regards
Sriram Kumar
-----Original Message-----
From: jwiegand [mailto:jwiegand_at_mn.rr.com]=20
Sent: Wednesday, February 11, 2004 6:55 AM
To: oracle-l_at_freelists.org
Subject: RMAN and Standby
Good Day!
I have Tivoli backups running on our production 9i RAC environment, and disk-to-tape backups running on the 9i standby. I want to be able to restore a certain standby backup to the standby server, then tell RMAN to create an auxiliary database with that backup. I would then have the current standby database, and an earlier version that I'd open as an auxiliary database. Is there a way to do this so I have control of what backup RMAN will use to restore, so it won't use a production backup for the restore?=20
Thanks,
Jeff
DISCLAIMER:
This message contains privileged and confidential information and is =
intended only for the individual named.If you are not the intended =
recipient you should not disseminate,distribute,store,print, copy or =
deliver this message.Please notify the sender immediately by e-mail if =
you have received this e-mail by mistake and delete this e-mail from =
your system.E-mail transmission cannot be guaranteed to be secure or =
error-free as information could be =
intercepted,corrupted,lost,destroyed,arrive late or incomplete or =
contain viruses.The sender therefore does not accept liability for any =
errors or omissions in the contents of this message which arise as a =
result of e-mail transmission. If verification is required please =
request a hard-copy version.
![]() |
![]() |