Re: copy database, change SID, create cntrlfile and recover using backup controlfile

Try this: having copied everything over from an offline backup (let us say, taken when the source database was at time 20000 last night), go back to the source database (which presumably has been opened since the backup) and perform a clean shutdown (immediate will do). Now transfer the source's ONLINE redo logs over to the clone that you've created.

Net result: all your datafiles for the clone are at time 20000, and the online redo logs for the clone are at time (say) 23000. That's an inconsistent database, and will cause Oracle to apply all redo up to time 23000

Regards
HJR "J. Bavendiek" <johannesbavendiek_at_my-deja.com> wrote in message news:9690jr$694$1_at_nnrp1.deja.com...
> Hello
>
> I want to copy a complete source-DB database to the test-system.
> 1. I take the files from a OFFline backup.
> 2. I do a create controlfile with a modified controlfile from the
> source-DB in nomount status. Modifications: DBNAME, Path to datafiles,
> ...
> 3. When I try to recover database using backup controlfile,
> can I carry on recovery after reaching the log-sequence-number/SCN of
> the (consistant) datafiles or not???
> I want to recover until last offline redo!
>
> thx for your help
> Johannes
>
> --
> *** "First think and than do and do not forget ***
> *** each of them", the old, wise man said. ***
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Feb 13 2001 - 01:16:49 CST