Home » Server Options » Data Guard » Oracle 9i Data Guard Questions
Oracle 9i Data Guard Questions [message #213136] Tue, 09 January 2007 11:09 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Oracle 9i Data Guard Questions [message #213862 is a reply to message #213459] Fri, 12 January 2007 09:52 Go to previous messageGo to next message
Ista
Messages: 14
Registered: January 2007
Junior Member
Thanks and best regards.
Re: Oracle 9i Data Guard Questions [message #214605 is a reply to message #213862] Wed, 17 January 2007 04:27 Go to previous messageGo to next message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member

Hi,

How you can back to Data Guard real data syncronization after cheched table query?


Thanks,
Re: Oracle 9i Data Guard Questions [message #214637 is a reply to message #213136] Wed, 17 January 2007 06:04 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
I am not sure what do you mean by "data guard sync after checked query"..can you please ask question again in detail?

Sandeep
Re: Oracle 9i Data Guard Questions [message #214745 is a reply to message #214637] Wed, 17 January 2007 19:51 Go to previous message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member

Thanks for reply

"data guard sync after checked query" is back to data guard real-time apply after test data changes in standby site.

Previous Topic: change protection mode
Next Topic: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY
Goto Forum:
  


Current Time: Sun Dec 04 10:50:56 CST 2016

Total time taken to generate the page: 0.11016 seconds