Online backup with redolog failed on newly installed SAP server

[Former Member]

Dear All,

Pls check the below log which was taken newly installed SAP server .

BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: beflcufp.and 2011-03-14 15.32.17

BR0484I BRBACKUP log file: D:\oracle\IBQ\sapbackup\beflcufp.and

BR0252W Function remove() failed for 'D:\oracle\IBQ\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'D:\oracle\IBQ\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file D:\oracle\IBQ\102\database\initIBQ.ora - default assumed

BR0274W File 'D:\oracle\IBQ\102\database\CTL1IBQ.ORA' not found

BR0280I BRBACKUP time stamp: 2011-03-14 15.32.20

BR0319I Control file copy created: D:\oracle\IBQ\sapbackup\CNTRLIBQ.DBF 12664832

BR0063I 17 of 17 files processed - 26652.203 MB of 26652.203 MB done

BR0204I Percentage done: 100.00%, estimated end time: 15:56

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2011-03-14 15.56.42

BR0340I Switching to next online redo log file for database instance IBQ ...

BR0321I Switch to next online redo log file for database instance IBQ successful

BR0117I ARCHIVE LOG LIST after backup for database instance IBQ

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination D:\oracle\IBQ\oraarch\IBQarch

Archive format ARC%S_%R.%T

Oldest online log sequence 308

Next log sequence to archive 311

Current log sequence 311 SCN: 2870470

Database block size 8192 Thread: 1

Current system change number 2870472 ResetId: 745348120

BR0017E Offline redo log file 'D:\oracle\IBQ\102\RDBMS\ARC00310_0745348120.001' not found

BR0056I End of database backup: beflcufp.and 2011-03-14 15.56.43

BR0280I BRBACKUP time stamp: 2011-03-14 15.56.43

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2011-03-14 15.56.43

BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20110314153206 -d disk -c force -p initIBQ.sap -cds'

BR0280I BRBACKUP time stamp: 2011-03-14 15.56.44

BR0292I Execution of BRARCHIVE finished with return code 3

Regards

[Former Member]

i ma closing this forum

[former_member204746]

setup environment variables such as:

ORACLE_SID

ORACLE_HOME

[Former Member]

Dear all,

