本繁體中文版使用機器翻譯，譯文僅供參考，若與英文版本牴觸，應以英文版本為準。
TR-4973：在 AWS FSx ONTAP上使用增量合併快速恢復和克隆 Oracle VLDB
貢獻者
建議變更
PDF
Allen Cao、Niyaz Mohamed， NetApp
該解決方案提供了快速恢復和克隆部署到 AWS EC2 計算實例的 Oracle VLDB 的概述和詳細信息，該實例在 FSx ONTAP上透過 NFS 掛載，以暫存備用資料檔案副本，並透過 RMAN 不斷進行增量合併。
目的
使用 Oracle 復原管理器 (RMAN) 備份工具還原 Oracle 中的超大型資料庫 (VLDB) 可能是一項極具挑戰性的任務。發生故障時從備份媒體還原資料庫的過程可能非常耗時，從而延遲資料庫復原並可能嚴重影響您的服務等級協定 (SLA)。但是，從 10g 版本開始，Oracle 引入了 RMAN 功能，允許使用者在位於 DB 伺服器主機上的附加磁碟儲存上建立 Oracle 資料庫資料檔案的分階段映像副本。這些影像副本可以使用 RMAN 每天進行增量更新。如果發生故障，資料庫管理員 (DBA) 可以迅速將 Oracle 資料庫從故障媒體切換到映像副本，從而無需進行完整的資料庫媒體還原。儘管所需的資料庫儲存量增加了一倍，但其結果是 SLA 得到了極大改善。
如果您熱衷於 VLDB 的 SLA 並考慮將 Oracle 資料庫遷移到 AWS 等公有雲，則可以使用 AWS FSx ONTAP等資源設定類似的資料庫保護結構來暫存備用資料庫映像副本。在本文檔中，我們示範如何從 AWS FSx ONTAP配置和匯出 NFS 檔案系統，並將其安裝在 Oracle 資料庫伺服器上，以便在主儲存發生故障時暫存備用資料庫副本以便快速復原。
更好的是，我們還展示瞭如何利用NetApp FlexClone為其他用例建立相同暫存 NFS 檔案系統的副本，例如使用相同的備用資料庫映像副本建立開發/測試 Oracle 環境，而無需額外的儲存投資。
此解決方案適用於以下用例：
-
透過 RMAN 在 AWS FSx ONTAP儲存的 NFS 掛載點上進行 Oracle VLDB 映像複製增量合併。
-
發生故障時，透過切換到 FSx ONTAP儲存上的資料庫映像副本來快速還原 Oracle VLDB。
-
克隆 FSx ONTAP NFS 檔案系統卷，儲存 Oracle VLDB 映像副本，用於為其他用例建立另一個資料庫實例。
對象
此解決方案適用於以下人群：
-
一位 DBA 透過 AWS 中的 RMAN 設定 Oracle VLDB 映像複製增量合併，以便更快地復原資料庫。
-
在 AWS 公有雲中測試 Oracle 工作負載的資料庫解決方案架構師。
-
管理部署到 AWS FSx ONTAP儲存的 Oracle 資料庫的儲存管理員。
-
希望在 AWS FSx/EC2 環境中建立 Oracle 資料庫的應用程式擁有者。
解決方案測試和驗證環境
此解決方案的測試和驗證是在可能與最終部署環境不符的 AWS FSx ONTAP和 EC2 環境中進行的。有關更多信息，請參閱部署考慮的關鍵因素 。
架構
硬體和軟體組件
硬體 |
||
FSx ONTAP存儲 |
AWS 提供的目前版本 |
同一 VPC 和可用區中的一個 FSx HA 集群 |
用於計算的 EC2 實例 |
t2.xlarge/4vCPU/16G |
兩個 EC2 T2 xlarge EC2 實例，一個作為主資料庫伺服器，另一個作為克隆資料庫伺服器 |
軟體 |
||
紅帽Linux |
RHEL-8.6.0_HVM-20220503-x86_64-2-Hourly2-GP2 |
部署 RedHat 訂閱進行測試 |
Oracle 網格基礎架構 |
版本 19.18 |
已套用RU補丁p34762026_190000_Linux-x86-64.zip |
Oracle 資料庫 |
版本 19.18 |
已套用RU補丁p34765931_190000_Linux-x86-64.zip |
Oracle OPatch |
版本 12.2.0.1.36 |
最新補丁 p6880880_190000_Linux-x86-64.zip |
部署考慮的關鍵因素
-
*用於 RMAN 增量合併的 Oracle VLDB 儲存佈局。 *在我們的測試和驗證中，用於 Oracle 增量備份和合併的 NFS 磁碟區是從單一 FSx 檔案系統分配的，該系統具有 4GBps 吞吐量、160,000 原始 SSD IOPS 和 192TiB 容量限制。對於超過閾值的部署，可以將多個 FSx 檔案系統與多個 NFS 掛載點並行連接以提供更高的容量。
-
*使用 RMAN 增量合併實作 Oracle 可恢復性。 * RMAN 增量備份和合併通常會根據您的 RTO 和 RPO 目標以使用者定義的頻率執行。如果主資料儲存和/或歸檔日誌完全遺失，則可能會發生資料遺失。 Oracle 資料庫可以還原到 FSx 資料庫備份映像副本提供的最後一個增量備份。為了盡量減少資料遺失，可以在 FSx NFS 掛載點上設定 Oracle 閃回復原區，並將存檔日誌與資料庫映像副本一起備份到 FSx NFS 掛載點。
-
*在 FSx NFS 檔案系統上執行 Oracle VLDB。 *與用於資料庫備份的其他大容量存儲不同，AWS FSx ONTAP是一種支援雲端的生產級存儲，可提供高水準的效能和儲存效率。一旦 Oracle VLDB 從主儲存切換到 FSx ONTAP NFS 檔案系統上的映像副本，資料庫效能就可以保持在高水平，同時解決主儲存故障。您可以放心，用戶應用程式體驗不會因主儲存故障而受到影響。
-
* 用於其他用例的 NFS 磁碟區的FlexClone Oracle VLDB 映像副本。 * AWS FSx ONTAP FlexClone提供可寫入的相同 NFS 資料磁碟區的共用副本。因此，它們可以用於許多其他用例，同時即使在 Oracle 資料庫切換時仍能保持暫存 Oracle VLDB 映像副本的完整性。透過大幅減少 VLDB 儲存空間，這可以節省大量的儲存成本。 NetApp建議在資料庫從主儲存切換到資料庫映像副本時盡量減少FlexClone活動，以將 Oracle 效能保持在高水準。
-
EC2 運算執行個體。在這些測試和驗證中，我們使用 AWS EC2 t2.xlarge 執行個體作為 Oracle 資料庫運算執行個體。 NetApp建議在生產部署中使用 M5 類型的 EC2 執行個體作為 Oracle 的運算實例，因為它針對資料庫工作負載進行了最佳化。您需要根據實際工作負載需求，適當調整 EC2 執行個體的 vCPU 數量和 RAM 容量。
-
*FSx 儲存 HA 叢集單區域或多區域部署。 *在這些測試和驗證中，我們在單一 AWS 可用區中部署了一個 FSx HA 叢集。對於生產部署， NetApp建議在兩個不同的可用區部署 FSx HA 對。 FSx HA 叢集始終在 HA 對中配置，該 HA 對在主動-被動檔案系統中同步鏡像，以提供儲存級冗餘。多區域部署進一步增強了單一 AWS 區域發生故障時的高可用性。
-
FSx 儲存叢集大小。 Amazon FSx ONTAP儲存檔案系統提供高達 160,000 個原始 SSD IOPS、高達 4GBps 的吞吐量以及最大 192TiB 的容量。但是，您可以根據部署時的實際需求，根據預先配置的 IOPS、吞吐量和儲存限制（最小 1,024 GiB）來確定叢集大小。容量可以動態調整，而不會影響應用程式的可用性。
-
*dNFS 配置。 * dNFS 內建於 Oracle 核心中，並且已知當 Oracle 部署到 NFS 儲存時可顯著提高 Oracle 資料庫效能。 dNFS 打包到 Oracle 二進位檔案中，但預設未開啟。對於 NFS 上的任何 Oracle 資料庫部署，都應該啟用它。對於 VLDB 的多個 FSx 檔案系統部署，應正確配置到不同 FSx NFS 檔案系統的 dNFS 多路徑。
解決方案部署
假設您已經在 VPC 內的 AWS EC2 環境中部署了 Oracle VLDB。如果您需要在 AWS 上部署 Oracle 的協助，請參考以下技術報告尋求協助。
您的 Oracle VLDB 可以在 FSx ONTAP或 AWS EC2 生態系統中的任何其他儲存體上運作。以下部分提供了設定 RMAN 增量合併到 Oracle VLDB 映像副本的逐步部署過程，該副本暫存在 AWS FSx ONTAP儲存的 NFS 掛載中。
部署先決條件
Details
部署需要以下先決條件。
-
已設定 AWS 帳戶，並在您的 AWS 帳戶內建立了必要的 VPC 和網路段。
-
從 AWS EC2 控制台，您必須部署兩個 EC2 Linux 實例，一個作為主 Oracle DB 伺服器，另一個作為可選的備用克隆目標 DB 伺服器。有關環境設定的更多詳細信息，請參閱上一節中的架構圖。還請查看"Linux 實例使用者指南"了解更多。
-
從 AWS EC2 控制台部署Amazon FSx ONTAP儲存 HA 叢集來託管儲存 Oracle 資料庫備用映像副本的 NFS 磁碟區。如果您不熟悉 FSx 儲存的部署，請參閱文檔"建立 FSx ONTAP檔案系統"以獲得逐步說明。
-
步驟 2 和 3 可以使用以下 Terraform 自動化工具包執行，該工具包會建立一個名為
ora_01`以及一個名為 `fsx_01。在執行之前，請仔細檢查說明並更改變數以適合您的環境。此範本可以根據您自己的部署要求輕鬆修改。git clone https://github.com/NetApp-Automation/na_aws_fsx_ec2_deploy.git
|
確保您已在 EC2 執行個體根磁碟區中指派至少 50G，以便有足夠的空間來暫存 Oracle 安裝檔案。 |
預置並匯出要掛載到 EC2 DB 執行個體主機的 NFS 卷
Details
在此示範中，我們將展示如何透過 FSx 集群管理 IP 以 fsxadmin 使用者身分透過 ssh 登入 FSx 集群，從命令列配置 NFS 磁碟區。或者，也可以使用 AWS FSx 控制台指派磁碟區。如果設定了多個 FSx 檔案系統來適應資料庫的大小，請在其他 FSx 檔案系統上重複這些過程。
-
首先，以 fsxadmin 使用者身分透過 SSH 登入 FSx 集群，透過 CLI 設定 NFS 磁碟區。變更為您的 FSx 叢集管理 IP 位址，可從 AWS FSx ONTAP UI 控制台擷取。
ssh fsxadmin@172.30.15.53 -
建立與主儲存大小相同的 NFS 卷，用於儲存主 Oracle VLDB 資料庫資料檔案映像副本。
vol create -volume ora_01_copy -aggregate aggr1 -size 100G -state online -type RW -junction-path /ora_01_copy -snapshot-policy none -tiering-policy snapshot-only -
或者，也可以從 AWS FSx 控制台 UI 設定卷，選項如下：儲存效率
Enabled，安全風格Unix、快照策略 `None`和儲存分層 `Snapshot Only`如下圖所示。
-
為 Oracle 資料庫建立自訂快照策略，具有每日排程和 30 天保留期。您應該調整策略以滿足您在快照頻率和保留視窗方面的特定需求。
snapshot policy create -policy oracle -enabled true -schedule1 daily -count1 30將政策套用至已設定的 NFS 磁碟區以進行 RMAN 增量備份和合併。
vol modify -volume ora_01_copy -snapshot-policy oracle -
以 ec2-user 身分登入 EC2 執行個體並建立目錄 /nfsfsxn。為其他 FSx 檔案系統建立其他掛載點目錄。
sudo mkdir /nfsfsxn -
將 FSx ONTAP NFS 磁碟區掛載到 EC2 DB 執行個體主機。變更為您的 FSx 虛擬伺服器 NFS lif 位址。可以從 FSx ONTAP UI 控制台檢索 NFS lif 位址。
sudo mount 172.30.15.19:/ora_01_copy /nfsfsxn -o rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144,nointr -
將掛載點所有權更改為 oracle:oisntall，根據需要更改為您的 oracle 使用者名稱和主要群組。
sudo chown oracle:oinstall /nfsfsxn
在 FSx 上設定 Oracle RMAN 增量合併到映像副本
Details
RMAN 增量合併在每個增量備份/合併間隔持續更新暫存資料庫資料檔案映像副本。資料庫備份的映像副本將與您執行增量備份/合併的頻率一樣最新。因此，在決定 RMAN 增量備份和合併的頻率時，請考慮資料庫效能、RTO 和 RPO 目標。
-
以 oracle 使用者身分登入主資料庫伺服器 EC2 執行個體
-
在掛載點 /nfsfsxn 下建立一個 oracopy 目錄，用於儲存 Oracle 資料檔案映像副本和用於 Oracle 閃回復原區的 archlog 目錄。
mkdir /nfsfsxn/oracopymkdir /nfsfsxn/archlog -
透過 sqlplus 登入 Oracle 資料庫，啟用區塊變更追蹤以加快增量備份速度，並將 Oracle 快閃記憶體復原區變更為 FSx ONTAP掛載（如果它目前位於主儲存體上）。這允許將 RMAN 預設控製檔/spfile 自動備份和存檔日誌備份到 FSx ONTAP NFS 掛載以進行還原。
sqlplus / as sysdba在 sqlplus 提示字元下，執行以下命令。
alter database enable block change tracking using file '/nfsfsxn/oracopy/bct_db1.ctf'alter system set db_recovery_file_dest='/nfsfsxn/archlog/' scope=both; -
建立 RMAN 備份和增量合併腳本。該腳本為並行 RMAN 備份和合併分配多個通道。第一次執行將產生初始的完整基線影像副本。在完整運行過程中，它首先清除保留視窗之外的過時備份，以保持暫存區清潔。然後它在合併和備份之前切換當前日誌檔案。增量備份在合併之後進行，因此資料庫映像副本落後於目前資料庫狀態備份/合併週期。可以根據使用者的喜好逆轉合併和備份的順序，以便更快地恢復。 RMAN 腳本可以整合到一個簡單的 shell 腳本中，從主 DB 伺服器上的 crontab 執行。確保 RMAN 設定中的控製檔自動備份處於開啟狀態。
vi /home/oracle/rman_bkup_merge.cmd Add following lines: RUN { allocate channel c1 device type disk format '/nfsfsxn/oracopy/%U'; allocate channel c2 device type disk format '/nfsfsxn/oracopy/%U'; allocate channel c3 device type disk format '/nfsfsxn/oracopy/%U'; allocate channel c4 device type disk format '/nfsfsxn/oracopy/%U'; delete obsolete; sql 'alter system archive log current'; recover copy of database with tag 'OraCopyBKUPonFSxN_level_0'; backup incremental level 1 copies=1 for recover of copy with tag 'OraCopyBKUPonFSxN_level_0' database; } -
在 EC2 DB 伺服器上，以 oracle 使用者身分本地登入 RMAN，可以使用或不使用 RMAN 目錄。在此示範中，我們沒有連接到 RMAN 目錄。
rman target / nocatalog; output: [oracle@ip-172-30-15-99 ~]$ rman target / nocatalog; Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 24 17:44:49 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: DB1 (DBID=1730530050) using target database control file instead of recovery catalog RMAN>
-
從 RMAN 提示字元執行腳本。第一次執行會建立基準資料庫映像副本，後續執行則會逐步合併和更新基準映像副本。以下是如何執行腳本以及典型的輸出。設定通道數以符合主機上的 CPU 核心。
RMAN> @/home/oracle/rman_bkup_merge.cmd RMAN> RUN 2> { 3> allocate channel c1 device type disk format '/nfsfsxn/oracopy/%U'; 4> allocate channel c2 device type disk format '/nfsfsxn/oracopy/%U'; 5> allocate channel c3 device type disk format '/nfsfsxn/oracopy/%U'; 6> allocate channel c4 device type disk format '/nfsfsxn/oracopy/%U'; 7> delete obsolete; 8> sql 'alter system archive log current'; 9> recover copy of database with tag 'OraCopyBKUPonFSxN_level_0'; 10> backup incremental level 1 copies=1 for recover of copy with tag 'OraCopyBKUPonFSxN_level_0' database; 11> } allocated channel: c1 channel c1: SID=411 device type=DISK allocated channel: c2 channel c2: SID=146 device type=DISK allocated channel: c3 channel c3: SID=402 device type=DISK allocated channel: c4 channel c4: SID=37 device type=DISK Starting recover at 17-MAY-23 no copy of datafile 1 found to recover no copy of datafile 3 found to recover no copy of datafile 4 found to recover no copy of datafile 5 found to recover no copy of datafile 6 found to recover no copy of datafile 7 found to recover . . Finished recover at 17-MAY-23 Starting backup at 17-MAY-23 channel c1: starting incremental level 1 datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00022 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.287.1137018311 input datafile file number=00026 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.291.1137018481 input datafile file number=00030 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.295.1137018787 input datafile file number=00011 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/undotbs1.271.1136668041 input datafile file number=00035 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.300.1137019181 channel c1: starting piece 1 at 17-MAY-23 channel c2: starting incremental level 1 datafile backup set channel c2: specifying datafile(s) in backup set input datafile file number=00023 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.288.1137018359 input datafile file number=00027 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.292.1137018523 input datafile file number=00031 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.296.1137018837 input datafile file number=00009 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/system.272.1136668041 input datafile file number=00034 name=+DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.299.1137019117 . . Finished backup at 17-MAY-23 Starting Control File and SPFILE Autobackup at 17-MAY-23 piece handle=+LOGS/DB1/AUTOBACKUP/2023_05_17/s_1137095435.367.1137095435 comment=NONE Finished Control File and SPFILE Autobackup at 17-MAY-23 released channel: c1 released channel: c2 released channel: c3 released channel: c4 RMAN> **end-of-file** -
列出備份後的資料庫映像副本，以觀察在 FSx ONTAP NFS 掛載點中是否建立了資料庫映像副本。
RMAN> list copy of database tag 'OraCopyBKUPonFSxN_level_0'; List of Datafile Copies ======================= Key File S Completion Time Ckp SCN Ckp Time Sparse ------- ---- - --------------- ---------- --------------- ------ 19 1 A 17-MAY-23 3009819 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_0h1sd7ae Tag: ORACOPYBKUPONFSXN_LEVEL_0 20 3 A 17-MAY-23 3009826 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_0i1sd7at Tag: ORACOPYBKUPONFSXN_LEVEL_0 21 4 A 17-MAY-23 3009830 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_0j1sd7b4 Tag: ORACOPYBKUPONFSXN_LEVEL_0 27 5 A 17-MAY-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_0p1sd7cf Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 26 6 A 17-MAY-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_0o1sd7c8 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 34 7 A 17-MAY-23 3009907 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_101sd7dl Tag: ORACOPYBKUPONFSXN_LEVEL_0 33 8 A 17-MAY-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_0v1sd7di Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 28 9 A 17-MAY-23 3009871 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_0q1sd7cm Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 22 10 A 17-MAY-23 3009849 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_0k1sd7bb Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 25 11 A 17-MAY-23 3009862 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_0n1sd7c1 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 35 12 A 17-MAY-23 3009909 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_111sd7dm Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 29 13 A 17-MAY-23 3009876 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_0r1sd7ct Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 23 14 A 17-MAY-23 3009854 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_0l1sd7bi Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 31 15 A 17-MAY-23 3009900 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_0t1sd7db Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 36 16 A 17-MAY-23 3009911 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_121sd7dn Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 30 17 A 17-MAY-23 3009895 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_0s1sd7d4 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 24 18 A 17-MAY-23 3009858 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_0m1sd7bq Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 32 19 A 17-MAY-23 3009903 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_0u1sd7de Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 37 20 A 17-MAY-23 3009914 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_131sd7do Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 4 21 A 17-MAY-23 3009019 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_021sd6pv Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 5 22 A 17-MAY-23 3009419 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_031sd6r2 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 6 23 A 17-MAY-23 3009460 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_041sd6s5 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 7 24 A 17-MAY-23 3009473 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_051sd6t9 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 8 25 A 17-MAY-23 3009502 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_061sd6uc Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 9 26 A 17-MAY-23 3009548 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_071sd6vf Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 10 27 A 17-MAY-23 3009576 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_081sd70i Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 11 28 A 17-MAY-23 3009590 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_091sd71l Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 12 29 A 17-MAY-23 3009619 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_0a1sd72o Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 13 30 A 17-MAY-23 3009648 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_0b1sd73r Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 14 31 A 17-MAY-23 3009671 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_0c1sd74u Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 15 32 A 17-MAY-23 3009729 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_0d1sd762 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 16 33 A 17-MAY-23 3009743 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_0e1sd775 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 17 34 A 17-MAY-23 3009771 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_0f1sd788 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 18 35 A 17-MAY-23 3009805 17-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_0g1sd79b Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 RMAN> -
從 Oracle RMAN 命令提示字元報告模式，觀察目前活動資料庫資料檔案位於主儲存 ASM +DATA 磁碟組中。
RMAN> report schema; Report of database schema for database with db_unique_name DB1 List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 1060 SYSTEM YES +DATA/DB1/DATAFILE/system.257.1136666315 3 810 SYSAUX NO +DATA/DB1/DATAFILE/sysaux.258.1136666361 4 675 UNDOTBS1 YES +DATA/DB1/DATAFILE/undotbs1.259.1136666385 5 400 PDB$SEED:SYSTEM NO +DATA/DB1/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.266.1136667165 6 460 PDB$SEED:SYSAUX NO +DATA/DB1/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.267.1136667165 7 5 USERS NO +DATA/DB1/DATAFILE/users.260.1136666387 8 230 PDB$SEED:UNDOTBS1 NO +DATA/DB1/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.268.1136667165 9 400 DB1_PDB1:SYSTEM YES +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/system.272.1136668041 10 490 DB1_PDB1:SYSAUX NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/sysaux.273.1136668041 11 465 DB1_PDB1:UNDOTBS1 YES +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/undotbs1.271.1136668041 12 5 DB1_PDB1:USERS NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/users.275.1136668057 13 400 DB1_PDB2:SYSTEM YES +DATA/DB1/FB867EA89ECF81C0E053630F1EACB901/DATAFILE/system.277.1136668057 14 470 DB1_PDB2:SYSAUX NO +DATA/DB1/FB867EA89ECF81C0E053630F1EACB901/DATAFILE/sysaux.278.1136668057 15 235 DB1_PDB2:UNDOTBS1 YES +DATA/DB1/FB867EA89ECF81C0E053630F1EACB901/DATAFILE/undotbs1.276.1136668057 16 5 DB1_PDB2:USERS NO +DATA/DB1/FB867EA89ECF81C0E053630F1EACB901/DATAFILE/users.280.1136668071 17 400 DB1_PDB3:SYSTEM YES +DATA/DB1/FB867F8A4D4F821CE053630F1EAC69CC/DATAFILE/system.282.1136668073 18 470 DB1_PDB3:SYSAUX NO +DATA/DB1/FB867F8A4D4F821CE053630F1EAC69CC/DATAFILE/sysaux.283.1136668073 19 235 DB1_PDB3:UNDOTBS1 YES +DATA/DB1/FB867F8A4D4F821CE053630F1EAC69CC/DATAFILE/undotbs1.281.1136668073 20 5 DB1_PDB3:USERS NO +DATA/DB1/FB867F8A4D4F821CE053630F1EAC69CC/DATAFILE/users.285.1136668087 21 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.286.1137018239 22 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.287.1137018311 23 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.288.1137018359 24 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.289.1137018405 25 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.290.1137018443 26 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.291.1137018481 27 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.292.1137018523 28 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.293.1137018707 29 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.294.1137018745 30 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.295.1137018787 31 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.296.1137018837 32 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.297.1137018935 33 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.298.1137019077 34 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.299.1137019117 35 4096 DB1_PDB1:SOE NO +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/DATAFILE/soe.300.1137019181 List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 123 TEMP 32767 +DATA/DB1/TEMPFILE/temp.265.1136666447 2 123 PDB$SEED:TEMP 32767 +DATA/DB1/FB864A929AEB79B9E053630F1EAC7046/TEMPFILE/temp.269.1136667185 3 10240 DB1_PDB1:TEMP 32767 +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/TEMPFILE/temp.274.1136668051 4 123 DB1_PDB2:TEMP 32767 +DATA/DB1/FB867EA89ECF81C0E053630F1EACB901/TEMPFILE/temp.279.1136668067 5 123 DB1_PDB3:TEMP 32767 +DATA/DB1/FB867F8A4D4F821CE053630F1EAC69CC/TEMPFILE/temp.284.1136668081 RMAN>
-
驗證來自 OS NFS 掛載點的資料庫映像副本。
[oracle@ip-172-30-15-99 ~]$ ls -l /nfsfsxn/oracopy/ total 70585148 -rw-r----- 1 oracle asm 4294975488 May 17 18:09 data_D-DB1_I-1730530050_TS-SOE_FNO-21_021sd6pv -rw-r----- 1 oracle asm 4294975488 May 17 18:10 data_D-DB1_I-1730530050_TS-SOE_FNO-22_031sd6r2 -rw-r----- 1 oracle asm 4294975488 May 17 18:10 data_D-DB1_I-1730530050_TS-SOE_FNO-23_041sd6s5 -rw-r----- 1 oracle asm 4294975488 May 17 18:11 data_D-DB1_I-1730530050_TS-SOE_FNO-24_051sd6t9 -rw-r----- 1 oracle asm 4294975488 May 17 18:11 data_D-DB1_I-1730530050_TS-SOE_FNO-25_061sd6uc -rw-r----- 1 oracle asm 4294975488 May 17 18:12 data_D-DB1_I-1730530050_TS-SOE_FNO-26_071sd6vf -rw-r----- 1 oracle asm 4294975488 May 17 18:13 data_D-DB1_I-1730530050_TS-SOE_FNO-27_081sd70i -rw-r----- 1 oracle asm 4294975488 May 17 18:13 data_D-DB1_I-1730530050_TS-SOE_FNO-28_091sd71l -rw-r----- 1 oracle asm 4294975488 May 17 18:14 data_D-DB1_I-1730530050_TS-SOE_FNO-29_0a1sd72o -rw-r----- 1 oracle asm 4294975488 May 17 18:14 data_D-DB1_I-1730530050_TS-SOE_FNO-30_0b1sd73r -rw-r----- 1 oracle asm 4294975488 May 17 18:15 data_D-DB1_I-1730530050_TS-SOE_FNO-31_0c1sd74u -rw-r----- 1 oracle asm 4294975488 May 17 18:16 data_D-DB1_I-1730530050_TS-SOE_FNO-32_0d1sd762 -rw-r----- 1 oracle asm 4294975488 May 17 18:16 data_D-DB1_I-1730530050_TS-SOE_FNO-33_0e1sd775 -rw-r----- 1 oracle asm 4294975488 May 17 18:17 data_D-DB1_I-1730530050_TS-SOE_FNO-34_0f1sd788 -rw-r----- 1 oracle asm 4294975488 May 17 18:17 data_D-DB1_I-1730530050_TS-SOE_FNO-35_0g1sd79b -rw-r----- 1 oracle asm 513810432 May 17 18:18 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_0k1sd7bb -rw-r----- 1 oracle asm 492838912 May 17 18:18 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_0l1sd7bi -rw-r----- 1 oracle asm 492838912 May 17 18:18 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_0m1sd7bq -rw-r----- 1 oracle asm 849354752 May 17 18:18 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_0i1sd7at -rw-r----- 1 oracle asm 482353152 May 17 18:18 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_0o1sd7c8 -rw-r----- 1 oracle asm 1111498752 May 17 18:18 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_0h1sd7ae -rw-r----- 1 oracle asm 419438592 May 17 18:19 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_0r1sd7ct -rw-r----- 1 oracle asm 419438592 May 17 18:19 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_0s1sd7d4 -rw-r----- 1 oracle asm 419438592 May 17 18:19 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_0p1sd7cf -rw-r----- 1 oracle asm 419438592 May 17 18:19 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_0q1sd7cm -rw-r----- 1 oracle asm 487596032 May 17 18:18 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_0n1sd7c1 -rw-r----- 1 oracle asm 246423552 May 17 18:19 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_0t1sd7db -rw-r----- 1 oracle asm 246423552 May 17 18:19 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_0u1sd7de -rw-r----- 1 oracle asm 707796992 May 17 18:18 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_0j1sd7b4 -rw-r----- 1 oracle asm 241180672 May 17 18:19 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_0v1sd7di -rw-r----- 1 oracle asm 5251072 May 17 18:19 data_D-DB1_I-1730530050_TS-USERS_FNO-12_111sd7dm -rw-r----- 1 oracle asm 5251072 May 17 18:19 data_D-DB1_I-1730530050_TS-USERS_FNO-16_121sd7dn -rw-r----- 1 oracle asm 5251072 May 17 18:19 data_D-DB1_I-1730530050_TS-USERS_FNO-20_131sd7do -rw-r----- 1 oracle asm 5251072 May 17 18:19 data_D-DB1_I-1730530050_TS-USERS_FNO-7_101sd7dl
這樣就完成了Oracle資料庫備用映像副本備份合併的設定。
將 Oracle DB 切換到映像副本以實現快速恢復
Details
如果因主儲存問題（例如資料遺失或損壞）而發生故障，則可以將資料庫快速切換到 FSx ONTAP NFS 掛載上的映像副本，並還原到目前狀態，而無需還原資料庫。消除媒體復原可大幅加快 VLDB 的資料庫復原速度。此用例假設資料庫主機執行個體完好無損，且資料庫控製檔案、存檔和目前日誌均可用於復原。
-
以 oracle 使用者登入 EC2 DB 伺服器主機並在切換之前建立測試表。
[ec2-user@ip-172-30-15-99 ~]$ sudo su [root@ip-172-30-15-99 ec2-user]# su - oracle Last login: Thu May 18 14:22:34 UTC 2023 [oracle@ip-172-30-15-99 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu May 18 14:30:36 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 READ WRITE NO 4 DB1_PDB2 READ WRITE NO 5 DB1_PDB3 READ WRITE NO SQL> alter session set container=db1_pdb1; Session altered. SQL> create table test (id integer, dt timestamp, event varchar(100)); Table created. SQL> insert into test values(1, sysdate, 'test oracle incremental merge switch to copy'); 1 row created. SQL> commit; Commit complete. SQL> select * from test; ID ---------- DT --------------------------------------------------------------------------- EVENT -------------------------------------------------------------------------------- 1 18-MAY-23 02.35.37.000000 PM test oracle incremental merge switch to copy SQL> -
透過關閉中止資料庫來模擬故障，然後在掛載階段啟動 oracle。
SQL> shutdown abort; ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 1.2885E+10 bytes Fixed Size 9177880 bytes Variable Size 1778384896 bytes Database Buffers 1.1073E+10 bytes Redo Buffers 24375296 bytes Database mounted. SQL>
-
以 oracle 使用者身份，透過 RMAN 連接到 Oracle 資料庫切換要複製的資料庫。
RMAN> switch database to copy; datafile 1 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_0h1sd7ae" datafile 3 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_0i1sd7at" datafile 4 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_0j1sd7b4" datafile 5 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_0p1sd7cf" datafile 6 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_0o1sd7c8" datafile 7 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_101sd7dl" datafile 8 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_0v1sd7di" datafile 9 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_0q1sd7cm" datafile 10 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_0k1sd7bb" datafile 11 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_0n1sd7c1" datafile 12 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_111sd7dm" datafile 13 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_0r1sd7ct" datafile 14 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_0l1sd7bi" datafile 15 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_0t1sd7db" datafile 16 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_121sd7dn" datafile 17 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_0s1sd7d4" datafile 18 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_0m1sd7bq" datafile 19 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_0u1sd7de" datafile 20 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_131sd7do" datafile 21 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_021sd6pv" datafile 22 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_031sd6r2" datafile 23 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_041sd6s5" datafile 24 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_051sd6t9" datafile 25 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_061sd6uc" datafile 26 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_071sd6vf" datafile 27 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_081sd70i" datafile 28 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_091sd71l" datafile 29 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_0a1sd72o" datafile 30 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_0b1sd73r" datafile 31 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_0c1sd74u" datafile 32 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_0d1sd762" datafile 33 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_0e1sd775" datafile 34 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_0f1sd788" datafile 35 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_0g1sd79b"
-
還原並開啟資料庫，使其從上次增量備份更新到目前狀態。
RMAN> recover database; Starting recover at 18-MAY-23 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=392 device type=DISK channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00009: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_0q1sd7cm destination for restore of datafile 00023: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_041sd6s5 destination for restore of datafile 00027: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_081sd70i destination for restore of datafile 00031: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_0c1sd74u destination for restore of datafile 00034: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_0f1sd788 channel ORA_DISK_1: reading from backup piece /nfsfsxn/oracopy/321sfous_98_1_1 channel ORA_DISK_1: piece handle=/nfsfsxn/oracopy/321sfous_98_1_1 tag=ORACOPYBKUPONFSXN_LEVEL_0 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00010: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_0k1sd7bb destination for restore of datafile 00021: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_021sd6pv destination for restore of datafile 00025: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_061sd6uc . . . channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00016: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_121sd7dn channel ORA_DISK_1: reading from backup piece /nfsfsxn/oracopy/3i1sfov0_114_1_1 channel ORA_DISK_1: piece handle=/nfsfsxn/oracopy/3i1sfov0_114_1_1 tag=ORACOPYBKUPONFSXN_LEVEL_0 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00020: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_131sd7do channel ORA_DISK_1: reading from backup piece /nfsfsxn/oracopy/3j1sfov0_115_1_1 channel ORA_DISK_1: piece handle=/nfsfsxn/oracopy/3j1sfov0_115_1_1 tag=ORACOPYBKUPONFSXN_LEVEL_0 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 starting media recovery media recovery complete, elapsed time: 00:00:01 Finished recover at 18-MAY-23 RMAN> alter database open; Statement processed RMAN>
-
復原後從 sqlplus 檢查資料庫結構，觀察除控制、臨時和目前日誌檔案之外的所有資料庫資料檔案現在都已切換到 FSx ONTAP NFS 檔案系統上的副本。
SQL> select name from v$datafile 2 union 3 select name from v$tempfile 4 union 5 select name from v$controlfile 6 union 7 select member from v$logfile; NAME -------------------------------------------------------------------------------- +DATA/DB1/CONTROLFILE/current.261.1136666435 +DATA/DB1/FB864A929AEB79B9E053630F1EAC7046/TEMPFILE/temp.269.1136667185 +DATA/DB1/FB867DA8C68C816EE053630F1EAC2BCF/TEMPFILE/temp.274.1136668051 +DATA/DB1/FB867EA89ECF81C0E053630F1EACB901/TEMPFILE/temp.279.1136668067 +DATA/DB1/FB867F8A4D4F821CE053630F1EAC69CC/TEMPFILE/temp.284.1136668081 +DATA/DB1/ONLINELOG/group_1.262.1136666437 +DATA/DB1/ONLINELOG/group_2.263.1136666437 +DATA/DB1/ONLINELOG/group_3.264.1136666437 +DATA/DB1/TEMPFILE/temp.265.1136666447 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_021sd6pv /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_031sd6r2 NAME -------------------------------------------------------------------------------- /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_041sd6s5 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_051sd6t9 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_061sd6uc /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_071sd6vf /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_081sd70i /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_091sd71l /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_0a1sd72o /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_0b1sd73r /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_0c1sd74u /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_0d1sd762 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_0e1sd775 NAME -------------------------------------------------------------------------------- /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_0f1sd788 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_0g1sd79b /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_0k1sd7bb /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_0l1sd7bi /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_0m1sd7bq /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_0i1sd7at /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_0o1sd7c8 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_0r1sd7ct /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_0s1sd7d4 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_0h1sd7ae /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_0p1sd7cf NAME -------------------------------------------------------------------------------- /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_0q1sd7cm /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_0n1sd7c1 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_0t1sd7db /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_0u1sd7de /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_0j1sd7b4 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_0v1sd7di /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_111sd7dm /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_121sd7dn /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_131sd7do /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_101sd7dl 43 rows selected. SQL>
-
從 SQL Plus 中，檢查在切換到複製之前插入的測試表的內容
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 READ WRITE NO 4 DB1_PDB2 READ WRITE NO 5 DB1_PDB3 READ WRITE NO SQL> alter session set container=db1_pdb1; Session altered. SQL> select * from test; ID ---------- DT --------------------------------------------------------------------------- EVENT -------------------------------------------------------------------------------- 1 18-MAY-23 02.35.37.000000 PM test oracle incremental merge switch to copy SQL> -
您可以在 FSx NFS 掛載中長時間執行 Oracle 資料庫而不會影響效能，因為 FSx ONTAP是可提供高效能的冗餘生產級儲存。當主儲存問題解決後，您可以透過逆轉增量備份合併過程，以最少的停機時間恢復原狀。
Oracle 資料庫從映像副本還原到不同的 EC2 DB 執行個體主機
Details
當主儲存和 EC2 DB 執行個體主機都遺失時，無法從原始伺服器進行復原。幸運的是，您在冗餘 FSx ONTAP NFS 檔案系統上仍然有一個 Oracle 資料庫備份映像副本。您可以快速配置另一個相同的 EC2 DB 實例，並透過 NFS 輕鬆地將 VLDB 的映像副本安裝到新的 EC2 DB 主機以執行復原。在本節中，我們將示範執行此操作的逐步過程。
-
在我們先前建立的測試表中插入一行，用於 Oracle 資料庫還原到備用主機驗證。
[oracle@ip-172-30-15-99 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 30 17:21:05 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 READ WRITE NO 4 DB1_PDB2 READ WRITE NO 5 DB1_PDB3 READ WRITE NO SQL> alter session set container=db1_pdb1; Session altered. SQL> insert into test values(2, sysdate, 'test recovery on a new EC2 instance host with image copy on FSx ONTAP'); 1 row created. SQL> commit; Commit complete. SQL> select * from test; ID ---------- DT --------------------------------------------------------------------------- EVENT -------------------------------------------------------------------------------- 1 18-MAY-23 02.35.37.000000 PM test oracle incremental merge switch to copy 2 30-MAY-23 05.23.11.000000 PM test recovery on a new EC2 instance host with image copy on FSx ONTAP SQL> -
以 oracle 使用者身分執行 RMAN 增量備份並合併以將交易刷新到 FSx ONTAP NFS 掛載上的備份集。
[oracle@ip-172-30-15-99 ~]$ rman target / nocatalog Recovery Manager: Release 19.0.0.0.0 - Production on Tue May 30 17:26:03 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: DB1 (DBID=1730530050) using target database control file instead of recovery catalog RMAN> @rman_bkup_merge.cmd
-
關閉主 EC2 DB 執行個體主機以模擬儲存和 DB 伺服器主機的完全故障。
-
透過 AWS EC2 控制台為具有相同作業系統和版本的新 EC2 DB 執行個體主機 ora_02 提供權限。使用與主 EC2 DB 伺服器主機相同的補丁配置 OS 內核，Oracle 預先安裝 RPM，並為主機新增交換空間。使用僅軟體選項安裝與主 EC2 DB 伺服器主機中相同版本和修補程式的 Oracle。這些任務可以透過NetApp自動化工具包自動執行，可從以下連結取得。
-
配置與主 EC2 DB 執行個體主機 ora_01 類似的 oracle 環境，例如 oratab、oraInst.loc 和 oracle 使用者 .bash_profile。將這些檔案備份到 FSx ONTAP NFS 掛載點是一種很好的做法。
-
FSx ONTAP NFS 掛載上的 Oracle 資料庫備份映像副本儲存在跨 AWS 可用區的 FSx 叢集上，以實現冗餘、高可用性和高效能。只要網路可達，NFS 檔案系統就可以輕鬆安裝到新伺服器上。以下步驟將 Oracle VLDB 備份的映像副本掛載到新配置的 EC2 DB 執行個體主機以進行還原。
以 ec2-user 身分建立掛載點。
sudo mkdir /nfsfsxn以 ec2-user 身分掛載儲存 Oracle VLDB 備份映像副本的 NFS 磁碟區。
sudo mount 172.30.15.19:/ora_01_copy /nfsfsxn -o rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144,nointr -
驗證 FSx ONTAP NFS 掛載點上的 Oracle 資料庫備份映像副本。
[ec2-user@ip-172-30-15-124 ~]$ ls -ltr /nfsfsxn/oracopy total 78940700 -rw-r-----. 1 oracle 54331 482353152 May 26 18:45 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_4m1t508t -rw-r-----. 1 oracle 54331 419438592 May 26 18:45 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_4q1t509n -rw-r-----. 1 oracle 54331 241180672 May 26 18:45 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_4t1t50a6 -rw-r-----. 1 oracle 54331 450560 May 30 15:29 6b1tf6b8_203_1_1 -rw-r-----. 1 oracle 54331 663552 May 30 15:29 6c1tf6b8_204_1_1 -rw-r-----. 1 oracle 54331 122880 May 30 15:29 6d1tf6b8_205_1_1 -rw-r-----. 1 oracle 54331 507904 May 30 15:29 6e1tf6b8_206_1_1 -rw-r-----. 1 oracle 54331 4259840 May 30 15:29 6f1tf6b9_207_1_1 -rw-r-----. 1 oracle 54331 9060352 May 30 15:29 6h1tf6b9_209_1_1 -rw-r-----. 1 oracle 54331 442368 May 30 15:29 6i1tf6b9_210_1_1 -rw-r-----. 1 oracle 54331 475136 May 30 15:29 6j1tf6bb_211_1_1 -rw-r-----. 1 oracle 54331 48660480 May 30 15:29 6g1tf6b9_208_1_1 -rw-r-----. 1 oracle 54331 589824 May 30 15:29 6l1tf6bb_213_1_1 -rw-r-----. 1 oracle 54331 606208 May 30 15:29 6m1tf6bb_214_1_1 -rw-r-----. 1 oracle 54331 368640 May 30 15:29 6o1tf6bb_216_1_1 -rw-r-----. 1 oracle 54331 368640 May 30 15:29 6p1tf6bc_217_1_1 -rw-r-----. 1 oracle 54331 57344 May 30 15:29 6r1tf6bc_219_1_1 -rw-r-----. 1 oracle 54331 57344 May 30 15:29 6s1tf6bc_220_1_1 -rw-r-----. 1 oracle 54331 57344 May 30 15:29 6t1tf6bc_221_1_1 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-23_3q1t4ut3 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-21_3o1t4ut2 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-27_461t4vt7 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-25_3s1t4v1a -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-22_3p1t4ut3 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-31_4a1t5015 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-29_481t4vt7 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-34_4d1t5058 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-26_451t4vt7 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-24_3r1t4ut3 -rw-r-----. 1 oracle 54331 555753472 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_4i1t5083 -rw-r-----. 1 oracle 54331 429924352 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_4n1t509m -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-30_491t5014 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-28_471t4vt7 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-35_4e1t5059 -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-32_4b1t501u -rw-r-----. 1 oracle 54331 487596032 May 30 17:26 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_4l1t508t -rw-r-----. 1 oracle 54331 4294975488 May 30 17:26 data_D-DB1_I-1730530050_TS-SOE_FNO-33_4c1t501v -rw-r-----. 1 oracle 54331 5251072 May 30 17:26 data_D-DB1_I-1730530050_TS-USERS_FNO-12_4v1t50aa -rw-r-----. 1 oracle 54331 1121984512 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_4f1t506m -rw-r-----. 1 oracle 54331 707796992 May 30 17:26 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_4h1t5083 -rw-r-----. 1 oracle 54331 534781952 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_4j1t508s -rw-r-----. 1 oracle 54331 429924352 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_4o1t509m -rw-r-----. 1 oracle 54331 429924352 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_4p1t509m -rw-r-----. 1 oracle 54331 534781952 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_4k1t508t -rw-r-----. 1 oracle 54331 1027612672 May 30 17:26 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_4g1t506m -rw-r-----. 1 oracle 54331 5251072 May 30 17:26 data_D-DB1_I-1730530050_TS-USERS_FNO-7_4u1t50a6 -rw-r-----. 1 oracle 54331 246423552 May 30 17:26 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_4r1t50a6 -rw-r-----. 1 oracle 54331 5251072 May 30 17:26 data_D-DB1_I-1730530050_TS-USERS_FNO-16_501t50ad -rw-r-----. 1 oracle 54331 246423552 May 30 17:26 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_4s1t50a6 -rw-r-----. 1 oracle 54331 5251072 May 30 17:26 data_D-DB1_I-1730530050_TS-USERS_FNO-20_511t50ad -rw-r-----. 1 oracle 54331 2318712832 May 30 17:32 721tfd6b_226_1_1 -rw-r-----. 1 oracle 54331 1813143552 May 30 17:33 701tfd6a_224_1_1 -rw-r-----. 1 oracle 54331 966656 May 30 17:33 731tfdic_227_1_1 -rw-r-----. 1 oracle 54331 5980160 May 30 17:33 751tfdij_229_1_1 -rw-r-----. 1 oracle 54331 458752 May 30 17:33 761tfdin_230_1_1 -rw-r-----. 1 oracle 54331 458752 May 30 17:33 771tfdiq_231_1_1 -rw-r-----. 1 oracle 54331 11091968 May 30 17:33 741tfdij_228_1_1 -rw-r-----. 1 oracle 54331 401408 May 30 17:33 791tfdit_233_1_1 -rw-r-----. 1 oracle 54331 2070708224 May 30 17:33 6v1tfd6a_223_1_1 -rw-r-----. 1 oracle 54331 376832 May 30 17:33 7a1tfdit_234_1_1 -rw-r-----. 1 oracle 54331 1874903040 May 30 17:33 711tfd6b_225_1_1 -rw-r-----. 1 oracle 54331 303104 May 30 17:33 7c1tfdiu_236_1_1 -rw-r-----. 1 oracle 54331 319488 May 30 17:33 7d1tfdiv_237_1_1 -rw-r-----. 1 oracle 54331 57344 May 30 17:33 7f1tfdiv_239_1_1 -rw-r-----. 1 oracle 54331 57344 May 30 17:33 7g1tfdiv_240_1_1 -rw-r-----. 1 oracle 54331 57344 May 30 17:33 7h1tfdiv_241_1_1 -rw-r--r--. 1 oracle 54331 12720 May 30 17:33 db1_ctl.sql -rw-r-----. 1 oracle 54331 11600384 May 30 17:54 bct_db1.ctf
-
驗證 FSx ONTAP NFS 掛載上可用的 Oracle 存檔日誌以進行恢復，並記下最後一個日誌檔案日誌序號。在這種情況下，它是 175。我們的復原點最多為日誌序號 176。
[ec2-user@ip-172-30-15-124 ~]$ ls -ltr /nfsfsxn/archlog/DB1/archivelog/2023_05_30 total 5714400 -r--r-----. 1 oracle 54331 321024 May 30 14:59 o1_mf_1_140__003t9mvn_.arc -r--r-----. 1 oracle 54331 48996352 May 30 15:29 o1_mf_1_141__01t9qf6r_.arc -r--r-----. 1 oracle 54331 167477248 May 30 15:44 o1_mf_1_142__02n3x2qb_.arc -r--r-----. 1 oracle 54331 165684736 May 30 15:46 o1_mf_1_143__02rotwyb_.arc -r--r-----. 1 oracle 54331 165636608 May 30 15:49 o1_mf_1_144__02x563wh_.arc -r--r-----. 1 oracle 54331 168408064 May 30 15:51 o1_mf_1_145__031kg2co_.arc -r--r-----. 1 oracle 54331 169446400 May 30 15:54 o1_mf_1_146__035xpcdt_.arc -r--r-----. 1 oracle 54331 167595520 May 30 15:56 o1_mf_1_147__03bds8qf_.arc -r--r-----. 1 oracle 54331 169270272 May 30 15:59 o1_mf_1_148__03gyt7rx_.arc -r--r-----. 1 oracle 54331 170712576 May 30 16:01 o1_mf_1_149__03mfxl7v_.arc -r--r-----. 1 oracle 54331 170744832 May 30 16:04 o1_mf_1_150__03qzz0ty_.arc -r--r-----. 1 oracle 54331 169380864 May 30 16:06 o1_mf_1_151__03wgxdry_.arc -r--r-----. 1 oracle 54331 169833984 May 30 16:09 o1_mf_1_152__040y85v3_.arc -r--r-----. 1 oracle 54331 165134336 May 30 16:20 o1_mf_1_153__04ox946w_.arc -r--r-----. 1 oracle 54331 169929216 May 30 16:22 o1_mf_1_154__04rbv7n8_.arc -r--r-----. 1 oracle 54331 171903488 May 30 16:23 o1_mf_1_155__04tv1yvn_.arc -r--r-----. 1 oracle 54331 179061248 May 30 16:25 o1_mf_1_156__04xgfjtl_.arc -r--r-----. 1 oracle 54331 173593088 May 30 16:26 o1_mf_1_157__04zyg8hw_.arc -r--r-----. 1 oracle 54331 175999488 May 30 16:27 o1_mf_1_158__052gp9mt_.arc -r--r-----. 1 oracle 54331 179092992 May 30 16:29 o1_mf_1_159__0551wk7s_.arc -r--r-----. 1 oracle 54331 175524352 May 30 16:30 o1_mf_1_160__057l46my_.arc -r--r-----. 1 oracle 54331 173949440 May 30 16:32 o1_mf_1_161__05b2dmwp_.arc -r--r-----. 1 oracle 54331 184166912 May 30 16:33 o1_mf_1_162__05drbj8n_.arc -r--r-----. 1 oracle 54331 173026816 May 30 16:35 o1_mf_1_163__05h8lm1h_.arc -r--r-----. 1 oracle 54331 174286336 May 30 16:36 o1_mf_1_164__05krsqmh_.arc -r--r-----. 1 oracle 54331 166092288 May 30 16:37 o1_mf_1_165__05n378pw_.arc -r--r-----. 1 oracle 54331 177640960 May 30 16:39 o1_mf_1_166__05pmg74l_.arc -r--r-----. 1 oracle 54331 173972992 May 30 16:40 o1_mf_1_167__05s3o01r_.arc -r--r-----. 1 oracle 54331 178474496 May 30 16:41 o1_mf_1_168__05vmwt34_.arc -r--r-----. 1 oracle 54331 177694208 May 30 16:43 o1_mf_1_169__05y45qdd_.arc -r--r-----. 1 oracle 54331 170814976 May 30 16:44 o1_mf_1_170__060kgh33_.arc -r--r-----. 1 oracle 54331 177325056 May 30 16:46 o1_mf_1_171__0631tvgv_.arc -r--r-----. 1 oracle 54331 164455424 May 30 16:47 o1_mf_1_172__065d94fq_.arc -r--r-----. 1 oracle 54331 178252288 May 30 16:48 o1_mf_1_173__067wnwy8_.arc -r--r-----. 1 oracle 54331 170579456 May 30 16:50 o1_mf_1_174__06b9zdh8_.arc -r--r-----. 1 oracle 54331 93928960 May 30 17:26 o1_mf_1_175__08c7jc2b_.arc [ec2-user@ip-172-30-15-124 ~]$
-
以 oracle 使用者身份，將 ORACLE_HOME 變數設定為新 EC2 實例 DB 主機 ora_02 上的目前 Oracle 安裝，將 ORACLE_SID 設定為主 Oracle 實例 SID。在本例中，它是 db1。
-
以 oracle 使用者身份，在 $ORACLE_HOME/dbs 目錄中建立一個通用 Oracle 初始化文件，並配置適當的管理目錄。最重要的是，擁有 Oracle
flash recovery area`指向主 Oracle VLDB 實例中定義的 FSx ONTAP NFS 掛載路徑。 `flash recovery area`配置在章節中進行了演示 `Setup Oracle RMAN incremental merge to image copy on FSx。將 Oracle 控制檔設定為 FSx ONTAP NFS 檔案系統。vi $ORACLE_HOME/dbs/initdb1.ora使用以下範例條目：
*.audit_file_dest='/u01/app/oracle/admin/db1/adump' *.audit_trail='db' *.compatible='19.0.0' *.control_files=('/nfsfsxn/oracopy/db1.ctl') *.db_block_size=8192 *.db_create_file_dest='/nfsfsxn/oracopy/' *.db_domain='demo.netapp.com' *.db_name='db1' *.db_recovery_file_dest_size=85899345920 *.db_recovery_file_dest='/nfsfsxn/archlog/' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=db1XDB)' *.enable_pluggable_database=true *.local_listener='LISTENER' *.nls_language='AMERICAN' *.nls_territory='AMERICA' *.open_cursors=300 *.pga_aggregate_target=1024m *.processes=320 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=10240m *.undo_tablespace='UNDOTBS1'如果存在差異，則應使用從主 Oracle DB 伺服器還原的備份初始化檔案取代上述初始化檔案。
-
以 oracle 使用者身分啟動 RMAN 以在新的 EC2 DB 執行個體主機上執行 Oracle 復原。
[oracle@ip-172-30-15-124 dbs]$ rman target / nocatalog; Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 31 00:56:07 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup nomount; Oracle instance started Total System Global Area 12884900632 bytes Fixed Size 9177880 bytes Variable Size 1778384896 bytes Database Buffers 11072962560 bytes Redo Buffers 24375296 bytes
-
設定資料庫ID。可以從 FSx NFS 掛載點上的映像副本的 Oracle 檔案名稱中檢索資料庫 ID。
RMAN> set dbid = 1730530050; executing command: SET DBID
-
從自動備份還原控製檔。如果啟用了 Oracle 控製檔案和 spfile 自動備份，則它們會在每個增量備份和合併週期中備份。如果有多個副本可用，將還原最新的備份。
RMAN> restore controlfile from autobackup; Starting restore at 31-MAY-23 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2 device type=DISK recovery area destination: /nfsfsxn/archlog database name (or database unique name) used for search: DB1 channel ORA_DISK_1: AUTOBACKUP /nfsfsxn/archlog/DB1/autobackup/2023_05_30/o1_mf_s_1138210401__08qlxrrr_.bkp found in the recovery area channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230531 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230530 channel ORA_DISK_1: restoring control file from AUTOBACKUP /nfsfsxn/archlog/DB1/autobackup/2023_05_30/o1_mf_s_1138210401__08qlxrrr_.bkp channel ORA_DISK_1: control file restore from AUTOBACKUP complete output file name=/nfsfsxn/oracopy/db1.ctl Finished restore at 31-MAY-23
-
將初始化檔案從 spfile 還原到 /tmp 資料夾，以便稍後更新參數檔案以與主資料庫執行個體相符。
RMAN> restore spfile to pfile '/tmp/archive/initdb1.ora' from autobackup; Starting restore at 31-MAY-23 using channel ORA_DISK_1 recovery area destination: /nfsfsxn/archlog database name (or database unique name) used for search: DB1 channel ORA_DISK_1: AUTOBACKUP /nfsfsxn/archlog/DB1/autobackup/2023_05_30/o1_mf_s_1138210401__08qlxrrr_.bkp found in the recovery area channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230531 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230530 channel ORA_DISK_1: restoring spfile from AUTOBACKUP /nfsfsxn/archlog/DB1/autobackup/2023_05_30/o1_mf_s_1138210401__08qlxrrr_.bkp channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete Finished restore at 31-MAY-23
-
掛載控制檔並驗證資料庫備份映像副本。
RMAN> alter database mount; released channel: ORA_DISK_1 Statement processed RMAN> list copy of database tag 'OraCopyBKUPonFSxN_level_0'; List of Datafile Copies ======================= Key File S Completion Time Ckp SCN Ckp Time Sparse ------- ---- - --------------- ---------- --------------- ------ 316 1 A 30-MAY-23 4120170 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_4f1t506m Tag: ORACOPYBKUPONFSXN_LEVEL_0 322 3 A 30-MAY-23 4120175 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_4g1t506m Tag: ORACOPYBKUPONFSXN_LEVEL_0 317 4 A 30-MAY-23 4120179 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_4h1t5083 Tag: ORACOPYBKUPONFSXN_LEVEL_0 221 5 A 26-MAY-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_4q1t509n Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 216 6 A 26-MAY-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_4m1t508t Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 323 7 A 30-MAY-23 4120207 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_4u1t50a6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 227 8 A 26-MAY-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_4t1t50a6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 308 9 A 30-MAY-23 4120158 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_4n1t509m Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 307 10 A 30-MAY-23 4120166 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_4i1t5083 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 313 11 A 30-MAY-23 4120154 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_4l1t508t Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 315 12 A 30-MAY-23 4120162 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_4v1t50aa Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 319 13 A 30-MAY-23 4120191 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_4o1t509m Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 318 14 A 30-MAY-23 4120183 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_4j1t508s Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 324 15 A 30-MAY-23 4120199 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_4r1t50a6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 325 16 A 30-MAY-23 4120211 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_501t50ad Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 320 17 A 30-MAY-23 4120195 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_4p1t509m Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 321 18 A 30-MAY-23 4120187 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_4k1t508t Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 326 19 A 30-MAY-23 4120203 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_4s1t50a6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 327 20 A 30-MAY-23 4120216 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_511t50ad Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 298 21 A 30-MAY-23 4120166 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_3o1t4ut2 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 302 22 A 30-MAY-23 4120154 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_3p1t4ut3 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 297 23 A 30-MAY-23 4120158 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_3q1t4ut3 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 306 24 A 30-MAY-23 4120162 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_3r1t4ut3 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 300 25 A 30-MAY-23 4120166 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_3s1t4v1a Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 305 26 A 30-MAY-23 4120154 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_451t4vt7 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 299 27 A 30-MAY-23 4120158 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_461t4vt7 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 310 28 A 30-MAY-23 4120162 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_471t4vt7 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 303 29 A 30-MAY-23 4120166 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_481t4vt7 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 309 30 A 30-MAY-23 4120154 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_491t5014 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 301 31 A 30-MAY-23 4120158 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_4a1t5015 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 312 32 A 30-MAY-23 4120162 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_4b1t501u Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 314 33 A 30-MAY-23 4120162 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_4c1t501v Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 304 34 A 30-MAY-23 4120158 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_4d1t5058 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 311 35 A 30-MAY-23 4120154 30-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_4e1t5059 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 -
將資料庫切換到複製以運行恢復，而無需資料庫還原。
RMAN> switch database to copy; Starting implicit crosscheck backup at 31-MAY-23 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=11 device type=DISK Crosschecked 33 objects Finished implicit crosscheck backup at 31-MAY-23 Starting implicit crosscheck copy at 31-MAY-23 using channel ORA_DISK_1 Crosschecked 68 objects Finished implicit crosscheck copy at 31-MAY-23 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /nfsfsxn/archlog/DB1/autobackup/2023_05_30/o1_mf_s_1138210401__08qlxrrr_.bkp datafile 1 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_4f1t506m" datafile 3 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_4g1t506m" datafile 4 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_4h1t5083" datafile 5 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_4q1t509n" datafile 6 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_4m1t508t" datafile 7 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_4u1t50a6" datafile 8 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_4t1t50a6" datafile 9 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_4n1t509m" datafile 10 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_4i1t5083" datafile 11 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_4l1t508t" datafile 12 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_4v1t50aa" datafile 13 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_4o1t509m" datafile 14 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_4j1t508s" datafile 15 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_4r1t50a6" datafile 16 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_501t50ad" datafile 17 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_4p1t509m" datafile 18 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_4k1t508t" datafile 19 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_4s1t50a6" datafile 20 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_511t50ad" datafile 21 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_3o1t4ut2" datafile 22 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_3p1t4ut3" datafile 23 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_3q1t4ut3" datafile 24 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_3r1t4ut3" datafile 25 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_3s1t4v1a" datafile 26 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_451t4vt7" datafile 27 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_461t4vt7" datafile 28 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_471t4vt7" datafile 29 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_481t4vt7" datafile 30 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_491t5014" datafile 31 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_4a1t5015" datafile 32 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_4b1t501u" datafile 33 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_4c1t501v" datafile 34 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_4d1t5058" datafile 35 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_4e1t5059"
-
執行 Oracle 復原直到閃回復原區中最後一個可用的存檔日誌。
RMAN> run { 2> set until sequence=176; 3> recover database; 4> } executing command: SET until clause Starting recover at 31-MAY-23 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 142 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_142__02n3x2qb_.arc archived log for thread 1 with sequence 143 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_143__02rotwyb_.arc archived log for thread 1 with sequence 144 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_144__02x563wh_.arc archived log for thread 1 with sequence 145 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_145__031kg2co_.arc archived log for thread 1 with sequence 146 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_146__035xpcdt_.arc archived log for thread 1 with sequence 147 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_147__03bds8qf_.arc archived log for thread 1 with sequence 148 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_148__03gyt7rx_.arc archived log for thread 1 with sequence 149 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_149__03mfxl7v_.arc archived log for thread 1 with sequence 150 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_150__03qzz0ty_.arc archived log for thread 1 with sequence 151 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_151__03wgxdry_.arc archived log for thread 1 with sequence 152 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_152__040y85v3_.arc archived log for thread 1 with sequence 153 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_153__04ox946w_.arc archived log for thread 1 with sequence 154 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_154__04rbv7n8_.arc archived log for thread 1 with sequence 155 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_155__04tv1yvn_.arc archived log for thread 1 with sequence 156 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_156__04xgfjtl_.arc archived log for thread 1 with sequence 157 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_157__04zyg8hw_.arc archived log for thread 1 with sequence 158 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_158__052gp9mt_.arc archived log for thread 1 with sequence 159 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_159__0551wk7s_.arc archived log for thread 1 with sequence 160 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_160__057l46my_.arc archived log for thread 1 with sequence 161 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_161__05b2dmwp_.arc archived log for thread 1 with sequence 162 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_162__05drbj8n_.arc archived log for thread 1 with sequence 163 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_163__05h8lm1h_.arc archived log for thread 1 with sequence 164 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_164__05krsqmh_.arc archived log for thread 1 with sequence 165 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_165__05n378pw_.arc archived log for thread 1 with sequence 166 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_166__05pmg74l_.arc archived log for thread 1 with sequence 167 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_167__05s3o01r_.arc archived log for thread 1 with sequence 168 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_168__05vmwt34_.arc archived log for thread 1 with sequence 169 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_169__05y45qdd_.arc archived log for thread 1 with sequence 170 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_170__060kgh33_.arc archived log for thread 1 with sequence 171 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_171__0631tvgv_.arc archived log for thread 1 with sequence 172 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_172__065d94fq_.arc archived log for thread 1 with sequence 173 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_173__067wnwy8_.arc archived log for thread 1 with sequence 174 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_174__06b9zdh8_.arc archived log for thread 1 with sequence 175 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_175__08c7jc2b_.arc archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_142__02n3x2qb_.arc thread=1 sequence=142 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_143__02rotwyb_.arc thread=1 sequence=143 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_144__02x563wh_.arc thread=1 sequence=144 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_145__031kg2co_.arc thread=1 sequence=145 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_146__035xpcdt_.arc thread=1 sequence=146 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_147__03bds8qf_.arc thread=1 sequence=147 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_148__03gyt7rx_.arc thread=1 sequence=148 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_149__03mfxl7v_.arc thread=1 sequence=149 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_150__03qzz0ty_.arc thread=1 sequence=150 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_151__03wgxdry_.arc thread=1 sequence=151 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_152__040y85v3_.arc thread=1 sequence=152 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_153__04ox946w_.arc thread=1 sequence=153 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_154__04rbv7n8_.arc thread=1 sequence=154 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_155__04tv1yvn_.arc thread=1 sequence=155 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_156__04xgfjtl_.arc thread=1 sequence=156 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_157__04zyg8hw_.arc thread=1 sequence=157 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_158__052gp9mt_.arc thread=1 sequence=158 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_159__0551wk7s_.arc thread=1 sequence=159 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_160__057l46my_.arc thread=1 sequence=160 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_161__05b2dmwp_.arc thread=1 sequence=161 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_162__05drbj8n_.arc thread=1 sequence=162 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_163__05h8lm1h_.arc thread=1 sequence=163 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_164__05krsqmh_.arc thread=1 sequence=164 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_165__05n378pw_.arc thread=1 sequence=165 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_166__05pmg74l_.arc thread=1 sequence=166 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_167__05s3o01r_.arc thread=1 sequence=167 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_168__05vmwt34_.arc thread=1 sequence=168 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_169__05y45qdd_.arc thread=1 sequence=169 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_170__060kgh33_.arc thread=1 sequence=170 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_171__0631tvgv_.arc thread=1 sequence=171 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_172__065d94fq_.arc thread=1 sequence=172 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_173__067wnwy8_.arc thread=1 sequence=173 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_174__06b9zdh8_.arc thread=1 sequence=174 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_05_30/o1_mf_1_175__08c7jc2b_.arc thread=1 sequence=175 media recovery complete, elapsed time: 00:48:34 Finished recover at 31-MAY-23
為了更快地恢復，請使用 recovery_parallelism 參數啟用並行會話或在資料庫恢復的恢復命令中指定並行度： RECOVER DATABASE PARALLEL (DEGREE d INSTANCES DEFAULT);。一般來說，並行度應該等於主機上的 CPU 核心數。 -
退出 RMAN，透過 sqlplus 以 oracle 使用者登入 Oracle，以在不完全恢復後開啟資料庫並重設日誌。
SQL> select name, open_mode from v$database; NAME OPEN_MODE --------- -------------------- DB1 MOUNTED SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- +DATA/DB1/ONLINELOG/group_3.264.1136666437 +DATA/DB1/ONLINELOG/group_2.263.1136666437 +DATA/DB1/ONLINELOG/group_1.262.1136666437 SQL> alter database rename file '+DATA/DB1/ONLINELOG/group_1.262.1136666437' to '/nfsfsxn/oracopy/redo01.log'; Database altered. SQL> alter database rename file '+DATA/DB1/ONLINELOG/group_2.263.1136666437' to '/nfsfsxn/oracopy/redo02.log'; Database altered. SQL> alter database rename file '+DATA/DB1/ONLINELOG/group_3.264.1136666437' to '/nfsfsxn/oracopy/redo03.log'; Database altered. SQL> alter database open resetlogs; Database altered.
-
驗證資料庫是否已還原到新主機，該主機具有我們在主資料庫故障之前插入的行。
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 READ WRITE NO 4 DB1_PDB2 READ WRITE NO 5 DB1_PDB3 READ WRITE NO SQL> alter session set container=db1_pdb1; Session altered. SQL> select * from test; ID DT EVENT ---------- --------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- 1 18-MAY-23 02.35.37.000000 PM test oracle incremental merge switch to copy 2 30-MAY-23 05.23.11.000000 PM test recovery on a new EC2 instance host with image copy on FSx ONTAP -
其他恢復後任務
Add FSx ONTAP NFS mount to fstab so that the NFS file system will be mounted when EC2 instance host rebooted. As EC2 user, vi /etc/fstab and add following entry: 172.30.15.19:/ora_01_copy /nfsfsxn nfs rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144,nointr 0 0 Update the Oracle init file from primary databse init file backup that is restored to /tmp/archive and create spfile as needed.
這完成了從 FSx ONTAP NFS 檔案系統上的備份映像副本到新的 EC2 DB 執行個體主機的 Oracle VLDB 資料庫復原。
複製 Oracle 備用映像副本以供其他用例使用
Details
使用 AWS FSx ONTAP暫存 Oracle VLDB 映像副本的另一個好處是，它可以透過 FlexCloned 實現許多其他用途，而只需最少的額外儲存投資。在以下用例中，我們示範如何為其他 Oracle 用例（例如 DEV、UAT 等）在 FSx ONTAP上快照和複製暫存 NFS 磁碟區。
-
我們首先將一行插入到我們之前建立的同一個測試表中。
SQL> insert into test values (3, sysdate, 'test clone on a new EC2 instance host with image copy on FSx ONTAP'); 1 row created. SQL> select * from test; ID ---------- DT --------------------------------------------------------------------------- EVENT -------------------------------------------------------------------------------- 1 18-MAY-23 02.35.37.000000 PM test oracle incremental merge switch to copy 2 30-MAY-23 05.23.11.000000 PM test recovery on a new EC2 instance host with image copy on FSx ONTAP ID ---------- DT --------------------------------------------------------------------------- EVENT -------------------------------------------------------------------------------- 3 05-JUN-23 03.19.46.000000 PM test clone on a new EC2 instance host with image copy on FSx ONTAP SQL> -
進行 RMAN 備份並合併至 FSx ONTAP資料庫映像副本，以便在 FSx NFS 安裝上的備份集中擷取事務，但在複製資料庫復原之前不會合併到副本中。
RMAN> @/home/oracle/rman_bkup_merge.cmd
-
以 fsxadmin 使用者身分透過 ssh 登入 FSx 集群，觀察由排程備份策略 - oracle 建立的快照，並拍攝一次性快照，以便它包含我們在步驟 1 中提交的交易。
FsxId06c3c8b2a7bd56458::> vol snapshot create -vserver svm_ora -volume ora_01_copy -snapshot one-off.2023-06-05-1137 -foreground true FsxId06c3c8b2a7bd56458::> snapshot show ---Blocks--- Vserver Volume Snapshot Size Total% Used% -------- -------- ------------------------------------- -------- ------ ----- svm_ora ora_01_copy daily.2023-06-02_0010 3.59GB 2% 5% daily.2023-06-03_0010 1.10GB 1% 1% daily.2023-06-04_0010 608KB 0% 0% daily.2023-06-05_0010 3.81GB 2% 5% one-off.2023-06-05-1137 168KB 0% 0% svm_ora_root weekly.2023-05-28_0015 1.86MB 0% 78% daily.2023-06-04_0010 152KB 0% 22% weekly.2023-06-04_0015 1.24MB 0% 70% daily.2023-06-05_0010 196KB 0% 27% hourly.2023-06-05_1005 156KB 0% 22% hourly.2023-06-05_1105 156KB 0% 22% hourly.2023-06-05_1205 156KB 0% 22% hourly.2023-06-05_1305 156KB 0% 22% hourly.2023-06-05_1405 1.87MB 0% 78% hourly.2023-06-05_1505 148KB 0% 22% 15 entries were displayed. -
從一次性快照克隆，用於在備用 EC2 Oracle 主機上建立新的 DB1 克隆執行個體。您可以選擇從磁碟區 ora_01_copy 的任何可用每日快照中進行複製。
FsxId06c3c8b2a7bd56458::> vol clone create -flexclone db1_20230605of -type RW -parent-vserver svm_ora -parent-volume ora_01_copy -junction-path /db1_20230605of -junction-active true -parent-snapshot one-off.2023-06-05-1137 [Job 464] Job succeeded: Successful FsxId06c3c8b2a7bd56458::> FsxId06c3c8b2a7bd56458::> vol show db1* Vserver Volume Aggregate State Type Size Available Used% --------- ------------ ------------ ---------- ---- ---------- ---------- ----- svm_ora db1_20230605of aggr1 online RW 200GB 116.6GB 38% FsxId06c3c8b2a7bd56458::> -
關閉克隆卷的快照策略，因為它繼承了父卷快照策略，除非您想保護克隆卷，否則不要管它。
FsxId06c3c8b2a7bd56458::> vol modify -volume db1_20230605of -snapshot-policy none Warning: You are changing the Snapshot policy on volume "db1_20230605of" to "none". Snapshot copies on this volume that do not match any of the prefixes of the new Snapshot policy will not be deleted. However, when the new Snapshot policy takes effect, depending on the new retention count, any existing Snapshot copies that continue to use the same prefixes might be deleted. See the 'volume modify' man page for more information. Do you want to continue? {y|n}: y Volume modify successful on volume db1_20230605of of Vserver svm_ora. FsxId06c3c8b2a7bd56458::> -
登入新的 EC2 Linux 執行個體，預先安裝了與主 Oracle EC2 執行個體相同版本和修補程式層級的 Oracle 軟體，並掛載複製的磁碟區。
[ec2-user@ip-172-30-15-124 ~]$ sudo mkdir /nfsfsxn [ec2-user@ip-172-30-15-124 ~]$ sudo mount -t nfs 172.30.15.19:/db1_20230605of /nfsfsxn -o rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144,nointr
-
驗證 FSx NFS 掛載上的資料庫增量備份集、映像副本和可用的存檔日誌。
[ec2-user@ip-172-30-15-124 ~]$ ls -ltr /nfsfsxn/oracopy total 79450332 -rw-r----- 1 oracle 54331 482353152 Jun 1 19:02 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_891tkrhr -rw-r----- 1 oracle 54331 419438592 Jun 1 19:03 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_8d1tkril -rw-r----- 1 oracle 54331 241180672 Jun 1 19:03 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_8g1tkrj7 -rw-r----- 1 oracle 54331 912506880 Jun 1 20:21 8n1tkvv2_279_1_1 -rw-r----- 1 oracle 54331 925696 Jun 1 20:21 8q1tl05i_282_1_1 -rw-r----- 1 oracle 54331 1169014784 Jun 1 20:21 8p1tkvv2_281_1_1 -rw-r----- 1 oracle 54331 6455296 Jun 1 20:21 8r1tl05m_283_1_1 -rw-r----- 1 oracle 54331 139264 Jun 1 20:21 8t1tl05t_285_1_1 -rw-r----- 1 oracle 54331 3514368 Jun 1 20:21 8s1tl05t_284_1_1 -rw-r----- 1 oracle 54331 139264 Jun 1 20:21 8u1tl060_286_1_1 -rw-r----- 1 oracle 54331 425984 Jun 1 20:21 901tl062_288_1_1 -rw-r----- 1 oracle 54331 344064 Jun 1 20:21 911tl062_289_1_1 -rw-r----- 1 oracle 54331 245760 Jun 1 20:21 931tl063_291_1_1 -rw-r----- 1 oracle 54331 237568 Jun 1 20:21 941tl064_292_1_1 -rw-r----- 1 oracle 54331 57344 Jun 1 20:21 961tl065_294_1_1 -rw-r----- 1 oracle 54331 57344 Jun 1 20:21 971tl066_295_1_1 -rw-r----- 1 oracle 54331 57344 Jun 1 20:21 981tl067_296_1_1 -rw-r----- 1 oracle 54331 1040760832 Jun 1 20:23 8m1tkvv2_278_1_1 -rw-r----- 1 oracle 54331 932847616 Jun 1 20:24 8o1tkvv2_280_1_1 -rw-r----- 1 oracle 54331 1121984512 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_821tkrb8 -rw-r----- 1 oracle 54331 1027612672 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_831tkrd9 -rw-r----- 1 oracle 54331 429924352 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_8a1tkrhr -rw-r----- 1 oracle 54331 707796992 Jun 5 15:21 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_851tkrgf -rw-r----- 1 oracle 54331 534781952 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_871tkrhr -rw-r----- 1 oracle 54331 534781952 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_881tkrhr -rw-r----- 1 oracle 54331 429924352 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_8b1tkril -rw-r----- 1 oracle 54331 429924352 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_8c1tkril -rw-r----- 1 oracle 54331 246423552 Jun 5 15:21 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_8e1tkril -rw-r----- 1 oracle 54331 246423552 Jun 5 15:21 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_8f1tkrj4 -rw-r----- 1 oracle 54331 5251072 Jun 5 15:21 data_D-DB1_I-1730530050_TS-USERS_FNO-7_8h1tkrj9 -rw-r----- 1 oracle 54331 5251072 Jun 5 15:21 data_D-DB1_I-1730530050_TS-USERS_FNO-16_8j1tkrja -rw-r----- 1 oracle 54331 5251072 Jun 5 15:21 data_D-DB1_I-1730530050_TS-USERS_FNO-20_8k1tkrjb -rw-r----- 1 oracle 54331 5251072 Jun 5 15:21 data_D-DB1_I-1730530050_TS-USERS_FNO-12_8i1tkrj9 -rw-r----- 1 oracle 54331 555753472 Jun 5 15:21 data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_861tkrgo -rw-r----- 1 oracle 54331 796925952 Jun 5 15:22 data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_841tkrf2 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-21_7j1tkqk6 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-34_801tkram -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-29_7r1tkr32 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-25_7n1tkqrh -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-31_7t1tkr3i -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-33_7v1tkra6 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-23_7l1tkqk6 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-27_7p1tkqrq -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-35_811tkrap -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-32_7u1tkr42 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-22_7k1tkqk6 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-24_7m1tkqk6 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-28_7q1tkqs1 -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-30_7s1tkr3a -rw-r----- 1 oracle 54331 4294975488 Jun 5 15:22 data_D-DB1_I-1730530050_TS-SOE_FNO-26_7o1tkqrj -rw-r----- 1 oracle 54331 1241432064 Jun 5 15:30 9d1tv06n_301_1_1 -rw-r----- 1 oracle 54331 1019805696 Jun 5 15:31 9a1tv06m_298_1_1 -rw-r----- 1 oracle 54331 4612096 Jun 5 15:31 9e1tv0ld_302_1_1 -rw-r----- 1 oracle 54331 967163904 Jun 5 15:31 9b1tv06n_299_1_1 -rw-r----- 1 oracle 54331 31563776 Jun 5 15:31 9g1tv0lt_304_1_1 -rw-r----- 1 oracle 54331 319488 Jun 5 15:31 9h1tv0lt_305_1_1 -rw-r----- 1 oracle 54331 335872 Jun 5 15:31 9i1tv0m0_306_1_1 -rw-r----- 1 oracle 54331 565248 Jun 5 15:31 9k1tv0m1_308_1_1 -rw-r----- 1 oracle 54331 581632 Jun 5 15:31 9l1tv0m5_309_1_1 -rw-r----- 1 oracle 54331 54345728 Jun 5 15:31 9f1tv0lt_303_1_1 -rw-r----- 1 oracle 54331 368640 Jun 5 15:31 9n1tv0m5_311_1_1 -rw-r----- 1 oracle 54331 385024 Jun 5 15:31 9o1tv0m6_312_1_1 -rw-r----- 1 oracle 54331 985858048 Jun 5 15:31 9c1tv06n_300_1_1 -rw-r----- 1 oracle 54331 57344 Jun 5 15:31 9q1tv0m7_314_1_1 -rw-r----- 1 oracle 54331 57344 Jun 5 15:31 9r1tv0m8_315_1_1 -rw-r----- 1 oracle 54331 57344 Jun 5 15:31 9s1tv0m9_316_1_1 -rw-r--r-- 1 oracle 54331 12720 Jun 5 15:31 db1_ctl.sql -rw-r----- 1 oracle 54331 11600384 Jun 5 15:48 bct_db1.ctf [ec2-user@ip-172-30-15-124 ~]$ [oracle@ip-172-30-15-124 ~]$ ls -l /nfsfsxn/archlog/DB1/archivelog/2023_06_05 total 2008864 -rw-r----- 1 oracle 54331 729088 Jun 5 14:38 o1_mf_1_190_l7vwvvt9_.arc -rw-r----- 1 oracle 54331 166651904 Jun 5 14:44 o1_mf_1_191_l7vx6vmg_.arc -rw-r----- 1 oracle 54331 167406080 Jun 5 14:47 o1_mf_1_192_l7vxctms_.arc -rw-r----- 1 oracle 54331 166868992 Jun 5 14:49 o1_mf_1_193_l7vxjjps_.arc -rw-r----- 1 oracle 54331 166087168 Jun 5 14:52 o1_mf_1_194_l7vxnxrh_.arc -rw-r----- 1 oracle 54331 175210496 Jun 5 14:54 o1_mf_1_195_l7vxswv5_.arc -rw-r----- 1 oracle 54331 167078400 Jun 5 14:57 o1_mf_1_196_l7vxylwp_.arc -rw-r----- 1 oracle 54331 169701888 Jun 5 14:59 o1_mf_1_197_l7vy3cyw_.arc -rw-r----- 1 oracle 54331 167845376 Jun 5 15:02 o1_mf_1_198_l7vy8245_.arc -rw-r----- 1 oracle 54331 170763776 Jun 5 15:05 o1_mf_1_199_l7vydv4c_.arc -rw-r----- 1 oracle 54331 193853440 Jun 5 15:07 o1_mf_1_200_l7vykf23_.arc -rw-r----- 1 oracle 54331 165523968 Jun 5 15:09 o1_mf_1_201_l7vyp1dh_.arc -rw-r----- 1 oracle 54331 161117184 Jun 5 15:12 o1_mf_1_202_l7vyvrm5_.arc -rw-r----- 1 oracle 54331 10098176 Jun 5 15:21 o1_mf_1_203_l7vzdfwm_.arc
-
現在的恢復過程類似於故障後恢復到新的 EC2 DB 實例的先前用例 - 設定 oracle 環境（oratab、$ORACLE_HOME、$ORACLE_SID）以匹配主生產實例，建立一個包含 db_recovery_file_dest_size 和 db_recovery_file_dest 的初始化檔，指向 FS NxFS 上的綜合目錄上的掛號。然後，啟動 RMAN 來運行恢復。以下是命令步驟和輸出。
[oracle@ip-172-30-15-124 dbs]$ rman target / nocatalog Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 7 14:44:33 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup nomount; Oracle instance started Total System Global Area 10737418000 bytes Fixed Size 9174800 bytes Variable Size 1577058304 bytes Database Buffers 9126805504 bytes Redo Buffers 24379392 bytes RMAN> set dbid = 1730530050; executing command: SET DBID RMAN> restore controlfile from autobackup; Starting restore at 07-JUN-23 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2 device type=DISK recovery area destination: /nfsfsxn/archlog/ database name (or database unique name) used for search: DB1 channel ORA_DISK_1: AUTOBACKUP /nfsfsxn/archlog/DB1/autobackup/2023_06_05/o1_mf_s_1138721482_l7vzybvq_.bkp found in the recovery area channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230607 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230606 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20230605 channel ORA_DISK_1: restoring control file from AUTOBACKUP /nfsfsxn/archlog/DB1/autobackup/2023_06_05/o1_mf_s_1138721482_l7vzybvq_.bkp channel ORA_DISK_1: control file restore from AUTOBACKUP complete output file name=/nfsfsxn/oracopy/db1.ctl Finished restore at 07-JUN-23 RMAN> alter database mount; released channel: ORA_DISK_1 Statement processed RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 DB1 1730530050 PARENT 1 17-APR-19 2 2 DB1 1730530050 CURRENT 1920977 12-MAY-23 RMAN> list copy of database tag 'OraCopyBKUPonFSxN_level_0'; List of Datafile Copies ======================= Key File S Completion Time Ckp SCN Ckp Time Sparse ------- ---- - --------------- ---------- --------------- ------ 362 1 A 05-JUN-23 8319160 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_821tkrb8 Tag: ORACOPYBKUPONFSXN_LEVEL_0 363 3 A 05-JUN-23 8319165 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_831tkrd9 Tag: ORACOPYBKUPONFSXN_LEVEL_0 365 4 A 05-JUN-23 8319171 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_851tkrgf Tag: ORACOPYBKUPONFSXN_LEVEL_0 355 5 A 01-JUN-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_8d1tkril Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 349 6 A 01-JUN-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_891tkrhr Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 372 7 A 05-JUN-23 8319201 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_8h1tkrj9 Tag: ORACOPYBKUPONFSXN_LEVEL_0 361 8 A 01-JUN-23 2383520 12-MAY-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_8g1tkrj7 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 2, PDB Name: PDB$SEED 364 9 A 05-JUN-23 8318717 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_8a1tkrhr Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 376 10 A 05-JUN-23 8318714 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_861tkrgo Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 377 11 A 05-JUN-23 8318720 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_841tkrf2 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 375 12 A 05-JUN-23 8318719 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_8i1tkrj9 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 368 13 A 05-JUN-23 8319184 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_8b1tkril Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 366 14 A 05-JUN-23 8319175 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_871tkrhr Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 370 15 A 05-JUN-23 8319193 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_8e1tkril Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 373 16 A 05-JUN-23 8319206 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_8j1tkrja Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 4, PDB Name: DB1_PDB2 369 17 A 05-JUN-23 8319188 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_8c1tkril Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 367 18 A 05-JUN-23 8319180 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_881tkrhr Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 371 19 A 05-JUN-23 8319197 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_8f1tkrj4 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 374 20 A 05-JUN-23 8319210 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_8k1tkrjb Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 5, PDB Name: DB1_PDB3 378 21 A 05-JUN-23 8318720 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_7j1tkqk6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 388 22 A 05-JUN-23 8318714 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_7k1tkqk6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 384 23 A 05-JUN-23 8318717 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_7l1tkqk6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 389 24 A 05-JUN-23 8318719 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_7m1tkqk6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 381 25 A 05-JUN-23 8318720 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_7n1tkqrh Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 392 26 A 05-JUN-23 8318714 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_7o1tkqrj Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 385 27 A 05-JUN-23 8318717 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_7p1tkqrq Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 390 28 A 05-JUN-23 8318719 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_7q1tkqs1 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 380 29 A 05-JUN-23 8318720 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_7r1tkr32 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 391 30 A 05-JUN-23 8318714 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_7s1tkr3a Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 382 31 A 05-JUN-23 8318717 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_7t1tkr3i Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 387 32 A 05-JUN-23 8318719 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_7u1tkr42 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 383 33 A 05-JUN-23 8318719 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_7v1tkra6 Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 379 34 A 05-JUN-23 8318717 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_801tkram Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 386 35 A 05-JUN-23 8318714 01-JUN-23 NO Name: /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_811tkrap Tag: ORACOPYBKUPONFSXN_LEVEL_0 Container ID: 3, PDB Name: DB1_PDB1 RMAN> switch database to copy; datafile 1 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_821tkrb8" datafile 3 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_831tkrd9" datafile 4 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_851tkrgf" datafile 5 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_8d1tkril" datafile 6 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_891tkrhr" datafile 7 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_8h1tkrj9" datafile 8 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_8g1tkrj7" datafile 9 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_8a1tkrhr" datafile 10 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_861tkrgo" datafile 11 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_841tkrf2" datafile 12 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_8i1tkrj9" datafile 13 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_8b1tkril" datafile 14 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_871tkrhr" datafile 15 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_8e1tkril" datafile 16 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_8j1tkrja" datafile 17 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_8c1tkril" datafile 18 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_881tkrhr" datafile 19 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_8f1tkrj4" datafile 20 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_8k1tkrjb" datafile 21 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_7j1tkqk6" datafile 22 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_7k1tkqk6" datafile 23 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_7l1tkqk6" datafile 24 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_7m1tkqk6" datafile 25 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_7n1tkqrh" datafile 26 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_7o1tkqrj" datafile 27 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_7p1tkqrq" datafile 28 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_7q1tkqs1" datafile 29 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_7r1tkr32" datafile 30 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_7s1tkr3a" datafile 31 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_7t1tkr3i" datafile 32 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_7u1tkr42" datafile 33 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_7v1tkra6" datafile 34 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_801tkram" datafile 35 switched to datafile copy "/nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_811tkrap" RMAN> run { 2> set until sequence 204; 3> recover database; 4> } executing command: SET until clause Starting recover at 07-JUN-23 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 190 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_190_l7vwvvt9_.arc archived log for thread 1 with sequence 191 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_191_l7vx6vmg_.arc archived log for thread 1 with sequence 192 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_192_l7vxctms_.arc archived log for thread 1 with sequence 193 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_193_l7vxjjps_.arc archived log for thread 1 with sequence 194 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_194_l7vxnxrh_.arc archived log for thread 1 with sequence 195 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_195_l7vxswv5_.arc archived log for thread 1 with sequence 196 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_196_l7vxylwp_.arc archived log for thread 1 with sequence 197 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_197_l7vy3cyw_.arc archived log for thread 1 with sequence 198 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_198_l7vy8245_.arc archived log for thread 1 with sequence 199 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_199_l7vydv4c_.arc archived log for thread 1 with sequence 200 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_200_l7vykf23_.arc archived log for thread 1 with sequence 201 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_201_l7vyp1dh_.arc archived log for thread 1 with sequence 202 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_202_l7vyvrm5_.arc archived log for thread 1 with sequence 203 is already on disk as file /nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_203_l7vzdfwm_.arc archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_190_l7vwvvt9_.arc thread=1 sequence=190 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_191_l7vx6vmg_.arc thread=1 sequence=191 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_192_l7vxctms_.arc thread=1 sequence=192 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_193_l7vxjjps_.arc thread=1 sequence=193 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_194_l7vxnxrh_.arc thread=1 sequence=194 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_195_l7vxswv5_.arc thread=1 sequence=195 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_196_l7vxylwp_.arc thread=1 sequence=196 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_197_l7vy3cyw_.arc thread=1 sequence=197 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_198_l7vy8245_.arc thread=1 sequence=198 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_199_l7vydv4c_.arc thread=1 sequence=199 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_200_l7vykf23_.arc thread=1 sequence=200 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_201_l7vyp1dh_.arc thread=1 sequence=201 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_202_l7vyvrm5_.arc thread=1 sequence=202 archived log file name=/nfsfsxn/archlog/DB1/archivelog/2023_06_05/o1_mf_1_203_l7vzdfwm_.arc thread=1 sequence=203 media recovery complete, elapsed time: 00:19:30 Finished recover at 07-JUN-23 RMAN> exit Recovery Manager complete. [oracle@ip-172-30-15-124 dbs]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 7 15:58:12 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0 SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- +DATA/DB1/ONLINELOG/group_3.264.1136666437 +DATA/DB1/ONLINELOG/group_2.263.1136666437 +DATA/DB1/ONLINELOG/group_1.262.1136666437 SQL> alter database rename file '+DATA/DB1/ONLINELOG/group_1.262.1136666437' to '/nfsfsxn/oracopy/redo01.log'; Database altered. SQL> alter database rename file '+DATA/DB1/ONLINELOG/group_2.263.1136666437' to '/nfsfsxn/oracopy/redo02.log'; Database altered. SQL> alter database rename file '+DATA/DB1/ONLINELOG/group_3.264.1136666437' to '/nfsfsxn/oracopy/redo03.log'; Database altered. SQL> alter database noarchivelog; Database altered. SQL> alter database open resetlogs; Database altered. SQL> set lin 200; SQL> select name from v$datafile 2 union 3 select name from v$controlfile 4 union 5 select name from v$tempfile 6 union 7 select member from v$logfile; NAME ---------------------------------------------------------------------------------------- /nfsfsxn/oracopy/DB1/FB864A929AEB79B9E053630F1EAC7046/datafile/o1_mf_temp_l81bhz6g_.tmp /nfsfsxn/oracopy/DB1/FB867DA8C68C816EE053630F1EAC2BCF/datafile/o1_mf_temp_l81bj16t_.tmp /nfsfsxn/oracopy/DB1/FB867EA89ECF81C0E053630F1EACB901/datafile/o1_mf_temp_l81bj135_.tmp /nfsfsxn/oracopy/DB1/FB867F8A4D4F821CE053630F1EAC69CC/datafile/o1_mf_temp_l81bj13g_.tmp /nfsfsxn/oracopy/DB1/datafile/o1_mf_temp_l81bhwjg_.tmp /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_7j1tkqk6 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_7k1tkqk6 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_7l1tkqk6 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_7m1tkqk6 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_7n1tkqrh /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_7o1tkqrj NAME ---------------------------------------------------------------------------------------- /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_7p1tkqrq /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_7q1tkqs1 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_7r1tkr32 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_7s1tkr3a /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_7t1tkr3i /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_7u1tkr42 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_7v1tkra6 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_801tkram /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_811tkrap /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_861tkrgo /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_871tkrhr NAME ---------------------------------------------------------------------------------------- /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_881tkrhr /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_831tkrd9 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_891tkrhr /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_8b1tkril /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_8c1tkril /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_821tkrb8 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_8d1tkril /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_8a1tkrhr /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_841tkrf2 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_8e1tkril /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_8f1tkrj4 NAME ----------------------------------------------------------------------------------------- /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_851tkrgf /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_8g1tkrj7 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_8i1tkrj9 /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_8j1tkrja /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_8k1tkrjb /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_8h1tkrj9 /nfsfsxn/oracopy/db1.ctl /nfsfsxn/oracopy/redo01.log /nfsfsxn/oracopy/redo02.log /nfsfsxn/oracopy/redo03.log 43 rows selected. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 READ WRITE NO 4 DB1_PDB2 READ WRITE NO 5 DB1_PDB3 READ WRITE NO SQL> alter session set container=db1_pdb1; Session altered. SQL> select * from test; ID DT EVENT ---------- --------------------------------------------------------------------------- ---------------------------------------------------------------- 1 18-MAY-23 02.35.37.000000 PM test oracle incremental merge switch to copy 2 30-MAY-23 05.23.11.000000 PM test recovery on a new EC2 instance host with image copy on FSx ONTAP 3 05-JUN-23 03.19.46.000000 PM test clone on a new EC2 instance host with image copy on FSx ONTAP SQL> -
使用 Oracle nid 公用程式重新命名複製的資料庫執行個體並變更資料庫 ID。資料庫執行個體狀態需要處於 `mount`執行命令。
SQL> select name, open_mode, log_mode from v$database; NAME OPEN_MODE LOG_MODE --------- -------------------- ------------ DB1 READ WRITE NOARCHIVELOG SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 1.0737E+10 bytes Fixed Size 9174800 bytes Variable Size 1577058304 bytes Database Buffers 9126805504 bytes Redo Buffers 24379392 bytes Database mounted. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0 [oracle@ip-172-30-15-124 dbs]$ nid target=/ dbname=db1tst DBNEWID: Release 19.0.0.0.0 - Production on Wed Jun 7 16:15:14 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to database DB1 (DBID=1730530050) Connected to server version 19.18.0 Control Files in database: /nfsfsxn/oracopy/db1.ctl Change database ID and database name DB1 to DB1TST? (Y/[N]) => Y Proceeding with operation Changing database ID from 1730530050 to 3054879890 Changing database name from DB1 to DB1TST Control File /nfsfsxn/oracopy/db1.ctl - modified Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-1_821tkrb - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-3_831tkrd - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-4_851tkrg - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-5_8d1tkri - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-6_891tkrh - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-7_8h1tkrj - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-8_8g1tkrj - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-9_8a1tkrh - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-10_861tkrg - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-11_841tkrf - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-12_8i1tkrj - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-13_8b1tkri - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-14_871tkrh - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-15_8e1tkri - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-16_8j1tkrj - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSTEM_FNO-17_8c1tkri - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SYSAUX_FNO-18_881tkrh - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-UNDOTBS1_FNO-19_8f1tkrj - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-USERS_FNO-20_8k1tkrj - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-21_7j1tkqk - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-22_7k1tkqk - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-23_7l1tkqk - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-24_7m1tkqk - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-25_7n1tkqr - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-26_7o1tkqr - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-27_7p1tkqr - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-28_7q1tkqs - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-29_7r1tkr3 - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-30_7s1tkr3 - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-31_7t1tkr3 - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-32_7u1tkr4 - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-33_7v1tkra - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-34_801tkra - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/data_D-DB1_I-1730530050_TS-SOE_FNO-35_811tkra - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/DB1/datafile/o1_mf_temp_l81bhwjg_.tm - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/DB1/FB864A929AEB79B9E053630F1EAC7046/datafile/o1_mf_temp_l81bhz6g_.tm - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/DB1/FB867DA8C68C816EE053630F1EAC2BCF/datafile/o1_mf_temp_l81bj16t_.tm - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/DB1/FB867EA89ECF81C0E053630F1EACB901/datafile/o1_mf_temp_l81bj135_.tm - dbid changed, wrote new name Datafile /nfsfsxn/oracopy/DB1/FB867F8A4D4F821CE053630F1EAC69CC/datafile/o1_mf_temp_l81bj13g_.tm - dbid changed, wrote new name Control File /nfsfsxn/oracopy/db1.ctl - dbid changed, wrote new name Instance shut down Database name changed to DB1TST. Modify parameter file and generate a new password file before restarting. Database ID for database DB1TST changed to 3054879890. All previous backups and archived redo logs for this database are unusable. Database is not aware of previous backups and archived logs in Recovery Area. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully. -
在 oratab、init 檔案中將 Oracle 資料庫環境配置變更為新的資料庫名稱或實例 ID，並建立與新執行個體 ID 相符的必要管理目錄。然後，使用 resetlogs 選項啟動實例。
SQL> startup mount; ORACLE instance started. Total System Global Area 1.0737E+10 bytes Fixed Size 9174800 bytes Variable Size 1577058304 bytes Database Buffers 9126805504 bytes Redo Buffers 24379392 bytes Database mounted. SQL> alter database open resetlogs; Database altered. SQL> select name, open_mode, log_mode from v$database; NAME OPEN_MODE LOG_MODE --------- -------------------- ------------ DB1TST READ WRITE NOARCHIVELOG SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 MOUNTED 4 DB1_PDB2 MOUNTED 5 DB1_PDB3 MOUNTED SQL> alter pluggable database all open; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DB1_PDB1 READ WRITE NO 4 DB1_PDB2 READ WRITE NO 5 DB1_PDB3 READ WRITE NO SQL>
這將完成從 FSx NFS 安裝上的暫存資料庫副本複製新的 Oracle 實例，以用於 DEV、UAT 或任何其他用例。可以從同一個暫存映像副本複製多個 Oracle 實例。
|
|
如果遇到錯誤 RMAN-06571: datafile 1 does not have recoverable copy`當切換資料庫進行複製時，檢查與主生產資料庫相符的資料庫化身。如果需要，請使用 RMAN 命令重置化身以與主化身匹配 `reset database to incarnation n;。
|
在哪裡可以找到更多信息
要了解有關本文檔中描述的信息的更多信息，請查看以下文檔和/或網站：
-
RMAN：合併增量備份策略（文件 ID 745798.1）
-
RMAN 備份與還原使用者指南
-
Amazon FSx ONTAP
-
亞馬遜 EC2