Scenario: Converting database from no archive log to archive log mode
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265:instance recovery required, cannot set ARCHIVELOG mode
Performed Instance Recovery as requested and converted database to archivelog Mode
SQL> alter database open;
Database altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@tnc1 ~]$
[oracle@tnc1 ~]$
[oracle@tnc1 ~]$ db
[oracle@tnc1 ~]$ sql
SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 3 01:43:52 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 549453824 bytes
Fixed Size 2926616 bytes
Variable Size 293603304 bytes
Database Buffers 247463936 bytes
Redo Buffers 5459968 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
---Nikhil Tatineni--
---12C Database---
