Shulou(Shulou.com)06/01 Report--

Because the default path of 11g archive log is: the DB_RECOVERY_FILE_DEST space size is 2G, the log is full, and the database hang resides.

Modify the archive log to report an ORA-16018 error:

First, create a directory for storing archive logs:

Orahost:root: [/ oracle] # mkdir arch_log

Orahost:root: [/ oracle] # chown-R oracle:oinstall. / arch_log

Orahost:root: [/ oracle] # chmod 775. / arch_log

Orahost:root: [/ oracle/arch_log] # su-oracle

Then modify the path:

SQL > alter system set log_archive_dest='/arch_log'

Alter system set log_archive_dest='/arch_log'

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or

DB_RECOVERY_FILE_DEST

[oracle@bsqkpi dbs] $oerr ora 16018

16018, 00000, "cannot use% s with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST"

/ / * Cause: One of the following events caused an incompatibility:

/ / 1) Parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

/ / was in use when a LOG_ARCHIVE_DEST_n (n = 1. 31) parameter

/ / was encountered while fetching initialization parameters.

/ / 2) An ALTER SYSTEM ARCHIVE LOG START TO command was in effect when

/ / a LOG_ARCHIVE_DEST_n parameter was encountered while fetching

/ / initialization parameters.

/ / 3) A LOG_ARCHIVE_DEST_n parameter was in use when an ALTER SYSTEM

/ / command was used to define a value for either the LOG_ARCHIVE_DEST

/ / or LOG_ARCHIVE_DUPLEX_DEST parameter.

/ / 4) Parameter DB_RECOVERY_FILE_DEST was in use when an attempt

/ / was made to use an ALTER SYSTEM or ALTER SESSION command to

/ / define a value for LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST.

/ / * Action: Eliminate any incompatible parameter definitions.

There is a conflict.

Enter pfile and put DB_recovery_FILE_DEST=. * drop

And then

SQL > create spfile from pfile

File created.

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 2505338880 bytes

Fixed Size 2230952 bytes

Variable Size 620758360 bytes

Database Buffers 1862270976 bytes

Redo Buffers 20078592 bytes

Database mounted.

Database opened.

SQL > alter system set log_archive_dest='/arch_log';- modified successfully

System altered.

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination / arch_log

Oldest online log sequence 136

Next log sequence to archive 138

Current log sequence 138

SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.