Querys for Manualy monitoring Dataguard

Raul.Alvarenga

BPeaslandDBA

One suggestion...put in some comments so that people know what the queries are supposed to tell us.

Raul.Alvarenga

One suggestion...put in some comments so that people know what the queries are supposed to tell us.

thanks for your help, i will update soon.

regards

Mark D Powell

thanks for your help, i will update soon.

regards

Just wanting to catch the response saying the update has been posted.

Raul.Alvarenga

Post updated

Thanks for your comments.

Mark D Powell

Post updated

Thanks for your comments.

Raul, I think you can improve the document more by removing excess output on the example output.  That is, you do not need to show 59 rows of output on the system event data.  A couple of rows is enough to show what the query produces.

- -

Also you might want to order the document queries such as (for example) the first section are queries to run on the primary, the second set run on the Standby, and the third are  queries that run on either.

- -

Here is a query I found in my notes you can see if you want to add it to your collection.

- -

set echo off

--

-- Scripts to check on status and help identify log application status

--

-- 2009-04-09  Mark D Powell    Save q

--

select

  a.open_mode

,a.database_role

,b.recovery_mode

from

  v$database a

,v$archive_dest_status b

where

   b.dest_id = 1

/

- -

HTH -- Mark D Powell --

Raul.Alvarenga

Raul, I think you can improve the document more by removing excess output on the example output.  That is, you do not need to show 59 rows of output on the system event data.  A couple of rows is enough to show what the query produces.

- -

Also you might want to order the document queries such as (for example) the first section are queries to run on the primary, the second set run on the Standby, and the third are  queries that run on either.

- -

Here is a query I found in my notes you can see if you want to add it to your collection.

- -

set echo off

--

-- Scripts to check on status and help identify log application status

--

-- 2009-04-09  Mark D Powell    Save q

--

select

  a.open_mode

,a.database_role

,b.recovery_mode

from

  v$database a

,v$archive_dest_status b

where

   b.dest_id = 1

/

- -

HTH -- Mark D Powell --

thanks for your recomendations, i will proceed, it is my first collaboration.

regards