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>
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