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

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 --

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

regards