数据库级别跨resetlogs和incarnation恢复

最新推荐文章于 2024-06-16 00:24:06 发布
最新推荐文章于 2024-06-16 00:24:06 发布
阅读量950 收藏
点赞数
分类专栏： Oracle Advanced Knowledge Oracle RMAN Oracle Backup & Recovery
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zuixinnet/article/details/12226313
版权

1、创建测试表
SQL> conn scott/oracle
Connected.
SQL> create table binbin as select * from user_objects;

Table created.

SQL> select count(1) from binbin;

  COUNT(1)
----------
        16

SQL> alter system switch logfile;

System altered.

2、备份
RMAN>  backup database format='/opt/backup/dbfull_%U.bak';

Starting backup at 2013-10-01
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/oracle/oradata/ORCL/system01.dbf
input datafile fno=00003 name=/opt/oracle/oradata/ORCL/sysaux01.dbf
input datafile fno=00002 name=/opt/oracle/oradata/ORCL/undotbs01.dbf
input datafile fno=00004 name=/opt/oracle/oradata/ORCL/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2013-10-01
channel ORA_DISK_1: finished piece 1 at 2013-10-01
piece handle=/opt/backup/dbfull_0holbhgn_1_1.bak tag=TAG20131001T220055 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 2013-10-01
channel ORA_DISK_1: finished piece 1 at 2013-10-01
piece handle=/opt/backup/dbfull_0iolbhjn_1_1.bak tag=TAG20131001T220055 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:06
Finished backup at 2013-10-01
SQL>  alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

Session altered.

SQL>  select sysdate from dual;

SYSDATE
-------------------
2013-10-01 22:49:27


          select * from v$Log;
   GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARCHIV STATUS          FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ --------------- ------------- -------------------
         1          1          2   52428800          1 NO     CURRENT                772273 2013-10-01 22:46:31
         2          1          1   52428800          1 YES    INACTIVE               771785 2013-10-01 22:41:53
         3          1          0   52428800          1 YES    UNUSED                      0

 

3、truncate测试表
SQL> truncate table binbin;

Table truncated.

SQL> alter system switch logfile;

System altered.
SQL> select * from v$Log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARCHIV STATUS          FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ --------------- ------------- -------------------
         1          1          2   52428800          1 YES    ACTIVE                 772273 2013-10-01 22:46:31
         2          1          1   52428800          1 YES    INACTIVE               771785 2013-10-01 22:41:53
         3          1          3   52428800          1 NO     CURRENT                772410 2013-10-01 22:50:27

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2020224 bytes
Variable Size              96472192 bytes
Database Buffers          184549376 bytes
Redo Buffers                2170880 bytes
Database mounted.

4、第一恢复：
[oracle@localhost backup]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 1 22:52:22 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1344415282, not open)

RMAN> run {
 allocate channel a1 type disk;
sql 'alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"';
set until time '2013-10-01 22:49:27';
restore database;
recover database;
sql 'alter database open resetlogs';
release channel a1;
}2> 3> 4> 5> 6> 7> 8> 9>

using target database control file instead of recovery catalog
allocated channel: a1
channel a1: sid=154 devtype=DISK

sql statement: alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"

executing command: SET until clause

Starting restore at 2013-10-01

channel a1: starting datafile backupset restore
channel a1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/ORCL/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/ORCL/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/ORCL/sysaux01.dbf
restoring datafile 00004 to /opt/oracle/oradata/ORCL/users01.dbf
channel a1: reading from backup piece /opt/backup/dbfull_0kolbk72_1_1.bak
channel a1: restored backup piece 1
piece handle=/opt/backup/dbfull_0kolbk72_1_1.bak tag=TAG20131001T224658
channel a1: restore complete, elapsed time: 00:01:16
Finished restore at 2013-10-01

Starting recover at 2013-10-01

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 2013-10-01

sql statement: alter database open resetlogs


released channel: a1

 

