-
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.
-
Hi:
If you have any idea..please let me know...
Thanks.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|