RMAN恢复RAC+DG环境备份到单实例
1、将备份拷贝到目标
此处备份已经拷贝到目标上了，其中包括了控制文件以及SPFILE的备份集：
[root@HIS-TEST 20171222230001#1]# pwd
/u01/testdata/20171222230001#1
[root@HIS-TEST 20171222230001#1]# ll
总用量 273340952
-rwxr-xr-x. 1 oracle oinstall 0 12月 25 09:27 baktime_20171223072930
-rwxr-xr-x. 1 oracle oinstall 259675766784 12月 25 10:46 lv0.ORCL-1316909453-11705-20171222-963442803-dpsmpu3j_1_1.bak
-rwxr-xr-x. 1 oracle oinstall 21463040 12月 25 10:46 ORCL-1316909453-11709-20171223-963479226-dtsmr1lq_1_1.ctl.bak
-rwxr-xr-x. 1 oracle oinstall 10366408704 12月 25 10:49 rac_arch_ORCL_20171223_11707.bak
-rwxr-xr-x. 1 oracle oinstall 9837453824 12月 25 10:52 rac_arch_ORCL_20171223_11708.bak
[root@HIS-TEST 20171222230001#1]#
2、在目标上启动实例到nomount状态
使用RMAN在没有参数文件的情况下启动实例到nomount状态：
删除目标环境原有的spfileorcl.ora
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 22 09:04:23 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1491172128)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 939526256 bytes
Database Buffers 654311424 bytes
Redo Buffers 7360512 bytes
3、在目标上恢复参数文件
RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora' from '/u01/testdata/20171217040001#1/lv0.ORCL-
1316909453-3455-20171217-962948189-bvsmar2t_1_1.bak';
Starting restore at 22-DEC-17
using channel ORA_DISK_1
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-
1487315582-16-20171214-962726570-0gsm42la_1_1-.bak
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 22-DEC-17
注：如果这边备份集中没有备份spfile，那就需要从原生产机生成pfile文件拷贝到$ORACLE_HOME/dbs目录修改即可。
4、修改参数文件/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora
由于恢复的参数文件是RAC+DG环境下的，这里需要修改为单实例环境下的：
#orcl1.__db_cache_size=385875968
#orcl2.__db_cache_size=503316480
#orcl1.__java_pool_size=16777216
#orcl2.__java_pool_size=16777216
#orcl1.__large_pool_size=16777216
#orcl2.__large_pool_size=16777216
#orcl1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
#orcl2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
#orcl1.__pga_aggregate_target=654311424
#orcl2.__pga_aggregate_target=654311424
#orcl1.__sga_target=956301312
#orcl2.__sga_target=956301312
#orcl1.__shared_io_pool_size=0
#orcl2.__shared_io_pool_size=0
#orcl1.__shared_pool_size=520093696
#orcl2.__shared_pool_size=402653184
#orcl1.__streams_pool_size=0
#orcl2.__streams_pool_size=0
*.audit_file_dest='/u01/app /oracle/admin/orcl/adump'
*.audit_trail='db'
#*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='/u01/app /oracle/oradata/orcl/control01.ctl','/u01/app /oracle/ oradata /orcl/control02.ctl'
*.db_block_size=8192
#*.db_create_file_dest='+DATADG'
*.db_domain=''
*.db_name='orcl'
#*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
#orcl1.instance_number=1
#orcl2.instance_number=2
#orcl1.log_archive_dest_1='LOCATION=+DATADG/orcl/archive/arch1'
#orcl2.log_archive_dest_1='LOCATION=+DATADG/orcl/archive/arch2'
*.memory_target=1606418432
*.open_cursors=300
*.processes=150
#*.remote_listener='scanip:1521'
*.remote_login_passwordfile='exclusive'
#orcl2.thread=2
#orcl1.thread=1
#orcl2.undo_tablespace='UNDOTBS2'
#orcl1.undo_tablespace='UNDOTBS1'
*.undo_tablespace='UNDOTBS1'
如果目录不存在创建相应的目录：
[oracle@oracletest dbs]$ mkdir -p /u01/app/oracle/oradata/orcl
[oracle@oracletest dbs]$ mkdir -p /u01/app/oracle/admin/ orcl /adump
5、删除$ORACL_HOME/dbs目录spfile文件，数据库默认使用修改后的pfile启动数据库到nomount状态
RMAN> shutdown immediate;
Oracle instance shut down
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0055E+10 bytes
Fixed Size 2691952 bytes
Variable Size 1778388112 bytes
Database Buffers 8254390272 bytes
Redo Buffers 19312640 bytes
5、还原控制文件并注册备份集
恢复控制文件：
RMAN> set dbid = 1384719405;
RMAN> restore controlfile from '/u01/testdata/20171217040001#1/ORCL-1316909453-3457-20171217-962948708-c1smarj4_1_1.ctl.bak';
Starting restore at 22-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=9 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/orcl/control01.ctl
output file name=/u01/app/oracle/oradata/orcl/control02.ctl
Finished restore at 22-DEC-17
加载数据库：
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
.
注册备份集：
RMAN> catalog start with '/u01/testdata/20171217040001#1/';
searching for all files that match the pattern /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/
List of Files Unknown to the Database
=====================================
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/ctrlfile-1487315582-18-20171214-962726599-0ism42m7_1_1-.bak
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-15-20171214-962726494-0fsm42iu_1_1-.bak
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/catalog.xml
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/catalog_mnt.xml
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-16-20171214-962726570-0gsm42la_1_1-.bak
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-1487315582-17-20171214-962726592-0hsm42m0_1_1-.bak
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/ctrlfile-1487315582-18-20171214-962726599-0ism42m7_1_1-.bak
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-15-20171214-962726494-0fsm42iu_1_1-.bak
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-16-20171214-962726570-0gsm42la_1_1-.bak
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-1487315582-17-20171214-962726592-0hsm42m0_1_1-.bak
List of Files Which Where Not Cataloged
=======================================
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/catalog.xml
RMAN-07517: Reason: The file header is corrupted
File Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/catalog_mnt.xml
RMAN-07517: Reason: The file header is corrupted
确认备份已注册：
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Incr 0 1.21G SBT_TAPE 00:05:33 13-NOV-17
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20171113T095616
Handle: unasbt-database-1487315582-1-20171113-959939777-01sjf161_1_1-.bak Media: unary_media
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/system.256.959534007
2 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/sysaux.257.959534009
3 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/undotbs1.258.959534009
4 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/users.259.959534009
5 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/undotbs2.264.959535607
6 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/orcltbs1.dbf
7 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/orcltbs2.dbf
8 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/orcltbs3.dbf
9 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/orcltbs4.dbf
10 0 Incr 2064911 13-NOV-17 +DATADG/orcl/datafile/orcltbs5.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Incr 0 24.00M SBT_TAPE 00:00:04 13-NOV-17
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20171113T095616
Handle: unasbt-database-1487315582-2-20171113-959940113-02sjf1gh_1_1-.bak Media: unary_media
SPFILE Included: Modification time: 12-NOV-17
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2067021 Ckp time: 13-NOV-17
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 779.75M SBT_TAPE 00:00:34 13-NOV-17
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20171113T100209
Handle: unasbt-archlog-1487315582-3-20171113-959940130-03sjf1h2_1_1-.bak Media: unary_media
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 9 1262337 09-NOV-17 1375023 09-NOV-17
1 10 1375023 09-NOV-17 1478733 10-NOV-17
1 11 1478733 10-NOV-17 1532268 10-NOV-17
1 12 1532268 10-NOV-17 1540839 10-NOV-17
1 13 1540839 10-NOV-17 1624591 11-NOV-17
1 14 1624591 11-NOV-17 1684153 11-NOV-17
1 15 1684153 11-NOV-17 1744090 11-NOV-17
1 16 1744090 11-NOV-17 1789499 12-NOV-17
1 17 1789499 12-NOV-17 1875053 12-NOV-17
1 18 1875053 12-NOV-17 1933846 12-NOV-17
1 19 1933846 12-NOV-17 1971386 12-NOV-17
1 20 1971386 12-NOV-17 2066704 13-NOV-17
1 21 2066704 13-NOV-17 2067690 13-NOV-17
1 22 2067690 13-NOV-17 2068047 13-NOV-17
2 5 1262217 09-NOV-17 1271906 09-NOV-17
2 6 1272914 09-NOV-17 1332951 09-NOV-17
2 7 1332951 09-NOV-17 1408376 09-NOV-17
2 8 1408376 09-NOV-17 1478731 10-NOV-17
2 9 1478731 10-NOV-17 1478924 10-NOV-17
2 10 1479096 10-NOV-17 1611496 11-NOV-17
2 11 1611496 11-NOV-17 1713771 11-NOV-17
2 12 1713771 11-NOV-17 1821475 12-NOV-17
2 13 1821475 12-NOV-17 1915604 12-NOV-17
2 14 1915604 12-NOV-17 2050036 13-NOV-17
2 15 2050036 13-NOV-17 2067072 13-NOV-17
2 16 2067072 13-NOV-17 2068050 13-NOV-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 24.00M SBT_TAPE 00:00:02 13-NOV-17
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20171113T100257
Handle: unasbt-ctrlfile-1487315582-4-20171113-959940177-04sjf1ih_1_1-.bak Media: unary_media
Control File Included: Ckp SCN: 2068118 Ckp time: 13-NOV-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Incr 0 1.21G SBT_TAPE 00:02:42 13-NOV-17
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20171113T100834
Handle: unasbt-database-1487315582-5-20171113-959940515-05sjf1t3_1_1-.bak Media: unary_media
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/system.256.959534007
2 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/sysaux.257.959534009
3 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/undotbs1.258.959534009
4 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/users.259.959534009
5 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/undotbs2.264.959535607
6 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/orcltbs1.dbf
7 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/orcltbs2.dbf
8 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/orcltbs3.dbf
9 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/orcltbs4.dbf
10 0 Incr 2068843 13-NOV-17 +DATADG/orcl/datafile/orcltbs5.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Incr 0 24.00M SBT_TAPE 00:00:04 13-NOV-17
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20171113T100834
Handle: unasbt-database-1487315582-6-20171113-959940680-06sjf228_1_1-.bak Media: unary_media
SPFILE Included: Modification time: 12-NOV-17
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2069301 Ckp time: 13-NOV-17
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7 768.00K SBT_TAPE 00:00:00 13-NOV-17
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20171113T101137
Handle: unasbt-archlog-1487315582-7-20171113-959940698-07sjf22q_1_1-.bak Media: unary_media
List of Archived Logs in backup set 7
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 23 2068047 13-NOV-17 2069325 13-NOV-17
1 24 2069325 13-NOV-17 2069395 13-NOV-17
2 17 2068050 13-NOV-17 2069321 13-NOV-17
2 18 2069321 13-NOV-17 2069392 13-NOV-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 24.00M SBT_TAPE 00:00:03 13-NOV-17
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20171113T101142
Handle: unasbt-ctrlfile-1487315582-8-20171113-959940703-08sjf22v_1_1-.bak Media: unary_media
Control File Included: Ckp SCN: 2069415 Ckp time: 13-NOV-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9 Incr 0 1.43G DISK 00:01:54 14-DEC-17
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20171214T154837
Piece Name: /tmp/mountpoint/s_oracle/ORCL/88AD1314D9EB458FABF548761105BDB8/database-1487315582-9-20171214-962725717-
09sm41ql_1_1-.bak
List of Datafiles in backup set 9
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/system.256.959534007
2 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/sysaux.257.959534009
3 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/undotbs1.258.959534009
4 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/users.259.959534009
5 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/undotbs2.264.959535607
6 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/orcltbs1.dbf
7 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/orcltbs2.dbf
8 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/orcltbs3.dbf
9 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/orcltbs4.dbf
10 0 Incr 2814360 14-DEC-17 +DATADG/orcl/datafile/orcltbs5.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Incr 0 17.73M DISK 00:00:09 14-DEC-17
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20171214T154837
Piece Name: /tmp/mountpoint/s_oracle/ORCL/88AD1314D9EB458FABF548761105BDB8/database-1487315582-11-20171214-962725835-
0bsm41ub_1_1-.bak
SPFILE Included: Modification time: 14-DEC-17
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2817910 Ckp time: 14-DEC-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Incr 0 1.43G DISK 00:02:19 14-DEC-17
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20171214T154938
Piece Name: /tmp/mountpoint/s_oracle/ORCL/308E98B2C76A4E578A331199F11569B4/database-1487315582-10-20171214-962725780-
0asm41sk_1_1-.bak
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/system.256.959534007
2 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/sysaux.257.959534009
3 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/undotbs1.258.959534009
4 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/users.259.959534009
5 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/undotbs2.264.959535607
6 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/orcltbs1.dbf
7 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/orcltbs2.dbf
8 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/orcltbs3.dbf
9 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/orcltbs4.dbf
10 0 Incr 2817838 14-DEC-17 +DATADG/orcl/datafile/orcltbs5.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Incr 0 17.73M DISK 00:00:14 14-DEC-17
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20171214T154938
Piece Name: /tmp/mountpoint/s_oracle/ORCL/308E98B2C76A4E578A331199F11569B4/database-1487315582-13-20171214-962725930-
0dsm421a_1_1-.bak
SPFILE Included: Modification time: 14-DEC-17
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2818160 Ckp time: 14-DEC-17
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13 1002.25M DISK 00:01:09 14-DEC-17
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20171214T155121
Piece Name: /tmp/mountpoint/s_oracle/ORCL/88AD1314D9EB458FABF548761105BDB8/archlog-1487315582-12-20171214-962725886-
0csm41vu_1_1-.bak
List of Archived Logs in backup set 13
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 25 2069395 13-NOV-17 2089837 13-NOV-17
1 26 2089837 13-NOV-17 2089868 13-NOV-17
1 27 2150771 13-NOV-17 2194709 13-NOV-17
1 28 2194709 13-NOV-17 2288147 14-NOV-17
1 29 2288147 14-NOV-17 2413255 15-NOV-17
1 30 2413255 15-NOV-17 2524639 15-NOV-17
1 31 2524639 15-NOV-17 2634941 16-NOV-17
1 32 2634941 16-NOV-17 2738368 14-DEC-17
1 33 2738368 14-DEC-17 2743099 14-DEC-17
1 34 2745342 14-DEC-17 2770169 14-DEC-17
1 35 2770169 14-DEC-17 2786514 14-DEC-17
1 36 2786514 14-DEC-17 2804139 14-DEC-17
1 37 2804139 14-DEC-17 2817980 14-DEC-17
1 38 2817980 14-DEC-17 2818067 14-DEC-17
2 19 2069392 13-NOV-17 2089839 13-NOV-17
2 20 2089839 13-NOV-17 2118584 13-NOV-17
2 21 2118584 13-NOV-17 2150404 13-NOV-17
2 22 2150404 13-NOV-17 2248797 14-NOV-17
2 23 2248797 14-NOV-17 2350806 14-NOV-17
2 24 2350806 14-NOV-17 2384942 14-NOV-17
2 25 2384942 14-NOV-17 2476051 15-NOV-17
2 26 2476051 15-NOV-17 2524636 15-NOV-17
2 27 2524636 15-NOV-17 2524668 15-NOV-17
2 28 2524893 15-NOV-17 2590759 15-NOV-17
2 29 2590759 15-NOV-17 2663100 16-NOV-17
2 30 2663100 16-NOV-17 2738370 14-DEC-17
2 31 2738370 14-DEC-17 2760445 14-DEC-17
2 32 2760445 14-DEC-17 2765311 14-DEC-17
2 33 2765311 14-DEC-17 2770139 14-DEC-17
2 34 2770139 14-DEC-17 2775568 14-DEC-17
2 35 2775568 14-DEC-17 2780896 14-DEC-17
2 36 2780896 14-DEC-17 2785987 14-DEC-17
2 37 2785987 14-DEC-17 2790849 14-DEC-17
2 38 2790849 14-DEC-17 2798867 14-DEC-17
2 39 2798867 14-DEC-17 2803690 14-DEC-17
2 40 2803690 14-DEC-17 2809091 14-DEC-17
2 41 2809091 14-DEC-17 2817983 14-DEC-17
2 42 2817983 14-DEC-17 2818070 14-DEC-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Full 17.70M DISK 00:00:04 14-DEC-17
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20171214T155256
Piece Name: /tmp/mountpoint/s_oracle/ORCL/88AD1314D9EB458FABF548761105BDB8/ctrlfile-1487315582-14-20171214-962725977-
0esm422p_1_1-.bak
Control File Included: Ckp SCN: 2818296 Ckp time: 14-DEC-17
BS Key Type LV Size
------- ---- -- ----------
15 Incr 0 1.43G
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/system.256.959534007
2 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/sysaux.257.959534009
3 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/undotbs1.258.959534009
4 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/users.259.959534009
5 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/undotbs2.264.959535607
6 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/orcltbs1.dbf
7 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/orcltbs2.dbf
8 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/orcltbs3.dbf
9 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/orcltbs4.dbf
10 0 Incr 2821763 14-DEC-17 +DATADG/orcl/datafile/orcltbs5.dbf
Backup Set Copy #1 of backup set 15
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:12 14-DEC-17 NO TAG20171214T160133
List of Backup Pieces for backup set 15 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
15 1 AVAILABLE /tmp/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-15-20171214-962726494-
0fsm42iu_1_1-.bak
Backup Set Copy #2 of backup set 15
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:12 22-DEC-17 NO TAG20171214T160133
List of Backup Pieces for backup set 15 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
19 1 AVAILABLE /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-15-20171214-962726494-
0fsm42iu_1_1-.bak
BS Key Type LV Size
------- ---- -- ----------
16 Incr 0 17.73M
SPFILE Included: Modification time: 14-DEC-17
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2823162 Ckp time: 14-DEC-17
Backup Set Copy #1 of backup set 16
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:04 14-DEC-17 NO TAG20171214T160133
List of Backup Pieces for backup set 16 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
16 1 AVAILABLE /tmp/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-16-20171214-962726570-
0gsm42la_1_1-.bak
Backup Set Copy #2 of backup set 16
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:04 22-DEC-17 NO TAG20171214T160133
List of Backup Pieces for backup set 16 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
20 1 AVAILABLE /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/database-1487315582-16-20171214-962726570-
0gsm42la_1_1-.bak
BS Key Size
------- ----------
17 12.00M
List of Archived Logs in backup set 17
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 39 2818067 14-DEC-17 2818227 14-DEC-17
1 40 2818227 14-DEC-17 2818267 14-DEC-17
1 41 2818267 14-DEC-17 2823186 14-DEC-17
1 42 2823186 14-DEC-17 2823269 14-DEC-17
2 43 2818070 14-DEC-17 2818201 14-DEC-17
2 44 2818201 14-DEC-17 2818270 14-DEC-17
2 45 2818270 14-DEC-17 2823182 14-DEC-17
2 46 2823182 14-DEC-17 2823273 14-DEC-17
Backup Set Copy #1 of backup set 17
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:01 14-DEC-17 NO TAG20171214T160311
List of Backup Pieces for backup set 17 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
17 1 AVAILABLE /tmp/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-1487315582-17-20171214-962726592-
0hsm42m0_1_1-.bak
Backup Set Copy #2 of backup set 17
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:01 22-DEC-17 NO TAG20171214T160311
List of Backup Pieces for backup set 17 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
21 1 AVAILABLE /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-1487315582-17-20171214-962726592-
0hsm42m0_1_1-.bak
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Full 17.70M DISK 00:00:00 14-DEC-17
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20171214T160319
Piece Name: /ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/ctrlfile-1487315582-18-20171214-962726599-
0ism42m7_1_1-.bak
Control File Included: Ckp SCN: 2823295 Ckp time: 14-DEC-17
6、确认数据文件，联机日志文件，临时文件路径
数据文件：
[oracle@localhost onlinelog]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 22 10:06:50 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> col name for a65
SQL> select file#, name from v$datafile;
FILE# NAME
---------- -----------------------------------------------------------------
1 +DATA/orcldg/datafile/system.257.929667053
2 +DATA/orcldg/datafile/sysaux.260.929666527
3 +DATA/orcldg/datafile/undotbs1.266.929666789
4 +DATA/orcldg/datafile/users.259.929666683
5 +DATA/orcldg/datafile/portal_lis.265.929666883
6 +DATA/orcldg/datafile/portal_lis.263.929665857
7 +DATA/orcldg/datafile/portal_lis.261.929666193
8 +DATA/orcldg/datafile/portal_tj.258.929666969
9 +DATA/orcldg/datafile/portal_lis.256.929667079
10 +DATA/orcldg/datafile/undotbs02.dbf
11 +DATA/orcldg/datafile/portal_lis267.dbf
11 rows selected.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATA/orcldg/onlinelog/group_31.281.929667105
+DATA/orcldg/onlinelog/group_32.282.929667107
+DATA/orcldg/onlinelog/group_11.268.929667083
+DATA/orcldg/onlinelog/group_12.269.929667085
+DATA/orcldg/onlinelog/group_13.270.929667087
+DATA/orcldg/onlinelog/group_14.271.929667087
+DATA/orcldg/onlinelog/group_15.272.929667089
+DATA/orcldg/onlinelog/group_16.273.929667091
+DATA/orcldg/onlinelog/group_33.283.929667109
+DATA/orcldg/onlinelog/group_34.284.929667111
+DATA/orcldg/onlinelog/group_35.285.929667113
MEMBER
--------------------------------------------------------------------------------
+DATA/orcldg/onlinelog/group_36.286.929667113
+DATA/orcldg/onlinelog/group_37.287.929667115
+DATA/orcldg/onlinelog/group_21.274.929667093
+DATA/orcldg/onlinelog/group_22.275.929667095
+DATA/orcldg/onlinelog/group_23.276.929667097
+DATA/orcldg/onlinelog/group_24.277.929667099
+DATA/orcldg/onlinelog/group_25.278.929667099
+DATA/orcldg/onlinelog/group_26.279.929667101
+DATA/orcldg/onlinelog/group_27.280.929667103
+ARCH/orcldg/onlinelog/group_11.262.929667083
+ARCH/orcldg/onlinelog/group_12.261.929667085
MEMBER
--------------------------------------------------------------------------------
+ARCH/orcldg/onlinelog/group_13.260.929667087
+ARCH/orcldg/onlinelog/group_14.259.929667089
+ARCH/orcldg/onlinelog/group_15.258.929667091
+ARCH/orcldg/onlinelog/group_16.257.929667093
+ARCH/orcldg/onlinelog/group_21.256.929667093
+ARCH/orcldg/onlinelog/group_22.265.929667095
+ARCH/orcldg/onlinelog/group_23.266.929667097
+ARCH/orcldg/onlinelog/group_24.267.929667099
+ARCH/orcldg/onlinelog/group_25.268.929667101
+ARCH/orcldg/onlinelog/group_26.269.929667103
+ARCH/orcldg/onlinelog/group_27.270.929667105
MEMBER
--------------------------------------------------------------------------------
+ARCH/orcldg/onlinelog/group_31.271.929667105
+ARCH/orcldg/onlinelog/group_32.272.929667107
+ARCH/orcldg/onlinelog/group_33.273.929667109
+ARCH/orcldg/onlinelog/group_34.274.929667111
+ARCH/orcldg/onlinelog/group_35.275.929667113
+ARCH/orcldg/onlinelog/group_36.276.929667115
+ARCH/orcldg/onlinelog/group_37.277.929667117
+DATA/orcldg/onlinelog/redo61_01
+ARCH/orcldg/onlinelog/redo61_01
+DATA/orcldg/onlinelog/redo62_01
+ARCH/orcldg/onlinelog/redo62_01
MEMBER
--------------------------------------------------------------------------------
+DATA/orcldg/onlinelog/redo63_01
+ARCH/orcldg/onlinelog/redo63_01
+DATA/orcldg/onlinelog/redo64_01
+ARCH/orcldg/onlinelog/redo64_01
+DATA/orcldg/onlinelog/redo65_01
+ARCH/orcldg/onlinelog/redo65_01
+DATA/orcldg/onlinelog/redo66_01
+ARCH/orcldg/onlinelog/redo66_01
52 rows selected.
SQL> select name from v$tempfile;
NAME
-----------------------------------------------------------------
+DATA/orcldg/tempfile/temp.288.929667967
SQL>
7、使用rman恢复数据文件和临时文件
脚本如下：
RUN{
SET NEWNAME FOR DATABASE TO '/u01/app/oracle/oradata/orcl/%U';
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
}
或者
RUN {
SET NEWNAME FOR DATAFILE 1 to'/u01/app/oracle/oradata/orcl/system01.dbf';
SET NEWNAME FOR DATAFILE 2 to'/u01/app/oracle/oradata/orcl/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 3 to'/u01/app/oracle/oradata/orcl/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 4 to'/u01/app/oracle/oradata/orcl/users01.dbf';
SET NEWNAME FOR DATAFILE 5 to'/u01/app/oracle/oradata/orcl/portal01.dbf';
SET NEWNAME FOR DATAFILE 6 to'/u01/app/oracle/oradata/orcl/hisrun01.dbf';
SET NEWNAME FOR DATAFILE 7 to'/u01/app/oracle/oradata/orcl/hisrun02.dbf';
SET NEWNAME FOR DATAFILE 8 to'/u01/app/oracle/oradata/orcl/hisrun03.dbf';
SET NEWNAME FOR DATAFILE 9 to'/u01/app/oracle/oradata/orcl/hisrun04.dbf';
SET NEWNAME FOR DATAFILE 10 to'/u01/app/oracle/oradata/orcl/hisrun04_2.dbf';
SET NEWNAME FOR DATAFILE 11 to'/u01/app/oracle/oradata/orcl/hisrun05.dbf';
SET NEWNAME FOR DATAFILE 12 to'/u01/app/oracle/oradata/orcl/hisrun06.dbf';
SET NEWNAME FOR DATAFILE 13 to'/u01/app/oracle/oradata/orcl/undotbs02.dbf';
SET NEWNAME FOR DATAFILE 14 to'/u01/app/oracle/oradata/orcl/hisrun07.dbf';
SET NEWNAME FOR DATAFILE 15 to'/u01/app/oracle/oradata/orcl/hisrun08.dbf';
SET NEWNAME FOR DATAFILE 16 to'/u01/app/oracle/oradata/orcl/portal02.dbf';
SET NEWNAME FOR TEMPFILE 1 to'/u01/app/oracle/oradata/orcl/temp01.dbf';
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
}
脚本执行结果如下：
RMAN> RUN{
SET NEWNAME FOR DATABASE TO '/u01/app/oracle/oradata/orcl/%U';
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
}
2> 3> 4> 5> 6>
executing command: SET NEWNAME
Starting restore at 22-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3767 device type=DISK
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 /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-SYSTEM_FNO-1
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-SYSAUX_FNO-2
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-UNDOTBS1_FNO-3
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-USERS_FNO-4
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-5
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-6
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-7
channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_TJ_FNO-8
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-9
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-UNDOTBS2_FNO-10
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-11
channel ORA_DISK_1: reading from backup piece /orabak/orabak/ORCL/20171217040001#1/lv0.ORCL-1316909453-3454-20171217-962942403-
busmale3_1_1.bak
channel ORA_DISK_1: errors found reading piece handle=/orabak/orabak/ORCL/20171217040001#1/lv0.ORCL-1316909453-3454-20171217-
962942403-busmale3_1_1.bak
channel ORA_DISK_1: failover to piece handle=/u01/testdata/20171217040001#1/lv0.ORCL-1316909453-3454-20171217-962942403-
busmale3_1_1.bak tag=TAG20171217T040003
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:17:55
Finished restore at 22-DEC-17
datafile 1 switched to datafile copy
input datafile copy RECID=23 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-SYSTEM_FNO-1
datafile 2 switched to datafile copy
input datafile copy RECID=24 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-SYSAUX_FNO-2
datafile 3 switched to datafile copy
input datafile copy RECID=25 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-UNDOTBS1_FNO-3
datafile 4 switched to datafile copy
input datafile copy RECID=26 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-USERS_FNO-4
datafile 5 switched to datafile copy
input datafile copy RECID=27 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-5
datafile 6 switched to datafile copy
input datafile copy RECID=28 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-6
datafile 7 switched to datafile copy
input datafile copy RECID=29 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-7
datafile 8 switched to datafile copy
input datafile copy RECID=30 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_TJ_FNO-8
datafile 9 switched to datafile copy
input datafile copy RECID=31 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-9
datafile 10 switched to datafile copy
input datafile copy RECID=32 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-UNDOTBS2_FNO-10
datafile 11 switched to datafile copy
input datafile copy RECID=33 STAMP=963420425 file name=/u01/app/oracle/oradata/orcl/data_D-ORCL_TS-PORTAL_LIS_FNO-11
renamed tempfile 1 to /u01/app/oracle/oradata/orcl/data_D-ORCL_TS-TEMP_FNO-1 in control file
RMAN>
8、恢复数据库
RMAN> recover database;
Starting recover at 22-DEC-17
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=41
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=45
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=46
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=42
channel ORA_DISK_1: reading from backup piece /tmp/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-1487315582-17-
20171214-962726592-0hsm42m0_1_1-.bak
channel ORA_DISK_1: errors found reading piece handle=/tmp/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-
1487315582-17-20171214-962726592-0hsm42m0_1_1-.bak
channel ORA_DISK_1: failover to piece handle=/ora/mountpoint/s_oracle/ORCL/2C1CCCB0270F4755B10A744A45819B10/archlog-1487315582-17-
20171214-962726592-0hsm42m0_1_1-.bak tag=TAG20171214T160311
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/opt/oracle/product/11.2.0.1.0/db_1/dbs/arch2_45_959534853.dbf thread=2 sequence=45
archived log file name=/opt/oracle/product/11.2.0.1.0/db_1/dbs/arch1_41_959534853.dbf thread=1 sequence=41
archived log file name=/opt/oracle/product/11.2.0.1.0/db_1/dbs/arch2_46_959534853.dbf thread=2 sequence=46
archived log file name=/opt/oracle/product/11.2.0.1.0/db_1/dbs/arch1_42_959534853.dbf thread=1 sequence=42
unable to find archived log
archived log thread=1 sequence=43
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/22/2017 10:20:22
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 43 and starting SCN of 2823269
9、处理联机日志
在SQLPLUS中分别执行下列语句：
alter database rename file '+DATA/redo01.log' to '/u01/app/oracle/oradata/orcl/redo01.log';
alter database rename file '+DATA/redo17.log' to '/u01/app/oracle/oradata/orcl/redo17.log';
alter database rename file '+DATA/redo18.log' to '/u01/app/oracle/oradata/orcl/redo18.log';
alter database rename file '+DATA/redo31.log' to '/u01/app/oracle/oradata/orcl/redo31.log';
alter database rename file '+DATA/redo11.log' to '/u01/app/oracle/oradata/orcl/redo11.log';
alter database rename file '+DATA/redo12.log' to '/u01/app/oracle/oradata/orcl/redo12.log';
alter database rename file '+DATA/redo13.log' to '/u01/app/oracle/oradata/orcl/redo13.log';
alter database rename file '+DATA/redo14.log' to '/u01/app/oracle/oradata/orcl/redo14.log';
alter database rename file '+DATA/redo15.log' to '/u01/app/oracle/oradata/orcl/redo15.log';
alter database rename file '+DATA/redo16.log' to '/u01/app/oracle/oradata/orcl/redo16.log';
alter database rename file '+DATA/redo32.log' to '/u01/app/oracle/oradata/orcl/redo32.log';
alter database rename file '+DATA/redo33.log' to '/u01/app/oracle/oradata/orcl/redo33.log';
alter database rename file '+DATA/redo34.log' to '/u01/app/oracle/oradata/orcl/redo34.log';
alter database rename file '+DATA/redo35.log' to '/u01/app/oracle/oradata/orcl/redo35.log';
alter database rename file '+DATA/redo36.log' to '/u01/app/oracle/oradata/orcl/redo36.log';
alter database rename file '+DATA/redo37.log' to '/u01/app/oracle/oradata/orcl/redo37.log';
alter database rename file '+DATA/redo38.log' to '/u01/app/oracle/oradata/orcl/redo38.log';
alter database rename file '+DATA/redo39.log' to '/u01/app/oracle/oradata/orcl/redo39.log';
alter database rename file '+DATA/redo40.log' to '/u01/app/oracle/oradata/orcl/redo40.log';
alter database rename file '+DATA/redo21.log' to '/u01/app/oracle/oradata/orcl/redo21.log';
alter database rename file '+DATA/redo22.log' to '/u01/app/oracle/oradata/orcl/redo22.log';
alter database rename file '+DATA/redo23.log' to '/u01/app/oracle/oradata/orcl/redo23.log';
alter database rename file '+DATA/redo24.log' to '/u01/app/oracle/oradata/orcl/redo24.log';
alter database rename file '+DATA/redo25.log' to '/u01/app/oracle/oradata/orcl/redo25.log';
alter database rename file '+DATA/redo26.log' to '/u01/app/oracle/oradata/orcl/redo26.log';
alter database rename file '+DATA/redo27.log' to '/u01/app/oracle/oradata/orcl/redo27.log';
alter database rename file '+DATA/redo28.log' to '/u01/app/oracle/oradata/orcl/redo28.log';
alter database rename file '+DATA/redo29.log' to '/u01/app/oracle/oradata/orcl/redo29.log';
alter database rename file '+DATA/redo30.log' to '/u01/app/oracle/oradata/orcl/redo30.log';
alter database rename file '+DATA/redo41' to '/u01/app/oracle/oradata/orcl/redo41.log';
alter database rename file '+DATA/redo42' to '/u01/app/oracle/oradata/orcl/redo42.log';
alter database rename file '+DATA/redo43' to '/u01/app/oracle/oradata/orcl/redo43.log';
alter database rename file '+DATA/redo44' to '/u01/app/oracle/oradata/orcl/redo44.log';
alter database rename file '+DATA/redo45' to '/u01/app/oracle/oradata/orcl/redo45.log';
alter database rename file '+DATA/redo46' to '/u01/app/oracle/oradata/orcl/redo46.log';
alter database rename file '+DATA/redo47' to '/u01/app/oracle/oradata/orcl/redo47.log';
alter database rename file '+DATA/redo48' to '/u01/app/oracle/oradata/orcl/redo48.log';
alter database rename file '+DATA/redo49' to '/u01/app/oracle/oradata/orcl/redo49.log';
处理后：
SQL> conn /as sysdba
Connected.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/redo01.log
/u01/app/oracle/oradata/orcl/redo17.log
/u01/app/oracle/oradata/orcl/redo18.log
/u01/app/oracle/oradata/orcl/redo11.log
/u01/app/oracle/oradata/orcl/redo12.log
/u01/app/oracle/oradata/orcl/redo13.log
/u01/app/oracle/oradata/orcl/redo14.log
/u01/app/oracle/oradata/orcl/redo15.log
/u01/app/oracle/oradata/orcl/redo16.log
/u01/app/oracle/oradata/orcl/redo41.log
查询一下关于logfile的信息：
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
1 ONLINE /u01/app/oracle/oradata/orcl/redo01.log NO
17 ONLINE /u01/app/oracle/oradata/orcl/redo17.log NO
18 ONLINE /u01/app/oracle/oradata/orcl/redo18.log NO
31 STANDBY /u01/app/oracle/oradata/orcl/redo31.log NO
11 ONLINE /u01/app/oracle/oradata/orcl/redo11.log NO
12 ONLINE /u01/app/oracle/oradata/orcl/redo12.log NO
13 ONLINE /u01/app/oracle/oradata/orcl/redo13.log NO
14 ONLINE /u01/app/oracle/oradata/orcl/redo14.log NO
15 ONLINE /u01/app/oracle/oradata/orcl/redo15.log NO
16 ONLINE /u01/app/oracle/oradata/orcl/redo16.log NO
32 STANDBY /u01/app/oracle/oradata/orcl/redo32.log NO
33 STANDBY /u01/app/oracle/oradata/orcl/redo33.log NO
34 STANDBY /u01/app/oracle/oradata/orcl/redo34.log NO
35 STANDBY /u01/app/oracle/oradata/orcl/redo35.log NO
36 STANDBY /u01/app/oracle/oradata/orcl/redo36.log NO
37 STANDBY /u01/app/oracle/oradata/orcl/redo37.log NO
38 STANDBY /u01/app/oracle/oradata/orcl/redo38.log NO
39 STANDBY /u01/app/oracle/oradata/orcl/redo39.log NO
40 STANDBY /u01/app/oracle/oradata/orcl/redo40.log NO
21 STANDBY /u01/app/oracle/oradata/orcl/redo21.log NO
22 STANDBY /u01/app/oracle/oradata/orcl/redo22.log NO
23 STANDBY /u01/app/oracle/oradata/orcl/redo23.log NO
24 STANDBY /u01/app/oracle/oradata/orcl/redo24.log NO
25 STANDBY /u01/app/oracle/oradata/orcl/redo25.log NO
26 STANDBY /u01/app/oracle/oradata/orcl/redo26.log NO
27 STANDBY /u01/app/oracle/oradata/orcl/redo27.log NO
28 STANDBY /u01/app/oracle/oradata/orcl/redo28.log NO
29 STANDBY /u01/app/oracle/oradata/orcl/redo29.log NO
30 STANDBY /u01/app/oracle/oradata/orcl/redo30.log NO
41 ONLINE /u01/app/oracle/oradata/orcl/redo41.log NO
42 ONLINE /u01/app/oracle/oradata/orcl/redo42.log NO
43 ONLINE /u01/app/oracle/oradata/orcl/redo43.log NO
44 ONLINE /u01/app/oracle/oradata/orcl/redo44.log NO
45 ONLINE /u01/app/oracle/oradata/orcl/redo45.log NO
46 ONLINE /u01/app/oracle/oradata/orcl/redo46.log NO
47 ONLINE /u01/app/oracle/oradata/orcl/redo47.log NO
48 ONLINE /u01/app/oracle/oradata/orcl/redo48.log NO
49 ONLINE /u01/app/oracle/oradata/orcl/redo49.log NO
38 rows selected.
删除所有tpye为STANDBY的日志组
SQL> alter database drop logfile group 31;
Database altered.
如果没有standby log就不用做下面的删除操作：
10、打开数据库
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/25/2017 13:19:57
ORA-03113: end-of-file on communication channel
Process ID: 10629
Session ID: 3769 Serial number: 7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/25/2017 13:19:57
ORA-03113: end-of-file on communication channel
Process ID: 10629
Session ID: 3769 Serial number: 7
alert 日志显示和DG有关系：
Sun Dec 24 14:31:46 2017
alter database open
Sun Dec 24 14:31:46 2017
LGWR: STARTING ARCH PROCESSES
Sun Dec 24 14:31:46 2017
ARC0 started with pid=22, OS id=14821
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LGWR: Minimum of 1 LGWR standby database required
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lgwr_24065.trc:
ORA-16072: a minimum of one standby database destination is required
Sun Dec 24 14:31:47 2017
ARC1 started with pid=20, OS id=14823
LGWR (ospid: 24065): terminating the instance due to error 16072
Sun Dec 24 14:31:47 2017
System state dump requested by (instance=1, osid=24065 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_24055_20171224143147.trc
Dumping diagnostic data in directory=[cdmp_20171224143147], requested by (instance=1, osid=24065 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 24065
网上查询解决方案：
http://blog.csdn.net/lixora/article/details/21083271
SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY MAXIMUM AVAILABILITY UNPROTECTED
SQL> alter database set standby to maximize performance;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter database open;
Database altered.
SQL> alter database open resetlogs;
Database altered.
11、创建spfile 关闭数据库从spfie启动
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 939526256 bytes
Database Buffers 654311424 bytes
Redo Buffers 7360512 bytes
Database mounted.
Database opened.
SQL>
到这里恢复过程结束，后续工作包括创建监听，多路复用控制文件和联机日志文件，修改闪回恢复区和归档的相关配置等。
浙公网安备 33010602011771号