Skip to Content
0
Former Member
Jul 21, 2009 at 01:50 PM

restore with brtools - need more archive redolog files

411 Views

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