Sample Header Ad - 728x90

Oracle 11gR2 archive log destinations

2 votes
1 answer
22706 views
I want to add a second archive log destination to an Oracle 11gR2 RAC database with ASM, the idea is that I will then have some redundancy if the primary storage should fail. Archive log is already enabled, and logs are currently archived in the Fast Recovery Area. However, as far as I can see, none of the LOG_ARCHIVE_DEST_n init parameters have been configured. Is there now an unset default that specifies the Fast Recovery Area as a log destination? If that is the case, I assume I must now configure two destinations. One entry to continue writing archive to that default destination, and one entry for the additional backup destination. If so, how do I specify the existing default location in the fast recovery area? Will this work, is there another preferred way? alter system set log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST'; alter system set log_archive_dest_2 = 'LOCATION=/s01/archive/TESTDB'; alter system set log_archive_dest_state_1 = enable; alter system set log_archive_dest_state_2 = enable; alter system set log_archive_min_succeed_dest = 1; Naturally, the /s01 filesystem is available on all (both) cluster nodes.
Asked by Roy (1060 rep)
Oct 29, 2012, 10:18 AM
Last activity: Oct 29, 2012, 10:27 PM