My archived log are saved in different folders according to the save date; for example 2014_03_10, 2014_03_11 which contains all the archives saved on that day and so on.
This is my log_archive_dest parameter,
SQL> show parameter log_archive_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string SQL> SELECT DEST_NAME, DESTINATION FROM V$ARCHIVE_DEST WHERE STATUS='VALID'; DEST_NAME DESTINATION ------------------------ ------------------------------------------- LOG_ARCHIVE_DEST_1 USE_DB_RECOVERY_FILE_DEST SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_ area
To change archived log save in one folder without separate it by day, we can change alter LOG_ARCHIVE_DEST_1
SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/backups/fast_recovery_area' scope=both; System altered.
Filed under: Oracle |
Leave a comment