文档章节

使用_allow_resetlogs_corruption打开无归档日志rman备份库

我就叫你女王吧
 我就叫你女王吧
发布于 2016/06/02 15:21
字数 1100
阅读 26
收藏 0

使用_allow_resetlogs_corruption打开无归档日志rman备份库

 rman还原恢复操作

--还原数据库

RMAN> restore database;

--恢复数据库

RMAN> recover database;

 

Starting recover at 2012-03-08 21:20:45

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=65 device type=DISK

 

starting media recovery

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/08/2012 21:20:47

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 1 with sequence 2936 and starting SCN of 25991695 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 2935 and starting SCN of 25991652 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 2934 and starting SCN of 25991649 found to restore

……………………

RMAN-06025: no backup of archived log for thread 1 with sequence 2902 and starting SCN of 25991156 found to restore

这里报日志缺少,实际上是备份的数据库文件后,没有备份归档日志,归档日志全部丢失

进行不完全恢复

SQL> recover database until cancel;

ORA-00279: change 25991194 generated at 03/08/2012 20:33:58 needed for thread 1

ORA-00289: suggestion : /opt/oracle/oradata/archivelog/chf/1_2902_752334071.dbf

ORA-00280: change 25991194 for thread 1 is in sequence #2902

 

 

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/opt/oracle/oradata/chf/system01.dbf'

 

 

ORA-01112: media recovery not started

 

 

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/opt/oracle/oradata/chf/system01.dbf'

查看相关SCN

SQL> select file#,to_char(checkpoint_change#,'999999999999') from v$datafile;

 

     FILE# TO_CHAR(CHECK

---------- -------------

         1      25992214

         2      25992214

         3      25992214

         4      25992214

         5      25992214

         6      25992214

         7      25992214

         8      25992214

         9      25992214

        10      25992214

        11      25992214

 

     FILE# TO_CHAR(CHECK

---------- -------------

        13      25992214

        14      25992214

 

13 rows selected.

 

SQL> select file#,online_status,to_char(change#,'999999999999') from v$recover_file;

 

     FILE# ONLINE_ TO_CHAR(CHANG

---------- ------- -------------

         1 ONLINE       25991194

         2 ONLINE       25991194

         3 ONLINE       25991194

         4 ONLINE       25991194

         5 ONLINE       25991194

         6 ONLINE       25991194

         7 ONLINE       25991194

         8 ONLINE       25991194

         9 ONLINE       25991194

        10 ONLINE       25991194

        11 ONLINE       25991194

 

     FILE# ONLINE_ TO_CHAR(CHANG

---------- ------- -------------

        13 ONLINE       25991194

        14 ONLINE       25991194

 

13 rows selected.

 

SQL> select file#,to_char(checkpoint_change#,'999999999999') from v$datafile_header;

 

     FILE# TO_CHAR(CHECK

---------- -------------

         1      25991194

         2      25991194

         3      25991194

         4      25991194

         5      25991194

         6      25991194

         7      25991194

         8      25991194

         9      25991194

        10      25991194

        11      25991194

 

     FILE# TO_CHAR(CHECK

---------- -------------

        13      25991194

        14      25991194

 

13 rows selected.

 

--发现数据文件scn和控制文件不一致,重建控制文件,然后查询相关scn

SQL> select file#,to_char(checkpoint_change#,'999999999999') from v$datafile;

 

     FILE# TO_CHAR(CHECK

---------- -------------

         1      25991194

         2      25991194

         3      25991194

         4      25991194

         5      25991194

         6      25991194

         7      25991194

         8      25991194

         9      25991194

        10      25991194

        11      25991194

 

     FILE# TO_CHAR(CHECK

---------- -------------

        13      25991194

        14      25991194

 

13 rows selected.

 

SQL> select file#,online_status,to_char(change#,'999999999999') from v$recover_file;

 

     FILE# ONLINE_ TO_CHAR(CHANG

---------- ------- -------------

         1 ONLINE       25991194

         2 ONLINE       25991194

         3 ONLINE       25991194

         4 ONLINE       25991194

         5 ONLINE       25991194

         6 ONLINE       25991194

         7 ONLINE       25991194

         8 ONLINE       25991194

         9 ONLINE       25991194

        10 ONLINE       25991194

        11 ONLINE       25991194

 

     FILE# ONLINE_ TO_CHAR(CHANG

---------- ------- -------------

        13 ONLINE       25991194

        14 ONLINE       25991194

 

13 rows selected.

 

SQL> select file#,to_char(checkpoint_change#,'999999999999') from v$datafile_header;

 

     FILE# TO_CHAR(CHECK

---------- -------------

         1      25991194

         2      25991194

         3      25991194

         4      25991194

         5      25991194

         6      25991194

         7      25991194

         8      25991194

         9      25991194

        10      25991194

        11      25991194

 

     FILE# TO_CHAR(CHECK

---------- -------------

        13      25991194

        14      25991194

 

13 rows selected.

--此时所有scn均一致

尝试打开数据库

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/opt/oracle/oradata/chf/system01.dbf'

 

 

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 25991194 generated at 03/08/2012 20:33:58 needed for thread 1

