TR-4973:在 AWS FSx ONTAP上使用增量合并快速恢复和克隆 Oracle VLDB
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 增量合并到正在 AWS FSx ONTAP存储的 NFS 挂载中暂存的 Oracle VLDB 映像副本的分步部署过程。
部署先决条件
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/oracopy
mkdir /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 的初始化文件,指向 FSx NFS 挂载上的闪存恢复目录。然后,启动 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
-
Amazon EC2