How to create formatted output from oracle database log file?

[Kirill Cherkashin]

We have oracle standby database logs files. I'd like to create output file with next entries:

date name of file.

How I could accomplish this?
pls. find below typical output from log file:

ORA-00279: change 104641228 generated at 06/04/2002 22:41:24 needed for thread 1
ORA-00289: suggestion : /oradata/archive/36011.rdo
ORA-00280: change 104641228 for thread 1 is in sequence #36011
ORA-00278: log file '/oradata/archive/36010.rdo' no longer needed for this recovery
Log applied.

[harry d brown jr]

In your example, do you want to log 36010 or 36011?

with awk or perl you can do this.

live free or die
harry

[Kirill Cherkashin]

The last one.

[Graham Cameron_1 · Accepted solution]

In that case:
awk '
/^ORA-00279/ {dattim = $6 $7}
/^ORA-00278/ {print dattim, $4}
' < ALERT_FILENAME >> OUTPUT_FILENAME

Where
ALERT_FILENAME is the name of the 'log file' you describe
and
OUTPUT_FILENAME is the output file you want to create

- Graham

[Aashish Raj]

Hi, Instead of getting this info from the alert.log, you can also get this information from v$log_history view of standby database.
select sequence#,first_time from v$log_history;

hth
AR