DG- log type and database role

Pri WEB> SELECT DEST_ID,VALID_TYPE,VALID_ROLE,VALID_NOW FROM V$ARCHIVE_DEST;

 

   DEST_ID VALID_TYPE      VALID_ROLE   VALID_NOW

---------- --------------- ------------ ----------------

         1 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         2 ONLINE_LOGFILE  PRIMARY_ROLE YES

         3 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         4 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         5 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         6 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         7 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         8 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         9 ALL_LOGFILES    ALL_ROLES    UNKNOWN

        10 ALL_LOGFILES    ALL_ROLES    YES

 

10 rows selected.

 

ST WEB> SELECT DEST_ID,VALID_TYPE,VALID_ROLE,VALID_NOW FROM V$ARCHIVE_DEST;

 

   DEST_ID VALID_TYPE      VALID_ROLE   VALID_NOW

---------- --------------- ------------ ----------------

         1 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         2 ONLINE_LOGFILE  PRIMARY_ROLE WRONG VALID_TYPE

         3 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         4 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         5 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         6 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         7 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         8 ALL_LOGFILES    ALL_ROLES    UNKNOWN

         9 ALL_LOGFILES    ALL_ROLES    UNKNOWN

        10 ALL_LOGFILES    ALL_ROLES    YES

        11 ALL_LOGFILES    ALL_ROLES    YES

 

11 rows selected.

 

DEST_ID :Log archive destination parameter identifier (1 to 10)

VALID_TYPE : Redo log type or types that are valid for the destination:

■ ONLINE_LOGFILE

■ STANDBY_LOGFILE

■ ALL_LOGFILES

VALID_ROLE : Database role or roles that are valid for the destination:

■ PRIMARY_ROLE

■ STANDBY_ROLE

■ ALL_ROLES

VALID_NOW : Indicates whether the destination is valid right now for archival

operations:

■ YES - Redo log type and database role for this destination are valid for the current database

■ WRONG VALID_TYPE - Redo log type specified for this destination is not valid for the current database role. For example, WRONG VALID_TYPE would be returned if a destination specified with the VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE) attribute is running in the standby database role but does not have standby redo logs implemented.

■ WRONG VALID_ROLE - Database role specified for this destination is not the role in which the database is currently running. For example, the WRONG VALID_ROLE would be returned when a destination defined with the VALID_FOR=(ONLINE_LOGFILE,STANDBY_ROLE) attribute is running in the primary database role.

■ INACTIVE - Destination is inactive, probably due to an error

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16348200/viewspace-619601/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16348200/viewspace-619601/