备份脚本如下:
run {
allocate channel ch1 type disk format '/backup/rman_%u';
backup database;
backup archivelog all;
release channel ch1;
}
现在把该数据库的所有相关文件(control file, datafile, online logfile, archive logfile, etc.)全部删除, 能否利用备份集把数据库恢复出来?
备份日志如下:
RMAN> run {
2> allocate channel ch1 type disk format '/backup/rman_%u';
3> backup database;
4> backup archivelog all;
5> release channel ch1;
6> }
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: sid=128 devtype=DISK
Starting backup at 05-OCT-09
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/product/10.2.0/db_1/oradata/db10g/system01.dbf
input datafile fno=00005 name=/backup/streams01.dbf
input datafile fno=00003 name=/u01/app/oracle/product/10.2.0/db_1/oradata/db10g/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/product/10.2.0/db_1/oradata/db10g/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/product/10.2.0/db_1/oradata/db10g/users01.dbf
channel ch1: starting piece 1 at 05-OCT-09
channel ch1: finished piece 1 at 05-OCT-09
piece handle=/backup/rman_01kr0lee tag=TAG20091005T035557 comment=NONE
channel ch1: backup set complete, elapsed time: 00:02:26
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ch1: starting piece 1 at 05-OCT-09
channel ch1: finished piece 1 at 05-OCT-09
piece handle=/backup/rman_02kr0lj0 tag=TAG20091005T035557 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:05
Finished backup at 05-OCT-09
Starting backup at 05-OCT-09
current log archived
channel ch1: starting archive log backupset
channel ch1: specifying archive log(s) in backup set
input archive log thread=1 sequence=227 recid=235 stamp=699377318
input archive log thread=1 sequence=228 recid=236 stamp=699377336
input archive log thread=1 sequence=229 recid=237 stamp=699377554
input archive log thread=1 sequence=230 recid=238 stamp=699377792
input archive log thread=1 sequence=231 recid=239 stamp=699379561
input archive log thread=1 sequence=232 recid=240 stamp=699379603
input archive log thread=1 sequence=233 recid=241 stamp=699379609
input archive log thread=1 sequence=234 recid=242 stamp=699379626
input archive log thread=1 sequence=235 recid=243 stamp=699422315
channel ch1: starting piece 1 at 05-OCT-09
channel ch1: finished piece 1 at 05-OCT-09
piece handle=/backup/rman_03kr0ljc tag=TAG20091005T035835 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:17
Finished backup at 05-OCT-09
released channel: ch1
|