oracle数据库恢复与备份(三)
database until cancel;
SQL> alter database open resetlogs;
3.丢失控制文件、重做日志文件、数据文件
RMAN> restore controlfile from autobackup;
RMAN> alter database mount;
RMAN> restore database;
SQL> recover database using backup controfile until cancel;
SQL> alter database open resetlogs;
4.初始化文件也丢失的情况
SQL> startup fpile='/app/oracle/admin/orcl/pfile/init.ora.2220136918';
RMAN> restore spfile from autobackup;
SQL> startup nomount;
其余步骤同丢失控制文件