[20170315]ORA-19656错误.txt

[20170315]ORA-19656错误.txt

--//上午删除测试数据库的归档日志,遇到ORA-19656,做一个记录.

1.环境:
SYS@book> @ &r/ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

RMAN> delete   archivelog all;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=12 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================
Key     Thrd Seq     S Low Time
------- ---- ------- - -------------------
1205    1    680     A 2017-02-23 08:31:29
        Name: /u01/app/oracle/archivelog/book/1_680_896605872.dbf

1206    1    681     A 2017-02-23 16:55:47
        Name: /u01/app/oracle/archivelog/book/1_681_896605872.dbf
....       

1441    1    808     A 2017-03-15 09:56:40
        Name: /u01/app/oracle/archivelog/book/1_808_896605872.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 03/15/2017 10:17:46
ORA-19656: cannot backup, copy, or delete online log /u01/app/oracle/archivelog/book/1_694_896605872.dbf

$ oerr ora 19656
19656, 00000, "cannot backup, copy, or delete online log %s"
// *Cause:  The indicated log file is an active log.  You can only backup,
//          copy, or delete archived logs.
// *Action: The indicated log file cannot be processed - select another file.

--//很明显/u01/app/oracle/archivelog/book/1_694_896605872.dbf是在线日志.因为当时我前面做测试删除归档日志,没有办法只能拿
--//冷备份的在线日志代替.

--//这样rman做删除操作时无法删除这个文件,导致以上操作根本没有执行.

2.很明显oracle知道这个文件是在线日志文件.看看根据前面学的知识修改它.
--//参考链接:http://blog.itpub.net/267265/viewspace-2135094/
--//备份
$ cp 1_694_896605872.dbf 1_694_896605872.dbf_XXX

SYS@book> alter system dump logfile '/u01/app/oracle/archivelog/book/1_694_896605872.dbf' validate;
System altered.

DUMP OF REDO FROM FILE '/u01/app/oracle/archivelog/book/1_694_896605872.dbf'
Opcodes *.*
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
VALIDATE ONLY
FILE HEADER:
    Compatibility Vsn = 186647552=0xb200400
    Db ID=1337401710=0x4fb7216e, Db Name='BOOK'
    Activation ID=1337448558=0x4fb7d86e
    Control Seq=36119=0x8d17, File size=102400=0x19000
    File Number=3, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000000694, SCN 0x0003175d9396-0x0003175d9565"
thread: 1 nab: 0x120 seq: 0x000002b6 hws: 0x3 eot: 0 dis: 0
resetlogs count: 0x35711eb0 scn: 0x0000.000e2006 (925702)
prev resetlogs count: 0x3121c97a scn: 0x0000.00000001 (1)
Low  scn: 0x0003.175d9396 (13276910486) 02/28/2017 14:40:06
Next scn: 0x0003.175d9565 (13276910949) 02/28/2017 14:40:12
Enabled scn: 0x0000.000e2006 (925702) 11/24/2015 09:11:12
Thread closed scn: 0x0003.175d9396 (13276910486) 02/28/2017 14:40:06
Disk cksum: 0x198d Calc cksum: 0x198d
Terminal recovery stop scn: 0x0000.00000000
Terminal recovery  01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 12 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x800000
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000
Zero blocks: 8
Format ID is 2
redo log key is 542736ff7fbed565a1b9fef4c3d95a
redo log key flag is 5
Enabled redo threads: 1
END OF REDO DUMP