5、查看sequence是否被重置

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

 select * from v$Log；

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARCHIV STATUS          FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ --------------- ------------- ----------
         1          1          2   52428800          1 YES    INACTIVE               772644 2013-10-01
         2          1          3   52428800          1 YES    INACTIVE               772646 2013-10-01
         3          1          4   52428800          1 NO     CURRENT                772650 2013-10-01

 

6、第二次恢复
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>  startup mount
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2020224 bytes
Variable Size             100666496 bytes
Database Buffers          180355072 bytes
Redo Buffers                2170880 bytes
Database mounted.
SQL>

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORCL     1344415282       PARENT  1          2005-10-22
2       2       ORCL     1344415282       PARENT  525876     2013-05-28
3       3       ORCL     1344415282       ORPHAN  693177     2013-09-12
4       4       ORCL     1344415282       PARENT  693177     2013-09-12
5       5       ORCL     1344415282       PARENT  693583     2013-09-12
6       6       ORCL     1344415282       PARENT  704038     2013-09-14
7       7       ORCL     1344415282       PARENT  728384     2013-09-15
8       8       ORCL     1344415282       PARENT  771785     2013-10-01
9       9       ORCL     1344415282       CURRENT 772367     2013-10-01

RMAN>
run {
 allocate channel a1 type disk;
sql 'alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"';
set until time '2013-10-01 22:49:27';
restore database;
recover database;
sql 'alter database open resetlogs';
release channel a1;
}
RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

allocated channel: a1
channel a1: sid=154 devtype=DISK

sql statement: alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"

executing command: SET until clause
released channel: a1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 10/01/2013 22:57:49
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

RMAN>
提示until time '2013-10-01 22:49:27'是resetlogs之前的时间。
7、修改 incarnation
RMAN> reset database to incarnation  8;

database reset to incarnation 8

RMAN>
run {
 allocate channel a1 type disk;
sql 'alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"';
set until time '2013-10-01 22:49:27';
restore database;
recover database;
sql 'alter database open resetlogs';
release channel a1;
}
RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

allocated channel: a1
channel a1: sid=154 devtype=DISK

sql statement: alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"

executing command: SET until clause

Starting restore at 2013-10-01

channel a1: starting datafile backupset restore
channel a1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/ORCL/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/ORCL/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/ORCL/sysaux01.dbf
restoring datafile 00004 to /opt/oracle/oradata/ORCL/users01.dbf
channel a1: reading from backup piece /opt/backup/dbfull_0kolbk72_1_1.bak
channel a1: restored backup piece 1
piece handle=/opt/backup/dbfull_0kolbk72_1_1.bak tag=TAG20131001T224658
channel a1: restore complete, elapsed time: 00:01:15
Finished restore at 2013-10-01

Starting recover at 2013-10-01

starting media recovery
media recovery failed
released channel: a1
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/01/2013 22:59:47
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until time '10ÔÂ 01 2013 22:49:27'
ORA-00283: recovery session canceled due to errors
ORA-38727: FLASHBACK DATABASE requires a current control file.
从这个报错可以看出打开了flashback

8、关闭flashback
RMAN> sql 'alter database flashback off';

sql statement: alter database flashback off
9、再次恢复
RMAN>
run {
 allocate channel a1 type disk;
sql 'alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"';
set until time '2013-10-01 22:49:27';
restore database;
recover database;
sql 'alter database open resetlogs';
release channel a1;
}
RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

allocated channel: a1
channel a1: sid=154 devtype=DISK

sql statement: alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"

executing command: SET until clause

Starting restore at 2013-10-01

skipping datafile 1; already restored to file /opt/oracle/oradata/ORCL/system01.dbf
skipping datafile 2; already restored to file /opt/oracle/oradata/ORCL/undotbs01.dbf
skipping datafile 3; already restored to file /opt/oracle/oradata/ORCL/sysaux01.dbf
skipping datafile 4; already restored to file /opt/oracle/oradata/ORCL/users01.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 2013-10-01

