oracleRAC无备份情况恢复ocr和olr(六)

2014-11-24 09:16:30 · 作者: · 浏览: 8
[grid@rac-one ~]$ [grid@rac-one ~]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATADG.dg ONLINE ONLINE rac-one OFFLINE OFFLINE rac-two ora.GIDG.dg ONLINE ONLINE rac-one ONLINE ONLINE rac-two ora.LISTENER.lsnr OFFLINE OFFLINE rac-one OFFLINE OFFLINE rac-two ora.asm ONLINE ONLINE rac-one Started ONLINE ONLINE rac-two Started ora.gsd OFFLINE OFFLINE rac-one OFFLINE OFFLINE rac-two ora.net1.network ONLINE ONLINE rac-one ONLINE ONLINE rac-two ora.ons ONLINE ONLINE rac-one ONLINE ONLINE rac-two ora.registry.acfs ONLINE ONLINE rac-one ONLINE ONLINE rac-two -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac-one ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE rac-two ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE rac-two ora.cvu 1 ONLINE ONLINE rac-two ora.oc4j 1 ONLINE ONLINE rac-two ora.rac-one.vip 1 ONLINE ONLINE rac-one ora.rac-two.vip 1 ONLINE ONLINE rac-two ora.scan1.vip 1 ONLINE ONLINE rac-one ora.scan2.vip 1 ONLINE ONLINE rac-two ora.scan3.vip 1 ONLINE ONLINE rac-two [grid@rac-one ~]$ 至此监听添加到ocr完毕。下面开始添加db,注意使用oracle用户:

继续添加:

[grid@rac-one ~]$ su - oracle
Password: 
[oracle@rac-one ~]$ srvctl add database -h

Adds a database configuration to the Oracle Clusterware.

Usage: srvctl add database -d  -o  [-c {RACONENODE | RAC | SINGLE} [-e ] [-i ] [-w ]] [-m ] [-p ] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s ] [-t ] [-n ] [-y {AUTOMATIC | MANUAL | NORESTART}] [-g ""] [-x ] [-a ""] [-j ""]
    -d       Unique name for the database
    -o          ORACLE_HOME path
    -c                 Type of database: RAC One Node, RAC, or Single Instance
    -e          Candidate server list for RAC One Node database
    -i            Instance name prefix for administrator-managed RAC One Node database (default first 12 characters of )
    -w              Online relocation timeout in minutes
    -x            Node name. -x option is specified for single-instance databases
    -m               Domain for database. Must be set if database has DB_DOMAIN set.
    -p               Server parameter file path
    -r                 Role of the database (primary, physical_standby, logical_standby, snapshot_standby)
    -s        Startup options for the database. Examples of startup options are OPEN, MOUNT, or 'READ ONLY'.
    -t         Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -n              Database name (DB_NAME), if different from the unique name given by the -d option
    -y             Management policy for the database (AUTOMATIC, MANUAL, or NORESTART)
    -g ""   Comma separated list of database server pool names
    -a ""    Comma separated list of disk groups
    -j ""    Comma separated list of ACFS paths where database's dependency will be set
    -h                       Print usage
[oracle@rac-one ~]$ srvctl add database -d Rac -o /u01/app/oracle/product/11.2.0/db_1/ -c RAC
[oracle@rac-one ~]$ 
[oracle@rac-one ~]$ srvctl add instance -h

Adds a database instance configuration to the Oracle Clusterware.

Usage: srvctl add insta