Standby Logs Not Applying.... - File.lock.bra in PRD

[former_member199632]

Hello

In our PRD there is a lock file under /oracle/PRD/saparch

File is; .lock.bra

Please let me know whats the purpose of this file. Is it harmful to delete this?

In our Standby Server archive logs are not applying. It fails.

Can it be due to this file in PRD?

(Logs are shipping correctly to Standby, But its not applying there)

In Standby there is no such lock file.

brapply command is as follows;

1. brarchive -u system/systempwd -c -f -d disk -m 30 -sd

Standby DB is in MOUNT state.

Standby log is as follows;

-

---

[http://notepad.cc/sbserver|http://notepad.cc/sbserver]

Please let me know , how to resolve this

regards,

zerandib

[sunny_pahuja2 · Accepted solution]

Hi,

This file is lock file for brtools. When you use brtools that time it make lock of brtools. You can rename this file if no brtools session is running. This cannot be the reason that you are not able to apply archive logs on stand by server. Please check alert log on your standby server.

Thanks

Sunny

[former_member199632 · Accepted solution]

Hi Sunny,

Can you please help me with the log

[http://notepad.cc/sbserver|http://notepad.cc/sbserver]

regards,

Zerandib

[former_member189725 · Accepted solution]

can you please check if the standby database is running and the state of the database.

[sunny_pahuja2 · Accepted solution]

Hi,

There could be multiple reason for this.

On your primary side, you are getting below error:

ORA-01017: invalid username/password; logon denied

Please check SAP note 1576837.

On secondary, you are getting error:

SP2-0734: unknown command

Please try to update brtools and then try.

Thanks

Sunny

[former_member199632 · Accepted solution]

Hello Sunny,

Error is not in primary side

Its occurring in stand by server, which is in MOUNT state

As said in sap note , its not possible to change the password as follows, coz its in mount state

#alter user system identified by <newPW>;

any idea....

regards,

Zerandib

[former_member199632 · Accepted solution]

Hello , Ratnajit

yes Standby server is up and running

but brapply fails

1. brarchive -u system/systempwd -c -f -d disk -m 30 -sd

regards,

zerandib

[former_member189725 · Accepted solution]

can you check the role of the database .

Is it standby or primary ??

login as ora <sid>

sqlplus "/as sysdba"

select DATABASE_ROLE from v$database;

It should be standby .

[former_member199632 · Accepted solution]

Yes, I have checked it

It shows as "PHYSICAL STANDBY"

regards,

Zerandib

[former_member189725 · Accepted solution]

Do you know the password of the user system in the primary server ?

If so , give the correct password of the system user in the brarchive options in the standby server .

[former_member199632 · Accepted solution]

I have tried like that as well.

(Providing the SYSTEM user password in primary server)

Still no success

Please check the logs here;

[http://notepad.cc/logsamples|http://notepad.cc/logsamples]

error (Applying fail) occurred from PRDarch1_24079_696018700 onwards. Till then, its successful

regards,

Zerandib

[former_member199632 · Accepted solution]

I have tried like that as well

Still no success

Please check the logs here;

[http://notepad.cc/logsamples|http://notepad.cc/logsamples]

error (Applying fail) occurred from PRDarch1_24079_696018700 onwards. Till then, its successful

regards,

Zerandib

[former_member199632 · Accepted solution]

Hello Ratnajit ,

Any idea about this..... Can this be the issue.

These lines shows , when execute the brapply (brarchive -u system/systempwd -c -f -d disk -m 30 -sd) command

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 18 10:02:49 2012

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> SQL> Connected.

SQL>

SQL> SQL> ORA-00279: change 1512738441 generated at 01/16/2012 16:15:42 needed for thread 1

ORA-00289: suggestion : /oracle/PRD/oraarch/standby/PRDarch1_24080_696018700.dbfORA-00280: change 1512738441 for thread 1 is in sequence #24080

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00310: archived log contains sequence 24079; sequence 24080 required

ORA-00334: archived log: '/oracle/PRD/oraarch/standby/PRDarch1_24079_696018700.dbf'

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0734: unknown command beginning "/oracle/PR..." - rest of line ignored.SQL> SP2-0042: unknown command "cancel" - rest of line ignored.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

BR0280I BRARCHIVE time stamp: 2012-01-18 10.02.52

BR0279E Return code from '/oracle/PRD/102_64/bin/sqlplus /nolog < /oracle/PRD/saparch/.aehroujx.spi': 0

BR0302E SQLPLUS call for database instance PRD/STANDBY failed

BR0338E Applying offline redo log file /oracle/PRD/oraarch/standby/PRDarch1_24079_696018700.dbf failed

Any idea , whats mean by this.....

[former_member189725 · Accepted solution]

can you check for the user ora<sid> in the standby server which shell it is using .

1. echo $SHELL

If different than C shell , change it to C shell.

In the /etc/passwd change the shell to C .

Edited by: Ratnajit Dey on Jan 18, 2012 12:53 PM

[former_member199632 · Accepted solution]

Hi, all

At last... the issue was due to corrupted log-file

regards

Zerandib

[former_member189725]

You can delete this file without any problem if there is no brarchive process is running in the system. This file is created in its working directory when brarchive starts running .

Check if archive logs are getting shipped to the standby server.

[former_member199632]

Hello Ratnajit ,

Logs are shipping to standby server successfully.

Logs are there in /oracle/PRD/oraarch

The issue is its not applying

Any suggestions pls

regards,

Zerandib