Starting recover at 2013-10-01

starting media recovery

archive log thread 1 sequence 2 is already on disk as file /u01/backup/1_2_827707313.dbf
archive log filename=/u01/backup/1_2_827707313.dbf thread=1 sequence=2
media recovery complete, elapsed time: 00:00:03
Finished recover at 2013-10-01

sql statement: alter database open resetlogs

released channel: a1

RMAN>
RMAN> list incarnation ;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORCL     1344415282       PARENT  1          2005-10-22
2       2       ORCL     1344415282       PARENT  525876     2013-05-28
3       3       ORCL     1344415282       ORPHAN  693177     2013-09-12
4       4       ORCL     1344415282       PARENT  693177     2013-09-12
5       5       ORCL     1344415282       PARENT  693583     2013-09-12
6       6       ORCL     1344415282       PARENT  704038     2013-09-14
7       7       ORCL     1344415282       PARENT  728384     2013-09-15
8       8       ORCL     1344415282       PARENT  771785     2013-10-01
9       9       ORCL     1344415282       ORPHAN  772367     2013-10-01
10      10      ORCL     1344415282       CURRENT 772367     2013-10-01


10、验证是否恢复成功
SQL> conn scott/oracle
Connected.
SQL> select count(1) from binbin;

  COUNT(1)
----------
        16

