[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

extract

Hi

We have having following output. From which we want to get following values using shell script.

1. Thread_Number ==> eg: Thread #: 12 is 12
2. Recovery_Checkpoint ==> eg:     Sequence #: 318 is 318
3. Recovery_RBA ==> eg:      RBA: 58896
4. Recovery_TS ==> eg: Timestamp: 2012-08-16 16:32:39.000000
5. BR_SEQ ==> eg: Sequence #: 318
6. BR_RBA ==> eg:   RBA: 39936
7. BR_TS ==> eg:     SCN: 2959.3465855811 (12712274084675)
8. CR_SEQ ==> 318
9. CR_RBA ==> 61440
10. CR_TS ==> 2012-08-16 16:32:39.000000
11. CR_SCN ==> 2959.3466057809 (12712274286673)

We can get Recovery details from Recovery Checkpoint and BR details from   BR Begin Recovery Checkpoint:.

How to get these details using shell script?


Read Checkpoint #12

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 12
    Sequence #: 192
    RBA: 2185232
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558712387 (12709366941251)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb97.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 12
    Sequence #: 318
    RBA: 58896
    Timestamp: 2012-08-16 16:32:39.000000
    SCN: 2959.3466057809 (12712274286673)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb95.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 12
    Sequence #: 318
    RBA: 61440
    Timestamp: 2012-08-16 16:32:39.000000
    SCN: 2959.3466057809 (12712274286673)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb95.log

  BR Previous Recovery Checkpoint:
    Thread #: 12
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 12
    Sequence #: 318
    RBA: 39936
    Timestamp: 2012-08-16 16:31:25.000000
    SCN: 2959.3465855811 (12712274084675)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 12
    Sequence #: 318
    RBA: 39936
    Timestamp: 2012-08-16 16:31:25.000000
    SCN: 2959.3465855811 (12712274084675)
    Redo File:


EXTRACT    EXT01     Last Started 2012-08-16 00:06   Status RUNNING
Checkpoint Lag       00:00:04 (updated 00:00:00 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:40  Thread 1, Seqno 487, RBA 767488
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:41  Thread 6, Seqno 313, RBA 65536
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:42  Thread 11, Seqno 314, RBA 53248
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:39  Thread 2, Seqno 466, RBA 61952
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:41  Thread 4, Seqno 370, RBA 100864
                     SCN 2959.3466057968 (12712274286832)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:41  Thread 5, Seqno 926, RBA 20480
                     SCN 2959.3466057953 (12712274286817)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:40  Thread 8, Seqno 314, RBA 44544
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:30  Thread 3, Seqno 808, RBA 1552282952
                     SCN 2959.3466026027 (12712274254891)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:40  Thread 7, Seqno 352, RBA 52736
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:40  Thread 9, Seqno 315, RBA 33792
                     SCN 2959.3466057580 (12712274286444)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:42  Thread 10, Seqno 314, RBA 43520
                     SCN 2959.3466058270 (12712274287134)
Log Read Checkpoint  Oracle Redo Logs
                     2012-08-16 16:32:39  Thread 12, Seqno 318, RBA 61440
                     SCN 2959.3466057809 (12712274286673)


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 361
    RBA: 3842576
    Timestamp: 2012-08-15 17:00:57.000000
    SCN: 2959.558696327 (12709366925191)
    Redo File: +DG_DB5GGS_RC_M/oraredo/redo_1b.dbf

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 487
    RBA: 766992
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/redo_1b.dbf

  Current Checkpoint (position of last record read in the data source):
    Thread #: 1
    Sequence #: 487
    RBA: 767488
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/redo_1b.dbf

  BR Previous Recovery Checkpoint:
    Thread #: 1
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 1
    Sequence #: 487
    RBA: 739840
    Timestamp: 2012-08-16 16:31:28.000000
    SCN: 2959.3465860412 (12712274089276)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 1
    Sequence #: 487
    RBA: 739840
    Timestamp: 2012-08-16 16:31:28.000000
    SCN: 2959.3465860412 (12712274089276)
    Redo File:

Read Checkpoint #2

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 6
    Sequence #: 187
    RBA: 2937360
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715159 (12709366944023)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb44.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 6
    Sequence #: 313
    RBA: 65040
    Timestamp: 2012-08-16 16:32:41.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb42.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 6
    Sequence #: 313
    RBA: 65536
    Timestamp: 2012-08-16 16:32:41.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb42.log

  BR Previous Recovery Checkpoint:
    Thread #: 6
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 6
    Sequence #: 313
    RBA: 50176
    Timestamp: 2012-08-16 16:31:25.000000
    SCN: 2959.3465856339 (12712274085203)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 6
    Sequence #: 313
    RBA: 50176
    Timestamp: 2012-08-16 16:31:25.000000
    SCN: 2959.3465856339 (12712274085203)
    Redo File:

Read Checkpoint #3

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 11
    Sequence #: 188
    RBA: 2155536
    Timestamp: 2012-08-15 17:01:12.000000
    SCN: 2959.558722115 (12709366950979)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb85.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 11
    Sequence #: 314
    RBA: 52752
    Timestamp: 2012-08-16 16:32:42.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb83.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 11
    Sequence #: 314
    RBA: 53248
    Timestamp: 2012-08-16 16:32:42.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb83.log

  BR Previous Recovery Checkpoint:
    Thread #: 11
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 11
    Sequence #: 314
    RBA: 39936
    Timestamp: 2012-08-16 16:31:24.000000
    SCN: 2959.3465855704 (12712274084568)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 11
    Sequence #: 314
    RBA: 39936
    Timestamp: 2012-08-16 16:31:24.000000
    SCN: 2959.3465855704 (12712274084568)
    Redo File:

Read Checkpoint #4

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 2
    Sequence #: 340
    RBA: 3456016
    Timestamp: 2012-08-15 17:00:08.000000
    SCN: 2959.558565974 (12709366794838)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb13.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 2
    Sequence #: 466
    RBA: 61456
    Timestamp: 2012-08-16 16:32:39.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb11.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 2
    Sequence #: 466
    RBA: 61952
    Timestamp: 2012-08-16 16:32:39.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb11.log

  BR Previous Recovery Checkpoint:
    Thread #: 2
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 2
    Sequence #: 466
    RBA: 43520
    Timestamp: 2012-08-16 16:31:27.000000
    SCN: 2959.3465857950 (12712274086814)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 2
    Sequence #: 466
    RBA: 43520
    Timestamp: 2012-08-16 16:31:27.000000
    SCN: 2959.3465857950 (12712274086814)
    Redo File:

Read Checkpoint #5

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 4
    Sequence #: 245
    RBA: 33808
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715097 (12709366943961)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb30.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 4
    Sequence #: 370
    RBA: 100368
    Timestamp: 2012-08-16 16:32:41.000000
    SCN: 2959.3466057968 (12712274286832)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb27.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 4
    Sequence #: 370
    RBA: 100864
    Timestamp: 2012-08-16 16:32:41.000000
    SCN: 2959.3466057968 (12712274286832)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb27.log

  BR Previous Recovery Checkpoint:
    Thread #: 4
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 4
    Sequence #: 370
    RBA: 51712
    Timestamp: 2012-08-16 16:31:26.000000
    SCN: 2959.3465857838 (12712274086702)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 4
    Sequence #: 370
    RBA: 51712
    Timestamp: 2012-08-16 16:31:26.000000
    SCN: 2959.3465857838 (12712274086702)
    Redo File:

Read Checkpoint #6

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 5
    Sequence #: 800
    RBA: 3139088
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715187 (12709366944051)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb41.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 5
    Sequence #: 926
    RBA: 19984
    Timestamp: 2012-08-16 16:32:41.000000
    SCN: 2959.3466057953 (12712274286817)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb39.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 5
    Sequence #: 926
    RBA: 20480
    Timestamp: 2012-08-16 16:32:41.000000
    SCN: 2959.3466057953 (12712274286817)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb39.log

  BR Previous Recovery Checkpoint:
    Thread #: 5
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 5
    Sequence #: 926
    RBA: 12800
    Timestamp: 2012-08-16 16:31:26.000000
    SCN: 2959.3465857714 (12712274086578)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 5
    Sequence #: 926
    RBA: 12800
    Timestamp: 2012-08-16 16:31:26.000000
    SCN: 2959.3465857714 (12712274086578)
    Redo File:

Read Checkpoint #7

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 8
    Sequence #: 188
    RBA: 2875920
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715183 (12709366944047)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb61.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 8
    Sequence #: 314
    RBA: 44048
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb59.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 8
    Sequence #: 314
    RBA: 44544
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb59.log

  BR Previous Recovery Checkpoint:
    Thread #: 8
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 8
    Sequence #: 314
    RBA: 23040
    Timestamp: 2012-08-16 16:31:23.000000
    SCN: 2959.3465855831 (12712274084695)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 8
    Sequence #: 314
    RBA: 23040
    Timestamp: 2012-08-16 16:31:23.000000
    SCN: 2959.3465855831 (12712274084695)
    Redo File:

Read Checkpoint #8

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 3
    Sequence #: 424
    RBA: 1905603088
    Timestamp: 2012-08-15 16:42:22.000000
    SCN: 2958.2940746352 (12707454007920)
    Redo File: +DG_DB5GGS_AR/oradata/3_424_788700668.dbf

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 3
    Sequence #: 803
    RBA: 2012348944
    Timestamp: 2012-08-16 16:23:54.000000
    SCN: 2959.3464604495 (12712272833359)
    Redo File: Not Available

  Current Checkpoint (position of last record read in the data source):
    Thread #: 3
    Sequence #: 808
    RBA: 1552282952
    Timestamp: 2012-08-16 16:32:30.000000
    SCN: 2959.3466026027 (12712274254891)
    Redo File: Not Available

  BR Previous Recovery Checkpoint:
    Thread #: 3
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 3
    Sequence #: 803
    RBA: 2012348944
    Timestamp: 2012-08-16 16:23:54.000000
    SCN: 2959.3464604495 (12712272833359)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 3
    Sequence #: 808
    RBA: 354321424
    Timestamp: 2012-08-16 16:31:29.000000
    SCN: 2959.3465864764 (12712274093628)
    Redo File:

Read Checkpoint #9

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 7
    Sequence #: 226
    RBA: 2686992
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715191 (12709366944055)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb51.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 7
    Sequence #: 352
    RBA: 52240
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb57.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 7
    Sequence #: 352
    RBA: 52736
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb57.log

  BR Previous Recovery Checkpoint:
    Thread #: 7
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 7
    Sequence #: 352
    RBA: 39952
    Timestamp: 2012-08-16 16:31:29.000000
    SCN: 2959.3465864660 (12712274093524)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 7
    Sequence #: 352
    RBA: 40976
    Timestamp: 2012-08-16 16:31:29.000000
    SCN: 2959.3465864663 (12712274093527)
    Redo File:

Read Checkpoint #10

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 9
    Sequence #: 189
    RBA: 2075152
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715178 (12709366944042)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb70.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 9
    Sequence #: 315
    RBA: 33296
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb68.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 9
    Sequence #: 315
    RBA: 33792
    Timestamp: 2012-08-16 16:32:40.000000
    SCN: 2959.3466057580 (12712274286444)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb68.log

  BR Previous Recovery Checkpoint:
    Thread #: 9
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 9
    Sequence #: 315
    RBA: 20480
    Timestamp: 2012-08-16 16:31:22.000000
    SCN: 2959.3465854347 (12712274083211)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 9
    Sequence #: 315
    RBA: 20480
    Timestamp: 2012-08-16 16:31:22.000000
    SCN: 2959.3465854347 (12712274083211)
    Redo File:

Read Checkpoint #11

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 10
    Sequence #: 188
    RBA: 2400784
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558715086 (12709366943950)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb77.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 10
    Sequence #: 314
    RBA: 43024
    Timestamp: 2012-08-16 16:32:42.000000
    SCN: 2959.3466058270 (12712274287134)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb75.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 10
    Sequence #: 314
    RBA: 43520
    Timestamp: 2012-08-16 16:32:42.000000
    SCN: 2959.3466058270 (12712274287134)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb75.log

  BR Previous Recovery Checkpoint:
    Thread #: 10
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 10
    Sequence #: 314
    RBA: 23552
    Timestamp: 2012-08-16 16:31:23.000000
    SCN: 2959.3465856754 (12712274085618)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 10
    Sequence #: 314
    RBA: 23552
    Timestamp: 2012-08-16 16:31:23.000000
    SCN: 2959.3465856754 (12712274085618)
    Redo File:

Read Checkpoint #12

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 12
    Sequence #: 192
    RBA: 2185232
    Timestamp: 2012-08-15 17:01:06.000000
    SCN: 2959.558712387 (12709366941251)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb97.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 12
    Sequence #: 318
    RBA: 58896
    Timestamp: 2012-08-16 16:32:39.000000
    SCN: 2959.3466057809 (12712274286673)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb95.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 12
    Sequence #: 318
    RBA: 61440
    Timestamp: 2012-08-16 16:32:39.000000
    SCN: 2959.3466057809 (12712274286673)
    Redo File: +DG_DB5GGS_RC_M/oraredo/logb95.log

  BR Previous Recovery Checkpoint:
    Thread #: 12
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-16 00:06:25.277527
    SCN: Not available
    Redo File:

  BR Begin Recovery Checkpoint:
    Thread #: 12
    Sequence #: 318
    RBA: 39936
    Timestamp: 2012-08-16 16:31:25.000000
    SCN: 2959.3465855811 (12712274084675)
    Redo File:

  BR End Recovery Checkpoint:
    Thread #: 12
    Sequence #: 318
    RBA: 39936
    Timestamp: 2012-08-16 16:31:25.000000
    SCN: 2959.3465855811 (12712274084675)
    Redo File:

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 7745
    RBA: 4101554
    Timestamp: 2012-08-16 16:32:46.588671
    Extract Trail: /apps/gg/DB5GGS/trail/aa

CSN state information:
  CRC: A2-D-62-3D
  CSN: Not available

Header:
  Version = 2
  Record Source = A
  Type = 11
  # Input Checkpoints = 12
  # Output Checkpoints = 1

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 12288
  Current Offset = 0

Configuration:
  Data Source = 3
  Transaction Integrity = 1
  Task Type = 0

Status:
  Start Time = 2012-08-16 00:06:45
  Last Update Time = 2012-08-16 16:32:46
  Stop Status = A
  Last Result = 0

Open in new window

0
basirana
Asked:
basirana
  • 2
1 Solution
 
basiranaAuthor Commented:
The output is  all 7 values in single lines as below and group by thread number.

echo $Thread_Number  $Recovery_Checkpoint $Recovery_RBA $Recovery_TS $BR_SEQ $BR_RBA $BR_TS
0
 
ahoffmannCommented:
awk '/Thread/{t=$3}/Sequence/{s=$3}/RBA:/{r=$2}/Timestamp:/{h=$2" "$3}/SCN:/{x=$0}/Redo File/{print t" "s" "r" "h" "s" "r" "x" "x}' your-file|sort -n

# BTW, assumed according your description that $Recovery_RBA == $BR_RBA and  $Recovery_Checkpoint == $BR_SEQ
0
 
basiranaAuthor Commented:
Thanks
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now