oracle 9i physical standby database 上的v$archived_log

SQL> col name format a34

SQL> set pagesize 15

SQL> col name format a34

SQL> set pagesize 15

SQL> select name ,sequence#,creator,REGISTRAR,STANDBY_DEST,ARCHIVED,applied from v$archived_log;

NAME SEQUENCE# CREATOR REGISTR STA ARC APP
---------------------------------- ---------- ------- ------- --- --- ---
/home/oracle/archive/1_12.dbf 12 ARCH RFS NO YES YES
/home/oracle/archive/1_13.dbf 13 ARCH RFS NO YES YES
/home/oracle/archive/1_14.dbf 14 ARCH RFS NO YES YES
/home/oracle/archive/1_15.dbf 15 ARCH RFS NO YES YES
/home/oracle/archive/1_16.dbf 16 FGRD RFS NO YES YES
/home/oracle/backup/1_17.dbf 17 ARCH ARCH NO YES NO
PRIMARY 17 ARCH ARCH YES YES YES
/home/oracle/backup/1_18.dbf 18 ARCH ARCH NO YES NO
PRIMARY 18 ARCH ARCH YES YES YES
/home/oracle/backup/1_19.dbf 19 FGRD RFS NO YES NO
PRIMARY 19 FGRD FGRD YES YES YES
/home/oracle/archive/1_20.dbf 20 ARCH RFS NO YES YES

12 rows selected.

[@more@]