今天oracel 9i出现一行错误,如下提示:
warning -The following error Occured during ORACLE redo log archival:
Oracle Instance zgxt - Can not allocate log,archival required:
Press enter to acknowledge message.
然后数据库就死掉了。
请求高手解决!
warning -The following error Occured during ORACLE redo log archival:
Oracle Instance zgxt - Can not allocate log,archival required:
Press enter to acknowledge message.
然后数据库就死掉了。
请求高手解决!
或者
sql>alter system archive log logfile 'on_line_log_name'
windows例子:
c:>sqlplus /nolog
sql>shutdown immediate
sql>startup mount
sql>alter database noarchivelog
sql>alter database open
sql>archive log list
先将初始化参数文件SpfileSID.ora导成initSID.ora文件,
c:\sqlplus /nolog
SQL>conn sys/password as sysdba;
SQL>create pfile=".../initSID.ora" from spfile=".../spfileSID.ORA";
之后物理修改刚创建的参数文件initSID.ora,
将参数设为:log_archive_start=false;保存关闭。
SQL>shutdown immediate
SQL>startup pfile=".../initSID.ora"
执行手工归档:
SQL>archive logfile all;
再正常启动数据库。