1.恢复控制文件
方式一:使用rman恢复指定控制文件
[oracle@cmxbak/oracle/rmanback]$ rman target /
Recovery Manager: Release11.2.0.4.0- Production on Sun Dec116:19:542024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: CMXDB (not mounted)
RMAN> restore controlfile from'/oracle/rmanback/control_01.dbf';
Starting restore at2024-12-0116:20:03using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=572 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/cmxdb/control01.ctl
output file name=/oracle/dbsoft/fast_recovery_area/cmxdb/control02.ctl
Finished restore at2024-12-0116:20:04
方式二:查看参数文件中控制文件的位置,将控制文件cp到指定的位置
此种方法需要手动生成的控制文件,并非备份的控制文件
[oracle@cmxbak/oracle/rmanback]$ cat init31.ora |grep control_files
*.control_files='/oradata/cmxdb/control01.ctl','/oracle/dbsoft/fast_recovery_area/cmxdb/control02.ctl'
[oracle@cmxbak/oracle/rmanback]$ cp /oracle/rmanback/control01.ctl /oradata/cmxdb/control01.ctl
[oracle@cmxbak/oracle/rmanback]$ cp /oracle/rmanback/control01.ctl /oracle/dbsoft/fast_recovery_area/cmxdb/control02.ctl
[oracle@cmxbak/oracle/rmanback]$ ll /oradata/cmxdb/control01.ctl
-rw-r----- 1 oracle oinstall 9895936 Dec 5 17:00 /oradata/cmxdb/control01.ctl
[oracle@cmxbak/oracle/rmanback]$ ll /oracle/dbsoft/fast_recovery_area/cmxdb/control02.ctl
-rw-r----- 1 oracle oinstall 9895936 Dec 5 17:00 /oracle/dbsoft/fast_recovery_area/cmxdb/control02.ctl2.启动到mount状态
RMAN>alter database mount;
database mounted
released channel: ORA_DISK_1
3.数据库中查看数据库的状态
SQL>select OPEN_MODE,database_role from v$database;
OPEN_MODE DATABASE_ROLE
-------------------- ----------------
MOUNTED PRIMARY
5.3 检查备份和备份片
RMAN> LIST BACKUP OF DATABASE;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ -------------------3Full1.11G DISK 00:00:022024-11-2717:00:21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20241127T170019
Piece Name: /ora_bak/db_0a3b6np3_1_1
List of Datafiles in backup set3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----1Full11488082024-11-2717:00:19/oradata/cmxdb/system01.dbf
2Full11488082024-11-2717:00:19/oradata/cmxdb/sysaux01.dbf
3Full11488082024-11-2717:00:19/oradata/cmxdb/undotbs01.dbf
4Full11488082024-11-2717:00:19/oradata/cmxdb/users01.dbf
5Full11488082024-11-2717:00:19/oradata/cmxdb/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ -------------------7Full1.11G DISK 00:00:022024-11-2717:03:37
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20241127T170335
Piece Name: /ora_bak/db_0f3b6nv7_1_1
List of Datafiles in backup set7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----1Full11490472024-11-2717:03:35/oradata/cmxdb/system01.dbf
2Full11490472024-11-2717:03:35/oradata/cmxdb/sysaux01.dbf
3Full11490472024-11-2717:03:35/oradata/cmxdb/undotbs01.dbf
4Full11490472024-11-2717:03:35/oradata/cmxdb/users01.dbf
5Full11490472024-11-2717:03:35/oradata/cmxdb/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ -------------------9Full1.11G DISK 00:00:012024-11-2717:04:42
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20241127T170441
Piece Name: /ora_bak/db_0i3b6o19_1_1
List of Datafiles in backup set9
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----1Full11491362024-11-2717:04:41/oradata/cmxdb/system01.dbf
2Full11491362024-11-2717:04:41/oradata/cmxdb/sysaux01.dbf
3Full11491362024-11-2717:04:41/oradata/cmxdb/undotbs01.dbf
4Full11491362024-11-2717:04:41/oradata/cmxdb/users01.dbf
5Full11491362024-11-2717:04:41/oradata/cmxdb/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ -------------------12Full1.15G DISK 00:00:272024-12-0115:40:18
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20241201T153951
Piece Name: /oracle/rmanback/data_0l3bjou7_1_1.dbf
List of Datafiles in backup set12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----1Full13910302024-12-0115:39:51/oradata/cmxdb/system01.dbf
2Full13910302024-12-0115:39:51/oradata/cmxdb/sysaux01.dbf
3Full13910302024-12-0115:39:51/oradata/cmxdb/undotbs01.dbf
4Full13910302024-12-0115:39:51/oradata/cmxdb/users01.dbf
5Full13910302024-12-0115:39:51/oradata/cmxdb/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ -------------------14Full1.15G DISK 00:00:022024-12-0115:42:20
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20241201T154218
Piece Name: /oracle/rmanback/data_0n3bjp2q_1_1.dbf
List of Datafiles in backup set14
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----1Full13911952024-12-0115:42:18/oradata/cmxdb/system01.dbf
2Full13911952024-12-0115:42:18/oradata/cmxdb/sysaux01.dbf
3Full13911952024-12-0115:42:18/oradata/cmxdb/undotbs01.dbf
4Full13911952024-12-0115:42:18/oradata/cmxdb/users01.dbf
5Full13911952024-12-0115:42:18/oradata/cmxdb/example01.dbf
RMAN>
查看备份片是否存在
[oracle@cmxbak~]$ ll /oracle/rmanback/data_0l3bjou7_1_1.dbf
-rw-r----- 1 oracle oinstall 1229717504 Dec 1 16:00 /oracle/rmanback/data_0l3bjou7_1_1.dbf
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