暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

对即将上线的Oracle10g ASM生产数据库进行备份恢复测试

原创 eygle 2005-04-13
675
新的10g ASM生产数据库即将上线,以下是上线前做的简单的备份恢复测试:

1.首先执行备份

$ rman target / @full_bak.sql         
Recovery Manager: Release 10.1.0.3.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: MMSDB (DBID=799462343)
RMAN> run {
2> backup database plus archivelog delete all input;
3> delete obsolete;
4> }
5>
Starting backup at 13-APR-05
current log archived
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=162 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=28 recid=2 stamp=555502358
channel ORA_DISK_1: starting piece 1 at 13-APR-05
channel ORA_DISK_1: finished piece 1 at 13-APR-05
piece handle=/msflsh/MMSDB/backupset/2005_04_13/o1_mf_annnn_TAG20050413T101239_15s00ry0_.bkp
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/msflsh/MMSDB/archivelog/2005_04_13/o1_mf_1_28_15s00pg2_.arc recid=2
stamp=555502358
Finished backup at 13-APR-05
Starting backup at 13-APR-05
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATADG/mmsdb/datafile/system.259.3
input datafile fno=00003 name=+DATADG/mmsdb/datafile/sysaux.257.3
input datafile fno=00002 name=+DATADG/mmsdb/datafile/undotbs1.258.3
input datafile fno=00004 name=+DATADG/mmsdb/datafile/users.256.3
channel ORA_DISK_1: starting piece 1 at 13-APR-05
channel ORA_DISK_1: finished piece 1 at 13-APR-05
piece handle=/msflsh/MMSDB/backupset/2005_04_13/o1_mf_nnndf_TAG20050413T101242_15s00thq_.bkp
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 13-APR-05
Starting backup at 13-APR-05
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=29 recid=3 stamp=555502377
channel ORA_DISK_1: starting piece 1 at 13-APR-05
channel ORA_DISK_1: finished piece 1 at 13-APR-05
piece handle=/msflsh/MMSDB/backupset/2005_04_13/o1_mf_annnn_TAG20050413T101257_15s01bwm_.bkp
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/msflsh/MMSDB/archivelog/2005_04_13/o1_mf_1_29_15s019mj_.arc recid=3
stamp=555502377
Finished backup at 13-APR-05
Starting Control File and SPFILE Autobackup at 13-APR-05
piece handle=/msflsh/MMSDB/autobackup/2005_04_13/o1_mf_s_555502380_15s01df2_.bkp
comment=NONE
Finished Control File and SPFILE Autobackup at 13-APR-05
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
no obsolete backups found
Recovery Manager complete.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论