oracle dump logfile方法及dump文件解读

最新推荐文章于 2021-12-03 16:32:56 发布
最新推荐文章于 2021-12-03 16:32:56 发布
阅读量1k 收藏 2
点赞数
文章标签： 数据库 操作系统

dump logfile

有时工作需要可能需要dump redo logfile，帮助解决问题。

 

这个命令需要alter system系统权限。

数据库可以是在nomount,mount,open状态。

可以dump在线redo log，也可以dump归档文件。

甚至可以dump其他数据的文件，但是操作系统要一致。

 

 

 

dump的几种方法：

1. To dump records based in DBA (Data Block Address)

2. To dump records based on RBA (Redo Block Address)

3. To dump records based on SCN

4. To dump records based on time

5. To dump records based on layer and opcode

6. Dump the file header information

7. Dump an entire log file:

 

1.To dump records based in DBA (Data Block Address)

ALTER SYSTEM DUMP LOGFILE 'filename'

 DBA MIN fileno . blockno

   DBA MAX fileno . blockno;

dump出指定范围数据块的redo记录。

 

数据库版本：

SQL> !sqlplus -V

 

SQL*Plus: Release 11.2.0.1.0 Production

 

SQL> sho user

USER is "MING"

SQL> set line 300

SQL> col b for a30

SQL> select dbms_rowid.rowid_relative_fno(rowid) file_id,
dbms_rowid.rowid_block_number(rowid) block_id,rowid,
test.* from test;

 

   FILE_ID   BLOCK_ID ROWID                       A B

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

         7       1683 AAASZ2AAHAAAAaTAAA          1 ming

更新一行：

SQL> update test set b='mingshuomingshuo' where a=1;

 

1 row updated.

 

SQL> select lg.group#,lg.sequence#,lg.bytes/1024/1024/1024 G,
lg.members,lgf.member,lg.archived,
lg.status from v$log lg,v$logfile lgf where lg.group#=lgf.group#;

 

 GROUP#  SEQUENCE#    G    MEMBERS MEMBER        ARC STATUS

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

3    36 .048828125   1 /tpdata/oradata/ogg1/redo03.log  NO CURRENT

2    35 .048828125   1 /tpdata/oradata/ogg1/redo02.log  YES  INACTIVE

1    34 .048828125   1 /tpdata/oradata/ogg1/redo01.log  YES INACTIVE

 

SQL> alter system dump logfile '/tpdata/oradata/ogg1/redo03.log' dba min 7 1683 dba max 7 1683;       

 

System altered.

 

SQL> select tracefile from v$process where addr in (
select paddr from v$session where sid in (select sid from v$mystat));

 

TRACEFILE

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

/tpsys/app/oracle/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_2647.trc

 

[oracle@oggtest1 ~]$ more /tpsys/app/oracle/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_2647.trc

Trace file /tpsys/app/oracle/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_2647.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /tpsys/app/oracle/product/11.2.0/db_1

System name:    Linux

Node name:      oggtest1

Release:        2.6.32-358.el6.x86_64

Version:        #1 SMP Tue Jan 29 11:47:41 EST 2013

Machine:        x86_64

Instance name: ogg1

Redo thread mounted by this instance: 1

Oracle process number: 29

Unix process pid: 2647, image: oracle@oggtest1 (TNS V1-V3)

 

 

*** 2018-05-31 23:35:34.677

*** SESSION ID:(38.36) 2018-05-31 23:35:34.677

*** CLIENT ID:() 2018-05-31 23:35:34.677

*** SERVICE NAME:(SYS$USERS) 2018-05-31 23:35:34.677

*** MODULE NAME:(sqlplus@oggtest1 (TNS V1-V3)) 2018-05-31 23:35:34.677

*** ACTION NAME:() 2018-05-31 23:35:34.677

 

Log read is SYNCHRONOUS though disk_asynch_io is enabled!

 

