Hi all!
I have a problem with configuration physical standby on the seperate sites.
One machine is: 10.149.33.11 with hostname is uranium
One machine is: 10.149.33.17 with hostname is oradba
The Primary DB is on uranium.
These are steps I began:
1/ Force Database
SQL>Show parameter log_archive_dest
log_archive_dest string J:\TEST\archive
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination J:\TEST\archive
Oldest online log sequence 25
Next log sequence to archive 27
Current log sequence 27
SQL> alter database force logging;
Database altered.
2/Copy the datafiles to the standby machine - oradba
SQL> select name from v$datafile;
NAME
---------------------------------
J:\TEST\TEST\SYSTEM01.DBF
J:\TEST\TEST\UNDOTBS01.DBF
J:\TEST\TEST\SYSAUX01.DBF
J:\TEST\TEST\USERS01.DBF
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
--I used the Windows Explorer Network to copy all of datafiles to the oradba machine.
--with the location of them is : C:\oradataTestStd
At this step, I lost something
2.1.Modify the parameter log_name_file_convert
2.2.Modify the parameter db_file_name_convert
However, I wonder about:
- Because the db_file_name_convert is '/Primary,'/Standby'. In this my case, what should I do?
Primary: J:\Test\Test
Standby: C:\oradataTeststd
Is this:
SQL>alter system set db_file_name_convert='J:\Test\Test','C:\oradataTeststd' scope=both;
??
And I execute statement in Primary DB?
- What do I modify log_file_name_convert?
3/ Create standby controlfile and Pfile
SQL> alter database create standby controlfile as 'J:\test\std\teststd.ctl'
Database altered.
SQL> create pfile='J:\test\std\InitTeststd.ora' from spfile
File created.
4/Modify the InitTeststd.ora
4.1: adump, bdump, udump, cdump
4.2: controlfile
4.3: log_archive_dest_1='LOCATION=C:\archive_TestStd'
standby_archive_dest='C:\archive_Teststd'
log_archive_dest_state_1=enable
4.4: fal_client=TestStd
fal_server=Test
5/ Modify the TNSNAME.ora in both of Uranium and OraDBA
Quote: |
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.149.33.11)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ORADBA)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Test)
)
)
TESTSTD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORADBA)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TestStd)
)
)
|
6/Startup Stdb Nomount
SQL> create spfile from pfile='C:\oradataTestStd\initTestStd.ora'
2 ;
File created.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 629145600 bytes
Fixed Size 1250548 bytes
Variable Size 171969292 bytes
Database Buffers 452984832 bytes
Redo Buffers 2940928 bytes
SQL>
But...
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL>
Would you like to correct and guide me more?
Thank you very much!
[Updated on: Wed, 23 April 2008 04:21]
Report message to a moderator