單例項恢復至RAC
環境介紹
單例項 RAC資料庫
OEL+Oracle 11.2.0.3 OEL+Oracle 11.2.0.3
1、備份單例項資料庫
run {
backup as compressed backupset filesperset 2 database format '/home/oracle/db_full_%d_%T_%s.bak';
sql 'alter system archive log current';
backup as compressed backupset archivelog all format '/home/oracle/arch_%d_%T_%s.bak';
backup current controlfile format '/home/oracle/ctl_%d_%T_%s.bak';
}
2、準備初始化引數檔案
jzh1.__db_cache_size=520093696
jzh2.__db_cache_size=520093696
jzh1.__java_pool_size=16777216
jzh2.__java_pool_size=16777216
jzh1.__large_pool_size=16777216
jzh2.__large_pool_size=16777216
jzh1.__pga_aggregate_target=587202560
jzh2.__pga_aggregate_target=587202560
jzh1.__sga_target=855638016
jzh2.__sga_target=855638016
jzh1.__shared_io_pool_size=0
jzh2.__shared_io_pool_size=0
jzh1.__shared_pool_size=285212672
jzh2.__shared_pool_size=285212672
jzh1.__streams_pool_size=0
jzh2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/jzh/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/jzh/controlfile/current.272.879168089','+ARCH/jzh/controlfile/current.258.879168089'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='jzh'
*.db_recovery_file_dest='+ARCH'
*.db_recovery_file_dest_size=6005194752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=jzhXDB)'
jzh1.instance_number=1
jzh2.instance_number=2
*.log_archive_dest_1='LOCATION=+ARCH'
*.log_archive_format='%t_%s_%r.arc'
*.memory_target=1438646272
*.open_cursors=300
*.processes=150
*.remote_listener='192.168.1.206:1521'
*.remote_login_passwordfile='exclusive'
jzh2.thread=2
jzh1.thread=1
jzh2.undo_tablespace='UNDOTBS2'
jzh1.undo_tablespace='UNDOTBS1'
3、啟動資料庫到nomount狀態
[oracle@jzh1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 7 16:10:23 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
[oracle@jzh1 tmp]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri May 8 14:43:54 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/tmp/initjzh.ora';
ORACLE instance started.
Total System Global Area 1436389376 bytes
Fixed Size 2228384 bytes
Variable Size 905973600 bytes
Database Buffers 520093696 bytes
Redo Buffers 8093696 bytes
4、恢復控制檔案
[oracle@jzh1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 7 16:12:40 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: JZH (not mounted)
RMAN> restore controlfile from '/home/oracle/ctl_JZH_20150507_26.bak';
Starting restore at 07-MAY-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=144 instance=jzh1 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/jzh/controlfile/control01.ctl
output file name=+ARCH/jzh/controlfile/control02.ctl
Finished restore at 07-MAY-15
5、啟動資料庫至mount狀態開始恢復
[oracle@jzh1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 7 16:18:27 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> alter database mount;
Database altered.
[oracle@jzh1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 7 16:19:16 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: JZH (DBID=233255254, not open)
RMAN> run {
2> set newname for database to '+DATA';
3> restore database;
4> switch datafile all;
5> catalog backuppiece '/home/oracle/arch_JZH_20150507_25.bak';
6> }
executing command: SET NEWNAME
Starting restore at 07-MAY-15
Starting implicit crosscheck backup at 07-MAY-15
allocated channel: ORA_DISK_1
Crosschecked 23 objects
Finished implicit crosscheck backup at 07-MAY-15
Starting implicit crosscheck copy at 07-MAY-15
using channel ORA_DISK_1
Finished implicit crosscheck copy at 07-MAY-15
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA
channel ORA_DISK_1: restoring datafile 00002 to +DATA
channel ORA_DISK_1: reading from backup piece /home/oracle/db_full_JZH_20150507_22.bak
channel ORA_DISK_1: piece handle=/home/oracle/db_full_JZH_20150507_22.bak tag=TAG20150507T151036
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to +DATA
channel ORA_DISK_1: restoring datafile 00004 to +DATA
channel ORA_DISK_1: reading from backup piece /home/oracle/db_full_JZH_20150507_23.bak
channel ORA_DISK_1: piece handle=/home/oracle/db_full_JZH_20150507_23.bak tag=TAG20150507T151036
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 07-MAY-15
datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=879094330 file name=+DATA/jzh/datafile/system.267.879094229
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=879094331 file name=+DATA/jzh/datafile/sysaux.262.879094229
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=879094331 file name=+DATA/jzh/datafile/undotbs1.260.879094285
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=879094331 file name=+DATA/jzh/datafile/users.256.879094285
cataloged backup piece
backup piece handle=/home/oracle/arch_JZH_20150507_25.bak RECID=24 STAMP=879094331
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 967172 generated at 05/07/2015 15:10:36 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/fast_recovery_area/JZH/archivelog/2015_05_07/o1_mf_1_128_bnp44s6
7_.arc
ORA-00280: change 967172 for thread 1 is in sequence #128
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/u01/app/oracle/fast_recovery_area/JZH/archivelog/2015_05_07/o1_mf_1_128_bnp44s
67_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/u01/app/oracle/fast_recovery_area/JZH/archivelog/2015_05_07/o1_mf_1_128_bnp44s
67_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '+DATA/jzh/datafile/undotbs1.260.879094285'
6、rename重做日誌
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ----------------------------------------
1 /u01/app/oracle/oradata/jzh/redo01.log
2 /u01/app/oracle/oradata/jzh/redo02.log
3 /u01/app/oracle/oradata/jzh/redo03.log
SQL> alter database rename file '/u01/app/oracle/oradata/jzh/redo01.log' to '+DATA';
Database altered
SQL> alter database rename file '/u01/app/oracle/oradata/jzh/redo02.log' to '+DATA';
Database altered.
SQL> alter database rename file '/u01/app/oracle/oradata/jzh/redo03.log' to '+DATA';
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '+DATA/jzh/datafile/undotbs1.262.879173283'
SQL> alter database datafile 3 offline;
Database altered.
SQL> alter database datafile 4 offline;
Database altered.
7、以resetlogs開啟資料庫
SQL> alter database open resetlogs;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database add logfile thread 1 group 3 ('+DATA','+ARCH') size 50M;
Database altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database add logfile thread 2 group 2 ('+DATA','+ARCH') size 50M;
Database altered.
SQL> alter database add logfile thread 2 group 4 ('+DATA','+ARCH') size 50M;
Database altered.
SQL> select group#,member from v$logfile order by group#;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 +DATA/jzh/onlinelog/group_1.264.879173771
1 +ARCH/jzh/onlinelog/group_1.261.879173773
2 +ARCH/jzh/onlinelog/group_2.271.879174165
2 +DATA/jzh/onlinelog/group_2.273.879174165
3 +DATA/jzh/onlinelog/group_3.256.879174125
3 +ARCH/jzh/onlinelog/group_3.260.879174125
4 +ARCH/jzh/onlinelog/group_4.259.879174203
4 +DATA/jzh/onlinelog/group_4.276.879174201
8 rows selected.
8、啟用thread 2
SQL> alter database enable public thread 2;
Database altered.
SQL> create undo tablespace undotbs2 datafile '+DATA' size 2048M;
Tablespace created.
9、執行指令碼
@?/rdbms/admin/catclust.sql
SQL> create spfile='+DATA' from pfile='/tmp/initjzh.ora';
File created.
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/jzh/parameterfile/spfile
.270.879175181
SQL> select * from v$active_instances;
INST_NUMBER INST_NAME
----------- ------------------------------
1 jzh1.oracle.com:jzh1
2 jzh2.oracle.com:jzh2
10、新增db，instance至crs
[oracle@jzh1 ~]$ srvctl add database -d jzh -o /u01/app/oracle/product/11.2.0/db_1/
[grid@jzh1 ~]$ srvctl add instance -d jzh -n jzh1 -i jzh1
[grid@jzh1 ~]$ srvctl add instance -d jzh -n jzh2 -i jzh2
[grid@jzh1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.ARCH.dg ora....up.type 0/5 0/ ONLINE ONLINE jzh1
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE jzh1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE jzh1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE jzh2
ora.VOTE.dg ora....up.type 0/5 0/ ONLINE ONLINE jzh1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE jzh1
ora.cvu ora.cvu.type 0/5 0/0 OFFLINE OFFLINE
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora.jzh.db ora....se.type 0/2 0/1 ONLINE ONLINE jzh1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE jzh1
ora....H1.lsnr application 0/5 0/0 ONLINE ONLINE jzh1
ora.jzh1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.jzh1.ons application 0/3 0/0 ONLINE ONLINE jzh1
ora.jzh1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE jzh1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE jzh2
ora....H2.lsnr application 0/5 0/0 ONLINE ONLINE jzh2
ora.jzh2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.jzh2.ons application 0/3 0/0 ONLINE ONLINE jzh2
ora.jzh2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE jzh2
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE jzh1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE jzh2
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE jzh1
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE jzh2
單例項 RAC資料庫
OEL+Oracle 11.2.0.3 OEL+Oracle 11.2.0.3
1、備份單例項資料庫
run {
backup as compressed backupset filesperset 2 database format '/home/oracle/db_full_%d_%T_%s.bak';
sql 'alter system archive log current';
backup as compressed backupset archivelog all format '/home/oracle/arch_%d_%T_%s.bak';
backup current controlfile format '/home/oracle/ctl_%d_%T_%s.bak';
}
2、準備初始化引數檔案
jzh1.__db_cache_size=520093696
jzh2.__db_cache_size=520093696
jzh1.__java_pool_size=16777216
jzh2.__java_pool_size=16777216
jzh1.__large_pool_size=16777216
jzh2.__large_pool_size=16777216
jzh1.__pga_aggregate_target=587202560
jzh2.__pga_aggregate_target=587202560
jzh1.__sga_target=855638016
jzh2.__sga_target=855638016
jzh1.__shared_io_pool_size=0
jzh2.__shared_io_pool_size=0
jzh1.__shared_pool_size=285212672
jzh2.__shared_pool_size=285212672
jzh1.__streams_pool_size=0
jzh2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/jzh/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/jzh/controlfile/current.272.879168089','+ARCH/jzh/controlfile/current.258.879168089'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='jzh'
*.db_recovery_file_dest='+ARCH'
*.db_recovery_file_dest_size=6005194752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=jzhXDB)'
jzh1.instance_number=1
jzh2.instance_number=2
*.log_archive_dest_1='LOCATION=+ARCH'
*.log_archive_format='%t_%s_%r.arc'
*.memory_target=1438646272
*.open_cursors=300
*.processes=150
*.remote_listener='192.168.1.206:1521'
*.remote_login_passwordfile='exclusive'
jzh2.thread=2
jzh1.thread=1
jzh2.undo_tablespace='UNDOTBS2'
jzh1.undo_tablespace='UNDOTBS1'
3、啟動資料庫到nomount狀態
[oracle@jzh1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 7 16:10:23 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
[oracle@jzh1 tmp]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri May 8 14:43:54 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/tmp/initjzh.ora';
ORACLE instance started.
Total System Global Area 1436389376 bytes
Fixed Size 2228384 bytes
Variable Size 905973600 bytes
Database Buffers 520093696 bytes
Redo Buffers 8093696 bytes
4、恢復控制檔案
[oracle@jzh1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 7 16:12:40 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: JZH (not mounted)
RMAN> restore controlfile from '/home/oracle/ctl_JZH_20150507_26.bak';
Starting restore at 07-MAY-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=144 instance=jzh1 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/jzh/controlfile/control01.ctl
output file name=+ARCH/jzh/controlfile/control02.ctl
Finished restore at 07-MAY-15
5、啟動資料庫至mount狀態開始恢復
[oracle@jzh1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 7 16:18:27 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> alter database mount;
Database altered.
[oracle@jzh1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 7 16:19:16 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: JZH (DBID=233255254, not open)
RMAN> run {
2> set newname for database to '+DATA';
3> restore database;
4> switch datafile all;
5> catalog backuppiece '/home/oracle/arch_JZH_20150507_25.bak';
6> }
executing command: SET NEWNAME
Starting restore at 07-MAY-15
Starting implicit crosscheck backup at 07-MAY-15
allocated channel: ORA_DISK_1
Crosschecked 23 objects
Finished implicit crosscheck backup at 07-MAY-15
Starting implicit crosscheck copy at 07-MAY-15
using channel ORA_DISK_1
Finished implicit crosscheck copy at 07-MAY-15
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA
channel ORA_DISK_1: restoring datafile 00002 to +DATA
channel ORA_DISK_1: reading from backup piece /home/oracle/db_full_JZH_20150507_22.bak
channel ORA_DISK_1: piece handle=/home/oracle/db_full_JZH_20150507_22.bak tag=TAG20150507T151036
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to +DATA
channel ORA_DISK_1: restoring datafile 00004 to +DATA
channel ORA_DISK_1: reading from backup piece /home/oracle/db_full_JZH_20150507_23.bak
channel ORA_DISK_1: piece handle=/home/oracle/db_full_JZH_20150507_23.bak tag=TAG20150507T151036
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 07-MAY-15
datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=879094330 file name=+DATA/jzh/datafile/system.267.879094229
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=879094331 file name=+DATA/jzh/datafile/sysaux.262.879094229
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=879094331 file name=+DATA/jzh/datafile/undotbs1.260.879094285
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=879094331 file name=+DATA/jzh/datafile/users.256.879094285
cataloged backup piece
backup piece handle=/home/oracle/arch_JZH_20150507_25.bak RECID=24 STAMP=879094331
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 967172 generated at 05/07/2015 15:10:36 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/fast_recovery_area/JZH/archivelog/2015_05_07/o1_mf_1_128_bnp44s6
7_.arc
ORA-00280: change 967172 for thread 1 is in sequence #128
Specify log: {
AUTO
ORA-00308: cannot open archived log
'/u01/app/oracle/fast_recovery_area/JZH/archivelog/2015_05_07/o1_mf_1_128_bnp44s
67_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/u01/app/oracle/fast_recovery_area/JZH/archivelog/2015_05_07/o1_mf_1_128_bnp44s
67_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '+DATA/jzh/datafile/undotbs1.260.879094285'
6、rename重做日誌
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ----------------------------------------
1 /u01/app/oracle/oradata/jzh/redo01.log
2 /u01/app/oracle/oradata/jzh/redo02.log
3 /u01/app/oracle/oradata/jzh/redo03.log
SQL> alter database rename file '/u01/app/oracle/oradata/jzh/redo01.log' to '+DATA';
Database altered
SQL> alter database rename file '/u01/app/oracle/oradata/jzh/redo02.log' to '+DATA';
Database altered.
SQL> alter database rename file '/u01/app/oracle/oradata/jzh/redo03.log' to '+DATA';
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '+DATA/jzh/datafile/undotbs1.262.879173283'
SQL> alter database datafile 3 offline;
Database altered.
SQL> alter database datafile 4 offline;
Database altered.
7、以resetlogs開啟資料庫
SQL> alter database open resetlogs;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database add logfile thread 1 group 3 ('+DATA','+ARCH') size 50M;
Database altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database add logfile thread 2 group 2 ('+DATA','+ARCH') size 50M;
Database altered.
SQL> alter database add logfile thread 2 group 4 ('+DATA','+ARCH') size 50M;
Database altered.
SQL> select group#,member from v$logfile order by group#;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 +DATA/jzh/onlinelog/group_1.264.879173771
1 +ARCH/jzh/onlinelog/group_1.261.879173773
2 +ARCH/jzh/onlinelog/group_2.271.879174165
2 +DATA/jzh/onlinelog/group_2.273.879174165
3 +DATA/jzh/onlinelog/group_3.256.879174125
3 +ARCH/jzh/onlinelog/group_3.260.879174125
4 +ARCH/jzh/onlinelog/group_4.259.879174203
4 +DATA/jzh/onlinelog/group_4.276.879174201
8 rows selected.
8、啟用thread 2
SQL> alter database enable public thread 2;
Database altered.
SQL> create undo tablespace undotbs2 datafile '+DATA' size 2048M;
Tablespace created.
9、執行指令碼
@?/rdbms/admin/catclust.sql
SQL> create spfile='+DATA' from pfile='/tmp/initjzh.ora';
File created.
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/jzh/parameterfile/spfile
.270.879175181
SQL> select * from v$active_instances;
INST_NUMBER INST_NAME
----------- ------------------------------
1 jzh1.oracle.com:jzh1
2 jzh2.oracle.com:jzh2
10、新增db，instance至crs
[oracle@jzh1 ~]$ srvctl add database -d jzh -o /u01/app/oracle/product/11.2.0/db_1/
[grid@jzh1 ~]$ srvctl add instance -d jzh -n jzh1 -i jzh1
[grid@jzh1 ~]$ srvctl add instance -d jzh -n jzh2 -i jzh2
[grid@jzh1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.ARCH.dg ora....up.type 0/5 0/ ONLINE ONLINE jzh1
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE jzh1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE jzh1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE jzh2
ora.VOTE.dg ora....up.type 0/5 0/ ONLINE ONLINE jzh1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE jzh1
ora.cvu ora.cvu.type 0/5 0/0 OFFLINE OFFLINE
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora.jzh.db ora....se.type 0/2 0/1 ONLINE ONLINE jzh1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE jzh1
ora....H1.lsnr application 0/5 0/0 ONLINE ONLINE jzh1
ora.jzh1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.jzh1.ons application 0/3 0/0 ONLINE ONLINE jzh1
ora.jzh1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE jzh1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE jzh2
ora....H2.lsnr application 0/5 0/0 ONLINE ONLINE jzh2
ora.jzh2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.jzh2.ons application 0/3 0/0 ONLINE ONLINE jzh2
ora.jzh2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE jzh2
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE jzh1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE jzh2
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE jzh1
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE jzh2
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10271187/viewspace-1630726/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 從nub備份恢復（同平臺）恢復RAC至單例項單例
- rac恢復到單例項單例
- 11G RAC 異機恢復至單例項測試單例
- RAC asm恢復到單例項ASM單例
- oracle 10g rac 單例項恢復至ORACLE10G RAC RMANOracle 10g單例
- rac到單例項的rman恢復單例
- 單例項備份恢復成RAC單例
- rac asm 恢復到 單例項 1ASM單例
- rac asm 恢復到 單例項 2ASM單例
- RMAN異機恢復：RAC到單例項單例
- RAC恢復到單例項節點上單例
- 恢復rac db(raw)到單例項下單例
- 單例項備份集恢復到RAC單例
- RAC從帶庫到單例項的恢復單例
- 恢復RAC資料庫到單例項（ASM）資料庫單例ASM
- 10g rac asm 恢復到 單例項(二)ASM單例
- 10g rac asm 恢復到 單例項(一)ASM單例
- 單例項恢復RAC資料庫步驟（三）單例資料庫
- 單例項恢復RAC資料庫步驟（二）單例資料庫
- 單例項恢復RAC資料庫步驟（一）單例資料庫
- 【RAC】將單例項備份集恢復為rac資料庫單例資料庫
- 【RAC】將RAC備份集恢復為單例項資料庫單例資料庫
- oracle資料庫跨平臺（AIX）從RAC恢復至（linux）下的單例項Oracle資料庫AILinux單例
- RAC資料庫恢復到單例項資料庫資料庫單例
- 將RAC備份集恢復為單例項資料庫單例資料庫
- 【RMAN】RAC資料恢復至單機環境資料恢復
- RAC 資料庫恢復到單例項下並且基於時間點恢復資料庫單例
- Oracle 11.2.0.4 從單例項，使用RMAN 異機恢復到RACOracle單例
- 單例項環境利用備份恢復RAC資料庫（四）單例資料庫
- 單例項環境利用備份恢復RAC資料庫（三）單例資料庫
- 單例項環境利用備份恢復RAC資料庫（二）單例資料庫
- 單例項環境利用備份恢復RAC資料庫（一）單例資料庫
- 【kingsql分享】將RAC資料庫異機恢復到單例項（Ⅰ）SQL資料庫單例
- Oracle例項恢復Oracle
- 記錄一次Oracle 11.2.0.4 RAC異地恢復到單例項Oracle單例
- Oracle例項恢復和介質恢復Oracle
- oracle 11C rman 恢復到單例項Oracle單例
- SCN、Checkpoint、例項恢復介質恢復理解