Oracle10g ASM生产数据库进行备份恢复测试

核心提示：新的10g ASM生产数据库即将上线，以下是上线前做的简单的备份恢复测试:1.首先执行备份$ rman target / @full_bak.sqlRecovery Manager: Release 10.1.0.3.0 - 64bit ProductionCopyright (c) 1995, 2004, Oracl

新的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