Re: HELP: problem restoring from cold backup

When we replicate a database we start our create control file command as listed below. Note the Set Database 'NEWSID' where NEWSID is the Oracle Sid of the new database. The rest of the create control file command is an edited version of a trace file (alter database backup controlfile to trace) from the old database which now points to the new path/logfiles and points to the new path/datafiles, and as shown sets the new database name .

CREATE CONTROLFILE REUSE SET DATABASE "NEWSID" RESETLOGS NOARCHIVELOG ........ ichwan.rachmat_at_creditlyonnais.fr wrote:

> Hello,
> I hope somebody can point me to the light on this matter.
>
> I am trying to replicate an Oracle database on HP-UX by:
> 1. Restore a copy of cold backup of the database into a different directory
> $NEW_PATH.
> 2. Rename *.dbf to avoid conflict.
> 3. Rename config$SID.ora and modify datafile paths, SID and database_name
> 4. Rename init.ora and modify the location of config$SID.ora
> 5. Remove control (*.ctl) files and log (log*.dbf) files in this directory
> 6. Start svrmgrl as DBA
> SVRMGR> connect internal
> Connected to an idle instance.
> SVRMGR> startup nomount pfile=$NEW_PATH/init.ora
> ORACLE instance started.
> Total System Global Area 32685320 bytes
> Fixed Size 38984 bytes
> Variable Size 18310336 bytes
> Database Buffers 10240000 bytes
> Redo Buffers 4096000 bytes
> SVRMGR>
>
> Up to here, everything seems to be OK, but when I issued the CREATE
> CONTROLFILE command, it failed with error message:
>
> SVRMGR> create controlfile reuse
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file '$NEW_PATH/syst$SID.dbf'
> ORA-09782: sfifi: another instance has the same database mounted.
> SVRMGR>
>
> Is there anything else that I missed out?
> I performed the same procedure with another dataset and it worked fine.
> Somebody please help....
>
> Thanx in advance!
> ichwan.rachmat_at_creditlyonnais.fr
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Linda Montgomery
Database Analyst
James Madison University
montgolh_at_jmu.edu Received on Thu Mar 25 1999 - 09:40:41 CST