RMAN备份恢复之SPFILE的恢复.docx

RMAN备份恢复之SPFILE的恢复（一）缺少初始化文件，数据库是无法启动的。如果通过RMAN备份了初始化参数，那么可以通过RMAN对初始化参数进行恢复。这篇文章简单介绍CATALOG方式下初始化参数的恢复问题。初始化参数的丢失和损坏，并不会造成太严重的问题，即使是最坏的情况，导致无法进行恢复，也是可以通过手工编辑一个新的PFILE文件，来启动实例的。而且，在数据库的alert文件中包含了每次数据库启动使用的所有非默认值初始化参数，因此重新编写一个初始化参数并不困难。不过，既然对SPFILE进行了备份，那么完全可以采用恢复的方式来还原SPFILE。对于CATALOG方式，SPFILE的恢复相对简单很多。不过Oracle文档上对于SPFILE的恢复的描述有些小问题：SET DBID这个步骤是不能省略的，否则会报错。$ rman target / catalog rman/rman@testcenRecovery Manager: Release .0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database (not started)connected to recovery catalog databaseRMAN startup force nomount;startup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file /opt/ora9/product/9.2/dbs/inittestdata.oratrying to start the Oracle instance without parameter files ...Oracle instance startedTotal System Global AreabytesFixed Size 451864 bytesVariable SizebytesDatabase BuffersbytesRedo Buffers 667648 bytesRMAN restore spfile;Starting restore at 27-6月 -07RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 06/27/2007 10:36:46RMAN-12010: automatic channel allocation initialization failedRMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog正确的方式如下：$ rman target / catalog rman/rman@testcenRecovery Manager: Release .0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: DUMMY (not mounted)connected to recovery catalog databaseRMAN set dbid 2270762593;executing command: SET DBIDRMAN startup force nomountstartup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file /opt/ora9/product/9.2/dbs/inittestdata.oratrying to start the Oracle instanc