请教一个sed问题？

jayli426

sed -n "/\*\*\*\*\*\*\*\*\*\*/{N
> N
> p
> }" /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/trace/ora11g_ora_21246.trc

请问这个sed语句如何理解呢？

原始文件类似
“
***************************************************************************
DATABASE ENTRY
***************************************************************************
(blkno = 0x1, size = 192, max = 1, in-use = 1, last-recid= 0)
DF Version: creation=0x9200000 compatible=0x8000000, Date  12/06/2007 17:05:49
DB Name "ETLDB"
Database flags = 0x00404000
Controlfile Creation Timestamp  12/06/2007 17:05:50
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp  12/06/2007 17:05:49
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp  01/01/1988 00:00:00
Redo Version: creation=0x9200000 compatable=0x9200000
#Data files = 8, #Online files = 8
Database checkpoint: Thread=1 scn: 0x0000.0010bd45
Threads: #Enabled=1, #Open=1, Head=1, Tail=1
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000
Max log members = 3, Max data members = 1
Arch list: Head=0, Tail=0, Force scn: 0x0000.001002bcscn: 0x0000.00000000
Controlfile Checkpointed at scn:  0x0000.0010bd45 10/15/2011 10:43:25
thread:0 rba0x0.0.0)
enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000




***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
(blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
THREAD #1 - status:0x2 flags:0x0 dirty:82
low cache rba0x2e.3.0) on disk rba0x2e.16b.0)
on disk scn: 0x0000.0010bee3 10/15/2011 10:47:24
resetlogs scn: 0x0000.00000001 12/06/2007 17:05:49
heartbeat: 764582561 mount id: 1680367809
MTTR statistics status: 3
Init time: Avg: 19462300, Times measured: 3
File open time: Avg: 10161, Times measured: 31
Log block read time: Avg: 392, Times measured: 32767
Data block handling time: Avg: 6319, Times measured: 283




***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
(blkno = 0x61, size = 276, max = 1, in-use = 1, last-recid= 0)
Control AutoBackup date(dd/mm/yyyy)= 6/12/2007
Next AutoBackup sequence= 0



***************************************************************************
REDO THREAD RECORDS
***************************************************************************
(blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
THREAD #1 - status:0xf thread links forward:0 back:0
#logs:3 first:1 last:3 current:1 last used seq#:0x2e
enabled at scn: 0x0000.00000001 12/06/2007 17:06:03
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
opened at 10/15/2011 10:43:24 by instance etldb
Checkpointed at scn:  0x0000.0010bd45 10/15/2011 10:43:24
thread:1 rba0x2e.2.10)
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000
log history: 45

--------------------------------------------
”

结果类似

“
***************************************************************************
DATABASE ENTRY
***************************************************************************
***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
***************************************************************************
REDO THREAD RECORDS
***************************************************************************
***************************************************************************
LOG FILE RECORDS
***************************************************************************
***************************************************************************
DATA FILE RECORDS
***************************************************************************
***************************************************************************
TEMP FILE RECORDS
***************************************************************************
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
***************************************************************************
RMAN CONFIGURATION RECORDS
***************************************************************************
***************************************************************************
FLASHBACK LOGFILE RECORDS
***************************************************************************
***************************************************************************
THREAD INSTANCE MAPPING RECORDS
***************************************************************************
***************************************************************************
MTTR RECORDS
***************************************************************************
***************************************************************************
STANDBY DATABASE MAP RECORDS
***************************************************************************
***************************************************************************
RESTORE POINT RECORDS
***************************************************************************
***************************************************************************
ACM SERVICE RECORDS
***************************************************************************
***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
***************************************************************************
ARCHIVED LOG RECORDS
***************************************************************************
***************************************************************************
FOREIGN ARCHIVED LOG RECORDS
***************************************************************************
***************************************************************************
BACKUP SET RECORDS
***************************************************************************
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
***************************************************************************
DATAFILE COPY RECORDS
***************************************************************************
***************************************************************************
BACKUP DATAFILE CORRUPTION RECORDS
***************************************************************************
***************************************************************************
DATAFILE COPY CORRUPTION RECORDS
***************************************************************************
***************************************************************************
DELETION RECORDS
***************************************************************************
***************************************************************************
PROXY COPY RECORDS
***************************************************************************
***************************************************************************
INCARNATION RECORDS
***************************************************************************
***************************************************************************
RMAN STATUS RECORDS
***************************************************************************
***************************************************************************
DATAFILE HISTORY RECORDS
***************************************************************************
***************************************************************************
NORMAL RESTORE POINT RECORDS
***************************************************************************
***************************************************************************
DATABASE BLOCK CORRUPTION RECORDS
***************************************************************************

”

yangyang1581

sed -rn '/\*+/,/\*+/p'

hbmhalley

1. sed '/^*/,//!d'

复制代码

loveacat

/\*\*\*\*\*\*\*\*\*\*/  \*转义*，即匹配10个*的行
两个N，读取下两行，即当前模式空间为
***************************************************************************
DATABASE ENTRY
***************************************************************************
小写的p,打印模式空间的内容