恢复:
(1)恢复参数文件
RMAN> set dbid=3629171862
RMAN> restore spfile from ‘/oracle/dbbak/spfile_15trju1q_1_1_20190304’;
(2)恢复控制文件
练习:
RMAN> set dbid=3629171862(dbid可以通过select dbid from v$database;得到)
RMAN> restore controlfile from ‘/oracle/dbbak/ctl_file_16trju1r_1_1_20190304’;
(3)恢复数据文件:
删除数据文件后开始恢复:
RMAN>restore database;
RMAN>recover database;
(4)恢复归档日志:
恢复,首先要查找logseq的数值,这个在数据库的alert日志里面有。
[oracle@lilna oracle]$ sqlplus /as sysdba
SQL> archive log list;
RMAN> list backup of archivelog all;
(5)开启数据库
RMAN> alter database open resetlogs;
database opened
===========================&