Home » Server Options » Data Guard » How to test standby database
How to test standby database [message #74605] Wed, 19 January 2005 20:00 Go to next message
Prasanna Sreenivasa Kumar
Messages: 5
Registered: January 2005
Junior Member
Hi,
I am creating a stabdby database in manual mode.
I want to test this database ...
Can anyone suggest me how to test this database??
Oracle objects can be tested using user_objects table. But how to test data ??
is there any scripts avilable for this ??
Thanks in advance.
Regards,
prasanna
Re: How to test standby database [message #74611 is a reply to message #74605] Thu, 20 January 2005 23:31 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

The easiest way to test if your physical standby database is working is to open it in read-only mode and to select the data and compare it to what's on your primary database.

Best regards.

Frank
Previous Topic: Data Guard 9i
Next Topic: Applying 8.1.7.4 database logs to Oracle 9 database
Goto Forum:
  


Current Time: Fri Mar 29 08:17:29 CDT 2024