#RMAN TARGET /
RMAN>SET DBID 1234567;
RMAN>STARTUP NOMOUNT;
RMAN>RESTORE CONTROLFILE FROM '/HOME/ORACLE/XXXXXX';
RMAN>ALTER DATABASE MOUNT;
RMAN>RESTORE DATABASE;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/21/2009 15:55:20
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/home/oracle/oradata/sales/system01.dbf'
原因，没有用pfile启动数据库到mount状态
首先从主服务器上面生成一个pfile文件
登陆主服务器数据库
SQL>CONN / AS SYSDBA
SQL>create pfile='/home/oracle/init.ora' from spfile;
创建成功之后将pfiile拷贝到需要恢复的服务器上面，或者在异地服务器上面用RMAN从数据库的完整备份文件中恢复pfile(recover spfile to pfile 'XXX' from '[backupset] XXX')
转回异地恢复数据库
RMAN>SHUTDOWN IMMEDIATE;
RMAN>SET DBID 1234567;
RMAN>STARTUP NOMOUNT;
RMAN>RESTORE CONTROLFILE FROM '/HOME/ORACLE/XXXXXX';--controlfile备份文件
RMAN>host
#
#sqlplus /nolog
SQL>SHUTDOWN IMMEDITE;
SQL>startup mount pfile='/home/oracle/init.ora';
RMAN>RESTORE DATABASE;
成功完成
待续
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/187805/viewspace-600698/ ，如需转载，请注明出处，否则将追究法律责任。
