oracle备份还原到本地_Oracle 11g R2 RAC数据库备份通过RMAN恢复到单实例数据库实现...
Oracle 11g R2 RAC數據庫備份通過RMAN恢復到單實例數據庫實現
下面是我的一次從Oracle 11g R2 RAC到單實例間通過RMAN恢復備份集的過程，記錄在此。
有些人以此方法作為RMAN備份有效性校驗，當然我不反對這個說法，但我也相信RMAN提供的備份有效性校驗方法，參考我整理的博文：《Oracle RMAN(Recovery Manager) – 安全性與監控》
操作環境：
? Source DB: 2-Node Oracle Database 11g R2 RAC On Linux(11.2.0.1 with ASM)
? Target DB: Single Instance Database 11g R2 On Linux(11.2.0.1 with FileSystem)
目標端數據庫環境介紹：
[root@luocs ~]# hostname
羅成網·新聞資訊服務北大門
[root@luocs ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p1 388G 9.1G 359G 3% /
/dev/cciss/c0d0p3 421G 2.6G 397G 1% /data
tmpfs 5.9G 0 5.9G 0% /dev/shm
– 目標端磁盤空間需要充足，至少要比源端所有數據文件大小還大。
源端與目標端環境已準備好，下面開始進入操作。
1.將源端的一個FULL BACKUPSET拷貝到目標端
我在目標端創建/data/bak目錄，將備份文件放于這里
[root@luocs ~]# mkdir /data/bak
[root@luocs ~]# chown -R oracle.oinstall /data/bak/
異機拷貝使用scp或者ftp方式都可以，略。
我這里備份文件已打包，所以在目標端進行解壓
[oracle@luocs bak]$ tar zxvf fulldb20121211.tgz
[oracle@luocs bak]$ tar zxvf ArchFile20121211.tgz
2.從備份中恢復參數文件
我的一貫作風，在動現場之前保留一份源文件
[oracle@luocs dbs]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@luocs dbs]$ cp -p spfilehkrt.ora spfilehkrt.ora.bak
將數據庫啟動到nomount狀態
SQL> startup nomount
ORACLE instance started.
Total System Global Area 5077495808 bytes
Fixed Size 2212976 bytes
Variable Size 3288337296 bytes
Database Buffers 1744830464 bytes
Redo Buffers 42115072 bytes
通過RMAN工具還原出參數文件，還原出初始化參數文件
RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/inithkrt.ora' from '/data/bak/full_HKRT_1mnsi77q_1_1';
Starting restore at 12-DEC-2012 00:21:03
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /data/bak/full_HKRT_1mnsi77q_1_1
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 12-DEC-2012 00:21:05
3.編輯初始化參數文件，相應地創建所需目錄
[oracle@luocs dbs]$ cp -p inithkrt.ora inithkrt.ora.bak
我們恢復過來的參數文件是RAC的，所以我們要改成符合單實例數據庫
[oracle@luocs dbs]$ cat inithkrt.ora
#hkrt1.__db_cache_size=4362076160
#hkrt2.__db_cache_size=5972688896
#hkrt1.__java_pool_size=67108864
#hkrt2.__java_pool_size=67108864
#hkrt1.__large_pool_size=67108864
#hkrt2.__large_pool_size=67108864
#hkrt1.__pga_aggregate_target=7381975040
#hkrt2.__pga_aggregate_target=6710886400
#hkrt1.__sga_target=9395240960
#hkrt2.__sga_target=10066329600
#hkrt1.__shared_io_pool_size=0
#hkrt2.__shared_io_pool_size=0
#hkrt1.__shared_pool_size=4630511616
#hkrt2.__shared_pool_size=3825205248
#hkrt2.__streams_pool_size=0
#hkrt1.__streams_pool_size=134217728
*.audit_file_dest='/u01/app/oracle/admin/hkrt/adump'
*.audit_trail='db'
#*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/hkrt/control01.dbf','/u01/app/oracle/oradata/hkrt/control02.dbf'
*.db_block_size=8192
#*.db_create_file_dest='+ASMDATA'
*.db_domain=''
*.db_name='hkrt'
#*.db_recovery_file_dest='+RECOVERY'
#*.db_recovery_file_dest_size=47185920000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=hkrtXDB)'
#hkrt2.instance_number=2
#hkrt1.instance_number=1
#hkrt1.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac01-vip.hkrt.com)(PORT=1521))))'
#hkrt2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac02-vip.hkrt.com)(PORT=1521))))'
*.log_archive_dest_1='LOCATION=/u01/arch'
#*.log_archive_dest_2='LOCATION=+ARCH'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=5034213376
*.open_cursors=300
*.processes=400
#*.remote_listener='scan-cluster:1521'
*.remote_login_passwordfile='exclusive'
#hkrt2.thread=2
#hkrt1.thread=1
#hkrt1.undo_tablespace='UNDOTBS1'
#hkrt2.undo_tablespace='UNDOTBS2'
*.undo_tablespace='UNDOTBS1'
創建相應的目錄
[root@luocs ~]# mkdir /u01/arch
[root@luocs ~]# chown oracle.oinstall /u01/arch
-- 存放歸檔日志文件
[root@luocs ~]# mkdir /u01/app/oracle/admin/hkrt/adump -p
[root@luocs ~]# chown -R oracle.oinstall /u01/app/oracle/admin/hkrt
-- 存放審計跟蹤文件
[root@luocs ~]# mkdir /u01/app/oracle/oradata/hkrt/
[root@luocs ~]# chown oracle.oinstall /u01/app/oracle/oradata/hkrt/
-- 存放數據文件
4.通過編輯好的初始化參數重啟數據庫到NOMOUNT
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> create spfile from pfile;
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 5077495808 bytes
Fixed Size 2212976 bytes
Variable Size 3288337296 bytes
Database Buffers 1744830464 bytes
Redo Buffers 42115072 bytes
5.從備份集還原控制文件
我們從備份集里還原出控制文件
RMAN> restore controlfile from '/data/bak/full_HKRT_1lnsi77o_1_1';
Starting restore at 12-DEC-2012 00:35:22
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/hkrt/control01.dbf
output file name=/u01/app/oracle/oradata/hkrt/control02.dbf
Finished restore at 12-DEC-2012 00:35:23
將數據庫啟動到MOUNT狀態
RMAN> mount database;
database mounted
released channel: ORA_DISK_1
6.將備份集注冊進控制文件里
RMAN> catalog start with '/data/bak/';
searching for all files that match the pattern /data/bak/
List of Files Unknown to the Database
=====================================
File Name: /data/bak/full_HKRT_1mnsi77q_1_1
File Name: /data/bak/arch_HKRT_1onsi78l_1_1
File Name: /data/bak/ArchFile20121211.tgz
File Name: /data/bak/full_HKRT_1knsi76k_1_1
File Name: /data/bak/full_HKRT_1lnsi77o_1_1
File Name: /data/bak/full_HKRT_1jnsi76k_1_1
File Name: /data/bak/arch_HKRT_1nnsi78j_1_1
File Name: /data/bak/arch_HKRT_1pnsi7ha_1_1
File Name: /data/bak/fulldb20121211.tgz
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /data/bak/full_HKRT_1mnsi77q_1_1
File Name: /data/bak/arch_HKRT_1onsi78l_1_1
File Name: /data/bak/full_HKRT_1knsi76k_1_1
File Name: /data/bak/full_HKRT_1lnsi77o_1_1
File Name: /data/bak/full_HKRT_1jnsi76k_1_1
File Name: /data/bak/arch_HKRT_1nnsi78j_1_1
File Name: /data/bak/arch_HKRT_1pnsi7ha_1_1
List of Files Which Where Not Cataloged
=======================================
File Name: /data/bak/ArchFile20121211.tgz
RMAN-07517: Reason: The file header is corrupted
File Name: /data/bak/fulldb20121211.tgz
RMAN-07517: Reason: The file header is corrupted
可以通過list backup;查看，略。
7.確認數據文件、聯機日志文件、臨時文件路徑
SQL> set pagesize 9999
SQL> col NAME for a65
SQL> select file#,name from v$datafile;
FILE# NAME
---------- -----------------------------------------------------------------
1 +ASMDATA/hkrt/datafile/system.260.781033387
2 +ASMDATA/hkrt/datafile/sysaux.269.781033387
3 +ASMDATA/hkrt/datafile/undotbs1.264.781033387
4 +ASMDATA/hkrt/datafile/users.268.781033387
5 +ASMDATA/hkrt/datafile/undotbs2.265.781033679
6 +ASMDATA/hkrt/datafile/sell.270.786630869
7 +ASMDATA/hkrt/datafile/proxy.271.786631115
8 +ASMDATA/hkrt/datafile/pay.272.786631367
9 +ASMDATA/hkrt/datafile/payment.273.786631689
10 +ASMDATA/hkrt/datafile/cms.274.786724997
11 +ASMDATA/hkrt/datafile/itrusradb.276.787063121
12 +ASMDATA/hkrt/datafile/itruscadb.275.787061395
13 +ASMDATA/hkrt/datafile/ob2c.277.789750069
13 rows selected.
SQL> col MEMBER for a65
SQL> select member from v$logfile;
MEMBER
------------------------------------------------------------------------------------------------------------------------------------------------------
+ASMDATA/hkrt/onlinelog/group_5.262.781033549
+RECOVERY/hkrt/onlinelog/group_5.259.781033555
+ASMDATA/hkrt/onlinelog/group_2.266.781033537
+RECOVERY/hkrt/onlinelog/group_2.258.781033543
+ASMDATA/hkrt/onlinelog/group_1.267.781033527
+RECOVERY/hkrt/onlinelog/group_1.257.781033533
+ASMDATA/hkrt/onlinelog/group_3.259.781033803
+RECOVERY/hkrt/onlinelog/group_3.260.781033809
+ASMDATA/hkrt/onlinelog/group_4.258.781033815
+RECOVERY/hkrt/onlinelog/group_4.261.781033821
+ASMDATA/hkrt/onlinelog/group_6.257.781033825
+RECOVERY/hkrt/onlinelog/group_6.262.781033831
12 rows selected.
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
+ASMDATA/hkrt/tempfile/temp.261.781033565
8.通過RMAN重命名數據文件和臨時文件，進行還原
RMAN> RUN {
2> SET NEWNAME FOR DATAFILE 1 to '/u01/app/oracle/oradata/hkrt/system01.dbf';
3> SET NEWNAME FOR DATAFILE 2 to '/u01/app/oracle/oradata/hkrt/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 3 to '/u01/app/oracle/oradata/hkrt/undotbs1.dbf';
SET NEWNAME FOR DATAFILE 4 to '/u01/app/oracle/oradata/hkrt/users01.dbf';
6> SET NEWNAME FOR DATAFILE 5 to '/u01/app/oracle/oradata/hkrt/undotbs2.dbf';
SET NEWNAME FOR DATAFILE 6 to '/u01/app/oracle/oradata/hkrt/sell01.dbf';
SET NEWNAME FOR DATAFILE 7 to '/u01/app/oracle/oradata/hkrt/proxy01.dbf';
9> SET NEWNAME FOR DATAFILE 8 to '/u01/app/oracle/oradata/hkrt/pay01.dbf';
10> SET NEWNAME FOR DATAFILE 9 to '/u01/app/oracle/oradata/hkrt/payment01.dbf';
SET NEWNAME FOR DATAFILE 10 to '/u01/app/oracle/oradata/hkrt/cms01.dbf';
SET NEWNAME FOR DATAFILE 11 to '/u01/app/oracle/oradata/hkrt/itrusradb01.dbf';
SET NEWNAME FOR DATAFILE 12 to '/u01/app/oracle/oradata/hkrt/itruscadb01.dbf';
14> SET NEWNAME FOR DATAFILE 13 to '/u01/app/oracle/oradata/hkrt/ob2c01.dbf';
SET NEWNAME FOR TEMPFILE 1 to '/u01/app/oracle/oradata/hkrt/temp01.dbf';
RESTORE DATABASE;
17> SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
19>
20> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-DEC-2012 00:37:38
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 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/hkrt/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/hkrt/undotbs1.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/hkrt/sell01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/hkrt/pay01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/hkrt/cms01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/hkrt/itrusradb01.dbf
channel ORA_DISK_1: reading from backup piece /u01/bak/rman_bk/full_HKRT_1knsi76k_1_1
channel ORA_DISK_1: errors found reading piece handle=/u01/bak/rman_bk/full_HKRT_1knsi76k_1_1
channel ORA_DISK_1: failover to piece handle=/data/bak/full_HKRT_1knsi76k_1_1 tag=BACKUPDATABASE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06: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 00002 to /u01/app/oracle/oradata/hkrt/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/hkrt/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/hkrt/undotbs2.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/hkrt/proxy01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/hkrt/payment01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/hkrt/itruscadb01.dbf
channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/hkrt/ob2c01.dbf
channel ORA_DISK_1: reading from backup piece /data/bak/full_HKRT_1jnsi76k_1_1
channel ORA_DISK_1: piece handle=/data/bak/full_HKRT_1jnsi76k_1_1 tag=BACKUPDATABASE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06:05
Finished restore at 12-DEC-2012 00:50:01
datafile 1 switched to datafile copy
input datafile copy RECID=14 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=15 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=16 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=17 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=18 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/undotbs2.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=19 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/sell01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=20 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/proxy01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=21 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/pay01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=22 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/payment01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=23 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/cms01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=24 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/itrusradb01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=25 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/itruscadb01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=26 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/ob2c01.dbf
renamed tempfile 1 to /u01/app/oracle/oradata/hkrt/temp01.dbf in control file
9.修改聯機日志文件的路徑
alter database rename file '+ASMDATA/hkrt/onlinelog/group_1.267.781033527' to '/u01/app/oracle/oradata/hkrt/redo1_1.log';
alter database rename file '+RECOVERY/hkrt/onlinelog/group_1.257.781033533' to '/u01/app/oracle/oradata/hkrt/redo1_2.log';
alter database rename file '+ASMDATA/hkrt/onlinelog/group_2.266.781033537' to '/u01/app/oracle/oradata/hkrt/redo2_1.log';
alter database rename file '+RECOVERY/hkrt/onlinelog/group_2.258.781033543' to '/u01/app/oracle/oradata/hkrt/redo2_2.log';
alter database rename file '+ASMDATA/hkrt/onlinelog/group_3.259.781033803' to '/u01/app/oracle/oradata/hkrt/redo3_1.log';
alter database rename file '+RECOVERY/hkrt/onlinelog/group_3.260.781033809' to '/u01/app/oracle/oradata/hkrt/redo3_2.log';
alter database rename file '+ASMDATA/hkrt/onlinelog/group_4.258.781033815' to '/u01/app/oracle/oradata/hkrt/redo4_1.log';
alter database rename file '+RECOVERY/hkrt/onlinelog/group_4.261.781033821' to '/u01/app/oracle/oradata/hkrt/redo4_2.log';
alter database rename file '+ASMDATA/hkrt/onlinelog/group_5.262.781033549' to '/u01/app/oracle/oradata/hkrt/redo5_1.log';
alter database rename file '+RECOVERY/hkrt/onlinelog/group_5.259.781033555' to '/u01/app/oracle/oradata/hkrt/redo5_2.log';
alter database rename file '+ASMDATA/hkrt/onlinelog/group_6.257.781033825' to '/u01/app/oracle/oradata/hkrt/redo6_1.log';
alter database rename file '+RECOVERY/hkrt/onlinelog/group_6.262.781033831' to '/u01/app/oracle/oradata/hkrt/redo6_2.log';
-- 上面操作在執行的時候會報ERROR，類似如下：
SQL> alter database rename file '+ASMDATA/hkrt/onlinelog/group_6.257.781033825' to '/u01/app/oracle/oradata/hkrt/redo6_1.log';
alter database rename file '+ASMDATA/hkrt/onlinelog/group_6.257.781033825' to '/u01/app/oracle/oradata/hkrt/redo6_1.log'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 14779
Session ID: 158 Serial number: 3
-- 可見報錯后session被斷開，我們需要重新連接實例繼續往下執行
聯機日志文件修改之后查看
SQL> set pagesize 9999
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/hkrt/redo5_1.log
/u01/app/oracle/oradata/hkrt/redo5_2.log
/u01/app/oracle/oradata/hkrt/redo2_1.log
/u01/app/oracle/oradata/hkrt/redo2_2.log
/u01/app/oracle/oradata/hkrt/redo1_1.log
/u01/app/oracle/oradata/hkrt/redo1_2.log
/u01/app/oracle/oradata/hkrt/redo3_1.log
/u01/app/oracle/oradata/hkrt/redo3_2.log
/u01/app/oracle/oradata/hkrt/redo4_1.log
/u01/app/oracle/oradata/hkrt/redo4_2.log
/u01/app/oracle/oradata/hkrt/redo6_1.log
/u01/app/oracle/oradata/hkrt/redo6_2.log
12 rows selected.
10.恢復數據庫
RMAN> recover database;
Starting recover at 12-DEC-2012 01:07:39
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=515
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=506
channel ORA_DISK_1: reading from backup piece /data/bak/arch_HKRT_1onsi78l_1_1
channel ORA_DISK_1: piece handle=/data/bak/arch_HKRT_1onsi78l_1_1 tag=BACKUPARCH
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:35
archived log file name=/u01/arch/1_515_781033526.dbf thread=1 sequence=515
archived log file name=/u01/arch/2_506_781033526.dbf thread=2 sequence=506
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=516
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=507
channel ORA_DISK_1: reading from backup piece /data/bak/arch_HKRT_1pnsi7ha_1_1
channel ORA_DISK_1: piece handle=/data/bak/arch_HKRT_1pnsi7ha_1_1 tag=BACKUPARCH
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/arch/1_516_781033526.dbf thread=1 sequence=516
archived log file name=/u01/arch/2_507_781033526.dbf thread=2 sequence=507
unable to find archived log
archived log thread=2 sequence=508
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/12/2012 01:11:21
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 508 and starting SCN of 121279435
11.RESETLOGS打開數據庫
SQL> alter database open resetlogs;
Database altered.
完整輸出日志內容：
alter database open resetlogs
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
RESETLOGS after incomplete recovery UNTIL CHANGE 121279435
Resetting resetlogs activation ID 3199883568 (0xbeba5930)
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Dec 12 01:13:12 2012
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Dec 12 01:13:25 2012
Setting recovery target incarnation to 3
Wed Dec 12 01:13:25 2012
Assigning activation ID 3220640364 (0xbff7126c)
LGWR: STARTING ARCH PROCESSES
Wed Dec 12 01:13:25 2012
ARC0 started with pid=21, OS id=14930
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Wed Dec 12 01:13:26 2012
ARC1 started with pid=25, OS id=14934
Wed Dec 12 01:13:26 2012
ARC2 started with pid=26, OS id=14938
Wed Dec 12 01:13:26 2012
ARC3 started with pid=27, OS id=14942
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/hkrt/redo1_1.log
Current log# 1 seq# 1 mem# 1: /u01/app/oracle/oradata/hkrt/redo1_2.log
Successful open of redo thread 1
Wed Dec 12 01:13:26 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Dec 12 01:13:26 2012
SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Redo thread 2 internally disabled at seq 1 (CKPT)
ARC3: Archiving disabled thread 2 sequence 1
Archived Log entry 1974 added for thread 2 sequence 1 ID 0x0 dest 1:
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Wed Dec 12 01:13:31 2012
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_dbw0_14440.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/hkrt/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_dbw0_14440.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/hkrt/temp01.dbf'
File 201 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Re-creating tempfile /u01/app/oracle/oradata/hkrt/temp01.dbf
Database Characterset is AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Dec 12 01:13:38 2012
Starting background process QMNC
Wed Dec 12 01:13:38 2012
QMNC started with pid=28, OS id=14950
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open resetlogs
Wed Dec 12 01:13:52 2012
Starting background process CJQ0
Wed Dec 12 01:13:52 2012
CJQ0 started with pid=34, OS id=14982
12.后續檢查
到這里RAC到單實例備份恢復已經完畢，我們可以簡單檢查下
到這里RAC到單實例備份恢復已經完畢，我們可以簡單檢查下
SQL> select thread#,status,enabled from v$thread;
THREAD# STATUS ENABLED
---------- ------------ ----------------
1 OPEN PUBLIC
2 CLOSED PUBLIC
SQL> select group#,thread#,archived,status from v$log;
GROUP# THREAD# ARCHIV STATUS
---------- ---------- ------ --------------------------------
1 1 NO CURRENT
2 1 YES UNUSED
3 2 YES ACTIVE
4 2 YES UNUSED
5 1 YES UNUSED
6 2 YES UNUSED
6 rows selected.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/arch
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
最后聊一下從full backupset里如何找出參數文件和控制文件備份集的方法
[oracle@luocs bak]$ ls -l
total 10951248
-rw-r--r-- 1 oracle oinstall 3393916104 Dec 11 08:22 ArchFile20121211.tgz
-rw-r----- 1 oracle oinstall 1953459712 Dec 11 01:06 arch_HKRT_1nnsi78j_1_1
-rw-r----- 1 oracle oinstall 1887318528 Dec 11 01:06 arch_HKRT_1onsi78l_1_1
-rw-r----- 1 oracle oinstall 32256 Dec 11 01:06 arch_HKRT_1pnsi7ha_1_1
-rw-r--r-- 1 oracle oinstall 569727216 Dec 11 08:21 fulldb20121211.tgz
-rw-r----- 1 oracle oinstall 1928757248 Dec 11 01:01 full_HKRT_1jnsi76k_1_1
-rw-r----- 1 oracle oinstall 1450770432 Dec 11 01:01 full_HKRT_1knsi76k_1_1
-rw-r----- 1 oracle oinstall 18972672 Dec 11 01:01 full_HKRT_1lnsi77o_1_1
-rw-r----- 1 oracle oinstall 98304 Dec 11 01:01 full_HKRT_1mnsi77q_1_1
這里以full開頭的就是數據文件+參數文件+控制文件的備份集，分辨方法非常簡單，看大小即可。
一般最小的為參數文件備份集，大的是數據文件備份集。
如果你難以確定，直接到RMAN里嘗試下就可以。
總結
以上是生活随笔為你收集整理的oracle备份还原到本地_Oracle 11g R2 RAC数据库备份通过RMAN恢复到单实例数据库实现...的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： python开发web运维工具_Pyth
- 下一篇： arcgis python脚本实现从界面