Oracle 10G RAC - control_files修改后无法启库

最新推荐文章于 2023-09-13 22:47:16 发布

原创最新推荐文章于 2023-09-13 22:47:16 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #disk #less #2010 #file

Oracle 10G RAC 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了解决Oracle 10g RAC实例因control_files参数错误导致无法启动的问题过程。通过创建临时参数文件、启动实例至nomount状态、从备份集中恢复spfile并重新创建参数文件的方法成功解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

10G RAC中修改了参数control_files='+DATA/jtprod/control101.ctl,+DATA/jtprod/control103.ctl,+DATA/jtprod/control103.ctl,+RECOVERY/jtprod/control104.ctl'导致RAC实例无法启动(startup nomount无法启动),显示该参数修改有问题,读取失败.

(1)创建一个临时pfile /home/oracle/pfileJTODS.ora
[oracle@vmrac1 ~]$ less pfileJTODS.ora
*.db_name='JTODS'
*.sga_target=285212672
含参数db_name和sga_target即可.

(2)启动JTODS1至nomount状态,使用创建的pfile.
export ORACLE_SID=JTODS
SQL>startup nomount pfile='/home/oracle/pfileJTODS.ora';

(3)到备份集中寻找spfile
export ORACLE_SID=+ASM1
RMAN> restore spfile from '+RECOVERY/JTODS/BACKUPSET/2012_01_03/ncsnf0_TAG20120103T214641_0.266.771630459';
Starting restore at 04-JAN-12
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: +RECOVERY/JTODS/BACKUPSET/2012_01_03/ncsnf0_TAG20120103T214641_0.266.771630459
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 04-JAN-12
cs表示该备份含有control file和spfile.

(4)此时spfile已经更新,可以正常启动,可以相互创建.
SQL> startup
SQL> cretae pfile='/home/oracle/pfilejtods.ora' from spfile;将恢复回来的spfile创建成最新的pfile.
SQL> create spfile='+data/jtods/spfilejtods.ora' from pfile;如果需要也可以将pfile创建成spfile到ASM上.