rman恢复所有数据，控制，参数文件，下

最新推荐文章于 2024-12-13 08:14:48 发布

make_zhf

最新推荐文章于 2024-12-13 08:14:48 发布

阅读量2.6k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/make_zhf/article/details/69053353

通过RMAN使用备份文件'/oracle.bacup/SHPOG1_25_20170403.bak'进行数据库恢复操作，包括数据文件和控制文件。执行'alter database open'以完成恢复并启动媒体恢复。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一
rman恢复所有数据，控制，参数文件，下
自动恢复spfile文件，自动恢复不了，使用之前备份的文件进行恢复
[oracle@oracle1 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 3 01:41:44 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: SHPOG1 (not mounted)

RMAN> restore spfile from autobackup;
Starting restore at 03-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=135 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 01:43:45
RMAN-06495: must explicitly specify DBID with SET DBID command

RMAN> exit
[oracle@oracle1 trace]$ ll
total 161592
-rw-r----- 1 oracle oinstall 111946 Apr 3 01:21 alert_shpog1.log
[oracle@oracle1 trace]$
[oracle@oracle1 trace]$ vi shpog1_ora_15444.trc
Compatibility Vsn = 186646528=0xb200000
Db ID=799280029=0x2fa40b9d, Db Name='SHPOG1'
Activation ID=799229341=0x2fa3459d
Control Seq=1934=0x78e, File size=102400=0x19000
File Number=5, Blksiz=512, File Type=2 LOG

（1）设置dbid
[oracle@oracle1 trace]$ rman target /

connected to target database: SHPOG1 (not mounted)

RMAN> set dbid=799280029;

executing command: SET DBID
（2）强制启动
RMAN> startup nomount force;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/product/11.2/db/dbs/initshpog1.ora'

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area 158662656 bytes
Fixed Size 2211448 bytes
Variable Size 92275080 bytes
Database Buffers 58720256 bytes
Redo Buffers 5455872 bytes
（3）先用自动恢复spfile参数文件，如果恢复不了，再用之前备份的进行恢复
RMAN> restore spfile from autobackup;

Starting restore at 03-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170403
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170402
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170401
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170331
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170330
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170329
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170328
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 01:53:16
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
（4）用之前备份的进行恢复
RMAN> restore spfile from '/oracle.bacup/control/cf_c-799280029-20170403-02';

Starting restore at 03-APR-17
using channel ORA_DISK_1

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /oracle.bacup/control/cf_c-799280029-20170403-02
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 03-APR-17

RMAN> exit
（5）spfile文件已经恢复
[oracle@oracle1 dbs]$ ll
total 2271764
-rw-r----- 1 oracle oinstall 1153318912 Mar 18 04:11 01rvdlk4_1_1
-rw-r----- 1 oracle oinstall 1153351680 Mar 18 04:14 02rvdlum_1_1
-rw-r----- 1 oracle oinstall 9830400 Mar 18 04:14 03rvdm22_1_1
drwxr-xr-x 2 oracle oinstall 4096 Apr 2 23:12 arch
-rw-rw---- 1 oracle oinstall 1544 Mar 18 03:01 hc_DBUA0.dat
-rw-rw---- 1 oracle oinstall 1544 Apr 3 01:52 hc_shpog1.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall 24 Mar 18 03:11 lkSHPOG1
-rw-r----- 1 oracle oinstall 1536 Mar 18 03:19 orapwshpog1
-rw-r----- 1 oracle oinstall 9748480 Apr 3 00:34 snapcf_shpog1.f
-rw-r----- 1 oracle oinstall 2560 Apr 3 01:56 spfileshpog1.ora
（6）关闭数据库，再开启报错少控制文件
[oracle@oracle1 dbs]$ sqlplus / as sysdba
SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1586708480 bytes
Fixed Size 2213736 bytes
Variable Size 1191184536 bytes
Database Buffers 385875968 bytes
Redo Buffers