DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: configure standby

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    Hi:

    O.S :Windows NT
    Oracle : 8.1.6

    I have done following steps to configure the standby database

    On Primary database
    1) shutdown primary database
    2) modified the tnsnames.ora
    3) modified the init.ora file
    4) startup the database
    5) alter database create standby controlfile 'd:\stdby.ctl'
    6) shutdown the database
    4) copy all the datafile,logfile,controlfile to standby location

    Here is my question:
    How can I change the name of the stanby database and location of the datafiles in controfile (stdby.ctl) since I can not read the controlfile?

    Let me know.

    Thanks.

  2. #2
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    If you have any idea..please let me know...

    Thanks.

  3. #3
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    I am trying to configure the stand by database..
    If I keep the same name for stand by database as primary dtabase and If I try to configure the tnsnames.ora on primary database then it gives me an error..
    If I change the database name and location of the datafile on standby database and try to run the contorlfile which was create on primary database using "alter database create standby controlfile as 'stdctl.ctl'" it gives me adn error..

    Also, I can not change the location and database name in the controlfile...

    Please HELP...


    Thanks.

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