--//我估计仅仅修改下划线位置就ok了.
$ bvi80 -s 512 -b 512 1_694_896605872.dbf
00000200  01 22 00 00 01 00 00 00 B6 02 00 00 00 80 8D 19 ................
00000210  00 00 00 00 00 04 20 0B 6E 21 B7 4F 42 4F 4F 4B ...... .n!.OBOOK
00000220  00 00 00 00 17 8D 00 00 00 90 01 00 00 02 00 00 ................
00000230  03 00 02 00 6E D8 B7 4F 00 00 00 00 00 00 00 00 ....n..O........
00000240  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000250  00 00 00 00 00 00 00 00 00 00 00 00 54 68 72 65 ............Thre
00000260  61 64 20 30 30 30 31 2C 20 53 65 71 23 20 30 30 ad 0001, Seq# 00
00000270  30 30 30 30 30 36 39 34 2C 20 53 43 4E 20 30 78 00000694, SCN 0x
00000280  30 30 30 33 31 37 35 64 39 33 39 36 2D 30 78 30 0003175d9396-0x0
00000290  30 30 33 31 37 35 64 39 35 36 35 00 20 01 00 00 003175d9565. ...
000002A0  B0 1E 71 35 06 20 0E 00 00 00 00 00 03 00 00 00 ..q5. ..........
000002B0  01 00 00 00 96 93 5D 17 03 00 00 00 46 BB DB 37 ......].....F..7
000002C0  65 95 5D 17 03 00 00 00 4C BB DB 37 00 00 08 02 e.].....L..7....
000002D0  06 20 0E 00 00 00 00 00 B0 1E 71 35 96 93 5D 17 . ........q5..].
000002E0  03 00 00 00 46 BB DB 37 00 00 00 00 00 00 80 00 ....F..7........
                                              ~~~~~~~~~~~
000002F0  00 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 ................
00000300  00 00 00 00 00 00 00 00 00 00 00 00 0C 00 00 00 ................
00000310  00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 ................
00000320  00 00 00 00 7A C9 21 31 00 00 00 00 00 00 00 00 ....z.!1........
00000330  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000340  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000350  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000360  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000370  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000380  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000390  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003A0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003B0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003C0  54 02 73 6F F7 FB 0E D5 65 A1 B9 FE F4 C3 D9 5A T.so....e......Z
000003D0  27 F7 6C 1F 74 8A 40 20 48 9C 47 0B 46 31 76 E0 '.l.t.@ H.G.F1v.
000003E0  05 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003F0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000400
--//修改0x2EB处 0x00008000 => 0x11008000

$ xor.sh /tmp/aaa.txt
1100
0000
8D19
xor result: 9C19

--//修改检查和偏移0x14-15处 0x9c19

SYS@book> alter system dump logfile '/u01/app/oracle/archivelog/book/1_694_896605872.dbf' validate;
System altered.

--//检查转储:
Miscellaneous flags: 0x800011

--再次执行rman:

RMAN> delete   archivelog all;
...

$ ls -l /u01/app/oracle/archivelog/book/1_694_896605872.dbf*
-rw-r----- 1 oracle oinstall 52429312 2017-03-15 10:22:57 /u01/app/oracle/archivelog/book/1_694_896605872.dbf_XXX

--ok,可以发现现在删除了归档文件1_694_896605872.dbf.也就是知道通过这个Miscellaneous flags标识那个文件是现在日志还是归档.

3.反向证明:
--//从冷备库恢复,测试机器有点乱,重来
$ ls -l /u01/app/oracle/archivelog/book/1_697_896605872.dbf
-rw-r----- 1 oracle oinstall 1139200 2017-03-15 11:02:58 /u01/app/oracle/archivelog/book/1_697_896605872.dbf
--//文件大小不足50M.

$ xor.sh /tmp/aaa.txt
1100
8F8D
xor result: 9E8D

--//以下是修改后的情况:
$ bvi80 -s 512 -b 512 1_697_896605872.dbf
00000200  01 22 00 00 01 00 00 00 B9 02 00 00 00 80 9E 8D ................
                                                    ~~~~~
00000210  00 00 00 00 00 04 20 0B 6E 21 B7 4F 42 4F 4F 4B ...... .n!.OBOOK
00000220  00 00 00 00 39 8D 00 00 00 90 01 00 00 02 00 00 ....9...........
00000230  03 00 02 00 6E D8 B7 4F 00 00 00 00 00 00 00 00 ....n..O........
00000240  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000250  00 00 00 00 00 00 00 00 00 00 00 00 54 68 72 65 ............Thre
00000260  61 64 20 30 30 30 31 2C 20 53 65 71 23 20 30 30 ad 0001, Seq# 00
00000270  30 30 30 30 30 36 39 37 2C 20 53 43 4E 20 30 78 00000697, SCN 0x
00000280  30 30 30 33 31 37 35 64 65 39 36 31 2D 30 78 30 0003175de961-0x0
00000290  30 30 33 31 37 35 64 65 61 33 32 00 B1 08 00 00 003175dea32.....
000002A0  B0 1E 71 35 06 20 0E 00 00 00 00 00 02 00 00 00 ..q5. ..........
000002B0  01 00 00 00 61 E9 5D 17 03 00 00 00 6B 42 F3 37 ....a.].....kB.7
000002C0  32 EA 5D 17 03 00 00 00 92 42 F3 37 00 00 08 02 2.]......B.7....
000002D0  06 20 0E 00 00 00 00 00 B0 1E 71 35 61 E9 5D 17 . ........q5a.].
000002E0  03 00 00 00 6B 42 F3 37 00 00 00 00 00 00 80 00 ....kB.7........
                                              ~~~~~~~~~~~
