通过rman起dummy实例(之前需全库备份)
全库备份(需要在归档模式)
rman> backup database format '/opt/app/rman/full_%u.dbf'; (全库备份)
备份全库(数据文件)、控制文件、spfile、归档日志
rman> backup database include current controlfile plus archivelog format '/opt/app/rman/full_%U.dbf';
------------------------------------------------------------------------------------------------------------------------------------
删除或改名 spfile pfile,数据库将无法启动,通过rman起一个dummy数据库,改名,再起数据库 (dummy只是把spfile要回来)
rman> startup
rman> restore spfile from '/home/oracle/sp_SYTONG1_02otag5v_1.ora
$ cd $ORACLE_HOME/dbs
$ mv *dunmay.ora sytong1.ora
$ rlwrap sqlplus / as sysdba
> startup
阅读(1482) | 评论(0) | 转发(0) |