ORA-00289: suggestion : /opt/oracle/oradata/archivelog/chf/1_2902_752334071.dbf

ORA-00280: change 25991194 for thread 1 is in sequence #2902

 

 

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/opt/oracle/oradata/chf/system01.dbf'

 

 

ORA-01112: media recovery not started

 

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/opt/oracle/oradata/chf/system01.dbf'

使用隐含参数打开数据库

SQL> create pfile='/tmp/pfile' from spfile;

 

File created.

 

-------/tmp/pfile中加上----------

_allow_resetlogs_corruption= TRUE

---------------------------------

 

SQL> startup mount pfile='/tmp/pfile' force

ORACLE instance started.

 

Total System Global Area  622149632 bytes

Fixed Size                  2230912 bytes

Variable Size             419431808 bytes

Database Buffers          192937984 bytes

Redo Buffers                7548928 bytes

Database mounted.

SQL> alter database open resetlogs;

 

Database altered.

 

SQL> select open_mode from v$database;

 

OPEN_MODE

--------------------

READ WRITE

总结
这次的试验没有多少实际意义,但是可以说明几个问题:
1.所有的数据文件的scn都一致,甚至和控制文件的也一致,数据库不一定可以open成功
(怀疑是数据文件中的scn大于data header scn)
2.对于这样的问题,如果使用bbed修改所有数据文件header的scn不知道是否可以解决
3.如果rman只备份了数据文件而没有任何一个归档日志,数据库通过隐含参数还是可以open,抢救数据

© 著作权归作者所有

我就叫你女王吧
粉丝 3
博文 34
码字总数 25430
作品 0
海淀
私信 提问
oracle 备份恢复 07rman不完全恢复

不完全恢复:将数据库恢复到过去的某个时间点或者SCN点 一、实验环境 1.开归档 2.实验操作 create table scott.lxtb3 tablespace lxtb as select * from scott.emp; insert into scott.lxtb3...

PeakFang-BOK
2018/10/14
0
0
使用RMAN恢复全库、表空间、数据文件的方法总结

废话一句,恢复的前提是要有备份;所以说备份很重要。 对数据库进行完全介质恢复 1、启动数据库到加载状态 RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP MOUNT; 2、执行恢复操作 RMAN> RESTORE ...

长平狐
2013/09/17
188
0
oracle 备份恢复 06ramn完全恢复

一、搭建实验环境 1.创建8张表scott.lxtb1-lxtb8 create table scott.lxtb9 tablespace lxtb as select * from scott.emp; 2.3DML操作 insert into scott.lxtb9 select * from scott.emp; c......

PeakFang-BOK
2018/10/14
0
0
Oracle学习系列之RMAN异地恢复数据

一:通过RMAN备份恢复数据库到其他服务器 设定环境: 源库:10.0.17.220 SID:zsddb 获取SID的方式: (1)通过查看/data/ora11g/product/11.2.0/db_1/dbs/spfilezsddb.ora,因为spfile[sid].ora...

SANSOM
2014/02/11
0
0
Oracle学习系列之RMAN异地恢复数据

一:通过RMAN备份恢复数据库到其他服务器 设定环境: 源库:10.0.17.220 SID:zsddb 获取SID的方式: (1)通过查看/data/ora11g/product/11.2.0/db_1/dbs/spfilezsddb.ora,因为spfile[sid].ora...

SANSOM
2014/01/22
0
0

没有更多内容

加载失败,请刷新页面

加载更多

好程序员web前端分享逻辑运算

  一门计算机语言,编程的核心在于逻辑思想,当我们在编写程序的时候,逻辑是否通顺,是能否正确写出程序的关键,可以说如果你掌握了逻辑,那么你就踏入了计算机编程的大门。 &&与 || 或 ...

好程序员IT
20分钟前
1
0
我的Linux系统开始学习的过程

我的Linux系统开始学习的过程 Linux系统,不知大家是否了解。接触计算机不多或对计算机不感冒的人可能对其比较陌生,曾经的我也是。上大学前的我的确对Linux一无所知,那时候接触面窄,都没有...

linuxCool
20分钟前
1
0
让自己的网站可以被搜索

第一步:先注册一个属于自己的域名,这个域名是独一无二的。推荐到主机屋注册一个,其实在哪里注册都是一样的,但是主机屋提供免费的地址解析服务(只对在主机屋注册的域名免费)。 主机屋官...

WinkJie
23分钟前
2
0
全站加速(DCDN)- IP应用加速产品解读

5月22日下午15点,阿里云全站加速(DCDN)-IP应用加速如期发布。IP应用加速是阿里云自主研发的一款更高效、更安全、更便捷的动态加速产品,结合阿里云CDN本身的资源优势,利用就近接入、智能...

阿里云官方博客
26分钟前
1
0
k8s常用命令

1.创建deployment资源kubectl apply -f nginx.yml2.删除deployment资源kubectl delete -f nginx.yml3.查看deployment资源基本信息deployment资源(运行的服务资源)kubectl get...

平头哥-Enjoystudy
26分钟前
1
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部