Home » Server Options » Data Guard » Setting up Data Guard
Setting up Data Guard [message #132549] Sun, 14 August 2005 10:41 Go to next message
stefan454
Messages: 8
Registered: August 2005
Junior Member
Hello,

I have a couple of questions about setting up a physical standby database.

1. I testing to setup the standby database on the same server and need to create the standby db with a different name.
How do I create the control file?

I tried this but got an error wile starting the standby db.
ALTER DATABASE CREATE STANDBY CONTROLFILE AS
‘C:\Oracle\oradata\dbstand\dbstand.ctl’;

2. How can I query tables on the standby db?
I want the standby database to be applying archived redo logs at the same time as I am able to query. Do I need to open the database in some how?

I started the standby db this way
STARTUP NOMOUNT pfile=c:\oracle\admin\dbstand\pfile\init.ora
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

I got the following error messege when executing a query.
ORA-01219 database not open: queries allowed on fixed tables/views only




3. Is the init.ora parameter correct?

------------Primary database

log_archive_dest_2 LOCATION=C:\oracle\oradata\dbstand\standby_archive

remote_archive_enable true
standby_archive_dest %ORACLE_HOME%\RDBMS

------------Standby database

standby_archive_dest='C:\Oracle\oradata\dbstand\standby_archive\'

db_file_name_convert=('C:\Oracle\oradata\dbprim\',
'C:\Oracle\oradata\dbstand\')

log_file_name_convert=('C:\Oracle\oradata\dbprim\',
'C:\Oracle\oradata\dbstand\')

standby_file_management=AUTO
remote_archive_enable=TRUE

# The following parameter is required only if the primary and standby databases
# are located on the same system.
lock_name_space=dbstand

Regards
Stefan
Re: Setting up Data Guard [message #132849 is a reply to message #132549] Tue, 16 August 2005 07:45 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
You may also need to specify some of the following parameters as documented in the Data Guard Guide:

INSTANCE_NAME:

Specify a different value for the standby database than the primary database when the primary and standby databases reside on the same system.

DB_UNIQUE_NAME

Specify a unique name for this database. This name stays with the database and does not change even if the primary and standby databases reverse roles.

Etc...

Best regards.

Frank
Previous Topic: recovery error
Next Topic: data guard?log shipping?redo shipping?
Goto Forum:
  


Current Time: Fri Dec 03 23:34:19 CST 2021