Topic: Backup & Recovery >> exacts steps for creating standby database
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: exacts steps for creating standby database |
| nadeem |
Posted: Feb 16, 2007 05:16:15 AM |
Total Post: 15
Joined: May, 2006
|
Dear All,
I am running an Oracle 9i database on CentOS 4.3.
Can any body tell me the exacts steps for creating standby database on same server.
Thanks and Regards
nadeem |
|
|
 Oracle Virus |
| Posted: Feb 16, 2007 05:33:37 AM |  |
|
Total Post: 50
Joined: Jan, 2007
|
Hi,
Keep checking our Article section. This is copied from there for your convenience....
Standby Database on the same Server :
Note: It is not recommended to have standby database on the same sever though you can use this tip to test or enhance your standby database concept only. Since this defeats the purpose of a standby if your entire machine were to crash.
Problem Description:
You are setting up a Standby database environment in the same machine as the primary database.
1. You issue....
alter database create standby controlfile as '$HOME/standby.ctl';
alter system archive log current;
2. copy this generated controlfile to directory where you intend to place the standby database
3. Make a copy of the init.ora file to be used by the standby database and include the appropriate initialization parameters to point to where where the primary database files reside, followed by the directory path where the (test) standby database will reside:
Oracle7 -- db_file_standby_name_convert
and log_file_standby_name_convert
Oracle8 -- db_file_name_convert and log_file_name_convert
Also edit the control_files parameter to point to the standby controlfile
4. With the primary database shutdown, copy the redo log files and database files to the standby directory
5. With the primary database now up, you try to mount the standby: you will receive:
SVRMGR> alter database mount standby database;
alter database mount standby database
*
ORA-01102: cannot mount database in EXCLUSIVE mode
6. If you shut the primary database down, the command succeeds but then you get the same error when trying to open the primary database.
7. Deleting the lk file made no difference - but maybe that was because it was not really deleted as it was being held open by some process.
Problem Explanation: The failure is because shared memory has already been created for this ORACLE SID, and you are attempting to create the same shared memory for the same ORACLE SID.
Solution Description:
1. Shutdown the standby database
2. Starting with Oracle Release 7.3.3:
add _standby_lock_name_space= in the init.ora of standby database
Starting with Oracle Release 8.0.X:
add lock_name_space= in the init.ora of standby database
where <name> is a name other than the primary's database name, up to 8 characters long .
You can use a naming convention like:
If Primary db_name = DB1
set lock_name_space = DB1s
3. startup nomount standby database
4. alter database mount standby database.
Solution Explanation: The above solution works for TESTING standby databases on the same machine as the Primary Database.
Regards,
Aneel Kanuri
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
