内容发布更新时间 : 2024/5/23 0:48:31星期一 下面是文章的全部内容请认真阅读。

orademo2: specifying archive log(s) in backup set input archive log thread=2 sequence=4 recid=89

stamp=661826286 …………………………………………………………………. channel orademo1: finished piece 1 at 04-MAY-08 piece

handle=/backup/database/contr_28_1_661826504 tag=TAG20080504T004130 comment=NONE channel orademo1: backup set complete, elapsed time: 00:00:09 Finished backup at 04-MAY-08 released channel: orademo1 released channel: orademo2

(2)COPY节点2上的备份文件/归档日志文件到节点1相应目录下。 rac2-> scp /backup/database/*

rac1:/backup/database/ rac2-> scp /archive/demo2/* rac1:/archive/demo1

(3)恢复database RMAN>run {restore controlfile from '/backup/database/contr_28_1_661826504'; sql 'alter database mount'; restore database; recover database; sql 'alter database open resetlogs';} starting restore at 04-MAY-08 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=147 instance=demo1 devtype=DISK channel ORA_DISK_1: restoring control file channel

ORA_DISK_1: restore complete, elapsed time:

00:00:20 ………………………………………………………………………………… archive log

filename=+DATA/demo/onlinelog/group_3.265.660615545 thread=2 sequence=7 archive log

filename=+DATA/demo/onlinelog/group_4.266.660615543 thread=2 sequence=8 media recovery complete, elapsed time: 00:00:06 Finished recover at 04-MAY-08 sql

statement: alter database open resetlogs 至此，恢复完成。 生产库的备份需要缜密部署与模拟测试，不同的数据库类型也需要制定不同的方案实现。对DATABASE来说，备份重于泰山，不能抱有任何侥幸心理。