备份数据库、参数文件、控制文件。
1.备份参数文件:
RMAN> backup spfile format '/backup/spfile%U';
2.备份控制文件:
RMAN> backup current controlfile format '/backup/control%U.bak';
3.备份数据库:
RMAN> backup database ;
=========================================
数据库的不完全恢复
备份参数文件、控制文件、数据库、没有备份归档和数据文件,是不能进行完全恢复的,在启动到
mount阶段的时候,会提示找不到数据文件
RMAN> restore database;
Starting restore at 08-MAR-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/08/2017 09:24:03
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
当报这种error的时候,需要用catalog start with指定数据文件路径。让备份片注册进这个地址,意思是在恢复的时候它可以通过这个地址找到数据文件 格式
catalog start with ‘/backup/';
然后就可以restore database或者是restore datafile 1这样一个一个的找。
============================================
1、确认存在数据库所需的所有备份片
[oracle@db11g rmanfull]$
ll
total 894752
-rw-r----- 1 oracle oinstall 248374272 Jul 24 15:31 arch_full2015072417qcrvcq_1_1
-rw-r----- 1 oracle oinstall 229207552 Jul 24 15:31 arch_full2015072418qcrvcq_1_1
-rw-r----- 1 oracle oinstall 4608 Jul 24 15:31 arch_full2015072419qcrvf5_1_1
-rw-r----- 1 oracle oinstall 118882304 Jul 24 15:32 ctl_DB11G_20150724_885915149.bak
-rw-r----- 1 oracle oinstall 207273984 Jul 24 15:29 full13qcrv7d_1_120150724
-rw-r----- 1 oracle oinstall 110247936 Jul 24 15:29 full14qcrv7d_1_120150724
-rw-r----- 1 oracle oinstall 1196032 Jul 24 15:30 full15qcrvbb_1_120150724
-rw-r----- 1 oracle oinstall 98304 Jul 24 15:32 spfile_DB11G_20150724_43_1.bak
[oracle@db11g rmanfull]$
2、删除数据库的参数文件、控制文件、数据文件、
redo
日志等
[oracle@db11g rmanfull]$
rm -f
$
ORACLE_HOME/dbs/spfiledb11g.ora
[oracle@db11g db11g]$
pwd
/oradata/db11g