您好,登錄后才能下訂單哦!
【DATAGUARD】物理dg的failover切換(六)
各位技術(shù)愛好者,看完本文后,你可以掌握如下的技能,也可以學(xué)到一些其它你所不知道的知識,~O(∩_∩)O~:
① 物理dg的failover切換演練過程
② 物理dg管理和維護的一些sql
③ 利用duplicate搭建物理dg
④
注意:本篇BLOG中代碼部分需要特別關(guān)注的地方我都用黃色背景和紅色字體來表示,比如下邊的例子中,thread 1的最大歸檔日志號為33,thread 2的最大歸檔日志號為43是需要特別關(guān)注的地方。
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 32 1621589 2015-05-29 11:09:52 1625242 2015-05-29 11:15:48
1 33 1625242 2015-05-29 11:15:48 1625293 2015-05-29 11:15:58
2 42 1613951 2015-05-29 10:41:18 1625245 2015-05-29 11:15:49
2 43 1625245 2015-05-29 11:15:49 1625253 2015-05-29 11:15:53
本文如有錯誤或不完善的地方請大家多多指正,ITPUB留言或QQ皆可,您的批評指正是我寫作的最大動力。
項目 |
主庫 |
dg庫 |
db 類型 |
單實例 |
單實例 |
db version |
11.2.0.3 |
11.2.0.3 |
db 存儲 |
FS type |
FS type |
ORACLE_SID |
oradg11g |
oradgphy |
db_name |
oradg11g |
oradg11g |
主機IP地址: |
192.168.59.130 |
192.168.59.130 |
OS版本及kernel版本 |
RHEL6.5 64位,2.6.32-504.16.2.el6.x86_64 |
RHEL6.5 64位,2.6.32-504.16.2.el6.x86_64 |
OS hostname |
rhel6_lhr |
rhel6_lhr |
【DATAGUARD】 基于同一個主機建立物理備庫和邏輯備庫(一): http://blog.itpub.net/26736162/viewspace-1448197/
【DATAGUARD】 基于同一個主機建立物理備庫和邏輯備庫(二 ): http://blog.itpub.net/26736162/viewspace-1448207/
【DATAGUARD】 基于同一個主機建立物理備庫和邏輯備庫(三 ): http://blog.itpub.net/26736162/viewspace-1481972/
【DATAGUARD】 基于同一個主機建立物理備庫和邏輯備庫 (四)--添加一個物理dg節(jié)點 :http://blog.itpub.net/26736162/viewspace-1484878/
【DATAGUARD】物理dg的switchover切換(五) :http://blog.itpub.net/26736162/viewspace-1753111/
接上一篇文章【DATAGUARD】物理dg的switchover切換(五) :http://blog.itpub.net/26736162/viewspace-1753111/,本章中介紹failover的切換。
1.角色
Oracle 數(shù)據(jù)庫中含有兩種角色。
用戶角色:定義了一組權(quán)限的集合,該角色可以分配給用戶,也可以分配給其他角色。
數(shù)據(jù)庫角色:在備庫中數(shù)據(jù)庫扮演什么樣的角色,primary還是standby。
v$database.DATABASE_ROLE標(biāo)識了數(shù)據(jù)庫的運行角色。
處于備庫環(huán)境中,數(shù)據(jù)庫有兩種類型:phsical standby、logical standby。
2.角色管理服務(wù)
一個數(shù)據(jù)庫運行在如下互相排斥的角色中。
Primary role:一個數(shù)據(jù)庫運行在primary role,那么log transport services傳遞重做日志到備庫。
Standby role:一個數(shù)據(jù)庫運行在standby role,那么log apply services應(yīng)用歸檔日志到備庫。
角色管理服務(wù)允許用戶動態(tài)地在主、備庫中進行角色切換。
用戶可以使用角色管理服務(wù),進行主、備庫的計劃中的角色切換,這個叫switchover,或者是非計劃中的角色切換,叫failover。
3.Switchover&Failover
切換是在主數(shù)據(jù)庫與其備數(shù)據(jù)庫之間進行角色反轉(zhuǎn),切換確保不丟失數(shù)據(jù)。這是對于主系統(tǒng)計劃維護的典型操作。在切換期間,主數(shù)據(jù)庫轉(zhuǎn)換到備角色,備數(shù)據(jù)庫轉(zhuǎn)換到主角色。轉(zhuǎn)換發(fā)生不需要重建任何數(shù)據(jù)庫。
(1)Switchover
用到的場景:計劃中的角色轉(zhuǎn)換或用戶操作系統(tǒng)和硬件的維護等。
(2)Failover
故障轉(zhuǎn)移是當(dāng)主數(shù)據(jù)庫不可用時執(zhí)行的。故障轉(zhuǎn)移只有在主數(shù)據(jù)庫災(zāi)難故障的情況下執(zhí)行,并且故障轉(zhuǎn)移導(dǎo)致備數(shù)據(jù)庫轉(zhuǎn)換到主角色。用到的場景:非計劃中的角色切換,一般在緊急情況下使用。根據(jù)保護模式的不同,可能會沒有或者很少的數(shù)據(jù)損失。
(3)角色轉(zhuǎn)換決策樹
角色轉(zhuǎn)換(switchover&failover)的最終目的是盡快地使主庫在線,而同時盡量減少數(shù)據(jù)損失或者是實現(xiàn)無數(shù)據(jù)損失。盡量選擇宕機時間最短,同時數(shù)據(jù)損失最小的策略。總之在失敗切換前,應(yīng)該先考慮修復(fù)主數(shù)據(jù)庫或者進行無數(shù)據(jù)損失的角色轉(zhuǎn)換。
即使使用無數(shù)據(jù)損失的備庫方案,修復(fù)主庫可能會比切換到備庫更快點。如果修復(fù)了主庫,那么就不需要修改客戶端的連接。但是如果修復(fù)工作導(dǎo)致了任何的數(shù)據(jù)損失,那么可能需要重新創(chuàng)建所有的備用數(shù)據(jù)庫。
通常情況下,最合適切換的備庫為已經(jīng)應(yīng)用了最多的歸檔日志的備用數(shù)據(jù)庫。
① 主庫和物理dg的failover切換
② 還原為最初始的狀態(tài)
注:failover切換后原來的主庫將不可用,必須重新搭建,所以該實驗請慎重選擇。
[oracle@rhel6_lhr oradg11g]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期日 7月 26 21:26:20 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
21:26:20 SQL>
21:26:29 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PRIMARY TO STANDBY oradg11g
已用時間: 00: 00: 00.01
21:26:37 SQL> alter system switch logfile;
系統(tǒng)已更改。
已用時間: 00: 00: 00.01
21:27:31 SQL> create table test as select * from dba_objects;
表已創(chuàng)建。
已用時間: 00: 00: 00.50
21:27:38 SQL> insert into test select * from test;
已創(chuàng)建 75250 行。
已用時間: 00: 00: 00.51
21:27:56 SQL> insert into test select * from test;
已創(chuàng)建 150500 行。
已用時間: 00: 00: 02.62
21:28:00 SQL> commit;
提交完成。
已用時間: 00: 00: 00.00
21:28:06 SQL> insert into test select * from test;
已創(chuàng)建 301000 行。
已用時間: 00: 00: 12.41
21:28:21 SQL> commit;
提交完成。
已用時間: 00: 00: 00.00
21:28:27 SQL> insert into test select * from test;
已創(chuàng)建 602000 行。
已用時間: 00: 00: 22.63
21:29:08 SQL> commit;
提交完成。
已用時間: 00: 00: 01.29
21:29:12 SQL> shutdown abort;
ORACLE 例程已經(jīng)關(guān)閉。
21:29:14 SQL>
備庫查詢:
20:45:30 SQL> select count(1) from test;
COUNT(1)
----------
1204000
已用時間: 00: 00: 00.05
21:29:42 SQL> select thread#, low_sequence#, high_sequence# from v$archive_gap;
未選定行
已用時間: 00: 00: 00.02
21:31:23 SQL>
如果沒有發(fā)現(xiàn)明顯的gap現(xiàn)象,說明此次的failover不會有數(shù)據(jù)損失情況。在standby端,要進行關(guān)閉apply和結(jié)束應(yīng)用動作。
21:31:23 SQL> alter database recover managed standby database cancel;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 01.01
21:33:46 SQL> alter database recover managed standby database finish;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.31
21:33:52 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ ONLY PHYSICAL STANDBY TO PRIMARY oradgphy
已用時間: 00: 00: 00.01
21:34:16 SQL> alter database commit to switchover to primary with session shutdown;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.07
21:36:16 SQL>
21:36:16 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG MOUNTED PRIMARY NOT ALLOWED oradgphy
已用時間: 00: 00: 00.01
21:38:18 SQL> alter database open;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.30
21:38:42 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PRIMARY RESOLVABLE GAP oradgphy
已用時間: 00: 00: 00.00
21:38:49 SQL>
切換成功。切換之后,我們觀察這個過程的日志情況。
alert日志:
alter database recover managed standby database cancel
Sun Jul 26 21:33:45 2015
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/oradgphy/oradgphy/trace/oradgphy_pr00_45791.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 1874535
Sun Jul 26 21:33:46 2015
MRP0: Background Media Recovery process shutdown (oradgphy)
Managed Standby Recovery Canceled (oradgphy)
Completed: alter database recover managed standby database cancel
alter database recover managed standby database finish
Attempt to do a Terminal Recovery (oradgphy)
Media Recovery Start: Managed Standby Recovery (oradgphy)
started logmerger process
Sun Jul 26 21:33:52 2015
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 2 slaves
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Terminal Recovery timestamp is '07/26/2015 21:33:52'
Terminal Recovery: applying standby redo logs.
Terminal Recovery: thread 1 seq# 183 redo required
Terminal Recovery:
Recovery of Online Redo Log: Thread 1 Group 4 Seq 183 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/oradgphy/standby_redo04.log
Identified End-Of-Redo (failover) for thread 1 sequence 183 at SCN 0xffff.ffffffff
Incomplete Recovery applied until change 1874536 time 07/26/2015 21:29:12
Media Recovery Complete (oradgphy)
Terminal Recovery: successful completion
Sun Jul 26 21:33:52 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance oradgphy - Archival Error
ORA-16014: log 4 sequence# 183 not archived, no available destinations
ORA-00312: online log 4 thread 1: '/u01/app/oracle/oradata/oradgphy/standby_redo04.log'
Forcing ARSCN to IRSCN for TR 0:1874536
Attempt to set limbo arscn 0:1874536 irscn 0:1874536
Resetting standby activation ID 1413582769 (0x54418fb1)
Completed: alter database recover managed standby database finish
Sun Jul 26 21:36:16 2015
alter database commit to switchover to primary with session shutdown
ALTER DATABASE SWITCHOVER TO PRIMARY (oradgphy)
Maximum wait for role transition is 15 minutes.
All dispatchers and shared servers shutdown
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Sun Jul 26 21:36:16 2015
SMON: disabling cache recovery
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/oradgphy/oradgphy/trace/oradgphy_ora_45673.trc
Standby terminal recovery start SCN: 1874535
RESETLOGS after incomplete recovery UNTIL CHANGE 1874536
Online log /u01/app/oracle/oradata/oradgphy/redo01.log: Thread 1 Group 1 was previously cleared
Online log /u01/app/oracle/oradata/oradgphy/redo02.log: Thread 1 Group 2 was previously cleared
Online log /u01/app/oracle/oradata/oradgphy/redo03.log: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 1874534
Sun Jul 26 21:36:16 2015
Setting recovery target incarnation to 3
AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.
Switchover: Complete - Database mounted as primary
Completed: alter database commit to switchover to primary with session shutdown
Sun Jul 26 21:36:45 2015
idle dispatcher 'D000' terminated, pid = (17, 1)
Sun Jul 26 21:36:54 2015
ARC0: Becoming the 'no SRL' ARCH
Sun Jul 26 21:36:55 2015
ARC1: Becoming the 'no SRL' ARCH
21:38:49 SQL> alter system switch logfile;
系統(tǒng)已更改。
已用時間: 00: 00: 00.01
21:40:59 SQL> delete from test where rownum<=10000;
已刪除10000行。
已用時間: 00: 00: 00.13
21:41:31 SQL> commit;
提交完成。
已用時間: 00: 00: 00.00
21:42:27 SQL> set line 9999
21:42:49 SQL> col DEST_NAME format a20
21:42:49 SQL> col DESTINATION format a20
21:42:49 SQL> col GAP_STATUS format a10
21:42:49 SQL> col DB_UNIQUE_NAME format a10
21:42:49 SQL> col error format a10
21:42:49 SQL> SELECT al.thread#,
21:42:50 2 ads.dest_id,
21:42:50 3 ads.DEST_NAME,
21:42:50 4 (SELECT ad.TARGET
21:42:50 5 FROM v$archive_dest AD
21:42:50 6 WHERE AD.DEST_ID = ADS.DEST_ID) TARGET,
21:42:50 7 ADS.DATABASE_MODE,
21:42:50 8 ads.STATUS,
21:42:50 9 ads.error,
21:42:50 10 ads.TYPE,
21:42:50 11 ads.RECOVERY_MODE,
21:42:50 12 ads.DB_UNIQUE_NAME,
21:42:50 13 ads.DESTINATION,
21:42:50 14 ads.GAP_STATUS,
21:42:50 15 (SELECT MAX(sequence#) FROM v$log na WHERE na.thread# = al.thread#) "Current Sequence",
21:42:50 16 MAX(sequence#) "Last Archived",
21:42:50 17 MAX(decode(al.APPLIED, 'YES', sequence#)) APPLIED_SEQ#
21:42:50 18 FROM (SELECT *
21:42:50 19 FROM v$archived_log V
21:42:50 20 WHERE V.resetlogs_change# =
21:42:50 21 (SELECT d.RESETLOGS_CHANGE# FROM v$database d)) al,
21:42:50 22 v$archive_dest_status ads
21:42:50 23 WHERE al.dest_id(+) = ads.dest_id
21:42:50 24 AND ads.STATUS != 'INACTIVE'
21:42:50 25 GROUP BY al.thread#,
21:42:50 26 ads.dest_id,
21:42:50 27 ads.DEST_NAME,
21:42:50 28 ads.STATUS,
21:42:50 29 ads.error,
21:42:50 30 ads.TYPE,
21:42:50 31 ADS.DATABASE_MODE,
21:42:50 32 ads.RECOVERY_MODE,
21:42:50 33 ads.DB_UNIQUE_NAME,
21:42:50 34 ads.DESTINATION,
21:42:50 35 ads.GAP_STATUS
21:42:50 36 ORDER BY al.thread#,
21:42:50 37 ads.dest_id;
THREAD# DEST_ID DEST_NAME TARGET DATABASE_MODE STATUS ERROR TYPE RECOVERY_MODE DB_UNIQUE_ DESTINATION GAP_STATUS Current Sequence Last Archived APPLIED_SEQ#
---------- ---------- -------------------- ------- --------------- --------- ---------- -------------- ----------------------- ---------- -------------------- ---------- ---------------- ------------- ------------
1 1 LOG_ARCHIVE_DEST_1 PRIMARY OPEN VALID LOCAL IDLE oradgphy 4 3
2 LOG_ARCHIVE_DEST_2 STANDBY UNKNOWN ERROR ORA-01034: UNKNOWN IDLE oradg11g tns_oradg11g RESOLVABLE
ORACLE GAP
不可用
已用時間: 00: 00: 00.00
21:42:50 SQL>
此時,failover過程成功。
21:52:00 SQL> startup
ORACLE 例程已經(jīng)啟動。
Total System Global Area 208769024 bytes
Fixed Size 2226936 bytes
Variable Size 146801928 bytes
Database Buffers 54525952 bytes
Redo Buffers 5214208 bytes
數(shù)據(jù)庫裝載完畢。
數(shù)據(jù)庫已經(jīng)打開。
21:52:15 SQL> alter database commit to switchover to physical standby with session shutdown;
alter database commit to switchover to physical standby with session shutdown
*
第 1 行出現(xiàn)錯誤:
ORA-16416: 沒有可行的 Physical Standby 切換目標(biāo)
已用時間: 00: 00: 02.06
21:52:24 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PRIMARY FAILED DESTINATION oradg11g
已用時間: 00: 00: 00.00
21:52:31 SQL>
現(xiàn)在原來的主庫被修復(fù)后,整個DataGuara架構(gòu)已經(jīng)被破壞了,所以必須把原來的主庫刪除后構(gòu)建成新的備庫,重新恢復(fù)DataGuard的環(huán)境,最后可以根據(jù)需要是否進行switchover切換來調(diào)整環(huán)境。
[oracle@rhel6_lhr oradg11g]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期日 7月 26 21:59:40 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
21:59:40 SQL> alter database close;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 02.17
22:00:01 SQL> alter system enable restricted session;
系統(tǒng)已更改。
已用時間: 00: 00: 02.06
22:00:05 SQL> drop database;
數(shù)據(jù)庫已刪除。
從 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 斷開
已用時間: 00: 00: 08.50
22:00:31 SQL> exit
[oracle@rhel6_lhr oradg11g]$ cd $ORACLE_HOME/dbs
[oracle@rhel6_lhr dbs]$ rm -rf spfileoradg11g.ora
[oracle@rhel6_lhr dbs]$ ll spfileoradg11g.ora
ls: cannot access spfileoradg11g.ora: No such file or directory
[oracle@rhel6_lhr dbs]$ more initoradg
initoradg11g.ora initoradglg.ora initoradgphy.ora initoradgss.ora
[oracle@rhel6_lhr dbs]$ more initoradg11g.ora
db_name='oradg11g'
[oracle@rhel6_lhr dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期日 7月 26 22:02:20 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
已連接到空閑例程。
22:02:20 SQL> startup nomount;
ORACLE 例程已經(jīng)啟動。
Total System Global Area 250560512 bytes
Fixed Size 2227256 bytes
Variable Size 192938952 bytes
Database Buffers 50331648 bytes
Redo Buffers 5062656 bytes
22:02:25 SQL> exit
從 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 斷開
[oracle@rhel6_lhr dbs]$
oracle@rhel6_lhr dbs]$ rman target sys/lhr@tns_oradgphy auxiliary sys/lhr@tns_oradg11g
恢復(fù)管理器: Release 11.2.0.3.0 - Production on 星期日 7月 26 22:04:17 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
已連接到目標(biāo)數(shù)據(jù)庫: ORADG11G (DBID=1403587593)
已連接到輔助數(shù)據(jù)庫: ORADG11G (未裝載)
RMAN> duplicate target database
2> for standby nofilenamecheck
3> from active database
4> DORECOVER
5> spfile
6> set db_unique_name='oradg11g'
7> set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)'
8> set log_archive_dest_2='SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
9> set log_archive_dest_3='SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
10> set log_archive_dest_4='SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
11> set log_archive_dest_state_1='ENABLE'
12> set log_archive_dest_state_2='ENABLE'
13> set log_archive_dest_state_3='defer'
14> set log_archive_dest_state_4='defer'
15> set standby_file_management='AUTO'
16> set fal_client='oradg11g'
17> set fal_server='oradgphy'
18> set control_files='/u01/app/oracle/oradata/oradg11g/control01.ctl','/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl'
19> set db_file_name_convert='oradgphy','oradg11g'
20> set log_file_name_convert='oradgphy','oradg11g'
21> set memory_target='200M'
22> set audit_file_dest='/u01/app/oracle/admin/oradg11g/adump'
23> ;
啟動 Duplicate Db 于 2015-07-26 22:04:34
使用目標(biāo)數(shù)據(jù)庫控制文件替代恢復(fù)目錄
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=171 設(shè)備類型=DISK
內(nèi)存腳本的內(nèi)容:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworadgphy' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworadg11g' targetfile
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradgphy.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora''";
}
正在執(zhí)行內(nèi)存腳本
啟動 backup 于 2015-07-26 22:04:34
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=145 設(shè)備類型=DISK
完成 backup 于 2015-07-26 22:04:37
sql 語句: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora''
內(nèi)存腳本的內(nèi)容:
{
sql clone "alter system set db_unique_name =
''oradg11g'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_2 =
''SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_3 =
''SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_4 =
''SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_1 =
''ENABLE'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_2 =
''ENABLE'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_3 =
''defer'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_4 =
''defer'' comment=
'''' scope=spfile";
sql clone "alter system set standby_file_management =
''AUTO'' comment=
'''' scope=spfile";
sql clone "alter system set fal_client =
''oradg11g'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''oradgphy'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''/u01/app/oracle/oradata/oradg11g/control01.ctl'', ''/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''oradgphy'', ''oradg11g'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''oradgphy'', ''oradg11g'' comment=
'''' scope=spfile";
sql clone "alter system set memory_target =
200M comment=
'''' scope=spfile";
sql clone "alter system set audit_file_dest =
''/u01/app/oracle/admin/oradg11g/adump'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
正在執(zhí)行內(nèi)存腳本
sql 語句: alter system set db_unique_name = ''oradg11g'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_1 = ''LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_2 = ''SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_3 = ''SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_4 = ''SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_state_1 = ''ENABLE'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_state_2 = ''ENABLE'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_state_3 = ''defer'' comment= '''' scope=spfile
sql 語句: alter system set log_archive_dest_state_4 = ''defer'' comment= '''' scope=spfile
sql 語句: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile
sql 語句: alter system set fal_client = ''oradg11g'' comment= '''' scope=spfile
sql 語句: alter system set fal_server = ''oradgphy'' comment= '''' scope=spfile
sql 語句: alter system set control_files = ''/u01/app/oracle/oradata/oradg11g/control01.ctl'', ''/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl'' comment= '''' scope=spfile
sql 語句: alter system set db_file_name_convert = ''oradgphy'', ''oradg11g'' comment= '''' scope=spfile
sql 語句: alter system set log_file_name_convert = ''oradgphy'', ''oradg11g'' comment= '''' scope=spfile
sql 語句: alter system set memory_target = 200M comment= '''' scope=spfile
sql 語句: alter system set audit_file_dest = ''/u01/app/oracle/admin/oradg11g/adump'' comment= '''' scope=spfile
Oracle 實例已關(guān)閉
已連接到輔助數(shù)據(jù)庫 (未啟動)
Oracle 實例已啟動
系統(tǒng)全局區(qū)域總計 208769024 字節(jié)
Fixed Size 2226936 字節(jié)
Variable Size 113247496 字節(jié)
Database Buffers 88080384 字節(jié)
Redo Buffers 5214208 字節(jié)
內(nèi)存腳本的內(nèi)容:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/oradg11g/control01.ctl';
restore clone controlfile to '/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl' from
'/u01/app/oracle/oradata/oradg11g/control01.ctl';
}
正在執(zhí)行內(nèi)存腳本
啟動 backup 于 2015-07-26 22:04:44
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
復(fù)制備用控制文件
輸出文件名=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_oradgphy.f 標(biāo)記=TAG20150726T220444 RECID=11 STAMP=886111485
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:01
完成 backup 于 2015-07-26 22:04:45
啟動 restore 于 2015-07-26 22:04:45
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=134 設(shè)備類型=DISK
通道 ORA_AUX_DISK_1: 已復(fù)制控制文件副本
完成 restore 于 2015-07-26 22:04:47
內(nèi)存腳本的內(nèi)容:
{
sql clone 'alter database mount standby database';
}
正在執(zhí)行內(nèi)存腳本
sql 語句: alter database mount standby database
內(nèi)存腳本的內(nèi)容:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/oradg11g/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/oradg11g/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/oradg11g/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/oradg11g/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/oradg11g/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/oradg11g/example01.dbf";
set newname for datafile 6 to
"/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/oradg11g/system01.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/oradg11g/sysaux01.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/oradg11g/undotbs01.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/oradg11g/users01.dbf" datafile
5 auxiliary format
"/u01/app/oracle/oradata/oradg11g/example01.dbf" datafile
6 auxiliary format
"/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf" ;
sql 'alter system archive log current';
}
正在執(zhí)行內(nèi)存腳本
正在執(zhí)行命令: SET NEWNAME
臨時文件 1 在控制文件中已重命名為 /u01/app/oracle/oradata/oradg11g/temp01.dbf
正在執(zhí)行命令: SET NEWNAME
正在執(zhí)行命令: SET NEWNAME
正在執(zhí)行命令: SET NEWNAME
正在執(zhí)行命令: SET NEWNAME
正在執(zhí)行命令: SET NEWNAME
正在執(zhí)行命令: SET NEWNAME
啟動 backup 于 2015-07-26 22:04:52
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件: 文件號=00001 名稱=/u01/app/oracle/oradata/oradgphy/system01.dbf
輸出文件名=/u01/app/oracle/oradata/oradg11g/system01.dbf 標(biāo)記=TAG20150726T220452
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:25
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件: 文件號=00002 名稱=/u01/app/oracle/oradata/oradgphy/sysaux01.dbf
輸出文件名=/u01/app/oracle/oradata/oradg11g/sysaux01.dbf 標(biāo)記=TAG20150726T220452
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:15
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件: 文件號=00005 名稱=/u01/app/oracle/oradata/oradgphy/example01.dbf
輸出文件名=/u01/app/oracle/oradata/oradg11g/example01.dbf 標(biāo)記=TAG20150726T220452
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:07
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件: 文件號=00006 名稱=/u01/app/oracle/oradata/oradgphy/logmnrtbs1.dbf
輸出文件名=/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf 標(biāo)記=TAG20150726T220452
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:03
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件: 文件號=00003 名稱=/u01/app/oracle/oradata/oradgphy/undotbs01.dbf
輸出文件名=/u01/app/oracle/oradata/oradg11g/undotbs01.dbf 標(biāo)記=TAG20150726T220452
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:03
通道 ORA_DISK_1: 啟動數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件: 文件號=00004 名稱=/u01/app/oracle/oradata/oradgphy/users01.dbf
輸出文件名=/u01/app/oracle/oradata/oradg11g/users01.dbf 標(biāo)記=TAG20150726T220452
通道 ORA_DISK_1: 數(shù)據(jù)文件復(fù)制完畢, 經(jīng)過時間: 00:00:01
完成 backup 于 2015-07-26 22:05:47
sql 語句: alter system archive log current
內(nèi)存腳本的內(nèi)容:
{
backup as copy reuse
archivelog like "/u01/app/oracle/flash_recovery_area/ORADGPHY/archivelog/2015_07_26/o1_mf_1_4_bv9t9vtg_.arc" auxiliary format
"/u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_%u_.arc" ;
catalog clone recovery area;
switch clone datafile all;
}
正在執(zhí)行內(nèi)存腳本
啟動 backup 于 2015-07-26 22:05:47
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 正在開始復(fù)制歸檔日志
輸入歸檔日志線程=1 序列=4 RECID=205 STAMP=886111547
輸出文件名=/u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc RECID=0 STAMP=0
通道 ORA_DISK_1: 歸檔日志復(fù)制完成, 經(jīng)過時間: 00:00:01
完成 backup 于 2015-07-26 22:05:49
搜索恢復(fù)區(qū)中的所有文件
數(shù)據(jù)庫未知文件的列表
=====================================
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_13/o1_mf_1_101_blphvhp6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_94_bl9w2pcn_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_83_bl91pfk8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_82_bl91gpm1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_92_bl9w2htt_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_91_bl9w2cpb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_86_bl91r2j5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_84_bl91r03h_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_87_bl91r46j_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_89_bl944htj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_96_bl9w7ym1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_90_bl944mbj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_88_bl944f8q_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_95_bl9w6x2l_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_85_bl91r1n9_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_93_bl9w2nqd_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_18_bkwnm191_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_8_bkwmq00d_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_7_bkwmhpjf_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_14_bkwn5m3n_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_28_bkwr591w_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_15_bkwn5onz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_23_bkwp1926_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_6_bkwmho6g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_10_bkwmts9r_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_29_bkwr5d1c_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_16_bkwnll4b_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_27_bkwr5820_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_12_bkwn2kg5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_21_bkwp14lm_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_19_bkwnyrd9_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_20_bkwp12lg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_5_bkwmhm1w_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_9_bkwms0xq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_11_bkwn1m0k_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_22_bkwp18j4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_25_bkwr53xb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_24_bkwr51nw_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_26_bkwr5792_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_13_bkwn5jjr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_17_bkwnltkg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_12/o1_mf_1_100_blmt7y70_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_12/o1_mf_1_99_blmt7qw3_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_105_bm3b08sr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_106_bm3b09br_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_108_bm46tv7x_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_107_bm3cr8c8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_22/o1_mf_1_112_bmgqwv55_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_22/o1_mf_1_111_bmgqwr6x_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_52_bl6lzfrl_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_55_bl6m5bmw_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_41_bl6ksxpc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_42_bl6kt79v_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_81_bl78wx8z_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_76_bl6zdp5q_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_59_bl6psk7g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_78_bl70ggr3_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_38_bl6jxyv7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_60_bl6rsyr5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_66_bl6txphk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_49_bl6lzbf9_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_58_bl6pphgd_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_69_bl6vsrjo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_77_bl6zjwor_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_65_bl6tvoy4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_67_bl6v0qpo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_39_bl6kc33t_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_44_bl6ktcns_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_70_bl6w7xdb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_43_bl6ktbhb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_46_bl6lgrvk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_51_bl6lzdv0_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_50_bl6lzcyk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_74_bl6xszqy_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_64_bl6tq9wk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_79_bl756jv6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_53_bl6lzgjo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_62_bl6s6n5b_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_73_bl6xsw3n_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_40_bl6kjq6t_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_75_bl6y75kr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_45_bl6kzrco_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_63_bl6tg3n5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_56_bl6m91dj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_57_bl6pnhgz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_68_bl6v2g09_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_72_bl6x12lr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_80_bl75fxqq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_47_bl6lmn9x_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_61_bl6ryph7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_71_bl6wwf5z_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_54_bl6lzh7p_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_48_bl6lz8ml_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_16/o1_mf_1_102_blyzlgl4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_10/o1_mf_1_98_blgfvnl1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_10/o1_mf_1_97_blgfvjsq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_33_bl1sgljq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_34_bl1t30n7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_37_bl1tm3wp_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_32_bl1sghl1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_35_bl1t82c7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_31_bl1r7lvx_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_30_bl1r2khh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_36_bl1tfkwh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_17/o1_mf_1_104_bm0sphhn_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_17/o1_mf_1_103_bm0spdc0_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_19/o1_mf_1_109_bm6c1gkg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_19/o1_mf_1_110_bm6vnvn8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_162_bv9lv9dh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_140_bv9f7bto_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_128_bv9bx6q6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_159_bv9lv1lc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_150_bv9l2tf8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_175_bv9np57g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_174_bv9njntv_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_123_bv8tk683_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_163_bv9lvb3z_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_125_bv8tlqbg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_149_bv9l2tg6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_124_bv8tln9j_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_119_bv8tfqjl_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_143_bv9g0kcy_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_153_bv9l3yvc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_126_bv9bjbtc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_115_bv8l7zwj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_186_bv9sjh5n_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_127_bv9bjfyx_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_176_bv9np9s1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_182_bv9r54gy_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_139_bv9dntg5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_152_bv9l3vjz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_bv9d1fw8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_183_bv9sf8gz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_161_bv9lv8m7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_178_bv9nsfr4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_157_bv9lplmh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_158_bv9lqynz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_169_bv9mo6vz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_173_bv9njhh7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_167_bv9mo4gs_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_170_bv9mo7ol_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_187_bv9sjhkw_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_164_bv9lvbtq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_141_bv9f7z0g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_120_bv8tfqjb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_1_bv9d1foq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_113_bv8k3g8d_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_130_bv9cn3l6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_122_bv8tk1hh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_129_bv9bxd7k_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_171_bv9nfm1o_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_188_bv9sjphl_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_148_bv9l2tfo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_166_bv9mo2o1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_114_bv8k3l2v_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_168_bv9mo6vs_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_121_bv8tdl7m_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_160_bv9lv7l7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_146_bv9hpfhc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_138_bv9dnqfx_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_116_bv8ly4j0_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_180_bv9r3b5v_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_154_bv9l5ko5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_3_bv9d1fkm_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_144_bv9g11md_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_155_bv9ldn80_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_118_bv8rwvmt_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_147_0pqd1l03_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_184_bv9sf9yd_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_156_bv9ldr9q_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_185_bv9shl4j_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_172_bv9nfnyf_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_181_bv9r4l18_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_165_bv9lvfkz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_2_bv9cn3kt_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_151_bv9l2xfj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_145_0hqd1kbq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_179_bv9r1cp8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_117_bv8rwqbv_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_177_bv9ns9rj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_5_bv9d3yjl_.arc
正在編制文件目錄...
目錄編制完畢
已列入目錄的文件的列表
=======================
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_13/o1_mf_1_101_blphvhp6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_94_bl9w2pcn_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_83_bl91pfk8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_82_bl91gpm1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_92_bl9w2htt_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_91_bl9w2cpb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_86_bl91r2j5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_84_bl91r03h_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_87_bl91r46j_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_89_bl944htj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_96_bl9w7ym1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_90_bl944mbj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_88_bl944f8q_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_95_bl9w6x2l_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_85_bl91r1n9_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_93_bl9w2nqd_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_18_bkwnm191_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_8_bkwmq00d_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_7_bkwmhpjf_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_14_bkwn5m3n_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_28_bkwr591w_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_15_bkwn5onz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_23_bkwp1926_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_6_bkwmho6g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_10_bkwmts9r_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_29_bkwr5d1c_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_16_bkwnll4b_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_27_bkwr5820_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_12_bkwn2kg5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_21_bkwp14lm_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_19_bkwnyrd9_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_20_bkwp12lg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_5_bkwmhm1w_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_9_bkwms0xq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_11_bkwn1m0k_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_22_bkwp18j4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_25_bkwr53xb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_24_bkwr51nw_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_26_bkwr5792_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_13_bkwn5jjr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_17_bkwnltkg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_12/o1_mf_1_100_blmt7y70_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_12/o1_mf_1_99_blmt7qw3_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_105_bm3b08sr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_106_bm3b09br_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_108_bm46tv7x_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_107_bm3cr8c8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_22/o1_mf_1_112_bmgqwv55_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_22/o1_mf_1_111_bmgqwr6x_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_52_bl6lzfrl_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_55_bl6m5bmw_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_41_bl6ksxpc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_42_bl6kt79v_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_81_bl78wx8z_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_76_bl6zdp5q_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_59_bl6psk7g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_78_bl70ggr3_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_38_bl6jxyv7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_60_bl6rsyr5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_66_bl6txphk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_49_bl6lzbf9_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_58_bl6pphgd_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_69_bl6vsrjo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_77_bl6zjwor_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_65_bl6tvoy4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_67_bl6v0qpo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_39_bl6kc33t_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_44_bl6ktcns_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_70_bl6w7xdb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_43_bl6ktbhb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_46_bl6lgrvk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_51_bl6lzdv0_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_50_bl6lzcyk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_74_bl6xszqy_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_64_bl6tq9wk_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_79_bl756jv6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_53_bl6lzgjo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_62_bl6s6n5b_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_73_bl6xsw3n_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_40_bl6kjq6t_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_75_bl6y75kr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_45_bl6kzrco_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_63_bl6tg3n5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_56_bl6m91dj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_57_bl6pnhgz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_68_bl6v2g09_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_72_bl6x12lr_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_80_bl75fxqq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_47_bl6lmn9x_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_61_bl6ryph7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_71_bl6wwf5z_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_54_bl6lzh7p_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_48_bl6lz8ml_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_16/o1_mf_1_102_blyzlgl4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_10/o1_mf_1_98_blgfvnl1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_10/o1_mf_1_97_blgfvjsq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_33_bl1sgljq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_34_bl1t30n7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_37_bl1tm3wp_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_32_bl1sghl1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_35_bl1t82c7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_31_bl1r7lvx_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_30_bl1r2khh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_36_bl1tfkwh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_17/o1_mf_1_104_bm0sphhn_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_17/o1_mf_1_103_bm0spdc0_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_19/o1_mf_1_109_bm6c1gkg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_19/o1_mf_1_110_bm6vnvn8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_162_bv9lv9dh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_140_bv9f7bto_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_128_bv9bx6q6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_159_bv9lv1lc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_150_bv9l2tf8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_175_bv9np57g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_174_bv9njntv_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_123_bv8tk683_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_163_bv9lvb3z_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_125_bv8tlqbg_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_149_bv9l2tg6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_124_bv8tln9j_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_119_bv8tfqjl_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_143_bv9g0kcy_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_153_bv9l3yvc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_126_bv9bjbtc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_115_bv8l7zwj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_186_bv9sjh5n_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_127_bv9bjfyx_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_176_bv9np9s1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_182_bv9r54gy_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_139_bv9dntg5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_152_bv9l3vjz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_bv9d1fw8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_183_bv9sf8gz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_161_bv9lv8m7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_178_bv9nsfr4_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_157_bv9lplmh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_158_bv9lqynz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_169_bv9mo6vz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_173_bv9njhh7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_167_bv9mo4gs_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_170_bv9mo7ol_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_187_bv9sjhkw_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_164_bv9lvbtq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_141_bv9f7z0g_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_120_bv8tfqjb_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_1_bv9d1foq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_113_bv8k3g8d_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_130_bv9cn3l6_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_122_bv8tk1hh_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_129_bv9bxd7k_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_171_bv9nfm1o_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_188_bv9sjphl_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_148_bv9l2tfo_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_166_bv9mo2o1_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_114_bv8k3l2v_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_168_bv9mo6vs_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_121_bv8tdl7m_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_160_bv9lv7l7_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_146_bv9hpfhc_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_138_bv9dnqfx_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_116_bv8ly4j0_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_180_bv9r3b5v_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_154_bv9l5ko5_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_3_bv9d1fkm_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_144_bv9g11md_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_155_bv9ldn80_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_118_bv8rwvmt_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_147_0pqd1l03_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_184_bv9sf9yd_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_156_bv9ldr9q_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_185_bv9shl4j_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_172_bv9nfnyf_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_181_bv9r4l18_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_165_bv9lvfkz_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_2_bv9cn3kt_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_151_bv9l2xfj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_145_0hqd1kbq_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_179_bv9r1cp8_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_117_bv8rwqbv_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_177_bv9ns9rj_.arc
文件名: /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_5_bv9d3yjl_.arc
數(shù)據(jù)文件 1 已轉(zhuǎn)換成數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件副本 RECID=11 STAMP=886111550 文件名=/u01/app/oracle/oradata/oradg11g/system01.dbf
數(shù)據(jù)文件 2 已轉(zhuǎn)換成數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件副本 RECID=12 STAMP=886111550 文件名=/u01/app/oracle/oradata/oradg11g/sysaux01.dbf
數(shù)據(jù)文件 3 已轉(zhuǎn)換成數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件副本 RECID=13 STAMP=886111550 文件名=/u01/app/oracle/oradata/oradg11g/undotbs01.dbf
數(shù)據(jù)文件 4 已轉(zhuǎn)換成數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件副本 RECID=14 STAMP=886111550 文件名=/u01/app/oracle/oradata/oradg11g/users01.dbf
數(shù)據(jù)文件 5 已轉(zhuǎn)換成數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件副本 RECID=15 STAMP=886111550 文件名=/u01/app/oracle/oradata/oradg11g/example01.dbf
數(shù)據(jù)文件 6 已轉(zhuǎn)換成數(shù)據(jù)文件副本
輸入數(shù)據(jù)文件副本 RECID=16 STAMP=886111550 文件名=/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf
內(nèi)存腳本的內(nèi)容:
{
set until scn 1877456;
recover
standby
clone database
delete archivelog
;
}
正在執(zhí)行內(nèi)存腳本
正在執(zhí)行命令: SET until clause
啟動 recover 于 2015-07-26 22:05:50
使用通道 ORA_AUX_DISK_1
正在開始介質(zhì)的恢復(fù)
線程 1 序列 4 的歸檔日志已作為文件 /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc 存在于磁盤上
歸檔日志文件名=/u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc 線程=1 序列=4
介質(zhì)恢復(fù)完成, 用時: 00:00:00
完成 recover 于 2015-07-26 22:05:51
完成 Duplicate Db 于 2015-07-26 22:06:01
RMAN>
[oracle@rhel6_lhr dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期日 7月 26 22:07:32 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
22:07:32 SQL>
22:07:33 SQL> select dbid,name,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from v$database;
DBID NAME CURRENT_SCN PROTECTION_MODE DATABASE_ROLE FOR OPEN_MODE SWITCHOVER_STATUS
---------- --------- ----------- -------------------- ---------------- --- -------------------- --------------------
1403587593 ORADG11G 1877455 MAXIMUM PERFORMANCE PHYSICAL STANDBY YES MOUNTED NOT ALLOWED
已用時間: 00: 00: 00.01
22:07:34 SQL> alter database open;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.30
22:07:45 SQL> alter database recover managed standby database using current logfile disconnect;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 06.02
22:07:56 SQL> 22:07:56 SQL>
已用時間: 00: 00: 00.01
22:07:34 SQL> alter database open;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.30
22:07:45 SQL> alter database recover managed standby database using current logfile disconnect;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 06.02
22:07:56 SQL> 22:07:56 SQL>
22:08:03 SQL> select dbid,name,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from v$database;
DBID NAME CURRENT_SCN PROTECTION_MODE DATABASE_ROLE FOR OPEN_MODE SWITCHOVER_STATUS
---------- --------- ----------- -------------------- ---------------- --- -------------------- --------------------
1403587593 ORADG11G 1877455 MAXIMUM PERFORMANCE PHYSICAL STANDBY YES MOUNTED NOT ALLOWED
校驗:
22:10:49 SQL> show parameter unique_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string oradgphy
22:10:55 SQL> select count(1) from test;
COUNT(1)
----------
1194000
已用時間: 00: 00: 00.05
22:11:01 SQL> delete from test where rownum<=9400;
已刪除9400行。
已用時間: 00: 00: 00.13
22:11:45 SQL> commit;
提交完成。
已用時間: 00: 00: 00.00
22:11:48 SQL> select count(1) from test;
COUNT(1)
----------
1184600
已用時間: 00: 00: 00.06
22:12:10 SQL> conn sys/lhr@tns_oradg11g as sysdba
已連接。
22:12:14 SQL> select count(1) from test;
COUNT(1)
----------
1184600
已用時間: 00: 00: 00.06
22:12:17 SQL>
23:16:58 SQL> show parameter unique_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string oradgphy
23:17:31 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PRIMARY TO STANDBY oradgphy
已用時間: 00: 00: 00.00
23:17:52 SQL> alter database commit to switchover to physical standby with session shutdown;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 04.83
23:18:15 SQL>
23:19:27 SQL>
23:19:27 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PHYSICAL STANDBY RECOVERY NEEDED oradgphy
已用時間: 00: 00: 00.01
23:19:45 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PHYSICAL STANDBY RECOVERY NEEDED oradgphy
已用時間: 00: 00: 00.00
23:21:48 SQL> startup mount;
ORA-01081: 無法啟動已在運行的 ORACLE - 請先將其關(guān)閉
23:21:57 SQL> shutdown abort;
ORACLE 例程已經(jīng)關(guān)閉。
23:22:28 SQL> startup mount;
ORACLE 例程已經(jīng)啟動。
Total System Global Area 242171904 bytes
Fixed Size 2227256 bytes
Variable Size 197133256 bytes
Database Buffers 37748736 bytes
Redo Buffers 5062656 bytes
數(shù)據(jù)庫裝載完畢。
23:22:51 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG MOUNTED PHYSICAL STANDBY RECOVERY NEEDED oradgphy
已用時間: 00: 00: 00.01
23:22:53 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG MOUNTED PHYSICAL STANDBY RECOVERY NEEDED oradgphy
已用時間: 00: 00: 00.00
源主庫:
23:22:35 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ ONLY WITH APPLY PHYSICAL STANDBY TO PRIMARY oradg11g
已用時間: 00: 00: 00.00
23:22:36 SQL> alter database commit to switchover to primary with session shutdown;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 03.08
23:24:06 SQL> alter database open;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.41
23:24:13 SQL> select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME
--------- ------------ -------------------- ---------------- -------------------- ------------------------------
ORADG11G ARCHIVELOG READ WRITE PRIMARY TO STANDBY oradg11g
已用時間: 00: 00: 00.42
備庫:
23:24:21 SQL> alter database open;
數(shù)據(jù)庫已更改。
已用時間: 00: 00: 00.30
23:24:31 SQL> alter database recover managed standby database using current logfile disconnect;
數(shù)據(jù)庫已更改。
至此所有的實驗完畢,數(shù)據(jù)庫也已經(jīng)還原到最初的狀態(tài)了。
3、結(jié)論
Failover是Dataguard的一個重要功能特性。經(jīng)過Failover,我們認(rèn)為Primary站點其實已經(jīng)不能作為HA架構(gòu)成員了。重新讓Primary加入進去的方法有三個:一個是利用RMAN備份將Primary恢復(fù)到failover之前,重新進行日志彌補、角色切換;第二個方法是利用Flashback Database策略,將數(shù)據(jù)庫恢復(fù)到failover之前的時間點;第三個是刪除Primary數(shù)據(jù)庫,重新利用新Primary搭建standby。
進行Dataguard switchover和failover是非常常見的運維需求,在實際場景下,我們盡可能選擇穩(wěn)妥完全的策略進行操作,SQL命令還是我們比較好的選擇,多操作幾次就熟悉了。
About Me
.............................................................................................................................................
● 本文作者:小麥苗,只專注于數(shù)據(jù)庫的技術(shù),更注重技術(shù)的運用
● 本文在itpub(http://blog.itpub.net/26736162/abstract/1/)、博客園(http://www.cnblogs.com/lhrbest)和個人微信公眾號(xiaomaimiaolhr)上有同步更新
● 本文itpub地址:http://blog.itpub.net/26736162/viewspace-1753130/
● 本文博客園地址:http://www.cnblogs.com/lhrbest
● 本文pdf版、個人簡介及小麥苗云盤地址:http://blog.itpub.net/26736162/viewspace-1624453/
● 數(shù)據(jù)庫筆試面試題庫及解答:http://blog.itpub.net/26736162/viewspace-2134706/
● DBA寶典今日頭條號地址:http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826
.............................................................................................................................................
● QQ群號:230161599(滿)、618766405
● 微信群:可加我微信,我拉大家進群,非誠勿擾
● 聯(lián)系我請加QQ好友(646634621),注明添加緣由
● 于 2015-07-26 09:00~ 2015-07-27 19:00 在魔都完成
● 文章內(nèi)容來源于小麥苗的學(xué)習(xí)筆記,部分整理自網(wǎng)絡(luò),若有侵權(quán)或不當(dāng)之處還請諒解
● 版權(quán)所有,歡迎分享本文,轉(zhuǎn)載請保留出處
.............................................................................................................................................
● 小麥苗的微店:https://weidian.com/s/793741433?wfr=c&ifr=shopdetail
● 小麥苗出版的數(shù)據(jù)庫類叢書:http://blog.itpub.net/26736162/viewspace-2142121/
.............................................................................................................................................
使用微信客戶端掃描下面的二維碼來關(guān)注小麥苗的微信公眾號(xiaomaimiaolhr)及QQ群(DBA寶典),學(xué)習(xí)最實用的數(shù)據(jù)庫技術(shù)。
小麥苗的微信公眾號 小麥苗的DBA寶典QQ群1 小麥苗的DBA寶典QQ群2 小麥苗的微店
.............................................................................................................................................
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。