ORA-16014 and ORA-00312 troubleshooting
When switching the role of the logical standby database switchover, the following error message is displayed in the log when the database is started;
Primary> startup
Oracle instance started.
Total System Global Area 281018368 bytes
Fixed Size 2020160 bytes
Variable Size 100666560 bytes
Database Buffers 171966464 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
A remote session terminal starts a database. The database has been opened, but an error has been reported in the log. The error message is as follows:
ARC0: Failed to archive thread 1 sequence 45 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Mar 27 15:27:54 2014
ORACLE Instance orcl-Archival Error
Thu Mar 27 15:27:54 2014
The ORA-16014: log 1 sequence #45 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oradata/orcl/redo01.log'
Thu Mar 27 15:27:54 2014
Errors in file/u01/app/admin/orcl/bdump/orcl_arc0_2955.trc:
The ORA-16014: log 1 sequence #45 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oradata/orcl/redo01.log'
Error message: archive log cannot be archived, and the error message is standby01.log. The log file is damaged.
Primary> alter database clear unarchived logfile group 1; -- clear unarchived content
Database altered.
Primary> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Primary> startup
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 2020160 bytes
Variable Size 104860864 bytes
Database Buffers 167772160 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
When the terminal executes the statement, It glances at the log information without blinking, and finally shows no error.
Note: During lab simulation exercises, you can open several more terminals to check the log information, so that you will not be confused when operating databases in the production environment in the future. The client may not report an error, but the log already prompts an error.
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
Oracle 11g from entry to proficient in PDF + CD source code
Installing Oracle 11g R2 using RHEL6 ASM