Monday, April 15, 2013

How to find archive logs location

Execute from sqlplus:

1) archive log list;
2) show parameter db_recovery_file_dest;
or query V$ARCHIVE_DEST

3) select dest_name, status, destination from v$archive_dest; 

No comments:

Post a Comment