| Setting up Data Guard [message #132549] |
Sun, 14 August 2005 10:41  |
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  |
Frank Naude
Messages: 4590
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
