11g RAC庫恢復過程小記
今天作個測試,先把兩個節點的庫停掉,開始恢復
[oracle@rac2 backup]$ ll
total 3106320
drwxr-xr-x 2 oracle oinstall 4096 Feb 12 06:06 file-bak
-rw-r----- 1 oracle asmadmin 266158080 Feb 12 06:07 rac_20140212_1_1.dbf
-rw-r----- 1 oracle asmadmin 816562176 Feb 12 07:29 rac_20140212_2_1.dbf
-rw-r----- 1 oracle asmadmin 2019778560 Feb 12 07:30 rac_20140212_3_1.dbf
-rw-r----- 1 oracle asmadmin 18612224 Feb 12 07:30 rac_20140212_4_1.dbf
-rw-r----- 1 oracle asmadmin 26966528 Feb 12 07:31 rac_20140212_5_1.arc
-rw-r----- 1 oracle asmadmin 10949632 Feb 12 07:31 rac_20140212_6_1.arc
-rw-r----- 1 oracle asmadmin 18579456 Feb 12 07:31 rac_20140212_7_1.ctl
-rw-r----- 1 oracle asmadmin 98304 Feb 12 07:31 rac_20140212_8_1.spf
drwxr-xr-x 2 oracle oinstall 4096 Feb 12 06:07 scripts
-rw-r--r-- 1 oracle oinstall 1414 Feb 12 07:29 tmp.dat
[oracle@rac2 backup]$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 12 08:38:55 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect / as sysdba
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "/"
RMAN> connect target /
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 943669248 bytes
Fixed Size 2234000 bytes
Variable Size 566233456 bytes
Database Buffers 369098752 bytes
Redo Buffers 6103040 bytes
RMAN> restore controlfile from '/s01/oracle/backup/rac_20140212_7_1.ctl';
Starting restore at 12-FEB-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 instance=rac2 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output file name=+DATABASEDG/rac/controlfile/current.260.836789301
output file name=+BACKUPDG/rac/controlfile/current.256.836789303
Finished restore at 12-FEB-14
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 25.72M DISK 00:00:01 12-FEB-14
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140212T073123
Piece Name: /s01/oracle/backup/rac_20140212_5_1.arc
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 23 3403555 12-FEB-14 3476656 12-FEB-14
1 24 3476656 12-FEB-14 3480849 12-FEB-14
1 25 3480922 12-FEB-14 3482720 12-FEB-14
1 26 3482720 12-FEB-14 3482741 12-FEB-14
1 27 3482741 12-FEB-14 3482792 12-FEB-14
1 28 3482792 12-FEB-14 3482815 12-FEB-14
1 29 3482815 12-FEB-14 3482827 12-FEB-14
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5 10.44M DISK 00:00:01 12-FEB-14
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140212T073133
Piece Name: /s01/oracle/backup/rac_20140212_6_1.arc
List of Archived Logs in backup set 5
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 22 3378022 12-FEB-14 3403518 12-FEB-14
2 23 3404107 12-FEB-14 3476655 12-FEB-14
2 24 3476655 12-FEB-14 3482726 12-FEB-14
2 25 3482726 12-FEB-14 3482737 12-FEB-14
2 26 3482737 12-FEB-14 3482801 12-FEB-14
2 27 3482801 12-FEB-14 3482812 12-FEB-14
2 28 3482812 12-FEB-14 3482832 12-FEB-14
2 29 3482832 12-FEB-14 3482851 12-FEB-14
RMAN>
RMAN> run{
2> set until sequence 30 thread 1;
3> restore database;
4> recover database;
5> }
executing command: SET until clause
Starting restore at 12-FEB-14
Starting implicit crosscheck backup at 12-FEB-14
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 12-FEB-14
Starting implicit crosscheck copy at 12-FEB-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 12-FEB-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +backupdg/RAC/ARCHIVELOG/2014_02_12/thread_2_seq_30.264.839320639
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 00013 to +DATABASEDG/rac/datafile/eport_tab_l.277.839233953
channel ORA_DISK_1: reading from backup piece /s01/oracle/backup/rac_20140212_2_1.dbf
channel ORA_DISK_1: piece handle=/s01/oracle/backup/rac_20140212_2_1.dbf tag=TAG20140212T072918
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:16
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 +DATABASEDG/rac/datafile/system.256.836789011
channel ORA_DISK_1: restoring datafile 00002 to +DATABASEDG/rac/datafile/sysaux.257.836789015
channel ORA_DISK_1: restoring datafile 00003 to +DATABASEDG/rac/datafile/undotbs1.258.836789019
channel ORA_DISK_1: restoring datafile 00004 to +DATABASEDG/rac/datafile/users.259.836789019
channel ORA_DISK_1: restoring datafile 00005 to +DATABASEDG/rac/datafile/undotbs2.266.836810891
channel ORA_DISK_1: restoring datafile 00006 to +DATABASEDG/rac/datafile/eport_fee_idx.274.839233923
channel ORA_DISK_1: restoring datafile 00007 to +DATABASEDG/rac/datafile/jablog.271.837406687
channel ORA_DISK_1: restoring datafile 00008 to +DATABASEDG/rac/datafile/jablog_blob.272.837406747
channel ORA_DISK_1: restoring datafile 00009 to +DATABASEDG/rac/datafile/dpe.273.837406883
channel ORA_DISK_1: restoring datafile 00010 to +DATABASEDG/rac/datafile/eport_fee_tab.270.839233931
channel ORA_DISK_1: restoring datafile 00011 to +DATABASEDG/rac/datafile/eport_idx_l.275.839233937
channel ORA_DISK_1: restoring datafile 00012 to +DATABASEDG/rac/datafile/eport_idx_s.276.839233945
channel ORA_DISK_1: restoring datafile 00014 to +DATABASEDG/rac/datafile/eport_tab_s.278.839233959
channel ORA_DISK_1: restoring datafile 00015 to +DATABASEDG/rac/datafile/eport_tab_xl.279.839233967
channel ORA_DISK_1: reading from backup piece /s01/oracle/backup/rac_20140212_3_1.dbf
channel ORA_DISK_1: piece handle=/s01/oracle/backup/rac_20140212_3_1.dbf tag=TAG20140212T072918
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:27
Finished restore at 12-FEB-14
Starting recover at 12-FEB-14
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 25 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_25.287.839316661
archived log for thread 1 with sequence 26 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_26.281.839316667
archived log for thread 1 with sequence 27 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_27.280.839316673
archived log for thread 1 with sequence 28 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_28.275.839316677
archived log for thread 1 with sequence 29 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_29.273.839316681
archived log for thread 2 with sequence 24 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_24.285.839316661
archived log for thread 2 with sequence 25 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_25.283.839316663
archived log for thread 2 with sequence 26 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_26.277.839316675
archived log for thread 2 with sequence 27 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_27.276.839316675
archived log for thread 2 with sequence 28 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_28.271.839316683
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_24.285.839316661 thread=2 sequence=24
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_25.287.839316661 thread=1 sequence=25
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_26.281.839316667 thread=1 sequence=26
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_25.283.839316663 thread=2 sequence=25
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_26.277.839316675 thread=2 sequence=26
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_27.280.839316673 thread=1 sequence=27
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_28.275.839316677 thread=1 sequence=28
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_27.276.839316675 thread=2 sequence=27
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_28.271.839316683 thread=2 sequence=28
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_29.273.839316681 thread=1 sequence=29
media recovery complete, elapsed time: 00:00:05
Finished recover at 12-FEB-14
RMAN>
[oracle@rac2 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 13 01:57:36 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL>alter database open resetlogs;
SQL> select tablespace_name from dba_tablespaces where contents='UNDO';
TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
+DATABASEDG/rac/tempfile/temp.264.836789383
SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';
TABLESPACE_NAME
------------------------------
TEMP
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26870952/viewspace-1080374/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 資料庫恢復過程資料庫
- DUL恢復資料庫過程資料庫
- 【資料庫資料恢復】透過恢復NDF檔案修復資料庫的資料恢復過程資料庫資料恢復
- MySQL恢復過程MySql
- 一次Oracle資料庫恢復過程Oracle資料庫
- RAC 11G ASM磁碟損壞恢復ASM
- 資料恢復記錄：硬碟分割槽損壞修復SqlServer資料庫過程資料恢復硬碟SQLServer資料庫
- 11g rac安裝過程感悟
- 【資料庫資料恢復】透過資料頁恢復Sql Server資料庫資料的過程資料庫資料恢復SQLServer
- oracle 11g rac 共享儲存壞掉後資料庫恢復Oracle資料庫
- low cache rba,on disk rba資料庫恢復過程資料庫
- oracle goldengate 恢復過程OracleGo
- 恢復之RAC資料庫RECOVER資料庫
- vsan儲存資料恢復過程—虛擬機器故障恢復過程資料恢復虛擬機
- 伺服器資料恢復案例：FreeNAS資料恢復過程記錄伺服器資料恢復
- 一次難忘的協助解決Oracle RAC恢復過程Oracle
- DG中模擬備庫斷檔並恢復過程
- 資料庫的一次資料恢復過程資料庫資料恢復
- 歸檔模式下資料庫全恢復的過程模式資料庫
- 一次客戶資料庫恢復的過程資料庫
- linux6.5安裝11g rac過程記錄 一Linux
- linux6.5安裝11g rac過程記錄 二Linux
- oracle 11G RAC 建立詳細過程Oracle
- 用flashback恢復儲存過程儲存過程
- MySQL 崩潰恢復過程分析MySql
- 閃回查詢恢復過程
- 【資料庫資料恢復】Sql Server資料庫檔案丟失的資料恢復過程資料庫資料恢復SQLServer
- 恢復之RAC資料庫DUPLICATE（一）資料庫
- AIX系統儲存故障後的Oracle 10g RAC恢復過程AIOracle 10g
- 一次客戶資料庫恢復的過程 [轉]資料庫
- 只存在RMAN備份片的資料庫恢復過程資料庫
- 【RMAN】資料庫到恢復目錄的註冊過程資料庫
- 虛擬機器資料丟失恢復過程記錄虛擬機
- 【11g 庫異地恢復】實驗
- Oracle 11g 資料庫恢復（一）Oracle資料庫
- RAC環境利用備份恢復RAC資料庫（五）資料庫
- RAC環境利用備份恢復RAC資料庫（四）資料庫
- RAC環境利用備份恢復RAC資料庫（三）資料庫