Restoring Database on a Different Node Using Cold Backup

[anuragmin]

I Have performed the following steps till now

1, copy all the files to the new Node

2, change the initSID.ora file to reflect the path of the new controlfile, back_dump, core_dump,..etc, etc..

Now the third step as suggested by gsprince is

3, startup mount ; /* make sure ORACLE_SID, ORACLE_HOME, PATH everything is set */

To startup the database i need to set the oracle_sid and create the services which I did as below

C:\>set oracle_sid=testsid6

C:\>oradim80 -new -sid testsid6 -intpwd oracle1 -startmode auto -pfile C:\testsid6\inittestsid6.ora

C:\>oradim80 -startup -sid testsid6 -starttype srvc,inst -usrpwd oracle1 -pfile C:\testsid6\inittestsid6.ora

Now open the server manager and try to mount the database
using the following commands

SVRMGR> connect internal/oracle1
ORA-12203: TNS:unable to connect to destination
SVRMGR> connect internal/oracle1@testsid6
ORA-12154: TNS:could not resolve service name

Please tell me what am I doing wrong here.
I want to restore the whole database on a production system if this test works. If you need I can also post my init.ora file also.

Thanks
Anurag

[dragon99]

I think you need to add one entry for your new sid in your tnsnames.ora file which will resolve your tns problem.

Good luck.

Dragon

[Heath]

I'm not sure if this is the right place to look or not, but it can't hurt to ask.

Is SVRMGR trying to connect to your local database through the standard BEQ-LOCAL service? If that is the case, then what does the BEQ-LOCAL entry in your TNSNAMES.ORA file look like? Is it referencing the SID of the database to which you are trying to connect?

[anuragmin]

Hi,
I added the entries into the ltnsnames.ora file and the listener file.

Now it gives me the following error.

SVRMGR> connect internal/oracle1@testsid6
ORA-12500: TNS:listener failed to start a dedicated server process

Please suggest.

Thanks
Anurag

[pangul]

check the listner services

[gsprince]

***
check "control panel --> services-->", the oracle service you added (say: OracleServiceSID) is started.
***

If not try start the service from control panel.

go to command prompt (DOS prompt)

set ORACLE_SID=SID

C:\> svrmgrl

SVRMGR> connect internal

Note: Asumption is ur database is installed on the same machine where u r trying the connection. Else, you need the TNS stuff like that.

[elintrend]

How about passwordfile -
did you also copy over to your new db.
I am doing new instance from cold backup tomorrow with a little bit confuse about password file.

[anuragmin]

Hi,
I was able to restore the database on a different node using cold backup. Thanks a lot everybody.

The problem was that the services were not getting created using the oradim80 command.

I have 2 oracle homes installed on my machines. One for Oracle 8.1.7 and one for Oracle 8.0.5. i tried creating the services using the oradim command (8.1.7) and it created them and it worked.

BUT WHY DID IT NOT CREATE THE SERVICES USING THE ORADIM80 COMMAND.

ANY IDEAS.....

Thanks
Anurag