Oracle11g备份恢复
我叫素小胖
这个作者很懒,什么都没留下…
展开
-
oracle11g数据文件和日志文件损坏恢复
1、重建数据文件RMAN> restore database;SQL> select checkpoint_change# from v$datafile_header;CHECKPOINT_CHANGE# 925071 925070 925070 925071 925070SQL> select checkpoint_change# from v$datafile;CHECKPOINT_CHANGE# 926020 92原创 2020-05-13 14:09:16 · 323 阅读 · 0 评论 -
oracle11g控制文件和日志文件损坏恢复
1、恢复控制文件RMAN> restore controlfile from '/home/oracle/bak/ctl_PROD4_20190417_116_1';RMAN> alter database mount;SQL> select checkpoint_change# from v$datafile_header;CHECKPOINT_CHANGE#------------------ 922731 922731 922731...原创 2020-05-13 14:01:47 · 928 阅读 · 0 评论 -
oracle11g 控制文件和数据文件损坏恢复
1、恢复控制文件RMAN> restore controlfile from '/home/oracle/bak/data/ctl_0hv00323_1_1';Starting restore at 12-MAY-20using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=10 device type=DISKch原创 2020-05-12 14:08:37 · 698 阅读 · 0 评论 -
oracle11g日志文件损坏恢复
1、开启数据库到mount状态startupSQL> select checkpoint_change# from v$datafile_header;CHECKPOINT_CHANGE#------------------ 919031 919031 919031 919031 919031SQL> select checkpoint_change# from v$datafile;CHECKPO...原创 2020-05-12 11:37:07 · 599 阅读 · 1 评论 -
Oracle11g所有文件损坏恢复
SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/PROD4/PROD4/system01.dbf/u01/app/oracle/oradata/PROD4/PROD4/sysaux01.dbf/u01/app/oracle/oradata/PROD4/PROD原创 2020-05-09 16:58:00 · 291 阅读 · 0 评论