|
|
| Re: recover a clone database with archived log of the production one [message #130715 is a reply to message #130628] |
Tue, 02 August 2005 02:17   |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi,
As i know ,
U can copy the latest control file from the old machine to the new machine ( keep old control file safe ) . Now when u try to start the database the checkpoint nos of the control files will not match with the checkpoint nos of ur datafiles so it will insist for recovery .
now store ur Archived log files in the same location as it was in the old machine and start recovery.
> Recover database
and recovery will b done automatically .
OR
if u cannot store the files in the same location as it was on the old machine then apply them one by one.
Then perform fake incomplete recovery, u can use the command
SQL> Recover database until cancel
using this command u wil b prompted to enter the path of the file when not found on default location.
I think this trick should work for u but before implementing it just wait for some more suggestions from big GURUS on this site.
regards,
tarun
[Updated on: Tue, 02 August 2005 02:20] Report message to a moderator |
|
|
|
| Re: recover a clone database with archived log of the production one [message #130772 is a reply to message #130715] |
Tue, 02 August 2005 07:16 |
mademba
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Ok,
My new database is not in production, it is just used for audit purposes.
If i get what u mean, i suppose, any time i want to apply the archived redo log gathered in the production database,
i've to create a new controlfile for the clone database using the production one.
plz can u give me the details the procedure to copy the controfile from the production database.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
