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

ams_pool_size=0 test2.__streams_pool_size=0 *.audit_file_dest='/opt/oracle/admin/test/adump' *.audit_trail='db' *.cluster_database=true *.compatible='11.2.0.4.0' *.control_files='+ZBDBA/test/controlfile/current.261.870904273','+ZBDBA/test/controlfile/current.260.870904273' *.db_block_size=8192 *.db_create_file_dest='+ZBDBA' *.db_domain='' *.db_name='test' *.db_recovery_file_dest='+ZBDBA' *.db_recovery_file_dest_size=4621074432 *.diagnostic_dest='/opt/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)' test1.instance_number=1 test2.instance_number=2 *.memory_target=786432000 *.open_cursors=300 *.processes=150 *.remote_listener='node-cluster-scan:1521' *.remote_login_passwordfile='exclusive' test2.thread=2 test1.thread=1 test2.undo_tablespace='UNDOTBS2' test1.undo_tablespace='UNDOTBS1'

配置环境变量：

[oracle@zbdba1 ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/products/11.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=test1
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

创建目录：
mkdir -p /opt/oracle/admin/test/adump

8、启动数据库
sqlplus / as sysdba
startup

查看日志：

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /opt/oracle/products/11.2.0
System name:    Linux
Node name:      zbdba1
Release:        2.6.32-279.el6.x86_64
Version:        #1 SMP Wed Jun 13 18:24:36 EDT 2012
Machine:        x86_64
Using parameter settings in server-side pfile /opt/oracle/products/11.2.0/dbs/inittest1.ora
System parameters with non-default values:
  processes                = 150
  memory_target            = 752M
  control_files            = "+ZBDBA/test/controlfile/current.261.870904273"
  control_files            = "+ZBDBA/test/controlfile/current.260.870904273"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  cluster_database         = TRUE
  db_create_file_dest      = "+ZBDBA"
  db_recovery_file_dest    = "+ZBDBA"
  db_recovery_file_dest_size= 4407M
  thread                   = 1
  undo_tablespace          = "UNDOTBS1"
  instance_number          = 1
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=testXDB)"
  remote_listener          = "node-cluster-scan:1521"
  audit_file_dest          = "/opt/oracle/admin/test/adump"
  audit_trail              = "DB"
  db_name                  = "test"
  open_cursors             = 300
  diagnostic_dest          = "/opt/oracle"
Cluster communication is configured to use the following interface(s) for this instance
  169.254.126.87
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sun Feb 08 03:18:08 2015
PMON started with pid=2, OS id=15720
Sun Feb 08 03:18:08 2015
PSP0 started with pid=3, OS id=15722
Sun Feb 08 03:18:09 2015
VKTM started with pid=4, OS id=15724 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Feb 08 03:18:09 2015
GEN0 started with pid=5, OS id=15728
Sun Feb 08 03:18:09 2015
DIAG started with pid=6, OS id=15730
Sun Feb 08 03:18:09 2015
DBRM started with pid=7, OS id=15732
Sun Feb 08 03:18:09 2015
PING started with pid=8, OS id=15734
Sun Feb 08 03:18:09 2015
ACMS started with pid=9, OS id=15736
Sun Feb 08 03:18:09 2015
DIA0 s

ASM磁盘组异机迁移(五)