首页 > 数据库 > Oracle > rman 恢复参数文件、控制文件
首先做数据库全备
关闭数据库
然后删除参数文件和控制文件。
数据库状况:丢失参数文件,控制文件。数据库关闭状态,但是有归档、备份。
恢复开始:
首先手动创建一个参数文件
vi pfileorcldb1.ora
db_name=orcl
把数据库启动到nomount状态。
RMAN> restore spfile to '/u01/oracle/spfileorcldb1.ora' from '/u01/oracle/flash_recovery_area/ORCLDB1/backupset/2011_08_11/o1_mf_ncsnf_TAG20110811T160530_7473dh61_.bkp';
Starting restore at 11-AUG-2011 16:35:53
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /u01/oracle/flash_recovery_area/ORCLDB1/backupset/2011_08_11/o1_mf_ncsnf_TAG20110811T160530_7473dh61_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 11-AUG-2011 16:35:55
RMAN>
SQL> shutdown abort
ORACLE instance shut down.
SQL>
把参数文件放在缺省位置。
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 159383552 bytes
Fixed Size 1218268 bytes
Variable Size 79694116 bytes
Database Buffers 75497472 bytes
Redo Buffers 2973696 bytes
SQL>
RMAN> restore controlfile from '/u01/oracle/flash_recovery_area/ORCLDB1/backupset/2011_08_11/o1_mf_ncsnf_TAG20110811T160530_7473dh61_.bkp';
Starting restore at 11-AUG-2011 16:42:20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/u01/oracle/oradata/orcldb1/control01.ctl
output filename=/u01/oracle/oradata/orcldb1/control02.ctl
output filename=/u01/oracle/oradata/orcldb1/control03.ctl
Finished restore at 11-AUG-2011 16:42:25
RMAN>
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN>
RMAN> recover database;
Starting recover at 11-AUG-2011 16:47:04
Starting implicit crosscheck backup at 11-AUG-2011 16:47:04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 11-AUG-2011 16:47:05
Starting implicit crosscheck copy at 11-AUG-2011 16:47:05
using channel ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck copy at 11-AUG-2011 16:47:06
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/oracle/flash_recovery_area/ORCLDB1/backupset/2011_08_11/o1_mf_ncsnf_TAG20110811T160530_7473dh61_.bkp
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 19 is already on disk as file /u01/oracle/oradata/orcldb1/redo01.log
archive log thread 1 sequence 20 is already on disk as file /u01/oracle/oradata/orcldb1/redo02.log
archive log filename=/u01/oracle/oradata/orcldb1/redo01.log thread=1 sequence=19
archive log filename=/u01/oracle/oradata/orcldb1/redo02.log thread=1 sequence=20
media recovery complete, elapsed time: 00:00:01
Finished recover at 11-AUG-2011 16:47:09
RMAN>
RMAN> recover database;
Starting recover at 11-AUG-2011 16:47:04
Starting implicit crosscheck backup at 11-AUG-2011 16:47:04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 11-AUG-2011 16:47:05
Starting implicit crosscheck copy at 11-AUG-2011 16:47:05
using channel ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck copy at 11-AUG-2011 16:47:06
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/oracle/flash_recovery_area/ORCLDB1/backupset/2011_08_11/o1_mf_ncsnf_TAG20110811T160530_7473dh61_.bkp
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 19 is already on disk as file /u01/oracle/oradata/orcldb1/redo01.log
archive log thread 1 sequence 20 is already on disk as file /u01/oracle/oradata/orcldb1/redo02.log
archive log filename=/u01/oracle/oradata/orcldb1/redo01.log thread=1 sequence=19
archive log filename=/u01/oracle/oradata/orcldb1/redo02.log thread=1 sequence=20
media recovery complete, elapsed time: 00:00:01
Finished recover at 11-AUG-2011 16:47:09
RMAN>
数据库恢复完毕。
转自 http://blog.itpub.net/25517773/viewspace-730297/来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30036720/viewspace-2106801/ ,如需转载,请注明出处,否则将追究法律责任。