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

Home -> Community -> Usenet -> c.d.o.server -> copy database, change SID, create cntrlfile and recover using backup controlfile

From: J. Bavendiek <johannesbavendiek_at_my-deja.com>
Date: Mon, 12 Feb 2001 15:48:14 GMT
Message-ID: <9690jr$694$1@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 Mon Feb 12 2001 - 09:48:14 CST