op-跨归档日志恢复
免费下载
实验时间：
20200825 14:30 - 17:30
实验时长：
3h
实验内容：
跨归档日志恢复
执行人员：
覃西贝
原始测试表 mx:
SQL> select * from mx;
ID NAME
---------- ----------
1 mx
2 xb
3 mxx
4 xbb
1.备份数据文件
$ rman target /
RMAN> backup datafile 10;
2.往测试表里插入数据 插入一条切一次归档
SQL> insert into mx values(5,'love');
SQL> commit;
SQL> alter system switch logfile;
System altered.
SQL> insert into mx values(6,'asd');
SQL> commit;
SQL> alter system switch logfile;
System altered.
SQL> insert into mx values(7,'west');
SQL> commit;
SQL> alter system switch logfile;
System altered.
SQL> insert into mx values(8,'winner');
SQL> commit;
SQL> alter system switch logfile;
System altered.
3.关闭数据库，删除测试表对应的数据文件
SQL> shutdown immediate;
$ cd /u01/app/oracle/oradata/testdb/
$ rm -rf testxbb.dbf
4.删除某条中间归档日志
$ cd /u01/app/oracle/arch
$ rm -rf 1_48_1033238042.dbf
5.开启数据库，转储-restore
$ rman target /
RMAN> startup
RMAN> restore datafile 10;
6.恢复-recover
SQL> recover datafile 10;
ORA-00279: change 1956218 generated at 08/19/2020 23:20:55 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/arch/1_47_1033238042.dbf
ORA-00280: change 1956218 for thread 1 is in sequence #47
#先用编号 47 的归档日志恢复
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1956493 generated at 08/19/2020 23:24:09 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/arch/1_48_1033238042.dbf
ORA-00280: change 1956493 for thread 1 is in sequence #48
#再到 48
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/u01/app/oracle/arch/1_48_1033238042.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
#此时报错，找不到相应的归档日志，想办法跳过
7.跳过编号 48 的归档日志，使用 bbed
#之前未安装 bbed，先安装
7.1.网上下载 oracle 11g 中缺的 bbed 包，并传到相应目录下
#文件与对应目录关系如下，可用 winscp 软件或者 rz 命令
$ ORACLE_HOME/rdbms/lib/ssbbded.o
$ ORACLE_HOME/rdbms/lib/sbbdpt.o
$ ORACLE_HOME/rdbms/mesg/bbedus.msb
7.2.编译 bbed
$ cd $ORACLE_HOME/rdbms/lib
$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed
$ORACLE_HOME/bin/bbed
7.3.添加配置文件 par.txt
$ cd /home/oracle
$ vi par.txt
blocksize=8192
listfile=filelist.txt
mode=edit
7.4.添加查看文件目录信息
$ sqlplus / as sysdba
SQL> select file#||chr(9)||name||chr(9)||bytes from v$datafile;
FILE#||CHR(9)||NAME||CHR(9)||BYTES
--------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/testdb/system01.dbf 786432000
2 /u01/app/oracle/oradata/testdb/sysaux01.dbf 660602880
3 /u01/app/oracle/oradata/testdb/undotbs01.dbf 89128960
4 /u01/app/oracle/oradata/testdb/users01.dbf 5242880
5 /u01/app/oracle/oradata/testdb/users02.dbf 1073741824
6 /u01/app/oracle/oradata/testdb/bak01.dbf 20971520
7 /u01/app/oracle/oradata/testdb/bak02.dbf 20971520
8 /u01/app/oracle/oradata/testdb/bak03.dbf 20971520
9 /u01/app/oracle/oradata/testdb/bak04.dbf 20971520
10 /u01/app/oracle/oradata/testdb/testxbb.dbf 10485760
of 4
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论