Restoring Database on a Different Node Using Cold Backup - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Restoring Database on a Different Node Using Cold Backup

  1. #11
    Join Date
    Sep 2000
    Posts
    362
    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


  2. #12
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    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

  3. #13
    Join Date
    Apr 2001
    Posts
    118
    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?

  4. #14
    Join Date
    Sep 2000
    Posts
    362
    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

  5. #15
    Join Date
    Mar 2001
    Posts
    61
    check the listner services

  6. #16
    Join Date
    Aug 2000
    Posts
    194
    ***
    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.


  7. #17
    Join Date
    Apr 2001
    Posts
    151
    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.

    Elin@trend

  8. #18
    Join Date
    Sep 2000
    Posts
    362
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width