Init parameterRedo, undo & archiving

LOG_ARCHIVE_DEST_N

What it controls

Where archived redo goes: a local location or a Data Guard standby service. Numbered 1 to 31.

Know this before you change it

USE_DB_RECOVERY_FILE_DEST sends archived logs to the Fast Recovery Area, where they're managed with backups.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'log_archive_dest_1';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'log_archive_dest_1' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES)' SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET log_archive_dest_1 SCOPE = SPFILE SID = '*';

Related scripts

• Redo destinations and transport errorsEvery active archive destination with its status, gap state and last error. Any text in the ERROR column means redo isn't reaching that standby.
• Archived redo generated per dayCount and size of archived logs for the last 14 days, from the local destination only so standby copies aren't double-counted. Useful for sizing the…

Open in the parameter referenceOracle's reference

More in Redo, undo & archiving

• UNDO_RETENTIONSeconds of committed undo Oracle tries to keep, for long queries and Flashback Query.
• UNDO_TABLESPACEWhich undo tablespace the instance uses. Each RAC instance has its own.
• LOG_ARCHIVE_FORMATFile name pattern for archived logs written to a plain directory.
• ARCHIVE_LAG_TARGETForces a log switch after this many seconds, even when the database is quiet.
• LOG_BUFFERSize of the redo log buffer.
• FAST_START_MTTR_TARGETTarget seconds for crash recovery. Oracle writes dirty blocks early enough to meet it.