数据库备份恢复--恢复数据库操作

 

恢复数据库注意事项：

 

 

1.将数据库启动到mount模式

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

 

2.从备份片中恢复数据文件

RMAN> restore database;

Starting restore at 07-SEP-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=921 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/OCP/datafile/o1_mf_system_fb8w44fm_.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/OCP/datafile/o1_mf_sysaux_fb8w44g7_.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/OCP/datafile/o1_mf_undotbs1_fb8w44gd_.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/OCP/datafile/o1_mf_users_fb8w44gz_.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/OCP/datafile/o1_mf_example_fb8w6fnx_.dbf
channel ORA_DISK_1: reading from backup piece /u01/FRA/OCP/backupset/2018_09_07/o1_mf_nnndf_TAG20180907T082038_fs4v8q06_.bkp
channel ORA_DISK_1: piece handle=/u01/FRA/OCP/backupset/2018_09_07/o1_mf_nnndf_TAG20180907T082038_fs4v8q06_.bkp tag=TAG20180907T082038
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:45
Finished restore at 07-SEP-18

 

3.通过备份归档或者本地归档和在线redo前滚数据库

RMAN> recover database;

Starting recover at 07-SEP-18
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:04

Finished recover at 07-SEP-18

 

4.打开数据库

RMAN> alter database open;

database opened