Skip to Content
author's profile photo Former Member
Former Member

Oraarch log backup is not working

Hello Experts,

I have an issue in a system with Oracle system.

Oracle log backup is not running successfully during automatic backup which runs every 4 hours or manual which we are running as it is filled.

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

nlyehvdcs4vuf27:oraac5 214> more aerufyrw.cds

BR0002I BRARCHIVE 7.00 (46)

BR0006I Start of offline redo log processing: aerufyrw.cds 2015-11-07 02.03.04

BR0484I BRARCHIVE log file: /oracle/SID/saparch/aerufyrw.cds

BR0477I Oracle pfile /oracle/SID/102_64/dbs/initSID.ora created from spfile /oracle/sid/102_64/dbs/spfileSID.ora

BR0101I Parameters

Name Value

oracle_sid SID

oracle_home /oracle/SID/102_64

oracle_profile /oracle/SID/102_64/dbs/initSID.ora

sapdata_home /oracle/SID

sap_profile /oracle/SID/102_64/dbs/initSID-arch_prim.sap

backup_dev_type util_file

util_par_file /oracle/SID/102_64/dbs/initSID-arch_prim.utl

archive_dupl_del only

system_info orasid/orasid hostname Linux 3.0.76-0.11-default #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990) x86_64

oracle_info SID 10.2.0.5.0 8192 495 9344008117592 nlyehvdcs4vuf27 US7ASCII AL16UTF16

sap_info 46C SAPSR3 SID Q0953831414 R3_ORA 0810000342

make_info linuxx86_64 OCI_102 Jan 29 2010

command_line /usr/sap/SID/SYS/exe/run/brarchive -c force -u / -d util_file -n 50 -p /oracle/SID/102_64/dbs/initSID-arch_prim.sap

BR0013W No offline redo log files found for processing

BR0007I End of offline redo log processing: aerufyrw.cds 2015-11-07 02.03.05

BR0280I BRARCHIVE time stamp: 2015-11-07 02.03.05

BR0004I BRARCHIVE completed successfully with warnings

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

There are files in the oraarch directory to be backed up as shown below:

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

hostname:orasid 217> df -h .

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/vgsiddb_2-lv_oraarch 4.0G 3.0G 1.1G 75% /oracle/SID/oraarch

hostname:orasid 218> ls -ltr

total 3091956

-rw-r----- 1 orasid dba 90646016 Oct 8 17:07 SIDarch1_367_877867423.dbf

-rw-r----- 1 orasid dba 30208 Oct 8 17:07 SIDarch1_368_877867423.dbf

-rw-r----- 1 orasid dba 9216 Oct 8 17:08 SIDarch1_369_877867423.dbf

-rw-r----- 1 orasid dba 12800 Oct 8 17:08 SIDarch1_370_877867423.dbf

-rw-r----- 1 orasid dba 3584 Oct 8 17:08 SIDarch1_371_877867423.dbf

-rw-r----- 1 orasid dba 4096 Oct 8 17:09 SIDarch1_372_877867423.dbf

-rw-r----- 1 orasid dba 2048 Oct 8 17:09 SIDarch1_373_877867423.dbf

-rw-r----- 1 orasid dba 17007104 Oct 9 00:59 SIDarch1_374_877867423.dbf

-rw-r----- 1 orasid dba 1024 Oct 9 00:59 SIDarch1_375_877867423.dbf

-rw-r----- 1 orasid dba 27648 Oct 9 00:59 SIDarch1_376_877867423.dbf

-rw-r----- 1 orasid dba 1024 Oct 9 01:01 SIDarch1_377_877867423.dbf

---------

---------

-rw-r----- 1 orasid dba 252601344 Nov 4 01:05 SIDarch1_485_877867423.dbf

-rw-r--r-- 1 orasid dba 0 Nov 4 18:19 archive

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

I got some screenshots from trace files of drc ( this has a standby db also , files are moving to standby - no problem with LAG part in db.

I have attached file with trace file screenshots.

PLEASE HELP ME ON THIS 😊 .

Thanks and regards,

Uday

AC5 3.png (10.8 kB)
AC5 2.png (33.6 kB)
ac5.png (19.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2015 at 10:55 AM

    Hello,

    Also as found below , in archSID.log , the files in oraarch and backed up and deleted

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

    #

    #ARCHIVE.. 483 /oracle/SID/oraarch/SIDarch1_483_877867423.dbf 2015-11-04 00.56.29 252602368 9344007975520 1

    #SAVED.... aertrprb cds *1446638439 2015-11-04 04.00.49 ........... ............

    #COPIED... aertskzs cds *1446652887 2015-11-04 08.02.15 ........... ............

    #DELETED.. aertskzs cds 2015-11-04 08.02.15

    #

    #ARCHIVE.. 484 /oracle/SID/oraarch/SIDarch1_484_877867423.dbf 2015-11-04 01.00.55 252598272 9344008008344 1

    #SAVED.... aertrprb cds *1446638435 2015-11-04 04.00.46 ........... ............

    #COPIED... aertskzs cds *1446652886 2015-11-04 08.02.12 ........... ............

    #DELETED.. aertskzs cds 2015-11-04 08.02.12

    #

    #ARCHIVE.. 485 /oracle/SID/oraarch/SIDarch1_485_877867423.dbf 2015-11-04 01.05.31 252601344 9344008010441 1

    #SAVED.... aertrprb cds *1446638426 2015-11-04 04.00.36 ........... ............

    #COPIED... aertskzs cds *1446652879 2015-11-04 08.02.09 ........... ............

    #DELETED.. aertskzs cds 2015-11-04 08.02.09

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


    NOTE : THE LAST FILE IN PRIMARY ORAARCH DIRECTORY IS 485.



    -rw-r----- 1 oraSID dba 252598272 Nov 4 01:00 SIDarch1_484_877867423.dbf

    -rw-r----- 1 oraSID dba 252601344 Nov 4 01:05 SIDarch1_485_877867423.dbf

    -rw-r--r-- 1 oraSID dba 0 Nov 4 18:19 archive

    nlyehvdcs4vuf27:oraSID 240>




    WHILE IN STANDBY ,



    rw-r----- 1 oraSID dba 2507776 Nov 5 14:29 SIDarch1_492_877867423.dbf

    -rw-r----- 1 oraSID dba 51200 Nov 5 14:33 SIDarch1_493_877867423.dbf

    -rw-r----- 1 oraSID dba 1536 Nov 5 14:34 SIDarch1_494_877867423.dbf

    nlyehvdcs4vuf28:oraSID 69>

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

    please help me understand this - why oraarch is 75% eventhough files are backed up and deleted as shown above .

    2.) why primary does not show files from 485 to 494 anywhere though they are already moved to standby.
    ( as shown above)

    IN STANDBY ALERT LOG ,

    Thu Nov 05 14:34:21 PST 2015

    Recovery of Online Redo Log: Thread 1 Group 5 Seq 495 Reading mem 0

    Mem# 0: /oracle/AC5/standbylog/srl1.dbf

    RSM0 started with pid=13, OS id=9983

    Expecting a reply,

    THANKS,

    Uday

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2015 at 04:19 AM

    Hi Udaya ,

    As i have seen in AC5 2 .png screen .

    Please check the space in Backup directory also if it is a Tap .

    If the space is available ..try with different TAP or backup location .

    Thanks and Regards

    Patel Harshal

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.