| Oracle 9i Data Guard Questions [message #213136] |
Tue, 09 January 2007 11:09  |
Ista
Messages: 14
Registered: January 2007
|
Junior Member |
|
|
Greetings,
1. How can I verify that the Data Guard Setup is working with Oracle 9i? In other words, if I make a change on the Active (Primary) DB, say create a new table and enter some data rows, how can I verify that this change has actually been copied to the Standby (Inactive) side?
2. How can I turn the Primary db off for maintenance and switch over to the inactive side? Would there be any data loss during the switch over?
Thanks and best regards.
|
|
|
|
| Re: Oracle 9i Data Guard Questions [message #213199 is a reply to message #213136] |
Tue, 09 January 2007 15:16  |
email.sandeepnaik
Messages: 121
Registered: August 2006
|
Senior Member |
|
|
you can open standby database in read only mode and make sure your primary data is applied on standby
Data guard has different modes. However, in switchover mode there should not be any data loss. In case of failover if you plan to have max protection mode then you will be garunteed for no data loss.
Sandeep
|
|
|
|
| Re: Oracle 9i Data Guard Questions [message #213211 is a reply to message #213199] |
Tue, 09 January 2007 18:19 |
Ista
Messages: 14
Registered: January 2007
|
Junior Member |
|
|
Greetings,
Thanks for the reply.
I tried the following and still unable to see the new table on the standby db that I created earlier on the Primary db. Am I missing something here?
Please advise,
Thanks and best regards.
On the standby db:
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
SQL> shutdown
ORA-16175: cannot shut down database when media recovery is active
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN read only;
Database altered.
SQL > select table_name from user_tables;
-- New table name is missing from the list
|
|
|
|
| Re: Oracle 9i Data Guard Questions [message #213421 is a reply to message #213136] |
Wed, 10 January 2007 12:54 |
email.sandeepnaik
Messages: 121
Registered: August 2006
|
Senior Member |
|
|
do you have any delay in log apply? That might prevent change to be propagated to standby right after they are available on pri.
when u create table on primary..do a switch logfile..cut new archive log now wait for this log to be applied by standby..you can query v$archive_log view to see if this is applied or not on remote destination. Once applied you open standby in read only and check again.
Sandeep
|
|
|
|
| Re: Oracle 9i Data Guard Questions [message #213433 is a reply to message #213421] |
Wed, 10 January 2007 14:59 |
Ista
Messages: 14
Registered: January 2007
|
Junior Member |
|
|
Hi Sandeep,
Thanks again for your reply.
- Yes, there is a 30 min delay in the data transfer.
- How do I switch the logfile from active to the standby?
And how do I verify the change in the v$archived_log.
Thanks and best regards.
|
|
|
|
| Re: Oracle 9i Data Guard Questions [message #213459 is a reply to message #213136] |
Wed, 10 January 2007 18:32 |
email.sandeepnaik
Messages: 121
Registered: August 2006
|
Senior Member |
|
|
if you have 30 min delay..you just run create table statement.then run alter system switch logfile. Make sure on primary new log file is generated . Wait for 30 min. Make sure file is applied on standby(check v$archive_log view ) and then verify table on standby.Total time you will have to wait is, 30 min after archive log is created on primary + delay to transport log and apply log on standby.
Sandeep
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
