今天在启动oracle的时候,提示归档路径出了问题,因为之前归档是在h:\oracle\arc,不知道什么时候,我把这个文件夹删掉了。
启动的时候报错:
C:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on 星期三 10月 12 16:08:48 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: ??????????????????????????
O/S-Error: (OS 2) ??????????????????????
我一看,应该是由于h:\oracle\arc目录不存在造成的,但是又不想再新建这个目录,就想把归档目录移动到h:\app\arc目录下。
我找到H:\app\Administrator\product\11.1.0\db_1\database\SPFILES62.ORA,打开,将里面的一个参数做了改动:
*.log_archive_dest_1='location=h:\app\arc'
然后重新startup...
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: ???????????????? 'H:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\INITS62.ORA'
心想,哎呀,坏了,spfile应该是二进制文件,我手工改保存过之后肯定把文件给损坏了,但是又没有备份!
想到之前修改spfile的方法,就试一试:
SQL> create pfile from spfile;
create pfile from spfile
*
第 1 行出现错误:
ORA-01565: error in identifying file
'%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: ?????????????? (OS 3536)
发现已经不能读取spfile了,spfile已经坏了...
这时,找到了一个解决办法:
1. 在spfile.ora所在文件夹下面建立一个inits62.ora文件(注:s62是我的实例名,如果你的实例名是orcl,那么就是新建initorcl.ora文件)
2. 将现在的spfiles62.ora里面的参数拷贝到inits62.ora中,将乱码删掉。
3. 执行下面命令:
startup pfile='H:\app\Administrator\product\11.1.0\db_1\database\INITS62.ORA'
启动正常了。
然后执行:
SQL> create spfile from pfile;
文件已创建。
OK了,spfile已经修复了。
正确的修改spfile方法:
1. create pfile from spfile;
2. 修改pfile,即inits62.ora里面相应的参数
3. create spfile from pfile;
或者使用alter system set 参数=新值 scope=spfile;
分享到:
相关推荐
主要介绍了Oracle存储过程、包、方法使用总结(推荐),需要的朋友可以参考下
df: ‘/root/.gvfs’: Transport endpoint is not connected Filesystem Size Used Avail Use% Mounted on /dev/mapper/rootvg-root 30G 25G 5.1G 84% / devtmpfs 32G 0 32G 0% /dev tmpfs 32G 640M 31G 2% /dev/shm...
look at structure x$kcbsw which is a list of all the functions that Oracle might call to visit a block You will find for 11 2 0 2 that there are 1 164 different functions for doing a logical I O do ...
The degree of a table is the number of _____ in the table. (a) keys (b) columns (c) rows (d) foreign keys Correct answer is (b) Your score on this question is: 10.00 Feedback: (b) ...
Multiagent systems:algorithmic, game-theoretic, and logical foundations
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information 数据库服务器是解决信息管理问题的核心组件。大体上说,数据库服务器 的...
Learning low-dimensional embeddings of knowledge graphs is a powerful approach used to predict unobserved or missing edges between entities. However, an open challenge in this area is developing ...
Logical Channel Descriptor and Allocation of Logical Channel Numbers
% I = ISINTEGER(A) returns a logical array, I, of the same size % as A, with 1s (TRUE) in the locations corresponding to integers % (i.e., . . . -2 -1 0 1 2 . . . )in A, and 0s (FALSE) elsewhere. % A ...
logical name of the driver device, which is requested, must be entered . Example: "!switch:D11" delivers the state of the driver device with the name "D11". This function is also available via ...
(This is a little bit of a white lie, as modern routers sometimes act as firewalls or caching components, and process Transport layer as well.) Link layer switches process link and physical layers ...
The PXF JDBC Connector now supports pushdown of OR and NOT logical filter operators when specified in a JDBC named query or in an external table query filter condition. PXF supports writing Avro-...
全面介绍了多智能体系统,这本教科书是从计算机科学的角度从运筹学,博弈论,经济学,逻辑,甚至哲学和语言学写的,而思想汇集。
E3 is a Px3 matrix containing a list of edge connections in the first two columns and edge weights in the third column NOTE: only valid with V as the first input [SID] (optional) 1xL vector of ...
McCulloch and Pitts 的经典文章。
If the table is a heap (in other words, it has no clustered index), the bookmark is a RID, which is an actual row locator in the form File#:Page#:Slot#. Finding Rows with a NC Index on a Heap ...
The main advantage of running in-process is that the system usually does not need to perform a context switch. The disadvantage to running in-process is that DLL has access to the process address ...
oracle动态性能表 学习动态性能表 第一篇--v$sysstat 2007.5.23 按照OracleDocument中的描述,v$sysstat存储自数据库实例运行那刻起就开始累计全实例(instance-wide)的资源使用情况。 类似于v$sesstat,该视图...
session logical reads db block changes execute count user commits Concurrent Trans redo size redo writes parse count (total) parse count (hard) 指标项: #IO Latency db file sequential read(ms) log ...
Optimal Flexible Architecture (OFA) 2-8 Using Optimal Flexible Architecture 2-9 Setting Environment Variables 2-11 Oracle Universal Installer (OUI) 2-13 Installing the Oracle Software 2-14 Database ...