apply prd1 redo logs to clone db [message #52973] |
Thu, 22 August 2002 01:02 |
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 |
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 #53142 is a reply to message #53132] |
Thu, 29 August 2002 01:22 |
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 !!!
|
|
|