Saturday, May 16, 2015

ORA-16014: log 2 sequence# 26 not archived, no available destinations

SQL> startup pfile='/drdb/oradr/db/tech_st/10.2.0/dbs/initPRODTEST.ora';
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2089336 bytes
Variable Size             432017032 bytes
Database Buffers          624951296 bytes
Redo Buffers               14684160 bytes
Database mounted.
ORA-16014: log 2 sequence# 26 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/drdb/oradr/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/drdb/oradr/db/apps_st/data/log02b.dbf'


SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup pfile=initPRODTEST.ora
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2089336 bytes
Variable Size             432017032 bytes
Database Buffers          624951296 bytes
Redo Buffers               14684160 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;

File created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oradr@crpdmz dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sun May 17 01:51:14 2015

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

No comments:

Post a Comment