Redo log sequence number

[Former Member]

hi everyone,

I am looking at our SB system, and try to do only redo log backup. however it comes back with error message: The current redo log sequence number is not greater than the sequence number of the last saved offline redo log file.

So, we suspect that since last refresh, we may reset the sequence back from 1. Any one know how to solve this problem? Thanks in advance.

Amy

[Former Member]

Hi,

Is your probh solved?

Can u pl tell if u executed a recovery of database earlier?

Pl check if there was a case of reset logs.

To do this run BRTOOLS-->Instance Mgt->Show Inst Status.

This will show if there was a case of reset logs.

If it is so try the following:

Shut down sap and the database.

Look for a folder named oraarch

Oracle/sid/oraarch

Copy all the archive files to another folder and delete all the arc files from the oraarch folder.

The name of the arch files will be like <SID>ARCHARC123456.001

After copying to another location and subsequently deleting them from oraarch folders start up oracle in mount mode.

Then issue the following sql

alter database open resetlogs;

then start sap.

NB:Dont forget to take a complete backup before and after diong this.

Hope this will help.

Most probably your database contains two icarnations of redo log files so this error is comming.

regards

[Former Member]

Hi Amy,

Can u pl quote the Error Message No.

Did it so happened that u have recovered this database sometime?

If it is so , most probably the database was opened without resetting the logs.to reset the logs the following sql command is to be executed

sql>alter system open resetlogs;

This may help.

Regards