Skip to Content
avatar image
Former Member

restore with brtools - need more archive redolog files

Good day

I will make online backup my oracle database with brtools

(Oracle 10g, BRBACKUP 7.00 (39))

brbackup -c -d util_file_online -t online -m all -u /

-


bdztoexw anf 2009-01-23 15.27.40 ; 2009-01-23 16.47.21 ; 1 ............... 57 56 0 17671 226215105 17676 226268039 ALL

online util_file_online -


7.00 (39)

BR0280I BRBACKUP time stamp: 2009-01-23 16.43.38

-


BR0232I 57 of 57 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2009-01-23 16.43.40

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

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

BR0117I ARCHIVE LOG LIST after backup for database instance VPP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/VPP/oraarch/VPParch

Archive format %t_%s_%r.dbf

Oldest online log sequence 17673

Next log sequence to archive 17676

Current log sequence 17676 SCN: 226268039

Database block size 8192 Thread: 1

Current system change number 226268041 ResetId: 603135330

-


After brbackup I'll do "brarchive" in the same script:

brarchive -c -d util_file -sd -u / > $br_out_file

-


#ARCHIVE.. 17670 /oracle/VPP/oraarch/VPParch1_17670_603135330.dbf ; 2009-01-23 15.10.36 ; 43450368 226202112 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17671 /oracle/VPP/oraarch/VPParch1_17671_603135330.dbf ; 2009-01-23 15.36.12 ; 43430912 226215105 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17672 /oracle/VPP/oraarch/VPParch1_17672_603135330.dbf ; 2009-01-23 15.40.27 ; 43515904 226227928 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17673 /oracle/VPP/oraarch/VPParch1_17673_603135330.dbf ; 2009-01-23 15.41.06 ; 43729408 226238784 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17674 /oracle/VPP/oraarch/VPParch1_17674_603135330.dbf ; 2009-01-23 16.06.06 ; 43450368 226250315 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17675 /oracle/VPP/oraarch/VPParch1_17675_603135330.dbf ; 2009-01-23 16.43.40 ; 13243904 226263012 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

  • VPP util_file adztolzu svd 2009-01-23 16.47.22 ; 2009-01-23 16.54.47 ; 1 ........... 17670 17675 0 0 ------- 7.00 (39) @0603135330

  • -


    BR0280I BRARCHIVE time stamp: 2009-01-23 16.51.11

    BR0232I 6 of 6 files saved by backup utility

    BR0230I Backup utility called successfully

    BR0016I 6 offline redo log files processed, total size 220.128 MB

    -


    Then I take tape with this data and try restore only from this tape

    all datafiles and relevant archive redologs files (17670-17675) restored without errors

    but in the end ERROR occurred

    -


    ERROR at line 1:

    ORA-01195: online backup of file 1 needs more recovery to be consistent

    ORA-01110: data file 1: '/oracle/VPP/sapdata1/system_1/system.data1'

    ORA-00279: change 226268039 generated at 01/23/2009 16:43:40 needed for thread

    1

    ORA-00289: suggestion : /oracle/VPP/oraarch/VPParch1_17676_603135330.dbf

    ORA-00280: change 226268039 for thread 1 is in sequence #17676

    -


    My online backup ended, before switch to redolog 17676

    Why I need this file? I think files (17670-17675) should be enough?

    Besides, the change 226268039 generated exactly at moment Switching to next online redo.

    Can I try open database regardless of this error?

    Thank you for your prompt response

    Andrey Timofeev

    Edited by: Andrey Timofeev on Jul 21, 2009 3:52 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Get RSS Feed

    4 Answers

    • Best Answer
      Jul 21, 2009 at 02:54 PM

      Hi Andrey

      could you please check when 17676 was generated? is that before or after 2009-01-23 16.43.40?

      You could also check archSID.log file for any corruption.

      Add comment
      10|10000 characters needed characters exceeded

      • online_cons will also backup offline redologs necessary for a full recovery. all of this from within brbackup. no need for barchive for this.

        This is very useful for system refresh.

        it also reduce risk during restore as you rely on only one tape and one backup session.

        Note that you still need to run brarchive on a regular basis in case you need to recover point-in-time.

    • Jul 21, 2009 at 01:59 PM

      Hi Andrey,

      please make use of the <code> tags.

      Did you already check whether the files are still in ONLINE BACKUP mode?

      Maybe all you've to do is to "ALTER ... DATAFILE END BACKUP" to get the database open.

      regards,

      Lars

      Add comment
      10|10000 characters needed characters exceeded

    • avatar image
      Former Member
      Jul 21, 2009 at 02:13 PM

      Hi Andrey,

      It looks like that your database need recovery.

      Check SAP Note 424102 - Restarting BRARCHIVE after creating a standby database

      Thanks

      Sunny

      Add comment
      10|10000 characters needed characters exceeded

      • Former Member

        <P>Good day, sorry for TAG. Once more time. <BR>

        I will make online backup my oracle database with brtools<BR>

        (Oracle 10g, BRBACKUP 7.00 (39))</P>

        <P>brbackup -c -d util_file_online -t online -m all -u /</P>

        <HR>

        <P>bdztoexw anf 2009-01-23 15.27.40 2009-01-23 16.47.21 1 ............... 57 56 0 17671 226215105 17676 226268039 ALL<BR>

        online util_file_online </P>

        <HR>

        <P> BR0280I BRBACKUP time stamp: 2009-01-23 16.43.38</P>

        <HR>

        <BR>

        <P>BR0232I 57 of 57 files saved by backup utility<BR>

        BR0230I Backup utility called successfully</P>

        <P>BR0280I BRBACKUP time stamp: 2009-01-23 16.43.40<BR>

        BR0340I Switching to next online redo log file for database instance VPP ...<BR>

        BR0321I Switch to next online redo log file for database instance VPP successful</P>

        <P>BR0117I ARCHIVE LOG LIST after backup for database instance VPP</P>

        <P>Parameter Value</P>

        <P>Database log mode Archive Mode<BR>

        Automatic archival Enabled<BR>

        Archive destination /oracle/VPP/oraarch/VPParch<BR>

        Archive format %t_%s_%r.dbf<BR>

        Oldest online log sequence 17673<BR>

        Next log sequence to archive 17676<BR>

        Current log sequence 17676 SCN: 226268039<BR>

        Database block size 8192 Thread: 1<BR>

        Current system change number 226268041 ResetId: 603135330</P>

        <HR>

        <BR>

        <P>After brbackup I'll do &quot;brarchive&quot; in the same script:</P>

        <P>brarchive -c -d util_file -sd -u / &gt; $br_out_file</P>

        <HR>

        <P>#ARCHIVE.. 17670 /oracle/VPP/oraarch/VPParch1_17670_603135330.dbf 2009-01-23 15.10.36 43450368 226202112 1<BR>

        #SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

        #COPIED... ........ ... ................. .......... ........ ........... ............<BR>

        #DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

        #<BR>

        #ARCHIVE.. 17671 /oracle/VPP/oraarch/VPParch1_17671_603135330.dbf 2009-01-23 15.36.12 43430912 226215105 1<BR>

        #SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

        #COPIED... ........ ... ................. .......... ........ ........... ............<BR>

        #DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

        #<BR>

        #ARCHIVE.. 17672 /oracle/VPP/oraarch/VPParch1_17672_603135330.dbf 2009-01-23 15.40.27 43515904 226227928 1<BR>

        #SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

        #COPIED... ........ ... ................. .......... ........ ........... ............<BR>

        #DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

        #<BR>

        #ARCHIVE.. 17673 /oracle/VPP/oraarch/VPParch1_17673_603135330.dbf 2009-01-23 15.41.06 43729408 226238784 1<BR>

        #SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

        #COPIED... ........ ... ................. .......... ........ ........... ............<BR>

        #DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

        #<BR>

        #ARCHIVE.. 17674 /oracle/VPP/oraarch/VPParch1_17674_603135330.dbf 2009-01-23 16.06.06 43450368 226250315 1<BR>

        #SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

        #COPIED... ........ ... ................. .......... ........ ........... ............<BR>

        #DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

        #<BR>

        #ARCHIVE.. 17675 /oracle/VPP/oraarch/VPParch1_17675_603135330.dbf 2009-01-23 16.43.40 13243904 226263012 1<BR>

        #SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

        #COPIED... ........ ... ................. .......... ........ ........... ............<BR>

        #DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

        #<BR>

        1. VPP util_file adztolzu svd 2009-01-23 16.47.22 2009-01-23 16.54.47 1 ........... 17670 17675 0 0 </P>

        <HR>

        <P>#</P>

        <HR>

        <P>BR0280I BRARCHIVE time stamp: 2009-01-23 16.51.11<BR>

        BR0232I 6 of 6 files saved by backup utility<BR>

        BR0230I Backup utility called successfully<BR>

        BR0016I 6 offline redo log files processed, total size 220.128 MB</P>

        <HR>

        <P>Then I take tape with this data and try restore only from this tape<BR>

        all datafiles and relevant archive redologs files (17670-17675) restored without errors <BR>

        but in the end ERROR occurred</P>

        <HR>

        <BR>

        <P>ERROR at line 1:<BR>

        ORA-01195: online backup of file 1 needs more recovery to be consistent<BR>

        ORA-01110: data file 1: '/oracle/VPP/sapdata1/system_1/system.data1'</P>

        <P>ORA-00279: change 226268039 generated at 01/23/2009 16:43:40 needed for thread<BR>

        1<BR>

        ORA-00289: suggestion : /oracle/VPP/oraarch/VPParch1_17676_603135330.dbf<BR>

        ORA-00280: change 226268039 for thread 1 is in sequence #17676</P>

        <HR>

        <BR>

        <P>My online backup ended, before swith to redolog 17676<BR>

        Why I need this file? I think files (17670-17675) should be enough?</P>

        <P>Besides, the cange 226268039 generated exactly at moment Switching to next online redo.<BR>

        Can I try open database regardless of this error?</P>

        <BR>

        <P>Thank you for your prompt response<BR>

        Andrey Timofeev</P>

        Edited by: Andrey Timofeev on Jul 21, 2009 4:53 PM

        Edited by: Andrey Timofeev on Jul 21, 2009 4:54 PM

    • Jul 21, 2009 at 03:06 PM

      shutdown you database.

      rename all your online redologs. do not delete, just rename or move just in case you need them later.

      try starting DB again

      recover again if needed.

      good luck.

      Add comment
      10|10000 characters needed characters exceeded

      • Former Member Eric Brunelle

        <P>

        I use script from NetBackup SAP Agent with include 2 command

        brbackup -c -d util_file_online -t online -m all -u /

        brarchive -c -d util_file -sd -u /

        What the difference between this script and online_cons options?

        They should be same, am I right?

        Can I make conclusion, that NetBackup script wrong, and not work properly?

        I have not VPParch1_17676_603135330.dbf but seems to me this file not important.

        Possibly it contain information about switching online redologs?

        How can I see what contain in change 226268039 ?

        </P>