Networker恢復oracle rac到單機
Networker恢復oracle rac到單機
此處oracle為oracle19c pdb
參考 Networker恢復oracle單節點，這裡主要列出來一些不同之處
http://blog.itpub.net/70004783/viewspace-2845335/
oracle恢復過程
此處oracle204是我用來恢復的單機
在oracle204機器上，建立最簡單的c引數檔案
|
1
2
3
4
5 |
[oracle@oracle204 dbs]$
cat
initprod.ora*.db_name=
'prod'*.sga_target=1496m[oracle@oracle204 dbs]$
pwd/u01/app/oracle/product/19c/db_1/dbs |
啟動資料庫到nomount狀態
|
1
2
3
4
5
6
7
8 |
[oracle@oracle204 dbs]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 6 10:35:18 2021Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL> startup nomount |
在Networker查詢最新的備份，確定rman恢復指令碼。
首先恢復引數檔案
依據查詢的引數對應修改這一行
send 'NSR_ENV=( NSR_CLIENT= rac1-vip ,NSR_SERVER= backserver,NSR_DATA_VOLUME_POOL= bstindex)';
RMAN> set dbid=496022129;
executing command: SET DBID
RMAN> run
{
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=( NSR_CLIENT=rac1-vip,NSR_SERVER=backserver,NSR_DATA_VOLUME_POOL=bstindex)';
restore spfile from autobackup;
release channel t1;
}2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=22 device type=SBT_TAPE
channel t1: NMDA Oracle v19.2.1.2
sent command to channel: t1
Starting restore at 2021-12-07 14:02:16
channel t1: looking for AUTOBACKUP on day: 20211207
channel t1: AUTOBACKUP found: c-496022129-20211207-00
channel t1: restoring spfile from AUTOBACKUP c-496022129-20211207-00
channel t1: SPFILE restore from AUTOBACKUP complete
Finished restore at 2021-12-07 14:12:21
released channel: t1
RMAN>
利用恢復的引數檔案轉化為引數檔案initprod.ora，並修改相應的引數。
[oracle@oracle204 dbs]$ strings spfileprod.ora > initprod.ora 恢復回來的引數檔案 [oracle@oracle204 dbs]$ cat initprod.ora prod2.__data_transfer_cache_size=0 prod1.__data_transfer_cache_size=0 prod2.__db_cache_size=1476395008 prod1.__db_cache_size=1207959552 prod2.__inmemory_ext_roarea=0 prod1.__inmemory_ext_roarea=0 prod2.__inmemory_ext_rwarea=0 prod1.__inmemory_ext_rwarea=0 prod2.__java_pool_size=0 prod1.__java_pool_size=0 prod2.__large_pool_size=16777216 prod1.__large_pool_size=16777216 prod1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment prod2.__oracle_base='/u01/app/oracle'#ORACLE_ BASE set from environment prod2.__pga_aggregate_target=822083584 prod1.__pga_aggregate_target=822083584 prod2.__sga_target=2466250752 prod1.__sga_target=2466250752 prod2.__shared_io_pool_size=117440512 prod1.__shared_io_pool_size=117440512 prod2.__shared_pool_size=838860800 prod1.__shared_pool_size=1107296256 prod2.__streams_pool_size=0 prod1.__streams_pool_size=0 prod2.__unified_pga_pool_size=0 prod1.__unified_pga_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/prod/adump' *.au dit_trail='db' *.cluster_database=true *.compatible='19.0.0' *.control_files='+DATADG/PROD/CONTROLFILE/current.261.1084183793' *.db_block_size=8192 *.db_create_file_dest='+DATADG' *.db_file_name_convert='+DATADG/','+DATADG/' *.db_name='prod' *.db_unique_name='prod' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)' *.enable_pluggable_database=true *.fal_client='tns_primary' *.fal_server='tns_standby' family:dw_helper.instance_mode='read-only' prod1.i nstance_number=1 prod2.instance_number=2 *.local_listener='-oraagent-dummy-' *.log_archive_config='DG_CONFIG=(prod,prodstd)' *.log_archive_dest_1='LOCATION=+FRADG/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prod' *.log_archive_dest_2='SERVICE=tns_standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prodstd' *.log_archive_format='%t_%s_%r.arc' *.log_archive_max_processes=8 *.log_file_name_convert='+DATADG/','+DATADG/' *.nls_language='AMERICAN' *.nls_territ ory='AMERICA' *.open_cursors=300 *.pga_aggregate_target=782m *.processes=1000 *.remote_login_passwordfile='exclusive' *.sga_target=2346m *.standby_file_management='AUTO' prod2.thread=2 prod1.thread=1 prod1.undo_tablespace='UNDOTBS1' prod2.undo_tablespace='UNDOTBS2' [oracle@oracle204 dbs]$
修改後的參 數檔案，刪掉恢復回來的spfile
[oracle@oracle204 dbs]$ pwd /u01/app/oracle/product/19c/db_1/dbs [oracle@oracle204 dbs]$ cat initprod.ora *.audit_file_dest='/u01/app/oracle/admin/prod/adump' *.audit_trail='db' *.compatible='19.0.0' *.control_files='/u01/app/oracle/oradata/control01.ctl' *.db_block_size=8192 *.db_create_file_dest='/u01/app/oracle/oradata/' *.db_create_online_log_dest_1='/u01/app/oracle/oradata/' *.db_file_name_convert='+DATADG/','/u01/app/oracle/oradata/' *.db_name='prod' *.db_unique_name='prod' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)' *.enable_pluggable_database=true *.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/' *.log_archive_format='%t_%s_%r.arc' *.log_archive_max_processes=8 *.log_file_name_convert='+DATADG/','/u01/app/oracle/oradata/' *.open_cursors=300 *.pga_aggregate_target=782m *.processes=1000 *.remote_login_passwordfile='exclusive' *.sga_target=2346m [oracle@oracle204 dbs]$
通過新的修改的pfile重新啟動資料庫到nomount狀態
SQL> startup nomount; ORACLE instance started. Total System Global Area 2466247664 bytes Fixed Size 9139184 bytes Variable Size 536870912 bytes Database Buffers 1912602624 bytes Redo Buffers 7634944 bytes SQL>
通過修改的pfile建立spfile，並重新通過spfile啟動到nomount狀態。
SQL> create spfile from pfile; File created. SQL> shutdown abort; ORACLE instance shut down. SQL> startup nomount;
恢復控制檔案
RMAN> set dbid=496022129;
executing command: SET DBID
RMAN> run
{
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=( NSR_CLIENT=rac1-vip,NSR_SERVER=backserver,NSR_DATA_VOLUME_POOL=bstindex)';
restore controlfile from autobackup;
release channel t1;
}2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=781 device type=SBT_TAPE
channel t1: NMDA Oracle v19.2.1.2
sent command to channel: t1
Starting restore at 2021-12-07 14:32:17
channel t1: looking for AUTOBACKUP on day: 20211207
channel t1: AUTOBACKUP found: c-496022129-20211207-00
channel t1: restoring control file from AUTOBACKUP c-496022129-20211207-00
channel t1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/oradata/control01.ctl
Finished restore at 2021-12-07 14:42:33
released channel: t1
RMAN>
啟動資料庫到mount狀態，list backup可以檢視記錄在控制檔案中的備份
RMAN> alter database mount; Statement processed RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 34 Full 1.47G SBT_TAPE 00:00:46 2021-12-06 16:41:12 BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20211206T164026 Handle: 230g2frq_1_1 Media: bstindex.001 List of Datafiles in backup set 34 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 Full 12810654 2021-12-06 16:40:27 NO +DATADG/PROD/DATAFILE/sysaux.258.1084183683 7 Full 12810654 2021-12-06 16:40:27 NO +DATADG/PROD/DATAFILE/users.260.1084183711 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 35 Full 1.22G SBT_TAPE 00:00:45 2021-12-06 16:41:12 BP Key: 35 Status: AVAILABLE Compressed: NO Tag: TAG20211206T164026 Handle: 240g2frr_1_1 Media: bstindex.001 List of Datafiles in backup set 35 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 Full 12810661 2021-12-06 16:40:27 NO +DATADG/PROD/DATAFILE/system.257.1084183629 4 Full 12810661 2021-12-06 16:40:27 NO +DATADG/PROD/DATAFILE/undotbs1.259.1084183709 9 Full 12810661 2021-12-06 16:40:27 NO +DATADG/PROD/DATAFILE/undotbs2.269.1084184569
restore database
因為我spfile裡面已經設定了，如果沒有設定，需要在rman恢復指令碼里自己指定檔案轉換
db_file_name_convert 和 db_file_name_convert引數會自動轉換asm路徑檔案到本地路徑
所以直接restore database
RMAN> run
{
allocate channel t1 type 'SBT_TAPE';
2> 3> 4> allocate channel t2 type 'SBT_TAPE';
allocate channel t3 type 'SBT_TAPE';
allocate channel t4 type 'SB5> T_TAPE';
send 'NSR_ENV=( NSR_CLIENT=rac1-vip,NSR_SERVER=backserver,NSR_DATA_VOLUME_POOL=bstindex)';
6> 7> 8> restore database ;
9> release channel t1;
release channel t2;
10> 11> release channel t3;
release channel t4;
12> 13> }
allocated channel: t1
channel t1: SID=18 device type=SBT_TAPE
channel t1: NMDA Oracle v19.2.1.2
allocated channel: t2
channel t2: SID=19 device type=SBT_TAPE
channel t2: NMDA Oracle v19.2.1.2
allocated channel: t3
channel t3: SID=786 device type=SBT_TAPE
channel t3: NMDA Oracle v19.2.1.2
allocated channel: t4
channel t4: SID=26 device type=SBT_TAPE
channel t4: NMDA Oracle v19.2.1.2
sent command to channel: t1
sent command to channel: t2
sent command to channel: t3
sent command to channel: t4
Starting restore at 2021-12-07 14:47:17
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00001 to +DATADG/PROD/DATAFILE/system.257.1084183629
channel t1: restoring datafile 00004 to +DATADG/PROD/DATAFILE/undotbs1.259.1084183709
channel t1: restoring datafile 00009 to +DATADG/PROD/DATAFILE/undotbs2.269.1084184569
channel t1: reading from backup piece 300g4cqf_1_1
channel t2: starting datafile backup set restore
channel t2: specifying datafile(s) to restore from backup set
channel t2: restoring datafile 00003 to +DATADG/PROD/DATAFILE/sysaux.258.1084183683
channel t2: restoring datafile 00007 to +DATADG/PROD/DATAFILE/users.260.1084183711
channel t2: reading from backup piece 2v0g4cqf_1_1
channel t3: starting datafile backup set restore
channel t3: specifying datafile(s) to restore from backup set
channel t3: restoring datafile 00011 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/sysaux.275.1084185285
channel t3: restoring datafile 00013 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/undo_2.277.1084185339
channel t3: restoring datafile 00014 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/users.278.1084185359
channel t3: restoring datafile 00016 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/haifeng.284.1088964183
channel t3: reading from backup piece 310g4crl_1_1
channel t4: starting datafile backup set restore
channel t4: specifying datafile(s) to restore from backup set
channel t4: restoring datafile 00005 to +DATADG/PROD/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.265.1084184215
channel t4: restoring datafile 00008 to +DATADG/PROD/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1084184215
channel t4: reading from backup piece 330g4cs6_1_1
channel t3: piece handle=310g4crl_1_1 tag=TAG20211207T100046
channel t3: restored backup piece 1
channel t3: restore complete, elapsed time: 00:10:15
channel t3: starting datafile backup set restore
channel t3: specifying datafile(s) to restore from backup set
channel t3: restoring datafile 00010 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/system.274.1084185285
channel t3: restoring datafile 00012 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/undotbs1.273.1084185285
channel t3: restoring datafile 00015 to +DATADG/PROD/CCC9B4B0A1183CDAE0536862080A56C6/DATAFILE/gdd.283.1088962699
channel t3: reading from backup piece 320g4cs6_1_1
channel t4: piece handle=330g4cs6_1_1 tag=TAG20211207T100046
channel t4: restored backup piece 1
channel t4: restore complete, elapsed time: 00:10:15
channel t4: starting datafile backup set restore
channel t4: specifying datafile(s) to restore from backup set
channel t4: restoring datafile 00006 to +DATADG/PROD/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.266.1084184215
channel t4: reading from backup piece 340g4csm_1_1
channel t1: piece handle=300g4cqf_1_1 tag=TAG20211207T100046
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:10:22
channel t2: piece handle=2v0g4cqf_1_1 tag=TAG20211207T100046
channel t2: restored backup piece 1
channel t2: restore complete, elapsed time: 00:10:22
channel t3: piece handle=320g4cs6_1_1 tag=TAG20211207T100046
channel t3: restored backup piece 1
channel t3: restore complete, elapsed time: 00:10:15
channel t4: piece handle=340g4csm_1_1 tag=TAG20211207T100046
channel t4: restored backup piece 1
channel t4: restore complete, elapsed time: 00:10:15
Finished restore at 2021-12-07 15:07:48
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN>
recover database
RMAN> run
{
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=( NSR_CLIENT=rac1-vip,NSR_SERVER=backserver,NSR_DATA_VOLUME_POOL=bstindex)';
recover database ;
release channel t1;
}2> 3> 4> 5> 6> 7>
allocated channel: t1
channel t1: SID=18 device type=SBT_TAPE
channel t1: NMDA Oracle v19.2.1.2
sent command to channel: t1
Starting recover at 2021-12-07 15:10:37
starting media recovery
channel t1: starting archived log restore to default destination
channel t1: restoring archived log
archived log thread=2 sequence=82
channel t1: reading from backup piece 350g4ct1_1_1
channel t1: piece handle=350g4ct1_1_1 tag=TAG20211207T100209
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:10:15
channel t1: starting archived log restore to default destination
channel t1: restoring archived log
archived log thread=1 sequence=104
channel t1: reading from backup piece 360g4ct1_1_1
channel t1: piece handle=360g4ct1_1_1 tag=TAG20211207T100209
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:10:05
archived log file name=/u01/app/oracle/oradata/1_104_1084183797.arc thread=1 sequence=104
archived log file name=/u01/app/oracle/oradata/2_82_1084183797.arc thread=2 sequence=82
unable to find archived log
archived log thread=2 sequence=83
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/07/2021 15:30:58
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 83 and starting SCN of 13050409
RMAN>
根據最後一句報錯，調整恢復rman語句
RMAN> run
{
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=( NSR_CLIENT=rac1-vip,NSR_SERVER=backserver,NSR_DATA_VOLUME_POOL=bstindex)';
recover database until scn 13050409 ;
release channel t1;
}2> 3> 4> 5> 6> 7>
allocated channel: t1
channel t1: SID=18 device type=SBT_TAPE
channel t1: NMDA Oracle v19.2.1.2
sent command to channel: t1
Starting recover at 2021-12-07 15:33:13
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 2021-12-07 15:33:14
released channel: t1
RMAN>
resetlogs 模式開啟資料庫
RMAN> alter database open resetlogs; Statement processed RMAN>
查詢rac備份恢復到單機的資料庫檔案。
SQL> select name from v$datafile; NAME ------------------------------------------------------------------------------------------------------------------------------------------------------ /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_jty1gp48_.dbf /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_jty1gowk_.dbf /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_jty1gpb9_.dbf /u01/app/oracle/oradata/PROD/CCC9746D268F19F9E0536762080AE444/datafile/o1_mf_system_jty1gpbs_.dbf /u01/app/oracle/oradata/PROD/CCC9746D268F19F9E0536762080AE444/datafile/o1_mf_sysaux_jty21r2j_.dbf /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_jty1gp4t_.dbf /u01/app/oracle/oradata/PROD/CCC9746D268F19F9E0536762080AE444/datafile/o1_mf_undotbs1_jty1gpfz_.dbf /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs2_jty1gpg0_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_system_jty21qtc_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_sysaux_jty1goor_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_undotbs1_jty21r5r_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_undo_2_jty1gowg_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_users_jty1gp08_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_gdd_jty21r95_.dbf /u01/app/oracle/oradata/PROD/CCC9B4B0A1183CDAE0536862080A56C6/datafile/o1_mf_haifeng_jty1gowx_.dbf 15 rows selected. SQL>
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/70004783/viewspace-2846190/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- RMAN異機恢復：RAC到單例項單例
- rac恢復到單例項單例
- Oracle 11.2.0.4 從單例項，使用RMAN 異機恢復到RACOracle單例
- Networker恢復虛擬機器虛擬機
- RAC asm恢復到單例項ASM單例
- rac到單例項的rman恢復單例
- rac asm 恢復到 單例項 1ASM單例
- rac asm 恢復到 單例項 2ASM單例
- RAC恢復到單例項節點上單例
- 恢復rac db(raw)到單例項下單例
- 單例項備份集恢復到RAC單例
- 將Oracle 10g RAC庫用rman 的方式備份並恢復到異機單機Oracle 10g
- Networker備份oracle racOracle
- RAC從帶庫到單例項的恢復單例
- 恢復RAC資料庫到單例項（ASM）資料庫單例ASM
- 將Oracle 10g RAC庫用rman 的方式備份並恢復到異機單機-3Oracle 10g
- 將Oracle 10g RAC庫用rman 的方式備份並恢復到異機單機 -2Oracle 10g
- 【kingsql分享】將RAC資料庫異機恢復到單例項（Ⅰ）SQL資料庫單例
- 10g rac asm 恢復到 單例項(二)ASM單例
- 10g rac asm 恢復到 單例項(一)ASM單例
- Oracle RAC恢復成單節點資料庫Oracle資料庫
- 【RMAN】RAC資料恢復至單機環境資料恢復
- 記錄一次Oracle 11.2.0.4 RAC異地恢復到單例項Oracle單例
- 【RMAN】oracle11g單機資料通過RMAN恢復至RACOracle
- 【RMAN】oracle11g單機資料透過RMAN恢復至RACOracle
- 單例項恢復至RAC單例
- RAC資料庫恢復到單例項資料庫資料庫單例
- oracle 10g rac 單例項恢復至ORACLE10G RAC RMANOracle 10g單例
- Oracle RAC備份與恢復Oracle
- RAC 資料庫恢復到單例項下並且基於時間點恢復資料庫單例
- oracle 11C rman 恢復到單例項Oracle單例
- RAC資料庫的RMAN備份異機恢復到單節點資料庫資料庫
- 將Oracle10g RAC庫用rman 的方式備份並恢復到異機Oracle
- oracle 異機恢復Oracle
- 單例項備份恢復成RAC單例
- rman恢復方案和oracle異機恢復Oracle
- 11G RAC 異機恢復至單例項測試單例
- 使用DP實現RAC異機恢復