Backup got failed pls check below logs (Note : Kernal also upgraded and ORACLE_SID

ORACLE_HOME also set .

BR0063I 17 of 17 files processed - 26652.203 of 26652.203 MB done

BR0204I Percentage done: 100.00%, estimated end time: 15:27

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2011-03-16 15.27.46

BR0340I Switching to next online redo log file for database instance IBQ ...

BR0321I Switch to next online redo log file for database instance IBQ successful

BR0117I ARCHIVE LOG LIST after backup for database instance IBQ

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination D:\oracle\IBQ\oraarch\IBQarch

Archive format ARC%S_%R.%T

Oldest online log sequence 312

Next log sequence to archive 315

Current log sequence 315 SCN: 2952702

Database block size 8192 Thread: 1

Current system change number 2952704 ResetId: 745348120

BR0018I Waiting for the next offline redo log file...

BR0202I Saving space_log

BR0203I to D:\oracle\IBQ\sapbackup\IBQ ...

BR0202I Saving D:\oracle\IBQ\sapbackup\beflmnyz.and

BR0203I to D:\oracle\IBQ\sapbackup\IBQ ...

BR0202I Saving D:\oracle\IBQ\sapbackup\backIBQ.log

BR0203I to D:\oracle\IBQ\sapbackup\IBQ ...

BR0056I End of database backup: beflmnyz.and 2011-03-16 15.27.54

BR0280I BRBACKUP time stamp: 2011-03-16 15.27.55

BR0053I BRBACKUP completed successfully with warnings

BR0280I BRBACKUP time stamp: 2011-03-16 15.27.55

BR0053I BRBACKUP completed successfully with warnings

BR0280I BRBACKUP time stamp: 2011-03-16 15.27.55

BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20110316151050 -c force -p initIBQ.sap -cds'

BR0280I BRBACKUP time stamp: 2011-03-16 15.27.57

BR0292I Execution of BRARCHIVE finished with return code 3

BRArchive is not done ,

Kindly advise.

[sivakumar_kilari3]

Which user ID you are using?

[Former Member]

Dear all

OFFLine with redolog Backup also we cant taken through DB13 .

[Former Member]

we are using sidadm for taking backups ....

[sivakumar_kilari3]

Can you post this log.

BR0202I Saving D:\oracle\IBQ\sapbackup\backIBQ.log

[Former Member]

We are taking backup through Disk , let me know which option i have to choose below for Archive.

-s Create the first copy of offline redo log files

-sd Create the first copy and delete

-ss Create the first and the second copy in parallel

-ssd Create the first, second copy in parallel and delete

-sc Create the second copy of offline redo log files

-scd Create the second copy and delete

-cs Create the second and the first copy serial

-cds Create the second copy, delete and the first copy serial

-ds Delete the offline redo log files after the first copy

-dc Delete the offline redo log files after the second copy

backIBQ.log :

beflhbre and 2011-03-15 12.27.54 2011-03-15 12.50.15 0 ............... 17 16 0 312 2897363 313 2910521 ALL online disk a----c 7.00 (48)

beflhihk afd 2011-03-15 13.42.32 0000-00-00 00.00.00 6 ............... ..... ..... ..... ........ ................ ........ ................ ............ ............... ................ ...... 7.00 (48)

beflmnyz and 2011-03-16 15.11.09 2011-03-16 15.27.54 1 ............... 17 16 0 314 2940078 315 2952702 ALL online disk a----c 7.00 (48)

beflmutj afd 2011-03-16 16.27.35 0000-00-00 00.00.00 6 ............... ..... ..... ..... ........ ................ ........ ................ ............ ............... ................ ...... 7.00 (48)

[Former Member]

We are taking backup on Disk , let me know which option i have to choose below for Archive.

-s Create the first copy of offline redo log files

-sd Create the first copy and delete

-ss Create the first and the second copy in parallel

-ssd Create the first, second copy in parallel and delete

-sc Create the second copy of offline redo log files

-scd Create the second copy and delete

-cs Create the second and the first copy serial

-cds Create the second copy, delete and the first copy serial

-ds Delete the offline redo log files after the first copy

-dc Delete the offline redo log files after the second copy

backIBQ.log :

beflhbre and 2011-03-15 12.27.54 2011-03-15 12.50.15 0 ............... 17 16 0 312 2897363 313 2910521 ALL online disk a----c 7.00 (48)

beflhihk afd 2011-03-15 13.42.32 0000-00-00 00.00.00 6 ............... ..... ..... ..... ........ ................ ........ ................ ............ ............... ................ ...... 7.00 (48)

beflmnyz and 2011-03-16 15.11.09 2011-03-16 15.27.54 1 ............... 17 16 0 314 2940078 315 2952702 ALL online disk a----c 7.00 (48)

beflmutj afd 2011-03-16 16.27.35 0000-00-00 00.00.00 6 ............... ..... ..... ..... ........ ................ ........ ................ ............ ............... ................ ...... 7.00 (48)

[sivakumar_kilari3]

Check the permissions for this folders

D:\oracle\IBQ\oraarch

D:\oracle\IBQ\oraarch\IBQarch

[Former Member]

Its windows server ........

only the below directory is there D:\oracle\IBQ\oraarch ...

there is no D:\oracle\IBQ\oraarch/IBQarch

Edited by: satheesh0812 on Mar 16, 2011 12:41 PM

[sivakumar_kilari3]

>

> Its windows server ........

>

> only the below directory is there D:\oracle\IBQ\oraarch ...

>

> there is no D:\oracle\IBQ\oraarch/IBQarch

>

> Edited by: satheesh0812 on Mar 16, 2011 12:41 PM

I know its windows server.

Do you know how to check the permissions for the folders.?

[Former Member]

Please, check parameter log_archive_dest in initSID.ora

[Former Member]

SQL> connect /as sysdba

Connected.

SQL> show parameter log_archive_dest;

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_dest string D:\oracle\IBQ\oraarch\IBQarch

log_archive_dest_1 string

log_archive_dest_10 string

log_archive_dest_2 string

log_archive_dest_3 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_dest_state_1 string enable

log_archive_dest_state_10 string enable

log_archive_dest_state_2 string enable

log_archive_dest_state_3 string enable

log_archive_dest_state_4 string enable

log_archive_dest_state_5 string enable

log_archive_dest_state_6 string enable

log_archive_dest_state_7 string enable

log_archive_dest_state_8 string enable

log_archive_dest_state_9 string enable

SQL>

[Former Member]

It's looks like strange:

1. Archive destination D:\oracle\IBQ\oraarch\IBQarch

2. only the below directory is there D:\oracle\IBQ\oraarch ...

there is no D:\oracle\IBQ\oraarch/IBQarch

3. BR0017E Offline redo log file 'D:\oracle\IBQ\102\RDBMS\ARC00310_0745348120.001' not found

Try to create subfolder IBQarch.

Where is arc* files are stored now?

[sivakumar_kilari3]

BR0252W Function remove() failed for 'D:\oracle\IBQ\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

Are you executing this tool in <SID>ADM user?

thanks,

Siva

[Former Member]

Hi,

Firstly update you brtools / Kernels they are well old....

Second what is your system details and how are you running this ?

Mark