Re: Online backup and renaming an instance

>
> 1. startup the database there,
> 2. do a media recovery,
> 3. open the database w/ resetlogs,
> 4. shut it down,
> 5. do an offline backup,
> 6. start it again,
> 7. back up controlfile to trace,
> 8. modify the trace controlfile to reflect the new instance name,
> 9. apply the resulting file,
> 10. open the instance with the new name.
>
> Number 10 is the problem. When I try a "alter database open resetlogs"
> the database tells me that file "sys01.dbf" needs recovery. But I have
> no valid archived redo logs for a recovery.
>

Did you shutdown the database cleanly (so no shutdown abort) between step 8 and 9? The database has to be in 'startup nomount' state before you recreate the controlfiles. Did you rename the old control files before creating the new ones?
Maybe you can specify one of your online redo-logs when the database says it needs recovery...

I usually rename the database somewhere around your step 1 and 2, when I clone a database that is running.

Raymond. Received on Thu Nov 08 2001 - 09:49:51 CST