|
执行rman恢复的时候报错
RMAN> alter database mount;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/03/2016 21:29:13
ORA-01103: database name 'POWERDES' in control file is not 'PDUNQ'
RMAN> exit
解决方案：
SQL> create pfile='/oracle/pfile.12' from spfile;
File created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@pldb1 ~]$ vim /oracle/pfile.12
*.db_name='powerdes' #这里原来是pdunq，将之换成powerdes即可，然后保存退出
[oracle@pldb1 ~]$ rlwrap sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 3 21:39:56 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> create spfile from pfile='/oracle/pfile.12';
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1453092864 bytes
Fixed Size 2213416 bytes
Variable Size 855640536 bytes
Database Buffers 587202560 bytes
Redo Buffers 8036352 bytes
SQL>
然后重新rman退出登录执行alter操作搞定，可以alter database mount了
[oracle@pldb1 ~]$ rlwrap rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Feb 3 21:40:55 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: POWERDES (not mounted)
RMAN> restore controlfile to '/home/oradata/powerdes/control01.ctl' from '/oracle/c-3391761643-20160203-01';
Starting restore at 03-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 03-FEB-16
RMAN> restore controlfile to '/oracle/app/oracle/flash_recovery_area/powerdes/control02.ctl' from '/oracle/c-3391761643-20160203-01';
Starting restore at 03-FEB-16
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 03-FEB-16
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN>
|
