又一例SPFILE设置错误导致数据库无法启动

--========================================--又一例SPFILE设置错误导致数据库无法启动--======================================== SPFILE参数错误，容易导致数据库无法启动。关于SPFILE设置错误处理办法的总结，请参照：SPFILE错误导致数据库无法启动 http://www.linuxidc.com/Linux/2013-08/88932.htm 此次的情况与上次的稍有不同，故列出该次的恢复过程故障SQL> startupORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translatedORA-07286: sksagdi: cannot obtain device information.Linux Error: 2: No such file or directory 分析SQL> ho cat /u01/app/Oracle/admin/orcl/bdump/alert_orcl.log--查看告警日志Tue Aug3 10:38:25 2010ALTER SYSTEM SET log_archive_dest="u01/app/oracle/archivelog1" SCOPE=SPFILE; --此处路径开始处少了"/"Tue Aug3 10:39:59 2010ALTER SYSTEM SET log_archive_duplex_dest="/u01/app/oracle/archivelog2" SCOPE=SPFILE;Tue Aug3 10:40:25 2010Incremental changes to log_archive_dest_1 not allowed with SPFILETue Aug3 10:40:43 2010ALTER SYSTEM SET log_archive_dest_1="location=/u01/app/oracle/archivelog3" SCOPE=SPFILE;Tue Aug3 10:40:57 2010ALTER SYSTEM SET log_archive_dest_2="location=/u01/app/oracle/archivelog4" SCOPE=SPFILE;Tue Aug3 10:41:02 2010Starting background process EMN0EMN0 started with pid=21, OS id=3944Tue Aug3 10:41:02 2010Shutting down instance: further logons disabled--实例开始关闭Tue Aug3 10:41:03 2010Stopping background process QMNCTue Aug3 10:41:04 2010Stopping background process CJQ0Tue Aug3 10:41:05 2010Stopping background process MMNLTue Aug3 10:41:06 2010Stopping background process MMONTue Aug3 10:41:07 2010Shutting down instance （immediate）License high water mark = 7Tue Aug3 10:41:07 2010Stopping Job queue slave processesTue Aug3 10:41:12 2010Process OS id : 3942 alive after killErrors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_3859.trcTue Aug3 10:41:12 2010Job queue slave processes stoppedAll dispatchers and shared servers shutdownTue Aug3 10:41:14 2010ALTER DATABASE CLOSE NORMALTue Aug3 10:41:15 2010SMON: disabling tx recoverySMON: disabling cache recoveryTue Aug 3 10:41:15 2010Shutting down archive processesArchiving is disabledTue Aug3 10:41:20 2010ARCH shutting downARC1: Archival stoppedTue Aug3 10:41:25 2010ARCH shutting downARC0: Archival stoppedTue Aug3 10:41:26 2010Thread 1 closed at log sequence 46Successful close of redo thread 1Tue Aug3 10:41:26 2010Completed: ALTER DATABASE CLOSE NORMALTue Aug3 10:41:26 2010ALTER DATABASE DISMOUNTCompleted: ALTER DATABASE DISMOUNTARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeTue Aug3 10:41:49 2010--至此所有的进程都被关闭Starting ORACLE instance （normal）--启动后仅出现了行提示LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2 SQL> ho ps -ef | grep oracle--后台进程被关闭root379637640 10:28 pts/000:00:00 su - oracleoracle379737960 10:29 pts/000:00:00 -bashoracle382937970 10:29 pts/000:00:00 /usr/bin/perl -w /usr/bin/uniread sqlplus / as sysdbaoracle383038290 10:29 pts/100:00:00 sqlplusas sysdbaoracle394738301 10:41 ？00:00:02 oracleorcl （DESCRIPTION=（LOCAL=YES）（ADDRESS=（PROTOCOL=beq）））oracle395338300 10:43 pts/100:00:00 /bin/bash -c ps -ef | grep oracleoracle395439530 10:43 pts/100:00:00 ps -ef SQL>ho strings /u01/app/oracle/10g/dbs/spfileorcl.ora--查看spfileorcl的信息 orcl.__db_cache_size=167772160orcl.__java_pool_size=4194304orcl.__large_pool_size=4194304orcl.__shared_pool_size=71303168orcl.__streams_pool_size=0*.audit_file_dest="/u01/app/oracle/admin/orcl/adump"*.background_dump_dest="/u01/app/oracle/admin/orcl/bdump"*.compatible="10.2.0.1.0"*.control_files="/u01/app/oracle/oradata/orcl/control01.ctl","/u01/app/oracle/oradata/orcl/control02.ctl"*.core_dump_dest="/u01/app/oracle/admin/orcl/cdump"*.db_block_size=8192*.db_domain=""*.db_file_multiblock_read_count=16*.db_name="orcl"*.db_recovery_file_dest="/u01/app/oracle/flash_recovery_area"*.db_recovery_file_dest_size=2147483648*.dispatchers="（PROTOCOL=TCP）（SERVICE=orclXDB）"*.fast_start_mttr_target=30*.job_queue_processes=10*.log_archive_dest_1="location=/u01/app/oracle/archivelog3"*.log_archive_dest_2="location=/u01/app/oracle/archivelog4"*.log_archive_dest_state_2="ENABLE"*.log_archive_dest="u01/app/oracle/archivelog1"--同告警日志提示的一样，路径开始处少了"/"*.log_archive_duplex_dest="/u01/app/oracle/archivelog2"*.log_archive_format="arc_%t_%s_%r.arc"*.open_cursors=300*.pga_aggregate_target=83886080*.processes=150*.remote_login_passwordfile="EXCLUSIVE"*.sga_target=251658240*.undo_management="AUTO"*.undo_tablespace="UNDOTBS1"*.user_dump_dest="/u01/app/oracle/admin/orcl/udump" 解决SQL> vim /u01/app/oracle/10g/dbs/initorcl.ora--由于没有备份的参数文件，在此新建一个pfile.--如果有内容可以先清空其内容然后再添加如下内容并保存spfile="/u01/app/oracle/10g/dbs/spfileorcl.ora"log_archive_dest="/u01/app/oracle/archivelog1/" SQL> startup pfile = "$ORACLE_HOME/dbs/initorcl.ora";--再次提示错误，原来是归档方式不兼容导致ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST --根据上面的错误提示在使用LOG_ARCHIVE_DEST_1不能同时指定LOG_ARCHIVE_DEST和LOG_ARCHIVE_DUPLEX_DEST参数--再次修改initorcl.ora，添加以下内容，添加后的结果如下--注意此处是将log_archive_dest_1和log_archive_dest_2清空--也可以将log_archive_dest和log_archive_duplex_dest置空，因为这是两种不同的归档方式，互不兼容 SQL> ho cat /u01/app/oracle/10g/dbs/initorcl.ora--查看修改后的初始化参数spfile="/u01/app/oracle/10g/dbs/spfileorcl.ora"log_archive_dest="/u01/app/oracle/archivelog1/"log_archive_dest_1=""log_archive_dest_2="" SQL> startup pfile = "/u01/app/oracle/10g/dbs/initorcl.ora";ORACLE instance started. Total System Global Area251658240 bytesFixed Size1218796 bytesVariable Size79693588 bytesDatabase Buffers167772160 bytesRedo Buffers2973696 bytesDatabase mounted.Database opened. SQL> show parameter pfile; NAMETYPEVALUE------------------------------------ ----------- ------------------------------spfilestring/u01/app/oracle/10g/dbs/spfileorcl.oraSQL> show parameter spfile; NAMETYPEVALUE------------------------------------ ----------- ------------------------------spfilestring/u01/app/oracle/10g/dbs/spfileorcl.ora SQL> desc v$spparameterNameNull？Type----------------------------------------- -------- ----------------------------SIDVARCHAR2（80）NAMEVARCHAR2（80）VALUEVARCHAR2（255）DISPLAY_VALUEVARCHAR2（255）ISSPECIFIEDVARCHAR2（6）ORDINALNUMBERUPDATE_COMMENTVARCHAR2（255） SQL> select distinct isspecified from v$spparameter; ISSPEC------TRUE--第一行为true 可以知道数据库使用spfile参数启动FALSE SQL> show parameter log_archive--查看log_archive相关参数 NAMETYPEVALUE------------------------------------ ----------- ------------------------------log_archive_configstringlog_archive_deststring/u01/app/oracle/archivelog1/--该参数已显示正确路径log_archive_dest_1string--该参数已经被初始化的pfile置空log_archive_dest_10stringlog_archive_dest_2string--该参数已经被初始化的pfile置空log_archive_dest_3stringlog_archive_dest_4stringlog_archive_dest_5stringlog_archive_dest_6stringlog_archive_dest_7stringlog_archive_dest_8 string NAMETYPEVALUE------------------------------------ ----------- ------------------------------log_archive_dest_9stringlog_archive_dest_state_1stringenablelog_archive_dest_state_10stringenablelog_archive_dest_state_2stringENABLElog_archive_dest_state_3stringenablelog_archive_dest_state_4stringenablelog_archive_dest_state_5stringenablelog_archive_dest_state_6stringenablelog_archive_dest_state_7stringenablelog_archive_dest_state_8stringenablelog_archive_dest_state_9stringenable NAMETYPEVALUE------------------------------------ ----------- ------------------------------log_archive_duplex_deststring/u01/app/oracle/archivelog2log_archive_formatstringarc_%t_%s_%r.arclog_archive_local_firstbooleanTRUElog_archive_max_processesinteger2log_archive_min_succeed_destinteger1log_archive_startbooleanFALSElog_archive_traceinteger0 --将出现错误的几个参数永久化修改到spfile参数SQL> alter system set log_archive_dest = "/u01/app/oracle/archivelog1" scope = spfile; System altered. SQL> alter system set log_archive_dest_1 = "" scope = spfile; System altered. SQL> alter system set log_archive_dest_2 = "" scope = spfile; System altered. SQL> startup--实例正常从spfile 启动ORACLE instance started. Total System Global Area251658240 bytesFixed Size1218796 bytesVariable Size79693588 bytesDatabase Buffers167772160 bytesRedo Buffers2973696 bytesDatabase mounted.Database opened. SQL> create pfile = "$ORACLE_HOME/dbs/spfileorcl.ora.bak" from spfile; File created.--备份spfile更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12SPFILE 错误导致数据库无法启动（ORA-01565）配置sqlnet.ora 限制IP访问Oracle相关资讯 spfile

SPFILE导致Oracle数据库启动失败（07/18/2014 09:51:18）
11.2环境ASM实例spfile放在ASM磁盘（05/16/2014 09:11:42）
RMAN还原相关概念、spfile、（04/28/2014 18:02:30）

11G RAC重建ASM实例的SPFILE （06/18/2014 13:02:58）
RAC环境中spfile和pfile互转注意事（05/16/2014 09:07:42）
使用SPFILE将所配置的初始化参数重（10/28/2013 17:20:34）

本文评论查看全部评论（0）