Oracle 11g数据库参数文件误删除恢复(5)

This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1, which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.


第八步:调整
pfile参数文件,并创建spfile文件后启动

打开pfile文件,可以看到两个弃用的参数后面都有注释“#Deprecate parameter”

将两个废弃的参数注释,然后生成spfile文件后启动

SYS@cams>create spfile from pfile;

File created.

SYS@cams>startup;

ORACLE instance started.

Total System Global Area 776646656 bytes

Fixed Size        2257272 bytes

Variable Size        482348680 bytes

Database Buffers    285212672 bytes

Redo Buffers        6828032 bytes

Database mounted.

Database opened.

第九步:模拟在第六步的时候未能及时发现参数文件被误删除,然后数据库关闭了,启动的时候报错。

[oracle@ora11g dbs]$ ls

backup hc_cams.dat initcams.ora lkCAMS orapwcams spfilecams.ora

[oracle@ora11g dbs]$ mkdir backup1

[oracle@ora11g dbs]$ mv initcams.ora spfilecams.ora backup1/

[oracle@ora11g dbs]$ ls backup1/

initcams.ora spfilecams.ora

[oracle@ora11g dbs]$ ls

backup backup1 hc_cams.dat lkCAMS orapwcams

SYS@cams>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@cams>startup;

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initcams.ora'

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/ddce8123c090d832ce209c71c8aab35d.html