How to test standby database [message #74605] |
Wed, 19 January 2005 20:00 |
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 |
Frank Naude
Messages: 4587 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
|
|
|