Oracle中如何使用BBED跳过丢失的归档

在recover datafile的过程当中如果丢失了需要的归档将使得recover无法进行，使用bbed工具可以跳过丢失的归档进行recover datafile。

实验过程如下：

SYS@ORCL>select * from v$version;

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE    10.2.0.1.0      Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

SYS@ORCL>create tablespace bbed_test_tbs

 2  datafile '/u01/app/oracle/oradata/ORCL/bbed_test_tbs01.dbf' size 20M;

Tablespace created.

SYS@ORCL>create table bbed_test1 tablespace bbed_test_tbs as select * from dba_objects;

Table created.

SYS@ORCL>create table bbed_test2 tablespace bbed_test_tbs as select * from dba_objects;

Table created.

SYS@ORCL>archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     2

Next log sequence to archive   4

Current log sequence           4

SYS@ORCL>select file#||' '||name||' '||bytes from v$datafile;

FILE#||''||NAME||''||BYTES

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

1 /u01/app/oracle/oradata/ORCL/system01.dbf 503316480

2 /u01/app/oracle/oradata/ORCL/undotbs01.dbf 36700160

3 /u01/app/oracle/oradata/ORCL/sysaux01.dbf 262144000

4 /u01/app/oracle/oradata/ORCL/users01.dbf 5242880

5 /u01/app/oracle/oradata/ORCL/example01.dbf 104857600

6 /u01/app/oracle/oradata/ORCL/bbed_test_tbs01.dbf 20971520

6 rows selected.

使用rman备份datafile 6

[oracle@jp bbed]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 19 21:33:16 2014

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

connected to target database: ORCL (DBID=1356549586)

RMAN> backup datafile 6;

Starting backup at 19-JUN-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=143 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00006 name=/u01/app/oracle/oradata/ORCL/bbed_test_tbs01.dbf

channel ORA_DISK_1: starting piece 1 at 19-JUN-14

channel ORA_DISK_1: finished piece 1 at 19-JUN-14

piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_06_19/o1_mf_nnndf_TAG20140619T213426_9t73x2s8_.bkp tag=TAG20140619T213426 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 19-JUN-14

然后在库里修改datafile 6中存储的数据

SYS@ORCL>delete from bbed_test1;

50316 rows deleted.

SYS@ORCL>commit;

Commit complete.

SYS@ORCL>alter system switch logfile;

System altered.

SYS@ORCL>alter system switch logfile;

System altered.

SYS@ORCL>alter system switch logfile;

System altered.

然后关闭数据库删除datafile 6

SYS@ORCL>shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@jp ORCL]$ ls

bbed_test_tbs01.dbf  control03.ctl  redo02.log    system01.dbf   users01.dbf

control01.ctl        example01.dbf  redo03.log    temp01.dbf

control02.ctl        redo01.log     sysaux01.dbf  undotbs01.dbf

[oracle@jp ORCL]$ mv bbed_test_tbs01.dbf bbed_test_tbs01.dbf.bak

时间： 2024-03-05 06:00:58

Oracle中如何使用BBED跳过丢失的归档的相关文章

Oracle中如何使用bbed手动提交事务

有时候数据库挂掉,起库会出现ORA-00704错误,而导致ORA-00704错误的根本原因是访问OBJ$的时候,ORACLE需要回滚段中的数据,而访问回滚段的时候需要的undo数据已经被覆盖,此时我们可以通过bbed工具手工提交事务,从而解决这个问题. 使用bbed提交事务测试过程如下: JP@ORCL>create table JP_BBED_TEST as select * from hr.employees where rownum<=10; Table created. JP@ORCL

Oracle中如何使用bbed恢复delete的数据

表中的数据被delete之后并不会真正删除数据,而是打了一个删除标记,只要还没有被覆盖就可以恢复回来. 实验过程如下: SYS@ORCL>create table bbed_test(x varchar2(20)); Table created. SYS@ORCL>insert into bbed_test values('BADLY9'); 1 row created. SYS@ORCL>insert into bbed_test values('JP'); 1 row created

[20150529]使用bbed解决丢失的归档.txt

[20150529]使用bbed解决丢失的归档.txt -- 以前跟别人探讨过这个问题,我个人的观点通过bbed等手段来跳过丢失的归档来恢复存在许多问题. -- 我以前个人的主张是通过别的手段抽取数据文件的数据,结合logminer来重新整合数据.但是如果抽取的logminer很多,会非常麻烦. --实际上无论那种方式,都存在许多问题,这里通过例子来说明bbed如何解决跳过丢失的归档. 1.测试环境建立: SCOTT@test> @ &r/ver1 PORT_STRING          

asp-ASP中session页面跳转丢失

问题描述 ASP中session页面跳转丢失 通过登录页面 Session["UserName"] = TextBox2.Text; Session["Pwd"]=TextBox1.Text; Response.Redirect("main.aspx"); 在主页面 string name = Session["UserName"].ToString(); Label1.Text = "欢迎你" + nam

Oracle中通过bbed模拟和修复corrupted block

使用bbed需要注意: 1.win下oracle不提供 2.随oracle软件一起发布 3.在unix/linux下使用时需要事先relink 4.oracle最初使用bbed用来修复坏block,从9i开始可以通过rman的blockrecover来恢复,不过前提是事先做过备份 [oracle@xys oracle]$ bbed Password: BBED: Release 2.0.0.0.0 - Limited Production on Tue Jun 9 13:13:04 2009 C

oracle中bbed恢复与找回删除数据

恢复己删除数据 一.创建模拟环境  代码如下 复制代码 SQL> create table hr.xifenfei (id number,name varchar2(20)) tablespace xff; Table created. SQL> insert into hr.xifenfei values(1,'xifenfei'); 1 row created. SQL> insert into hr.xifenfei values(2,'xff'); 1 row created.

oracle中如何设置自增主键

 首先,你要有一张表! CREATE TABLE example( ID Number(4) NOT NULL PRIMARY KEY, NAME VARCHAR(25), PHONE VARCHAR(10), ADDRESS VARCHAR(50)); 如果对于以上的建表语句还有疑问的话,建议您不要继续了!有那么些时间您还不如去看看金庸读读琼瑶! 然后,你需要一个自定义的sequence CREATE SEQUENCE emp_sequence INCREMENT BY 1 -- 每次加几个

oracle中系统回滚段坏块恢复记录

数据库启动报错  代码如下 复制代码 SQL> startup mount pfile='c:＼pfile.txt' ORACLE 例程已经启动.    代码如下 复制代码 Total System Global Area  452984832 bytes Fixed Size                  1291120 bytes Variable Size             201329808 bytes Database Buffers          243269632 b

ORACLE中字符串比较

oracle|比较|字符串  在ORACLE中,将空字符串视为NULL,任何值与NULL比较结果都为NULL.如此一来,在比较两个字符串的时候就会出现意外.请看以下的例子:DECLARE     i VARCHAR2(10) := NULL;    v VARCHAR2(10) := 'ABC';BEGIN    IF(i = v) THEN        DBMS_OUTPUT.PUT_LINE('相等');    ELSE        DBMS_OUTPUT.PUT_LINE('不等');