DBMS_BACUP_RESTORE恢复数据库.doc

DBMS_BACKUP_RESTORE恢复数据库+恢复archivelog RMAN ??2009-08-08 23:06 ??阅读58???评论0 ? 字号： 大大? 中中? 小小 ?? 录 ? 1，面临的问题.... 2 备份集明明存在，但是rman恢复时却报找不到备份文件的错误！... 2 如何从备份集中恢复archivelog文件？... 2 2，用dbms_backup_restore包从备份集中恢复数据库文件.... 2 2.1，rman整库备份.... 2 2.2，关闭数据库.... 3 2.3，移走所有数据文件（模拟数据库文件丢失）.... 3 2.4，启动数据库.... 3 2.5，从备份集中恢复出数据库文件（报错了！no backup）.... 3 2.6，查看备份集，里面明明有备份的数据。.... 4 2.7，用dbms_backup_restore包来恢复数据库文件.... 5 2.7.1，dbms_backup_restore的调用示例... 5 2.7.2，日志里面可以看到执行后的scn号：... 5 2.7.3，ls可以看到数据库文件成功地恢复了出来... 5 2.8，查看可用的归档日志.... 6 恢复数据库文件但未修复的情况下，尝试打开数据库时报错了！... 6 修复数据库... 7 2.9，查询备份后插入的数据有没有被恢复出来？.... 7 2.10，参考文档：.... 7 3，恢复archivelog.. 8 3.1, 恢复archivelog.. 8 3.2, 恢复指定范围的日志序列号.... 9 ? 开始啦！ 1，面临的问题 备份集明明存在，但是rman恢复时却报找不到备份文件的错误！ 如何从备份集中恢复archivelog文件？ 2，用dbms_backup_restore包从备份集中恢复数据库文件 2.1，rman整库备份 RMAN connect target ? connected to target database: BOY (DBID=1716583807) ? RMAN @/home/oracle/bak_rman.sh ? RMAN run{ 2 allocate channel c1 type disk; 3 backup full tag dbfull format /home/oracle/backup/full%u_%s_%p database 4 include current controlfile; 5 sql alter system archive log current; 6 release channel c1; 7 } using target database control file instead of recovery catalog allocated channel: c1 channel c1: sid=159 devtype=DISK ? Starting backup at 31-JUL-09 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00001 name=/opt/oracle/oradata/boy/system01.dbf input datafile fno=00003 name=/opt/oracle/oradata/boy/sysaux01.dbf input datafile fno=00002 name=/opt/oracle/oradata/boy/undotbs01.dbf input datafile fno=00004 name=/opt/oracle/oradata/boy/users01.dbf channel c1: starting piece 1 at 31-JUL-09 channel c1: finished piece 1 at 31-JUL-09 piece handle=/home/oracle/backup/full0eklgblh_14_1 tag=DBFULL comment=NONE channel c1: backup set complete, elapsed time: 00:00:16 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset including current control file in backupset including curr