brbackup finished with return code 3; for online backup database must be in archeivelog mode...

[Former Member]

THREAD LOCKED BY MODERATOR. FAQ.

Hi everyone,

I am a Beginner of SAP BASIS . i want to do online backup with the use of BRTOOLS, but i faced some errors. I am not able to understand how to rectify this. Can any one help me out this?

here is the error faced in brtools

BR0051I BRBACKUP 7.20 (17)

BR0055I Start of database backup: bepfcbxt.and 2014-11-17 11.47.49

BR0484I BRBACKUP log file: D:\oracle\IDS\sapbackup\bepfcbxt.and

BR0477I Oracle pfile D:\app\Administrator\product\11.2.0\dbhome_1\database\initI

DS.ora created from spfile D:\app\Administrator\product\11.2.0\dbhome_1\database

\spfileIDS.ora

BR0280I BRBACKUP time stamp: 2014-11-17 11.47.54

BR0319I Control file copy created: D:\oracle\IDS\sapbackup\CNTRLIDS.DBF 39206912

BR0066E For online backup, the database must be in ARCHIVELOG mode

BR0056I End of database backup: bepfcbxt.and 2014-11-17 11.47.56

BR0280I BRBACKUP time stamp: 2014-11-17 11.47.56

BR0054I BRBACKUP terminated with errors

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 3

BR0280I BRTOOLS time stamp: 2014-11-17 11.47.56

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

I have also attached log file in sapbackup folder in oracle.

bepfcbxt.txt.zip

[Former Member · Accepted solution]

Hi Mani,

BR0066E For online backup, the database must be in ARCHIVELOG mode

As Suggested you have to enable Archive log

You can check Archive log in sql thru command

SQL> archive log list

Example --

SQL> archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 2296

Current log sequence 2299

OR

SQL> select log_mode from v$database;

LOG_MODE

------------

NOARCHIVELOG

Enabling Archive Log

SQL> STARTUP MOUNT

SQL> ALTER DATABASE ARCHIVELOG;

Database altered.

SQL> ALTER DATABASE OPEN;

Regards,

Abhishek

[Former Member · Accepted solution]

Thnks for your step by step answers. some other error came with return code 5

[Former Member · Accepted solution]

Hi,

Please let us know, If Issue has been resolved or you need further help/support

Thanks!!

Regards,

Abhi

[former_member207186 · Accepted solution]

Hello,

Could you please provide the latest backup log (maybe some other error occured this time with return code 5).

Regards,

Bíborka

[hemanth2 · Accepted solution]

Hi Mani,

Hope you are doing good.
Nice to hear from you again.

For an online backup the database must be in ARCHIVELOG mode, because if not, the backup is useless later. Regarding the ARCHIVELOG mode, there should be no problem in creating archive logs during online reorganization.

Thank you!
____________
Kind Regards,
Hemanth
SAP AGS

[ankit_gupta32]

Hello Mani,

We understood from you that archivelog mode is enabled now. Now, you are mentioning the error code as 5 which is probably the error while backing up the database. So, there could be the problem with target storage. Is it a tape or disk where you want to backup ?

Can you check the backup log and look for errors ?

Regards,

Ankit

[Former Member]

BR0066E For online backup, the database must be in ARCHIVELOG mode.

Crystal Clear - DB should be in Archive log mode.

[former_member207186]

Hello,

As suggested you should enable Archive log mode.

You can only carry out an online backup if the ARCHIVELOG mode is active.This ensures that the online redo log files are archived in the archiving directory before they are overwritten during a redo log file switch.

For more details about BR0066E, please refer to SAP note #17163- "BRARCHIVE/BRBACKUP messages and codes".

Regards,

Bíborka

[former_member182657]

BR0066E For online backup, the database must be in ARCHIVELOG mode

Please enable the archive log mode and retry the backup again, same has already been suggested above.

Regards,

Gaurav

[divyanshu_srivastava3]

BR0066E For online backup, the database must be in ARCHIVELOG mode

Enable archive logs and then start online backup.

Refer: ARCHIVELOG mode for SAP with Oracle - Basis Corner - SCN Wiki

Regards,

[Former Member]

Thanks for you reply. i have set archivelog mode and it started also, but it comes again some error with return code 5

[divyanshu_srivastava3]

You need to 1st stop the AP and database.

Then mount DB and enable archiving and at last open it.

Once this is done, start SAP and rerun brbackup and share the logs.

[ACE-SAP]

Hi

You could activate Oracle archiving without stopping the SAP system, as the SAP system can stay up if the DB is down. Active users will get disconnected but a least you keep the data that is stored in the SAP buffers.

Share the detailed log as it is not possible to diagnose based only on error message number...

Regards