ORA-16038: ORA-00312 ORA-00312


adrci>show alert
Errors in file /d01/oradual/db/tech_st/11.1.0/admin/PROD_proddb/diag/rdbms/prod/PROD/trace/PROD_arc0_4745.trc:
ORA-16038: log 2 sequence# 1782 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02b.dbf'
2013-01-25 11:26:55.041000 +05:30
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance PROD - Archival Error
ORA-16014: log 2 sequence# 1782 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02b.dbf'
Errors in file /d01/oradual/db/tech_st/11.1.0/admin/PROD_proddb/diag/rdbms/prod/PROD/trace/PROD_arc3_4751.trc:
ORA-16014: log 2 sequence# 1782 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02b.dbf'
2013-01-25 11:30:00.107000 +05:30
Setting Resource Manager plan SCHEDULER[0x7301A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2013-01-25 11:30:02.767000 +05:30
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2013-01-25 11:31:55.781000 +05:30
ARC3: Closing local archive destination LOG_ARCHIVE_DEST_10: '/backup/PROD/archivelog/2013_01_25/o1_mf_1_1782_8j47ym32_.arc' (error 19502)
(PROD)
Deleted Oracle managed file /backup/PROD/archivelog/2013_01_25/o1_mf_1_1782_8j47ym32_.arc
Errors in file /d01/oradual/db/tech_st/11.1.0/admin/PROD_proddb/diag/rdbms/prod/PROD/trace/PROD_arc3_4751.trc:
ORA-19502: write error on file "/backup/PROD/archivelog/2013_01_25/o1_mf_1_1782_8j47ym32_.arc", block number 495617 (block size=512)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 495617
Additional information: 52736
ORA-19502: write error on file "/backup/PROD/archivelog/2013_01_25/o1_mf_1_1782_8j47ym32_.arc", block number 495617 (block size=512)
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance PROD - Archival Error
ORA-16038: log 2 sequence# 1782 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02b.dbf'
Errors in file /d01/oradual/db/tech_st/11.1.0/admin/PROD_proddb/diag/rdbms/prod/PROD/trace/PROD_arc3_4751.trc:
ORA-16038: log 2 sequence# 1782 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02b.dbf'
2013-01-25 11:32:02.353000 +05:30
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance PROD - Archival Error
ORA-16014: log 2 sequence# 1782 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1: '/d01/oradual/db/apps_st/data/log02b.dbf'
Errors in file /d01/oradual/db/tech_st/11.1.0/admin/PROD_proddb/diag/rdbms/prod/PROD/trace/PROD_arc0_4745.trc:
ORA-16014: log 2 sequence# 1782 not archived, no available destinations

SQL> select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,number_of_files as "number" from v$flash_recovery_area_usage;

FILE_TYPE USED RECLAIMABLE number
-------------------- ---------- ----------- ----------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 15.12 0 68
BACKUP PIECE 52.83 29.42 131
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.

SQL>

solution


SQL> select status from v$instance;

STATUS
------------
MOUNTED

[oradual@proddb ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VG0-LV0 9.7G 449M 8.8G 5% /
/dev/mapper/VG0-LV1 5.9G 141M 5.4G 3% /home
/dev/mapper/VG0-LV2 992M 34M 908M 4% /opt
/dev/mapper/VG0-LV3 3.9G 137M 3.6G 4% /tmp
/dev/mapper/VG0-LV4 9.7G 3.4G 5.9G 37% /usr
/dev/mapper/VG0-LV6 46G 180M 44G 1% /s01
/dev/mapper/VG0-LV5 4.9G 391M 4.3G 9% /var
/dev/mapper/VG0-LV9 868G 120G 712G 15% /d01
/dev/mapper/VG0-LV7 49G 180M 46G 1% /b01
/dev/sda1 494M 17M 452M 4% /boot
tmpfs 8.0G 4.9M 8.0G 1% /dev/shm
/dev/mapper/VG0-LV10 448G 297G 245M 100% /backup

rman target / < alter database open;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,number_of_files as "number" from v$flash_recovery_area_usage;

FILE_TYPE USED RECLAIMABLE number
-------------------- ---------- ----------- ----------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 15.12 0 68
BACKUP PIECE 52.83 29.42 131
IMAGE COPY 0 0 0
FLASHBACK LOG 1.44 .74 250
FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.

SQL>