Home » Server Options » Data Guard » Configure Data Guard for testing purpose (OS: Windows XP, OracleDB: 10.2.0.1.0)
Configure Data Guard for testing purpose [message #315919] Wed, 23 April 2008 04:13
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
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

Previous Topic: Physical Standby in two machines(!?)
Next Topic: Dataguard
Goto Forum:
  


Current Time: Thu Mar 28 05:50:13 CDT 2024