Creation of New Online Redolog File.

[Former Member]

Hi,

We are working in SAP 7.0 environment.

My Problem is related to Basis.

In our BI Development system we had schedule AllOffline backup through Brtools.

From last few months backup is geeting finished with warning & the warning is,

BR0335W Status of online redo log file /oracle/BID/mirrlogB/log_g12m2.dbf is INVALID

BR0274W File '/oracle/BID/mirrlogB/log_g12m2.dbf' not found

BR0335W Status of online redo log file /oracle/BID/mirrlogB/log_g14m2.dbf is INVALID

BR0274W File '/oracle/BID/mirrlogB/log_g14m2.dbf' not found.

When i had checked at the O.S level i found that at location /oracle/BID/mirrlogB there is no such file is found.

So i checked in other system at same location files are available.

I think somebody had deleted the respective files; because before the same backup was getting finished successfully.

Now what can i do to remove this warning.

Is it possible to add new file at the same location with same name???????????

please guide me.

Thanks & Regards,

Aasmi.

[Former Member · Accepted solution]

Yes, you may add new a logfile group at the same loaction. But first you will have to drop the old one, because Oracle still knows of it.

The SQL commands described in SAP note 309526 should help.

regards

[Former Member · Accepted solution]

Thanks for your immediate reply.

I am still confused at one point.

See no log file are exist at /oracle/BID/mirrlogB this location but at /oracle/BID/origlogB location two log files are exist namely '/oracle/BID/origlogB' & '/oracle/BID/origlogB'.

Adding new file will not create any problem for Orilog files????

One more question Mirrlog & Orilog are copy of each other?

Regards,

Aasmi.

[Former Member · Accepted solution]

...  two log files are exist namely '/oracle/BID/origlogB' & '/oracle/BID/origlogB'.

That's impossible. Probably names are like

'/oracle/BID/origlogB/log_g1m1.dbf' & '/oracle/BID/origlogB/log_g3m1.dbf'

Adding new logfiles or logfile groups will not cause any problems, but take care to keep names different from the names of existing files!

You shouldn't create single logfiles, but logfile groups, with two members, one in origlog, one in mirrlog. The two members aren't copies, but they are used by Oracle in exactly the same way, just in case one of the is lost. That's because they are crucial for keeping data integrity.

Explaining details can't be the objective of a forum thread. I suggest thoroughly studying the manuals.

regards

Edited by: Joe Bo. on Jun 23, 2009 8:29 AM

[Former Member · Accepted solution]

Yeah ,

You are right.

Files are namely log_g12m1.dbf & log_g14m1.dbf .

Thanks.