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

核心提示： archive log filename=/msflsh/MMSDB/archivelog/2005_04_13/o1_mf_1_29_15s019mj_.arc recid=3stamp=555502377Finished backup at 13-APR-05Starting Cont

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.

2.冻结HA,停止数据库进行恢复

$ id
uid=101(oracle) gid=101(dba)
$ exit
# id
uid=0(root) gid=1(other)
# hagrp -freeze MMSDB -persistent
# su - oracle
Sun Microsystems Inc.　 SunOS 5.8　　　 Generic Patch　 October 2001
You have new mail.
$ id
uid=101(oracle) gid=101(dba)
$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 10:19:28 2005

Copyright (c) 1982, 2004, Oracle.　All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production