在一次迁移数据库过程中,遭遇如此问题:
首先遭遇这个问题处理过程就是看告警,第二show db_recovery
查看归档路径和归档目录大小是否正常。
这里错误是由于归档目录空间不足
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 1 sequence# 47 not archived, no available destinations
ORA-00312: online log 1 thread 1:
‘/oradata/IMSBASE/onlinelog/o1_mf_1_6dnpv5f9_.log’
ORA-00312: online log 1 thread 1:
‘/oracle/flash_recovery_area/IMSBASE/onlinelog/o1_mf_1_6dnpv5rh_.log’
SQL> alter system set log_archive_start=false scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 3472883712 bytes
Fixed Size 2024792 bytes
Variable Size 738200232 bytes
Database Buffers 2717908992 bytes
Redo Buffers 14749696 bytes
Database mounted.
SQL> alter database flashback off
2 ;
Database altered.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.