mydba_bin
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
incarnation oracle,对rman中的incarnation（化身）详解
weixin_34518190的博客
04-05 834
incarnation在英文中是“化身”的意思。那么在oracle中，它又是什么意思呢？有什么作用呢？我们看一些基本概念Current Incarnation(当前化身)：数据库当前正在使用的化身。Parent Incarnation(父化身)：数据库当前化身的上一个化身。在父化身以 OPEN RESETLOGS 打开后，就生成当前化身。Ancestor Incarnation(祖辈化身)：在父化...
oracle数据库归档日志丢失,丢失数据文件的恢复 归档和非归档日志模式下
weixin_42351189的博客
04-14 1210
在Oracle数据库中，构成SYSTEM表空间和当前活动的撤销表空间(由UNDO_TABLESPACE参数指定)的数据文件被认为是"关键的"。这类文件受损将导致实例立即终止。而且，在通过还原和恢复操作修复损坏之前，数据库无法再次打开。构成用户数据表空间的其他文件受损通常不会导致实例崩溃。Oracle将使受损的文件脱机，使其内容不可访问，但数据库的其余部分仍保持打开。您的应用程序对此的反应将取决于其...
深入理解incarnation (resetlogs)
csdn7007的博客
03-27 266
深入理解incarnation 10g引入了一个很重要的功能，就是可以跨越resetlogs进行数据恢复。这就需要我们比较深入的了解一个概念，incarnation。 我们通过下面的几个实验，来说明什么是incarnatio...
关于alter database open resetlogs及incarnation的一点理解
05-18 2998
<br /><br />关于alter database open resetlogs及incarnation的一点理解<br /><br />不完全恢复只能做一次吗？<br /><br />采用rman的默认设置，对数据库进行了backup database备份，进行了一些操作后，然后直接关闭启动到mount状态<br />RMAN> run{<br />2> set until time "to_date('2010-10-16 23:14:42','yyyy-mm-dd hh24:mi:ss')";<
有关resetlogs和incarnation关系的理解
cqis22460的博客
08-05 208
一、实验环境： Sqldeveloper+linux in virtual machine； [oracle@lzc ~]$ lsb_release -a LSB Version: :core-3.1-ia32:...
incarnation的理解
冰刀(skate)
02-26 3946
author：skatetime：2010/02/26 incarnation的理解 incarnation英文的翻印的“化身”，那在oracle里如何理解它呢？我理解为“数据库实体”（一个数据库场景）数据库自从创建起就连续的发展，但经过不完全恢复后，数据库要重新设置起点，然后继续来连续的发展，而数据库的连续性是通过SCN来保证的，在不完全恢复后，数据库的控制文件，保证重做日志
＜经典＞ set newname 切换数据库文件位置 incarnation切换恢复
最新发布
jnrjian的博客
06-16 948
-----------------------手动apply log也是一样的---------------------------------------------------------恢复到原有位置了，但是是从datafile copy过来的，不是从backup 来的。------------------------上面方法会有有什么好处，可以自己控制恢复那个archivedlog。--------------------------一个都不恢复除了大问题-----------
管理RMAN备份_管理恢复目录（Recovery Catalog）
jetliu05的博客
12-07 1483
管理RMAN备份_管理恢复目录（recovery catalog）
Oracle数据库恢复教程之resetlogs操作
09-09
Oracle数据库恢复教程中的resetlogs操作是一项关键且潜在风险较高的功能，通常用于不完全恢复或数据库点时间恢复。在这些场景中，数据库可能因为用户错误、系统故障等原因需要回滚到某个特定时间点，但无法使用...
RAC数据库恢复到单实例数据库
01-21
RAC数据库恢复到单实例数据库的基本步骤如下： 　a.准备单实例服务器，pfile文件，启动到nomount 　b.备份rac数据库 　c.将备份文件拷贝到单实例服务器 　d.在单实例服务器上还原、恢复 　e.resetlogs打开...
Open resetlogs操作对Oracle数据库恢复的影响.pdf
10-10
Open resetlogs操作对Oracle数据库恢复的影响.pdf
ORACLE_数据库备份和恢复
07-20
总的来说，Oracle数据库的备份和恢复是一个复杂而重要的过程，需要深入了解数据库的内部工作原理，熟悉相关工具和命令，以及制定合理的备份策略，以确保在面临灾难性事件时，能够迅速、有效地恢复数据，保障业务的...
INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid clust
zuixinnet的专栏
06-04 4270
INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster   CAUSE: Prior to installing Oracle RAC, you must create a valid cluster. This is done by deplo
or改写为union all性能提升n倍
zuixinnet的专栏
08-13 2211
SQL> explain plan for SELECT SUM(OCCOUNT) as EVENTCOUNT , F_4 FROM binbin1 WHERE binbin1.EUIDCODE like '19739-19740-704013-%' or binbin1.EUIDCODE like '19739-19740-704018-%' or binbin1.EUIDCODE like '
两节点时间不同步导致CRS-0184
zuixinnet的专栏
08-17 1932
节点二： [oracle@rac2 ~]$ crs_stat -t CRS-0184: Cannot communicate with the CRS daemon 节点一： [root@rac1 ~]# crs_stat -t Name           Type           Target    State     Host ------------------------
ORA-00603 和ORA-00600: internal error code, arguments: [kdsgrp1]解决过程
zuixinnet的专栏
11-07 1917
1、查看alert log 报错如下： Thu Nov  7 17:21:27 2013 Errors in file /eas2/oracle/oraeas/udump/oraeas_ora_12596.trc: ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [] Thu Nov
分页语句特殊搞法－内联改join
zuixinnet的专栏
08-15 1579
SQL>   select * from (select rows_.*, rownum rn from ( select piresult.* from (select null IMPLEMENT_RESULT_ID, baseinfo.implement_id,   2    baseinfo.cycle_id, baseinfo.emp_class_id, baseinfo.org_
帮朋友处理ora-00600 [2662]和ora-00600 [4194]错误
zuixinnet的专栏
08-13 1475
recover database using backup controlfile  until cancel         *._allow_resetlogs_corruption=true *._allow_error_simulation=true 加入两个隐含参数再启动 SQL> alter database open resetlogs; alt
Oracle数据库备份与恢复测试实战
"Oracle数据库的备份与恢复测试文档，包含多种场景下的测试案例和恢复方法，旨在详细讲解如何处理不同情况下的数据保护和故障恢复。文档通过目录结构组织，方便直接定位到特定的测试或恢复策略。" 在Oracle数据库...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值