Home » Server Options » Data Guard » apply prd1 redo logs to clone db
apply prd1 redo logs to clone db [message #52973] Thu, 22 August 2002 01:02 Go to next message
andy
Messages: 92
Registered: December 1999
Member
Scenario:
prd1 full offline backup (bck1) at 7pm. all eod jobs afterwards.
copy bck1 to clone destination. create new controlfiles and startup clone.
all works fine.
now: is there a way to apply all archived redo log files to the clone db from
prd1 generated after 7pm? eg recover database (clone) until time ... (eg 08:00 next morning)?
(not standby db concept)

is there a method to modify the clone controlfiles, what would enable me to do a time based recovery?
Re: apply prd1 redo logs to clone db [message #53031 is a reply to message #52973] Sun, 25 August 2002 18:29 Go to previous messageGo to next message
P
Messages: 29
Registered: May 2002
Junior Member
Not sure if i read your question correctly
Yes you can just type alter database backup controlfile to /u01/oradata/backup/cntl01.ctl
then copy this file across adn use it to restore.
or you can backup controlfile to trace.
edit and use this
and just do a recover database until time '01-JAN-02 12:00:00' using backup controlfile
Re: apply prd1 redo logs to clone db [message #53054 is a reply to message #53031] Mon, 26 August 2002 20:39 Go to previous messageGo to next message
andy
Messages: 92
Registered: December 1999
Member
thanks for your answer.

does your suggestion also work, if the other db has a different name or has it to be the same db-name?
Re: apply prd1 redo logs to clone db [message #53132 is a reply to message #53054] Wed, 28 August 2002 16:40 Go to previous messageGo to next message
P
Messages: 29
Registered: May 2002
Junior Member
does not matter what the db name is when applying arch logs..
Re: apply prd1 redo logs to clone db [message #53142 is a reply to message #53132] Thu, 29 August 2002 01:22 Go to previous message
andy
Messages: 92
Registered: December 1999
Member
OK! that's great! I eventually succeeded with my problem!

1. copy *.dbf (from cold bck, 19:00 yesterday) to $ORACLE_DB_DATA of clone db
2. alter database backup controlfile to 'clone.ctl' (on prd1)
3. copy clone.ctl over to $ORACLE_DB_DATA of clone.
4. startup nomount, create controlfile REUSE ...
5. startup mount, recover until time (with arch logs of prd1)

many thanks for your Input !!!
Previous Topic: Oracle Standby with 8i
Next Topic: Standby database setup
Goto Forum:
  


Current Time: Thu Mar 28 06:08:18 CDT 2024