The location of the archived Redo Log files is specified using the init.ora
init.ora parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_n where n is a value between 1 and 10, which allows you to specify up to ten archive destinations for extra assurance of recoverability.
When the archive destination becomes full, database processing halts, and an error message is written to the database Alert log. When this error occurs, the database will remain halted until space is made available in the archive location. You can temporarily change the archive location using the following command:
SQL> ALTER SYSTEM ARCHIVE LOG ALL TO ‘/u04/oradata/PROD’;
Once space is made available in the archive destination, archiving will resume, and a message will be written to the Alert log to indicate that archiving has resumed.
|
