error ORA-16014

9 Oct

error ORA-16014

1. error ORA-16014
SQL> startup;
ORACLE instance started.
Total System Global Area 1519898624 bytes
Fixed Size 2144624 bytes
Variable Size 872416912 bytes
Database Buffers 637534208 bytes
Redo Buffers 7802880 bytes
Database mounted.
ORA-16014: log 2 sequence# 2 not archived, no available destinations
ORA-00312: online log 2 thread 1: ‘/u02/perak/redo02.log’

2. restart database
SQL> shutdown;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.
Total System Global Area 1519898624 bytes
Fixed Size 2144624 bytes
Variable Size 872416912 bytes
Database Buffers 637534208 bytes
Redo Buffers 7802880 bytes
Database mounted.

SQL> alter system set log_archive_dest_1=’location=/u03/perak’;
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03/perak
Oldest online log sequence 2
Next log sequence to archive 2
Current log sequence 4

SQL> host ls -la /u03/perak
total 8
drwxr-xr-x 2 oracle oinstall 4096 Oct 9 08:15 .

3. alter database noarchivelog
SQL> alter database noarchivelog;
Database altered.

SQL> alter database open;
Database altered.

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

4. startup database
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1519898624 bytes
Fixed Size 2144624 bytes
Variable Size 872416912 bytes
Database Buffers 637534208 bytes
Redo Buffers 7802880 bytes
Database mounted.

5. alter database archivelog
SQL> alter database archivelog;
Database altered.

6. alter database open
SQL> alter database open;
Database altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: