ASM磁盘组异机迁移 - 数据库编程

ng file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Sun Feb 08 03:18:25 2015 minact-scn: Inst 1 is now the master inc#:2 mmon proc-id:15768 status:0x7 minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000 Database Characterset is ZHS16GBK No Resource Manager plan active Sun Feb 08 03:18:30 2015 Starting background process GTX0 Sun Feb 08 03:18:30 2015 GTX0 started with pid=34, OS id=15838 Starting background process RCBG Sun Feb 08 03:18:30 2015 RCBG started with pid=35, OS id=15840 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC Sun Feb 08 03:18:36 2015 QMNC started with pid=36, OS id=15857 Sun Feb 08 03:18:53 2015 Completed: ALTER DATABASE OPEN Sun Feb 08 03:19:01 2015 Starting background process CJQ0 Sun Feb 08 03:19:01 2015 CJQ0 started with pid=41, OS id=15920 Sun Feb 08 03:19:10 2015 Decreasing number of real time LMS from 1 to 0 Sun Feb 08 03:19:13 2015 db_recovery_file_dest_size of 4407 MB is 5.08% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup.
数据库启动成功，查看数据文件：

SQL> select name from v$dbfile;

NAME
--------------------------------------------------------------------------------
+ZBDBA/test/datafile/users.259.870904095
+ZBDBA/test/datafile/undotbs1.258.870904095
+ZBDBA/test/datafile/sysaux.257.870904095
+ZBDBA/test/datafile/system.256.870904095
+ZBDBA/test/datafile/undotbs2.267.870904553
+ZBDBA/test/datafile/zbdba.273.870905233

6 rows selected.

SQL> conn zbdba/oracle;
Connected.
SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
HUIHUI                         TABLE
XIONGGE                        TABLE
ZBDBA                          TABLE

发现实例不存在crs资源中：

[grid@zbdba1 /]$ srvctl stop database -d test
PRCD-1120 : The resource for database test could not be found.
PRCR-1001 : Resource ora.test.db does not exist


[root@zbdba1 ~]# crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    zbdba1     
ora....ER.lsnr ora....er.type ONLINE    ONLINE    zbdba1     
ora....N1.lsnr ora....er.type ONLINE    ONLINE    zbdba2     
ora.asm        ora.asm.type   ONLINE    ONLINE    zbdba1     
ora.cvu        ora.cvu.type   ONLINE    ONLINE    zbdba1     
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora....network ora....rk.type ONLINE    ONLINE    zbdba1     
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    zbdba1     
ora.ons        ora.ons.type   ONLINE    ONLINE    zbdba1     
ora....ry.acfs ora....fs.type ONLINE    ONLINE    zbdba1     
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    zbdba2     
ora....SM1.asm application    ONLINE    ONLINE    zbdba1     
ora....A1.lsnr application    ONLINE    ONLINE    zbdba1     
ora.zbdba1.gsd application    OFFLINE   OFFLINE              
ora.zbdba1.ons application    ONLINE    ONLINE    zbdba1     
ora.zbdba1.vip ora....t1.type ONLINE    ONLINE    zbdba1     
ora....SM2.asm application    ONLINE    ONLINE    zbdba2     
ora....A2.lsnr application    ONLINE    ONLINE    zbdba2     
ora.zbdba2.gsd application    OFFLINE   OFFLINE              
ora.zbdba2.ons application    ONLINE    ONLINE    zbdba2     
ora.zbdba2.vip ora....t1.type ONLINE    ONLINE    zbdba2

9、将实例加入到crs资源中

[oracle@zbdba1 dbs]$ /opt/grid/products/11.2.0/bin/srvctl a

ASM磁盘组异机迁移(七)