本来默认的归档路径是flash_recovery_area
我想将归档设置为指定路径 alter system set log_archive_dest='/u01/app/oracle/oradata/archive' scope=spfile;
重启后
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 1 sequence# 34 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/jys/redo01.l难道是flash_recovery_area和log_archive_dest不可以同时使用??然后我将flash_recovery_area设置成空
然后重启数据库SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/archive
Oldest online log sequence 34
Next log sequence to archive 34
Current log sequence 36
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 34 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/jys/redo01.l请教各位前辈这是什么情况。。
我想将归档设置为指定路径 alter system set log_archive_dest='/u01/app/oracle/oradata/archive' scope=spfile;
重启后
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 1 sequence# 34 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/jys/redo01.l难道是flash_recovery_area和log_archive_dest不可以同时使用??然后我将flash_recovery_area设置成空
然后重启数据库SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/archive
Oldest online log sequence 34
Next log sequence to archive 34
Current log sequence 36
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 34 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/jys/redo01.l请教各位前辈这是什么情况。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货