Restore coldbackup to another database

[TheDash]

Hello,

We are using an Oracle 10g express edition (development database) on windows 2003 machine. The plan was to perform a cold back up of the database in order to back up existing data. The database was shutdown and datafiles, controlfiles and redo logs were backed up and control file was backed up using SQL>alter database backup controlfile to 'c:\tmp\b.ctl'; and backed up control file to trace.

The original database was deleted and all we have now is the 10 data files, 3 redologs, 3 control files and the backed up control file (b.ctl).

Can someone give the steps for restoring this on a brand new database and instance?

Thanks in advance.

 

[TheDash]

Hello all, I have also copied the init.ora file. I have backed up the contol file using alter . But the trace is not available because the original database is no longer there. Thanks.

 

[SantaMufasa]

Dash,

If all of the database data files and on-line redo log files reside where the control files think that they should be and if the control files reside where the init.ora file thinks they should be, then your attempt a normal startup:

sqlplus /nolog
SQL> connect / as sysdba
SQL> startup

...and let us know the results.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[karluk]

You won't be able to start your new database on Windows until you create the associated Windows service. Based on some documentation on Metalink, this can be done via the "oradim" command. The syntax is

ORADIM -NEW -SID SID -INTPWD PASSWORD -MAXUSERS USERS
     -STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA