arc_dest

col DEST_NAME for a20
col DESTINATION for a30
col RECOVERY_MODE for a20
col TYPE for a10
col database_mode for a12
select DEST_NAME,STATUS,TYPE,DATABASE_MODE,RECOVERY_MODE,PROTECTION_MODE,DESTINATION,SYNCHRONIZED,SYNCHRONIZATION_STATUS
FRom v$archive_dest_status
where STATUS<>'INACTIVE';