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