000002F0  00 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 ................
00000300  00 00 00 00 00 00 00 00 00 00 00 00 FD 01 00 00 ................
00000310  00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 ................
00000320  00 00 00 00 7A C9 21 31 00 00 00 00 00 00 00 00 ....z.!1........
00000330  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000340  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000350  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000360  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000370  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000380  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000390  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003A0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003B0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003C0  B1 12 8F FC F6 9C F4 8F B7 29 84 ED E9 A0 3B 51 .........)....;Q
000003D0  27 F7 6C 1F 74 8A 40 20 48 9C 47 0B 46 31 76 E0 '.l.t.@ H.G.F1v.
000003E0  05 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000003F0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000400

SYS@book> alter system dump logfile '/u01/app/oracle/archivelog/book/1_697_896605872.dbf' validate;
System altered.

DUMP OF REDO FROM FILE '/u01/app/oracle/archivelog/book/1_697_896605872.dbf'
Opcodes *.*
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
VALIDATE ONLY
FILE HEADER:
    Compatibility Vsn = 186647552=0xb200400
    Db ID=1337401710=0x4fb7216e, Db Name='BOOK'
    Activation ID=1337448558=0x4fb7d86e
    Control Seq=36153=0x8d39, File size=102400=0x19000
    File Number=3, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000000697, SCN 0x0003175de961-0x0003175dea32"
thread: 1 nab: 0x8b1 seq: 0x000002b9 hws: 0x2 eot: 0 dis: 0
resetlogs count: 0x35711eb0 scn: 0x0000.000e2006 (925702)
prev resetlogs count: 0x3121c97a scn: 0x0000.00000001 (1)
Low  scn: 0x0003.175de961 (13276932449) 03/15/2017 10:58:51
Next scn: 0x0003.175dea32 (13276932658) 03/15/2017 10:59:30
Enabled scn: 0x0000.000e2006 (925702) 11/24/2015 09:11:12
Thread closed scn: 0x0003.175de961 (13276932449) 03/15/2017 10:58:51
Disk cksum: 0x8d9e Calc cksum: 0x8d9e
Terminal recovery stop scn: 0x0000.00000000
Terminal recovery  01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 509 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x800000
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000
Zero blocks: 8
Format ID is 2
redo log key is b1128ffcf69cf48fb72984ede9a03b51
redo log key flag is 5
Enabled redo threads: 1
END OF REDO DUMP

RMAN> delete archivelog sequence 697 ;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=12 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - -------------------
1237    1    697     A 2017-03-15 10:58:51
        Name: /u01/app/oracle/archivelog/book/1_697_896605872.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 03/15/2017 11:08:00
ORA-19656: cannot backup, copy, or delete online log /u01/app/oracle/archivelog/book/1_697_896605872.dbf

--//再次验证了自己的判断.加入force参数可以从控制文件中剔除.但是实际的文件还存在.

RMAN> delete force archivelog sequence 697 ;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=12 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - -------------------
1237    1    697     A 2017-03-15 10:58:51
        Name: /u01/app/oracle/archivelog/book/1_697_896605872.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/app/oracle/archivelog/book/1_697_896605872.dbf RECID=1237 STAMP=938689172
Deleted 1 objects

RMAN> list archivelog  sequence 696;
specification does not match any archived log in the repository

$ ls -l /u01/app/oracle/archivelog/book/1_697_896605872.dbf
-rw-r----- 1 oracle oinstall 1139200 2017-03-15 11:02:58 /u01/app/oracle/archivelog/book/1_697_896605872.dbf

--//可以发现文件还存在,oracle可能出于安全的考虑,实际上并没有删除这个文件.毕竟它认为这个文件是在线日志文件^_^.

