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

Failure phenomenon:

When you change the database to archive mode, you have the following prompt:

SQL > alter database archivelog

Alter database archivelog

*

ERROR at line 1:

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Cause analysis:

Database shutdown is used, such as shutdown abort or startup force mount non-consistent shutdown, resulting in the database

The data file, the control file and the log file are out of sync. You need to restore the instance next time you start the database. The archiving mode can be changed only after the instance is restored and the database is consistent.

Solution:

After booting the database to the OPEN state, it shuts down normally (consistent), and then starts to the MOUNT phase to modify the archive mode.

SQL > alter database open

Database altered.

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 623546368 bytes

Fixed Size 1338308 bytes

Variable Size 436208700 bytes

Database Buffers 180355072 bytes

Redo Buffers 5644288 bytes

Database mounted.

SQL > alter database archivelog

Database altered.

SQL > alter database open

Database altered.

Summary:

Only if the database is consistent can it be archived.

Http://blog.itpub.net/25851087/viewspace-764035/

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.