The following error occurs when I open the database today and want to modify the archive mode of oracle:
SQL> alter database archivelog;
Alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
I checked it online. It turned out to be caused by the abnormal shutdown of the last system. You need to re-open the database to synchronize data files, control files, and log files, and then 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 301305856 bytes
Fixed Size 1336148 bytes
Variable Size 167775404 bytes
Database Buffers 125829120 bytes
Redo Buffers 6365184 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
Review the database archive mode:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6
Next log sequence to archive 8
Current log sequence 8
OK!
Author "mood station"