时间： 2024-08-21 14:40:32

[20170315]ORA-19656错误.txt的相关文章

[20160203]ora-04031错误.txt

[20160203]ora-04031错误.txt --生产系统10g的数据库,修改为手工内存管理后出现ora-04031错误,自己手工模拟看看: 1.环境: SYS@test> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------

[20160910]低级错误.txt

[20160910]低级错误.txt --记录一个低级错误,要在表ms_yyhy中增加一个字段fyxh,并且要与同步ms_ysks.fyxh相关记录保持一直. --我同事在测试环境下,执行如下: UPDATE ms_yyhy    SET fyxh =           (SELECT fyxh              FROM ms_ysks             WHERE     ms_yyhy.ysdm = ms_ysks.ysdm                   AND ms

[20140429]ORA-01665 错误.txt

[20140429]ORA-01665 错误.txt $ oerr ora 1665 01665, 00000, "control file is not a standby control file" // *Cause:  Attempting to mount, recover or activate a standby database //          without a standby control file. // *Action: Create a standb

[20120929]ora-55605错误.txt

[20120929]ora-55605错误.txt 昨天在测试机器查看进程,发现一个进程. $ ps -ef | grep fbda 503      13583     1  0 09:27 ?        00:00:00 ora_fbda_test 503      14502 14465  0 09:43 pts/2    00:00:00 grep fbda 查看alert.log也能发现这个进程的启动,我查看以前的日志,发现并没有启动. 我记得当时测试时使用的表空间我前几天已经删除

Oracle数据库ORA 54013错误的解决办法_oracle

ORA-54013: 不允许对虚拟列执行 INSERT 操作 这是Oracle 11 的新特性 -- 虚拟列. 在以前的Oracle 版本,当我们需要使用表达式或者一些计算公式时,我们会创建数据库视图,如果我们需要在这个视图上使用索引,我们会创建基于函数的索引.现在Oracle 11允许我们直接在表上使用虚拟列来存储表达式.虚拟列的值是不存储在磁盘的,它们是在查询时根据定义的表达式临时计算的.我们不能往虚拟列中插入数据,我们也不能隐式的添加数据到虚拟列,我们只能使用物理列来插入数据.然后可以查询

plsql连接oracle数据库报ora 12154错误解决方法_oracle

plsql连接oracle数据库报ora 12154错误 今天遇到一个问题,使用sqlplus能够连接到远程的数据库,但是使用plsql却连接不上,报错"ORA-12154: TNS: 无法解析指定的连接标识符" 解决方法如下: 1.先检查服务器端的监听服务是否打开,如果没有打开请启动其监听 客户端:tnsping <tns_name> 服务器Linux下: #>lsnrctl status 查看监听状态 #>lsnrctl start 启动监听 2.通过Sql

[20170914]tnsnames.ora的管理.txt

[20170914]tnsnames.ora的管理.txt --//昨天朋友讲tnsnams.ora的内容太长了,而且许多不需要的.管理不方便.我记得以前写[20150409]tnsnames.ora与IFILE.txt.链接 --//http://blog.itpub.net/267265/viewspace-1561107/ --//这样你可以按照某种分类管理.实际上这个我也是以前看别人的机器学来的,很简单就是建立多个tnsnames配置文件. --//使用参数IFILE=/path/xxx

[20171205]bash for例子错误.txt

[20171205]bash for例子错误.txt --//今天写bash for循环,遇到问题.通过例子说明: $ cat tt1.sh #! /bin/bash for i in { 1 .. 5 } do   echo $i done --//本想输出1,2,3,4,5的.而实际上执行输出是: $ . tt1.sh { 1 .. 5 } --//使用这样的方式{ 1 .. 5 }之间不能有任何空格.正确的写法如下: $ cat tt1.sh #! /bin/bash for i in {

[20150601]模拟ora-00600[2608]错误.txt

[20150601]模拟ora-00600[2608]错误.txt --前几天在测试使用bbed解决丢失的归档,链接: http://blog.itpub.net/267265/viewspace-1676438/ [20150529]使用bbed解决丢失的归档.txt --出现如下错误: ORA-00600: internal error code, arguments: [2608], [1], [2], [4101877000], [2], [4101877009], [], [] --不