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

 新的10g asm消费数据库行将上线，以次是上线前做的大略的备份回复尝试:1.开始实行备份$ rman target / @full_bak.sql recovery manager: release 10.1.0.3.0 - 64bit productioncopyright (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-05current log archivedusing target database controlfile instead of recovery catalogallocated channel: ora_disk_1channel ora_disk_1: sid=162 devtype=diskchannel ora_disk_1: starting archive log backupsetchannel ora_disk_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=28 recid=2 stamp=555502358channel ora_disk_1: starting piece 1 at 13-apr-05channel ora_disk_1: finished piece 1 at 13-apr-05piece handle=/msflsh/mmsdb/backupset/2005_04_13/o1_mf_annnn_tag20050413t101239_15s00ry0_.bkp comment=nonechannel ora_disk_1: backup set complete, elapsed time: 00:00:02channel 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=555502358finished backup at 13-apr-05starting backup at 13-apr-05using channel ora_disk_1channel ora_disk_1: starting full datafile backupsetchannel ora_disk_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=+datadg/mmsdb/datafile/system.259.3input datafile fno=00003 name=+datadg/mmsdb/datafile/sysaux.257.3input datafile fno=00002 name=+datadg/mmsdb/datafile/undotbs1.258.3input datafile fno=00004 name=+datadg/mmsdb/datafile/users.256.3channel ora_disk_1: starting piece 1 at 13-apr-05channel ora_disk_1: finished piece 1 at 13-apr-05piece handle=/msflsh/mmsdb/backupset/2005_04_13/o1_mf_nnndf_tag20050413t101242_15s00thq_.bkp comment=nonechannel ora_disk_1: backup set complete, elapsed time: 00:00:15finished backup at 13-apr-05starting backup at 13-apr-05current log archivedusing channel ora_disk_1channel ora_disk_1: starting archive log backupsetchannel ora_disk_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=29 recid=3 stamp=555502377channel ora_disk_1: starting piece 1 at 13-apr-05channel ora_disk_1: finished piece 1 at 13-apr-05piece handle=/msflsh/mmsdb/backupset/2005_04_13/o1_mf_annnn_tag20050413t101257_15s01bwm_.bkp comment=nonechannel ora_disk_1: backup set complete, elapsed time: 00:00:02channel 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=555502377finished backup at 13-apr-05starting control file and spfile autobackup at 13-apr-05piece handle=/msflsh/mmsdb/autobackup/2005_04_13/o1_mf_s_555502380_15s01df2_.bkp comment=nonefinished control file and spfile autobackup at 13-apr-05rman retention policy will be applied to the commandrman retention policy is set to redundancy 2using channel ora_disk_1no obsolete backups foundrecovery manager complete.

2.停止ha,遏止数据库举行回复 $ iduid=101(oracle) gid=101(dba)$ exit# iduid=0(root) gid=1(other)# hagrp -freeze mmsdb -persistent# su - oraclesun microsystems inc. sunos 5.8 generic patch october 2001you have new mail.$ iduid=101(oracle) gid=101(dba)$ sqlplus "/ as sysdba"sql*plus: release 10.1.0.3.0 - production on wed apr 13 10:19:28 2005copyright (c) 1982, 2004, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.1.0.3.0 - 64bit productionwith the partitioning and data mining optionssql> shutdown immediate;database closed.database dismounted.oracle instance shut down.sql> exitdisconnected from oracle database 10g enterprise edition release 10.1.0.3.0 - 64bit productionwith the partitioning and data mining options

3.实行回复 $ rman target /recovery manager: release 10.1.0.3.0 - 64bit productioncopyright (c) 1995, 2004, oracle. all rights reserved.connected to target database (not started)rman> startup mount;oracle instance starteddatabase mountedtotal system global area 3204448256 bytesfixed size 1304912 bytesvariable size 651957936 bytesdatabase buffers 2550136832 bytesredo buffers 1048576 bytesrman> restore database;starting restore at 13-apr-05using target database controlfile instead of recovery catalogallocated channel: ora_disk_1channel ora_disk_1: sid=160 devtype=diskchannel ora_disk_1: starting datafile backupset restorechannel ora_disk_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to +datadg/mmsdb/datafile/system.259.3restoring datafile 00002 to +datadg/mmsdb/datafile/undotbs1.258.3restoring datafile 00003 to +datadg/mmsdb/datafile/sysaux.257.3restoring datafile 00004 to +datadg/mmsdb/datafile/users.256.3channel ora_disk_1: restored backup piece 1piece handle=/msflsh/mmsdb/backupset/2005_04_13/o1_mf_nnndf_tag20050413t101242_15s00thq_.bkp tag=tag20050413t101242channel ora_disk_1: restore completefinished restore at 13-apr-05rman> recover database;starting recover at 13-apr-05using channel ora_disk_1starting media recoverymedia recovery completefinished recover at 13-apr-05rman> alter database open;database openedrman>

4.结果不要忘怀冻结ha $ exit# iduid=0(root) gid=1(other)# hagrp -unfreeze mmsdb -persistent

尝试进程，仅供参考.