+ASM STARTED

SQL> alter system set ASM_DISKSTRING='/dev/rdisk*';

--ASM_DISKSTRING参数设置，使ASM可以找到裸设备创建磁盘组

--创建ASM磁盘组为DATA

SQL> create diskgroup DATA normalredundancy

2 FAILGROUP DATA1 disk'/dev/rdisk1'

3 FAILGROUP DATA2 disk '/dev/rdisk2'

4 FAILGROUP DATA3 disk '/dev/rdisk3';

SQL> alter diskgroup DATA check all; --检查磁盘组的统一性

SQL> select name,state from v$asm_diskgroup; --查看磁盘组状态，已经mounted

NAME STATE

------------------------------ -----------

DATA MOUNTED

*****************************************************************************************

*中期目标：原库做好冷备、利用RMAN转储文件至ASM（参数文件、控制文件、数据文件）

*****************************************************************************************

--关库，为数据库做一次全备

SQL> create pfile='/home/oracle/bak/initmetro.ora' from spfile;--备份参数文件

SQL> shutdown immediate; --关库

SQL> startup mount; --启库到mount状态,做一次全备

RMAN> backup full database format'/backup/datafile_bak/level0_%s_%d.bak'; --备份数据文件

RMAN> backup archivelog all format '/backup/arch_bak/arc_%s_%p_%c';

--备份归档文件，因之前删除过无用归档，致使有过期归档文件产生

RMAN-00571:===========================================================

RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571:===========================================================

RMAN-03002:failure of backup command at 05/29/2014 15:36:44

RMAN-06059:expected archived log not found, lost of archived log compromisesrecoverability

ORA-19625:error identifying file /arch/1_190_821107190.dbf

ORA-27037:unable to obtain file status

IBM AIXRISC System/6000 Error: 2: No such file or directory

Additionalinformation: 3

RMAN> crosscheck archivelog all; --检查归档的连续性

releasedchannel: ORA_DISK_1

allocatedchannel: ORA_DISK_1

channelORA_DISK_1: sid=132 devtype=DISK

validationfailedfor archived log

archivelog filename=/arch/1_190_821107190.dbf recid=191 stamp=821547060

RMAN> delete expired archivelog all; --删除过期归档

RMAN> backup archivelog all format '/backup/arch_bak/arc_%s_%p_%c';

--再次执行备份归档文件，成功完成

SQL>startup nomount; --启库到nomount状态

[oracle@aix203]$rman target / --登录到rman

--做一次冷备，备份到ASM磁盘组

RMAN> run{

2> ALLOCATE CHANNEL c1 DEVICE TYPE DISK;

3> ALLOCATE CHANNEL c2 DEVICE TYPE DISK;

4> backup as copy database format='+DATA';

5> release channel ch1;

6> release channel ch2;

7> }

RMAN> restore spfile to '+DATA/spfilemetro.ora'; --转储spfile文件到ASM

SQL>shutdown immediate;

[aix203 oracle:/oracle]vi /u01/app/oracle/product/10.2.0/db_1/dbs/initmetro.ora

--修改$ORACLE_HOME下pfile文件，并将spfile文件重命名，令其使用pfile启动

SPFILE='+DATA/spfilemetro.ora'

SQL> startup mount; --此时查看spfile应该为ASM下的spfile启动

SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST='+DATA'; --修改数据文件指向路径为ASM

SQL> ALTER SYSTEM SET CONTROL_FILES='DATA' SCOPE=SPFILE;--修改控制文件指向路径

SQL> startup nomount; --重启库到nomount状态

RMAN> restore controlfile from'/u01/app/oracle/oradata/metro/control01.ctl';

--此时控制文件中的信息已经指向ASM，用rman完成将控制文件转储到ASM

RMAN> mount database; --将数据库启动到mount状态

RMAN> switch database to copy;

releasedchannel: ORA_DISK_1

RMAN-00571:===========================================================

RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571:===========================================================