DUMP OF REDO FROM FILE '/tpdata/oradata/ogg1/redo03.log'

 Opcodes *.*

 DBAs: (file # 7, block # 1683) thru (file # 7, block # 1683)

data块的起点和终点（thru），这里我只dump了1683号一个块。

 

RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff

 SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff

 Times: creation thru eternity

 FILE HEADER:

        Compatibility Vsn = 186646528=0xb200000

        Db ID=4132820558=0xf655d64e, Db Name='OGG1'

        Activation ID=4132850254=0xf6564a4e

        Control Seq=3130=0xc3a, File size=102400=0x19000

        File Number=3, Blksiz=512, File Type=2 LOG

 descrip:"Thread 0001, Seq# 0000000036, SCN 0x000000158f45-0xffffffffffff"

 thread: 1 nab: 0xffffffff seq: 0x00000024 hws: 0x1 eot: 1 dis: 0

 resetlogs count: 0x38d85a12 scn: 0x0000.000e6c20 (945184)

 prev resetlogs count: 0x296b946b scn: 0x0000.00000001 (1)

 Low  scn: 0x0000.00158f45 (1412933) 05/31/2018 23:05:04

 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00

 Enabled scn: 0x0000.000e6c20 (945184) 09/03/2017 05:28:50

 Thread closed scn: 0x0000.00158f45 (1412933) 05/31/2018 23:05:04

 Disk cksum: 0x471d Calc cksum: 0x471d

 Terminal recovery stop scn: 0x0000.00000000

 Terminal recovery  01/01/1988 00:00:00

 Most recent redo scn: 0x0000.00000000

 Largest LWN: 0 blocks

 End-of-redo stream : No

 Unprotected mode

 Miscellaneous flags: 0x800000

 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000

 

REDO RECORD - Thread:1 RBA: 0x000024.00000ad6.0010 LEN: 0x01f4 VLD: 0x05

SQL> SELECT TO_NUMBER('24','XXXXXXXXXXXXXXXX') FROM DUAL;       

 

TO_NUMBER('23','XXXXXXXXXXXXXXXX')

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

                                36

 

SQL> SELECT TO_NUMBER('00000ad6','XXXXXXXXXXXXXXXX') FROM DUAL; 

 

TO_NUMBER('1E3A','XXXXXXXXXXXXXXXX')

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

                                2774

36号日志，redo块number是2774，就是我们dump的redo log

 

 

SCN: 0x0000.0015939d SUBSCN:  1 05/31/2018 23:33:53

CHANGE #1 TYP:0 CLS:17 AFN:3 DBA:0x00c00080 OBJ:4294967295 SCN:0x0000.0015932b
SEQ:1 OP:5.2 ENC:0 RBL:0

ktudh redo: slt: 0x000e sqn: 0x00000355 flg: 0x0012 siz: 160 fbi: 0

            uba: 0x00c00211.010e.03    pxid:  0x0000.000.00000000

CHANGE #2 TYP:0 CLS:18 AFN:3 DBA:0x00c00211 OBJ:4294967295 SCN:0x0000.0015932a
SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 160 spc: 7794 flg: 0x0012 seq: 0x010e rec: 0x03

            xid:  0x0001.00e.00000355 

ktubl redo: slt: 14 rci: 0 opc: 11.1 [objn: 75382 objd: 75382 tsn: 8]

Undo type:  Regular undo        Begin trans    Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

             0x00000000  prev ctl uba: 0x00c00211.010e.02

prev ctl max cmt scn:  0x0000.00158bd7  prev tx cmt scn:  0x0000.00158be6

txn start scn:  0xffff.ffffffff  logon user: 95  prev brb: 12583426  prev bcl: 0 BuExt idx: 0
flg2: 0

KDO undo record:

KTB Redo

op: 0x03  ver: 0x01 

compat bit: 4 (post-11) padding: 1

op: Z

KDO Op code: URP row dependencies Disabled

##下面这部分是修改前的数据,上面和下面这一部分其实是undo的信息

  xtype: XA flags: 0x00000000  bdba: 0x01c00693  hdba: 0x01c00692

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0

ncol: 2 nnew: 1 size: -12

col  1: [ 4]  6d 69 6e 67   ##4是长度，6d 69 6e 67是修改前的值

修改前的值:

SQL> select utl_raw.cast_to_varchar2(replace('6d,69,6e,67',',')) value from dual;

 

VALUE

------------------------------------------------------------------------------------------------------
ming

 

CHANGE #3 TYP:0 CLS:1 AFN:7 DBA:0x01c00693 OBJ:75382 SCN:0x0000.0015673a SEQ:1 OP:11.5 ENC:0 RBL:0

SQL> SELECT TO_NUMBER('01c00693','XXXXXXXXXXXXXXXX') FROM DUAL;                                                         

 

TO_NUMBER('01C00693','XXXXXXXXXXXXXXXX')

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

          29361811

 

SQL> select

2  dbms_utility.data_block_address_block(29361811) "BLOCK",

3  dbms_utility.data_block_address_file(29361811) "FILE"

4  from dual;

 

     BLOCK       FILE

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

      1683          7

7号数据文件的1693块就是我dump的块。

 

75382就是我们操作的test表的object_id

 

OP code是11.5，在DML的操作代码中，11.5代表update row piece

 

KTB Redo

op: 0x01  ver: 0x01 

compat bit: 4 (post-11) padding: 1

op: F  xid:  0x0001.00e.00000355    uba: 0x00c00211.010e.03

KDO Op code: URP row dependencies Disabled

  xtype: XA flags: 0x00000000  bdba: 0x01c00693  hdba: 0x01c00692

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 0

ncol: 2 nnew: 1 size: 12

col  1: [16]  6d 69 6e 67 73 68 75 6f 6d 69 6e 67 73 68 75 6f

Bdba是更新的块的地址，所以跟DBA:0x01c00693一样也就是显而易见的了；

Hdba是更新的块所在的段的地址。

SQL> SELECT TO_NUMBER('01c00692','XXXXXXXXXXXXXXXX') FROM DUAL;

 

TO_NUMBER('01C00692','XXXXXXXXXXXXXXXX')

----------------------------------------
  29361810

SQL> select

  2  dbms_utility.data_block_address_block(29361810) "BLOCK",

  3  dbms_utility.data_block_address_file(29361810) "FILE"

  4  from dual;

 

     BLOCK       FILE

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

      1682          7

TEST表所在的段的信息：

SQL> select owner,segment_name,segment_type,header_file,header_block from dba_segments where segment_name='TEST' and tablespace_name='TEST';

OWNER   SEGMENT_NAME   SEGMENT_TYPE HEADER_FILE HEADER_BLOCK

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

MING    TEST           TABLE                  7         1682

两者是一致的

 

itli: 2 该事务正在使用第二个事务槽。

tabn: 0 该块上第一个表。

Flag是0x2c，代表没有出现行迁移，包括first data piece,last data piecehe head piece of row.

ncol: 2 该记录有2行

nnew：1 修改了1列（b那一列）

size: 12 修改列长度增加了12（从4变成16）

修改后的值：

SQL> select
utl_raw.cast_to_varchar2(replace('6d,69,6e,67,73,68,75,6f,6d,69,6e,67,73,68,75,6f',',')) value
from dual;

 

VALUE

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

mingshuomingshuo

 

CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:5.20 ENC:0

session number   = 1

serial  number   = 15

执行事务的会话信息：

SQL> SELECT SID,SERIAL# FROM V$SESSION
WHERE SID=( select userenv('SID') FROM DUAL);

 

       SID    SERIAL#

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

         1         15

 

transaction name =

version 186646784

audit sessionid 151083

Client Id =

END OF REDO DUMP

----- Redo read statistics for thread 1 -----

Read rate (SYNC): 1419Kb in 0.01s => 138.57 Mb/sec

Total redo bytes: 2047Kb Longest record: 13Kb, moves: 1/2688 moved: 0Mb (0%)

Longest LWN: 504Kb, reads: 240

Last redo scn: 0x0000.001593c8 (1414088)

Change vector header moves = 261/4848 (5%)

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

 

 

2. To dump records based on RBA (Redo Block Address)

ALTER SYSTEM DUMP LOGFILE 'filename'

   RBA MIN seqno . blockno

   RBA MAX seqno . blockno;

RBA实际就是块的变化在redo log中的记录位置。所以这里是dump出指定范围的redo块的redo记录。

3. To dump records based on SCN 

ALTER SYSTEM DUMP LOGFILE 'filename' 
   SCN MIN minscn 
   SCN MAX maxscn;

Dump出指定范围SCN的redo记录

 

 

 

 

 

 

 

 

4. To dump records based on time 

ALTER SYSTEM DUMP LOGFILE 'filename' 
   TIME MIN value 
   TIME MAX value;

这里的value实际是时间范围,确切说是redo dump time。

下面给出一个时间转变为redo dump time的脚本：

/* Formatted on2011/8/8 23:00:53 (QP5 v5.163.1008.3004) */

SET ECHO OFF

REM NAME:   TFSTM2RD.SQL

REMUSAGE:"@path/tfstm2rd"

REM------------------------------------------------------------------------

REM REQUIREMENTS:

REM   None.

REM------------------------------------------------------------------------

REM AUTHOR:

REM   Anonymous

REM   Copyright 1996, Orqacle Corporation

REM------------------------------------------------------------------------

REM PURPOSE:

REM   Converts a standard date into redo dump timeformat.

REM------------------------------------------------------------------------

REM EXAMPLE:

REM   Enter day (DD/MM/YYYY) ?08/07/1996

REM   Enter time (HH24:MI:SS) ? 12:05:05

REM

REM   REDO_YEAR REDO_MONTH REDO_DAY REDO_HOURREDO_MIN REDO_SEC

REM   --------- ---------- -------- ----------------- --------

REM        1996       7      8       12       5      5

REM

REM   EDO_TIME

REM   ----------

REM    273845105

REM

REM------------------------------------------------------------------------

REM DISCLAIMER:

REM   This script. is provided for educational purposesonly. It is NOT

REM   supported by Oracle World Wide TechnicalSupport.

REM   The script. has been tested and appears towork as intended.

REM   You should always run new scripts on a testinstance initially.

REM------------------------------------------------------------------------

REM Main text ofscript. follows:

 

UNDEFINE redo_day

UNDEFINE redo_hhmiss

 

ACCEPT redo_day PROMPT "Enter day (DD/MM/YYYY) ? "

ACCEPT redo_hhmiss PROMPT "Enter time (HH24:MI:SS) ? "

 

COLUMN redo_year NEW_VALUE redo_year FORMAT 9999

COLUMN redo_month NEW_VALUE redo_month FORMAT 9999

COLUMN redo_day  NEW_VALUE redo_day FORMAT9999

COLUMN redo_hour NEW_VALUE redo_hour FORMAT 9999

COLUMN redo_min  NEW_VALUE redo_min FORMAT9999

COLUMN redo_sec  NEW_VALUE redo_sec FORMAT9999

COLUMN redo_time NEW_VALUE redo_time

 

SETVERIFY OFF

 

SELECT TO_NUMBER (

          TO_CHAR (

             TO_DATE ('&redo_day&redo_hhmiss', 'DD/MM/YYYY HH24:MI:SS'),

             'YYYY'))

          redo_year,

       TO_NUMBER (

          TO_CHAR (

             TO_DATE ('&redo_day&redo_hhmiss', 'DD/MM/YYYY HH24:MI:SS'),

             'MM'))

          redo_month,

       TO_NUMBER (

          TO_CHAR (

             TO_DATE ('&redo_day&redo_hhmiss', 'DD/MM/YYYY HH24:MI:SS'),

             'DD'))

          redo_day,

       TO_NUMBER (

          TO_CHAR (

             TO_DATE ('&redo_day&redo_hhmiss', 'DD/MM/YYYY HH24:MI:SS'),

             'HH24'))

          redo_hour,

       TO_NUMBER (

          TO_CHAR (

             TO_DATE ('&redo_day&redo_hhmiss', 'DD/MM/YYYY HH24:MI:SS'),

             'MI'))

          redo_min,

       TO_NUMBER (

          TO_CHAR (

             TO_DATE ('&redo_day&redo_hhmiss', 'DD/MM/YYYY HH24:MI:SS'),

             'SS'))

          redo_sec

  FROM DUAL;

 

SELECT ( ( ( ( ( (&redo_year - 1988)) * 12 + (&redo_month - 1)) * 31

            + (&redo_day - 1))

          * 24

          + (&redo_hour))

        * 60

        + (&redo_min))

       * 60

       + (&redo_sec)

          redo_time

  FROM DUAL;

 

 

 

5. To dump records based on layer and opcode 

ALTER SYSTEM DUMP LOGFILE 'filename' 
   LAYER value 
   OPCODE value;

Layer和opcode是用来dump出特定类型的redo记录的。

 

 

6. Dump the file header information 

Dump出所有在线日志的header信息：
   alter session set events 'immediate trace name redohdr level 10'; 
dump出归档日志的header信息：
   ALTER SYSTEM DUMP LOGFILE 'filename' RBA MIN 1 1 RBA MAX 1 1;
 
在线日志：

SQL> alter session set events 'immediate trace name redohdr level 10';

Session altered.

 

[oracle@oggtest1 trace]$ more ogg1_ora_3048.trc

Trace file /tpsys/app/oracle/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_3048.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /tpsys/app/oracle/product/11.2.0/db_1

System name:    Linux

Node name:      oggtest1

Release:        2.6.32-358.el6.x86_64

Version:        #1 SMP Tue Jan 29 11:47:41 EST 2013

Machine:        x86_64

Instance name: ogg1

Redo thread mounted by this instance: 1

Oracle process number: 29

Unix process pid: 3048, image: oracle@oggtest1 (TNS V1-V3)

 

 

*** 2018-06-01 01:31:40.458

*** SESSION ID:(38.38) 2018-06-01 01:31:40.458

*** CLIENT ID:() 2018-06-01 01:31:40.458

*** SERVICE NAME:(SYS$USERS) 2018-06-01 01:31:40.458

*** MODULE NAME:(sqlplus@oggtest1 (TNS V1-V3)) 2018-06-01 01:31:40.458

*** ACTION NAME:() 2018-06-01 01:31:40.458

 

DUMP OF LOG FILES: 3 logs in database

LOG FILE #1:

  name #3: /tpdata/oradata/ogg1/redo01.log

 Thread 1 redo log links: forward: 2 backward: 0

 siz: 0x19000 seq: 0x00000022 hws: 0x3 bsz: 512 nab: 0x12c7e flg: 0x1 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00150d87

 Low scn: 0x0000.00151fff 05/30/2018 21:31:05

 Next scn: 0x0000.00154ded 05/30/2018 22:54:33

 FILE HEADER:

        Compatibility Vsn = 186646528=0xb200000

        Db ID=4132820558=0xf655d64e, Db Name='OGG1'

        Activation ID=4132850254=0xf6564a4e

        Control Seq=3105=0xc21, File size=102400=0x19000

        File Number=1, Blksiz=512, File Type=2 LOG

redo log key is 35a83c3bcc89f58a38e79d8babc0cd

redo log key flag is 5

 descrip:"Thread 0001, Seq# 0000000034, SCN 0x000000151fff-0x000000154ded"

 thread: 1 nab: 0x12c7e seq: 0x00000022 hws: 0x3 eot: 0 dis: 0

 reset logs count: 0x38d85a12 scn: 0x0000.000e6c20

 Low scn: 0x0000.00151fff 05/30/2018 21:31:05

 Next scn: 0x0000.00154ded 05/30/2018 22:54:33

 Enabled scn: 0x0000.000e6c20 09/03/2017 05:28:50

 Thread closed scn: 0x0000.00151fff 05/30/2018 21:31:05

 Disk cksum: 0xdeda Calc cksum: 0xdeda

 Terminal Recovery Stop scn: 0x0000.00000000

 Terminal Recovery Stamp  01/01/1988 00:00:00

 Most recent redo scn: 0x0000.00000000

 Largest LWN: 2048 blocks

 Miscellaneous flags: 0x800000

 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000

LOG FILE #2:

  name #2: /tpdata/oradata/ogg1/redo02.log

 Thread 1 redo log links: forward: 3 backward: 1

 siz: 0x19000 seq: 0x00000023 hws: 0x5 bsz: 512 nab: 0x13ea0 flg: 0x1 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00151fff

 Low scn: 0x0000.00154ded 05/30/2018 22:54:33

 Next scn: 0x0000.00158f45 05/31/2018 23:05:04

 FILE HEADER:

        Compatibility Vsn = 186646528=0xb200000

        Db ID=4132820558=0xf655d64e, Db Name='OGG1'

        Activation ID=4132850254=0xf6564a4e

        Control Seq=3130=0xc3a, File size=102400=0x19000

        File Number=2, Blksiz=512, File Type=2 LOG

redo log key is 65a21627df0616da4e0eab04481274

redo log key flag is 5

 descrip:"Thread 0001, Seq# 0000000035, SCN 0x000000154ded-0x000000158f45"

 thread: 1 nab: 0x13ea0 seq: 0x00000023 hws: 0x5 eot: 0 dis: 0

 reset logs count: 0x38d85a12 scn: 0x0000.000e6c20

 Low scn: 0x0000.00154ded 05/30/2018 22:54:33

 Next scn: 0x0000.00158f45 05/31/2018 23:05:04

 Enabled scn: 0x0000.000e6c20 09/03/2017 05:28:50

 Thread closed scn: 0x0000.0015680b 05/31/2018 02:12:09

 Disk cksum: 0xb8e7 Calc cksum: 0xb8e7

 Terminal Recovery Stop scn: 0x0000.00000000

 Terminal Recovery Stamp  01/01/1988 00:00:00

 Most recent redo scn: 0x0000.00000000

 Largest LWN: 2048 blocks

 Miscellaneous flags: 0x800000

 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000

LOG FILE #3:

  name #1: /tpdata/oradata/ogg1/redo03.log

 Thread 1 redo log links: forward: 0 backward: 2

 siz: 0x19000 seq: 0x00000024 hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00154ded

 Low scn: 0x0000.00158f45 05/31/2018 23:05:04

 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00

 FILE HEADER:

        Compatibility Vsn = 186646528=0xb200000

        Db ID=4132820558=0xf655d64e, Db Name='OGG1'

        Activation ID=4132850254=0xf6564a4e

        Control Seq=3130=0xc3a, File size=102400=0x19000

        File Number=3, Blksiz=512, File Type=2 LOG

redo log key is 822c416515657eb0b48bc9b93c403cc8

redo log key flag is 5

 descrip:"Thread 0001, Seq# 0000000036, SCN 0x000000158f45-0xffffffffffff"

 thread: 1 nab: 0xffffffff seq: 0x00000024 hws: 0x1 eot: 1 dis: 0

 reset logs count: 0x38d85a12 scn: 0x0000.000e6c20

 Low scn: 0x0000.00158f45 05/31/2018 23:05:04

 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00

 Enabled scn: 0x0000.000e6c20 09/03/2017 05:28:50

 Thread closed scn: 0x0000.00158f45 05/31/2018 23:05:04

 Disk cksum: 0x471d Calc cksum: 0x471d

 Terminal Recovery Stop scn: 0x0000.00000000

 Terminal Recovery Stamp  01/01/1988 00:00:00

 Most recent redo scn: 0x0000.00000000

 Largest LWN: 0 blocks

 Miscellaneous flags: 0x800000

 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000

 

 

 

 

 

 

7. Dump an entire log file: 

ALTER SYSTEM DUMP LOGFILE 'filename';

Dump出指定日志的所有内容。


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31480688/viewspace-2155667/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31480688/viewspace-2155667/

conghe6716
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle dump() 详解
m0_37253968的博客
09-24 1660
文章目录 1 概述2 语法3 扩展3.1 Typ 类型3.2 chr()、ascii() 1 概述 dump: 字面意思 '转储' -> '数据类型' 在计算机中存储的形式(ascii 码) 2 语法 Oracle 12c 官方文档 - dump() dump(expr[,return_format [,start_position[, length]]]) expr: 要分析的表达式 return_format: 返回值的格式 (1) 8 : 八进制符号 (2)..
oracle data dump 详解
征服在路上
03-09 1458
转帖 Oracle Database 10g引入了最新的数据泵(Data Dump)技术,使DBA或开发人员可以将数据库 元数据(对象定义)和数据快速移动到另一个oracle数据库中. 数据泵导出导入(EXPDP和IMPDP)的作用 1,实现逻辑备份 和逻辑恢复. 2,在数据库用户之间移动对象. 3,在数据库之间移动对象 4,实现表空间搬移....
oracle之 如何 dump logfile
weixin_34238633的博客
03-19 104
这篇文章解释了如何在联机或归档重做日志文件中获取转储。 约束和限制:1。数据库必须安装(或打开)。更改系统转储日志文件与任何实例无关，因此不需要为其操作安装数据库。但是，在ALTER SYSTEM DUMP REDO的情况下，系统需要知道实例是什么，以及其他日志文件在哪里。此查找需要控制文件，因此必须安装或打开数据库。 2。DUMP REDO限制在控制文件中识别的日志文件集。因为我们在控制文件中查...
oracle dump日志
weixin_30767835的博客
02-29 187
oracle有两种进程日志 一个是后台进程日志，一个是用户进程日志 通过命令:show parameter dump NAME TYPE VALUE ------------------------------------ ---------- ---------------------...
oracle redo internal,oracle redo internal 之 dump logfile
weixin_32273559的博客
04-06 140
常使用的Dumpredo命令Dumplogfile的方法有很多，现总结如下，后续将对orcacle的redo进行更深入的研究(1)Dump日志文件的内容SQL> selectgroup#,memberfromv$logfile;GROUP#----------MEMBER-------------------------------------------------------------...
oracle的dumpfile,OracleDumpRedoLogFile说明
weixin_33068055的博客
04-03 289
关于Dump redo log 的示例，MOS 上的文档：[ID 1031381.6] 有详细说明。Dump 有两种方式：(1)使用一. dump redo 说明关于Dump redo log 的示例，MOS 上的文档：[ID 1031381.6] 有详细说明。Dump 有两种方式：(1)使用'alter session' 命令dumpredo header。(2)使用'alter system ...
[alter system dump学习1]alter system dump logfile
congxinlan3332的博客
11-11 191
-------------------------------------------------------------------------------------------------- PURPOSE Th...
oracle数据库dump文件的作用,Oracle数据库event事件与dump文件介绍
weixin_42512356的博客
04-05 661
Oracle数据库event事件与dump文件介绍一、Oracle跟踪文件 Oracle跟踪文件分为三种类型，一种是后台报警日志文件，记录数据库在启动、关闭和运行期间后台进程的活动情况,如表空间创建、回滚段创建、某些alter命令、日志切换、错误消息等。在数据库出现故障时，应首先查看该文件，但文件中的信息与任何错误状态没有必然的联系。后台报警日志文件保存BACKGROUND_DUMP_DEST参数...
oracle dump 文件解析,实用解析dmp文件内容
weixin_33329305的博客
04-03 1339
配置实验环境：1.1 生产三个文件expwoo/oracletable=dump_tablefile=1.dmp;expdpwoo/oracletables=dump_tabledirectory=dhomedumpfile=2.dmp;touch3.dmp2.创建随机数据SQL>createtabledump_tableas2selectrownumasi...
oracle dump数据,【Oracle】 Dump数据导出
weixin_42190030的博客
04-09 896
1.Oracle dump新建导出目录[root@mldb002 oracle]# mkdir /u03/oracle/dump/[root@mldb002 oracle]# chown -R oracle:oinstall /u03/oracle/dump[root@mldb002 oracle]# lltotal 4drwxr-xr-x 2 oracle oinstall 4096 Aug 1...
oracle查看onlinelog文件,Oracle 联机重做日志文件(ONLINE LOG FILE)
weixin_30248619的博客
04-03 651
--=========================================-- Oracle 联机重做日志文件(ONLINE LOG FILE)--=========================================一、Oracle中的几类日志文件Redo log files --&gt联机重做日志Archive log files --&g...
ALTER SYSTEM DUMP LOGFILE 的用法
最新发布
06-08
ALTER SYSTEM DUMP LOGFILE命令用于在Oracle数据库中生成一个系统日志文件的转储。这个命令可以在运行时使用，也可以在Oracle数据库中的参数文件中配置。以下是ALTER SYSTEM DUMP LOGFILE命令的用法： 1. 在运行时...
oracle dump log的内容分析
opendba的专栏
10-27 1493
执行下面的SQL，SQL> insert into t1 values(6,sysdate);1 row created.SQL> rollback;Rollback complete.SQL> alter system switch logfile;trace文件为：oratest_ora_6535.trc然后再alter system dump log file '/opt/oracle/oradata/oratest/arch/126.dbf'，得到的trace文件的信息：REDO RECORD -
ALTER SYSTEM DUMP LOGFILE
ctf7893的博客
05-08 230
PURPOSE This article explain how to obtain a dump of the header information in the online redo log file(s), as wel...
oracle数据库的dump,Oracle常用dump命令，记录一下备查。
weixin_35075655的博客
04-03 250
一.MemoryDumps1).GlobalAreaALTERSESSIONSETEVENTS‘immediatetracenameglobal_arealeveln';1包含PGA2包含SGA4包含UGA8包含indrectmemory2).LibraryCacheALTERSESSIONSETEVENTS‘immediatetracenameli...
Oracle常用dump命令
love4959的专栏
04-22 1949
一.Memory Dumps1).Global Area ALTER SESSION SET EVENTS ‘immediate trace name global_area level n’; 1 包含PGA 2 包含SGA 4 包含UGA 8 包含indrect memory2).Library Cache ALTER SESSION SET EVENTS ‘immediate trace name library_cache level n’; 1 library cache统计信息 2 包含hash
解析oracle的dump文件,使用awk来解析dump文件
weixin_39956612的博客
04-04 222
dump文件是平时工作中经常碰见的，有时候得到一个dump，但是没有提供一些更多的信息，导入的时候就很可能会有问题。如果某个用户默认表空间是user,但是dump中的表所属的表空间是datas01,则导入的时候会自动转换表空间。但是如果表中存在lob字段且dump的表空间和目标环境的表空间不一致，就有在导入dump的时候，经典的00959问题,错误类似下面的形式。IMP-00017: follow...
通过 alter system dump logfile语句dump REDO及归档日志信息示例
还不算晕的专栏
11-17 5897
说明：alter system dump logfile 'filename'; 这个语句在NOMOUNT/MOUNT/OPEN状态下，均可以DUMP REDO日志或归档日志，从而可以从文件头信息中找到DBID，在数据恢复时很有用。 因为我们可以仅使用任意一个参数文件，就可以将一个实例打开到NOMOUNT，然后将待恢复却不知道DBID的数据库的REDO或归档文件进行DUMP（也可传输到远程库）
ORA-00600 25027错误问题处理
m0_37625564的博客
12-03 1578
用户反映应用软件在保存相关数据时报错，并提供了如下报错截图： 通过直接查找alert日志中的错误对应TRACE文件以及通过设置errorstack方式从TRACE文件中分析相应的应用软件报错时对应的数据库对象信息： ORA-00600 25027错误 [oracle@orcl01 trace]$ more /oracle/app/diag/rdbms/primary/orcl/trace/orcl_ora_166102.trc Trace file /oracle/app/diag/rdbms/prim
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值