oracle备份之rman_恢复控制文件
来源:互联网 发布:数据库隔离的四个级别 编辑:程序博客网 时间:2024/05/29 16:57
测试环境:redhat 5.5 oracle 11g
RMAN> backup database;
Starting backup at 21-DEC-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00008 name=/opt/oracle/oradata/ORCL2/users03.dbf
input datafile file number=00001 name=/opt/oracle/oradata/ORCL/system01.dbf
input datafile file number=00002 name=/opt/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00004 name=/opt/oracle/oradata/ORCL/users01.dbf
input datafile file number=00005 name=/opt/oracle/oradata/ORCL/data161123.dbf
input datafile file number=00011 name=/opt/oracle/oradata/ORCL2/undotbs03.dbf
channel ORA_DISK_1: starting piece 1 at 21-DEC-17
channel ORA_DISK_1: finished piece 1 at 21-DEC-17
piece handle=/opt/oracle/oradata/ORCL2/1csmlsoe_1_1_ORCL tag=TAG20171221T101230 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/opt/oracle/oradata/ORCL2/users02.dbf
input datafile file number=00006 name=/opt/oracle/oradata/ORCL2/km0711.dbf
input datafile file number=00007 name=/opt/oracle/oradata/ORCL2/km0628.dbf
channel ORA_DISK_1: starting piece 1 at 21-DEC-17
channel ORA_DISK_1: finished piece 1 at 21-DEC-17
piece handle=/opt/oracle/oradata/ORCL2/1dsmlsoq_1_1_ORCL tag=TAG20171221T101230 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-DEC-17
Starting Control File and SPFILE Autobackup at 21-DEC-17
piece handle=/opt/oracle/flash_recovery_area/ORCL/autobackup/2017_12_21/o1_mf_s_963310363_f3p64ww2_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-17
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
此时,故意把:/opt/oracle/oradata/ORCL/control01.ctl 改成 control01.ctl_1221
RMAN> startup;
connected to target database (not started)
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 12/21/2017 10:16:09
ORA-00205: error in identifying control file, check alert log for more info
RMAN> startup nomount;
database is already started
RMAN> RESTORE CONTROLFILE FROM '/opt/oracle/flash_recovery_area/ORCL/autobackup/2017_12_21/o1_mf_s_963310363_f3p64ww2_.bkp';
Starting restore at 21-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/oracle/oradata/ORCL/control01.ctl
output file name=/opt/oracle/flash_recovery_area/ORCL/control02.ctl
Finished restore at 21-DEC-17
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> recover database;
Starting recover at 21-DEC-17
Starting implicit crosscheck backup at 21-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
Crosschecked 18 objects
Finished implicit crosscheck backup at 21-DEC-17
Starting implicit crosscheck copy at 21-DEC-17
using channel ORA_DISK_1
Crosschecked 4 objects
Finished implicit crosscheck copy at 21-DEC-17
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /opt/oracle/flash_recovery_area/ORCL/autobackup/2017_12_21/o1_mf_s_963310363_f3p64ww2_.bkp
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 8793 is already on disk as file /opt/oracle/oradata/ORCL/redo02.log
archived log file name=/opt/oracle/oradata/ORCL/redo02.log thread=1 sequence=8793
media recovery complete, elapsed time: 00:00:00
Finished recover at 21-DEC-17
RMAN> ALTER DATABASE OPEN;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/21/2017 10:20:28
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> ALTER DATABASE OPEN RESETLOGS;
database opened
- oracle备份之rman_恢复控制文件
- oracle备份之rman_恢复数据文件
- oracle备份之rman_全库备份恢复
- 探索ORACLE不完全恢复之--基于备份控制文件恢复
- ORACLE控制文件备份恢复 noresetlogs 恢复
- Oracle DB备份恢复篇之丢失控制文件
- Oracle DB备份恢复篇之丢失控制文件
- Oracle控制文件备份恢复 resetlogs方式
- oracle冷备份恢复重建控制文件
- oracle-控制文件备份和恢复
- oracle控制文件备份和日志文件备份和恢复
- oracle 日志文件、参数文件、控制文件备份恢复
- Oracle 基于备份控制文件的恢复(unsing backup controlfile)
- oracle数据恢复案例 - 控制文件损坏,无备份
- oracle 从备份的控制文件进行完全恢复
- Oracle 基于备份控制文件的恢复(unsing backup controlfile)
- Oracle控制文件的备份、恢复以及多路复用
- 控制文件恢复与备份
- Opengl 导入3Dmax制作的.3ds模型 并显示出来
- bean
- Android实现RecyclerView的下拉刷新和上拉加载更多
- vue-template 命令使用说明
- 淺談IT與風投的關係
- oracle备份之rman_恢复控制文件
- Java中多线程
- Eclipse中在项目右键菜单点击->Maven->Update Projects时,JDK总是切回 1.5
- python中递归的两个小案例
- maven常见错误
- SQLAlchemy添加分页-paginate
- pat甲级1006-Sign In and Sign Out
- 项目分层 facade service
- 记录:研究生,怎么学,学什么