BR0439E No offline redolog files found in ..processing for device type TAPE/BACKINT/RMAN in recovery interval

Error:

brrestore -a 265931-265933=/oracle/PRD/oraarch/ -r /oracle/PRD/102 _64/dbs/initPRD.utl

BR0401I BRRESTORE 7.20 (33)
BR0405I Start of file restore: remjonan.rsa 2013-10-24 15.04.25
BR0484I BRRESTORE log file: /oracle/PRD/sapbackup/remjonan.rsa

BR0461W Redolog sequence number in line 1830920 of /oracle/PRD/saparch/archPRD.log not ascending
BR0462W All lines in /oracle/PRD/saparch/archPRD.log till line 1830920 will be ignored
BR0461W Redolog sequence number in line 1831168 of /oracle/PRD/saparch/archPRD.log not ascending
BR0462W All lines in /oracle/PRD/saparch/archPRD.log till line 1831168 will be ignored

BR0439E No offline redolog files found in /oracle/PRD/saparch/archPRD.log for processing for device type TAPE/BACKINT/RMAN in recovery interval of 30 days


BR0406I End of file restore: remjonan.rsa 2013-10-24 15.04.27
BR0280I BRRESTORE time stamp: 2013-10-24 15.04.27
BR0404I BRRESTORE terminated with errors


OR

brrestore -a 265931-265982=/oracle/PRD/oraarch/ -r /oracle/PRD/102 _64/dbs/initPRD.utl


BR0401I BRRESTORE 7.20 (33)
BR0405I Start of file restore: remjomos.rsa 2013-10-24 14.59.18
BR0484I BRRESTORE log file: /oracle/PRD/sapbackup/remjomos.rsa

BR0461W Redolog sequence number in line 1830920 of /oracle/PRD/saparch/archPRD.log not ascending
BR0462W All lines in /oracle/PRD/saparch/archPRD.log till line 1830920 will be ignored

BR0461W Redolog sequence number in line 1831168 of /oracle/PRD/saparch/archPRD.log not ascending
BR0462W All lines in /oracle/PRD/saparch/archPRD.log till line 1831168 will be ignored
BR0438W Redolog sequence number 265931 not found in /oracle/PRD/saparch/archPRD.log
BR0438W Redolog sequence number 265932 not found in /oracle/PRD/saparch/archPRD.log
BR0438W Redolog sequence number 265933 not found in /oracle/PRD/saparch/archPRD.log
 

Solution:

Step 1. Make a backup copy of archPRD.log file

cp  /oracle/PRD/saparch/archPRD.log /oracle/PRD/saparch/archPRD.log_bkp

Step 2. Identify sequence line entry in archPRD.log file for the archive files to be restored


#ARCHIVE.. 265931  /oracle/PRD/oraarch/PRDarch1_265931_759153586.arc  2013-05-19 04.50.33  26548224     7994146315208  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-05-19 05.04.11 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-05-19 05.04.11
#
#ARCHIVE.. 265932  /oracle/PRD/oraarch/PRDarch1_265932_759153586.arc  2013-05-19 04.57.24  28307968     7994149385123  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-05-19 05.04.11 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-05-19 05.04.11
#
#ARCHIVE.. 265933  /oracle/PRD/oraarch/PRDarch1_265933_759153586.arc  2013-05-19 04.57.39  30245888     7994205640697  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-05-19 05.04.12 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-05-19 05.04.12
#


Step 3. Modify date as recent (within 30 days) and paste it at the end of the archPRD.log file , save the file . Changed 2013-05-19 to 2013-10-19

#ARCHIVE.. 265931  /oracle/PRD/oraarch/PRDarch1_265931_759153586.arc  2013-10-19 04.50.33  26548224     7994146315208  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-10-19 05.04.11 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-10-19 05.04.11
#
#ARCHIVE.. 265932  /oracle/PRD/oraarch/PRDarch1_265932_759153586.arc  2013-10-19 04.57.24  28307968     7994149385123  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-10-19 05.04.11 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-10-19 05.04.11
#
#ARCHIVE.. 265933  /oracle/PRD/oraarch/PRDarch1_265933_759153586.arc  2013-10-19 04.57.39  30245888     7994205640697  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-10-19 05.04.12 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-10-19 05.04.12
#


Step 4.  execute the brrestore command


brrestore -a 265931-265933=/oracle/PRD/oraarch/ -r /oracle/PRD/102 _64/dbs/initPRD.utl
BR0401I BRRESTORE 7.20 (33)
BR0405I Start of file restore: remjoneo.rsa 2013-10-24 15.06.10
BR0484I BRRESTORE log file: /oracle/PRD/sapbackup/remjoneo.rsa

BR0461W Redolog sequence number in line 1830920 of /oracle/PRD/saparch/archPRD.log not ascending
BR0462W All lines in /oracle/PRD/saparch/archPRD.log till line 1830920 will be ignored
BR0414I Offline redolog files for restore of database instance PRD:
/oracle/PRD/oraarch/:
265931,265932,265933

BR0280I BRRESTORE time stamp: 2013-10-24 15.06.13
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

BR0280I BRRESTORE time stamp: 2013-10-24 15.06.18
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2013-10-24 15.06.18
BR0407I Restore of database: PRD
BR0408I BRRESTORE action ID: remjoneo
BR0409I BRRESTORE function ID: rsa
BR0419I Files will be restored from backup: aelfptms.svd 2013-05-19 05.02.14
BR0416I 3 files found to restore, total size 196.816 MB
BR0421I Restore device type: util_file

BR0280I BRRESTORE time stamp: 2013-10-24 15.06.18
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

BR0280I BRRESTORE time stamp: 2013-10-24 15.06.19
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2013-10-24 15.06.19
BR0229I Calling backup utility with function 'restore'...
BR0278I Command output of 'backint -u PRD -f restore -i /oracle/PRD/sapbackup/.remjoneo.lst -t file -p /oracle/PRD/102_64/dbs/initPRD.utl':
********************************************************************************
Program:        backint 7.5
Input File:        /oracle/PRD/sapbackup/.remjoneo.lst
Profile:        /oracle/PRD/102_64/dbs/initPRD.utl
Function:        RESTORE
********************************************************************************
[14722.00] Restore started Thu Oct 24 15:06:20 2013
[14722.00]
[14722.00]
[14722.00] 15:06:21 (819365.xxx) Restore job id 819365 will require 1 image.
[14722.00] 15:06:21 (819365.xxx) Media id 000677 is needed for the restore.
[14722.00]
[14722.00] 15:06:23 (819365.001) Restoring from copy 2 of image created Sun May 19 05:02:24 2013
[14722.00] 15:06:26 (819365.001) TAR STARTED 14788
[14722.00] 15:06:26 (819365.001) INF - If Media id 000677 is not in a robotic library administrative interaction may be required to satisfy this mount request.
[14722.00] 15:06:29 (819365.001) INF - No drives available or requesting resources
[14722.00] 15:06:50 (819365.001) INF - Waiting for mount of media id 000677 on server lvsb-media2 for reading.
[14722.00] 15:07:56 (819365.001) INF - Waiting for positioning of media id 000677 on server lvsb-media2 for reading.
[14722.00] 15:08:50 (819365.001) INF - Beginning restore from server lvsb-media2 to client inmulvsapcdbdev.
[14722.00] 15:08:52 (819365.001) /oracle/PRD/oraarch/PRDarch1_265931_759153586.arc
[14722.00] 15:08:53 (819365.001) /oracle/PRD/oraarch/PRDarch1_265932_759153586.arc
BR0280I BRRESTORE time stamp: 2013-10-24 15.08.54
#ARCHIVE.. /oracle/PRD/oraarch/PRDarch1_265931_759153586.arc  /oracle/PRD/oraarch//PRDarch1_265931_759153586.arc
#RESTORED. VXF1368919944
[14722.00] 15:08:57 (819365.001) /oracle/PRD/oraarch/PRDarch1_265933_759153586.arc
[14722.00] 15:10:02 (819365.001) INF - TAR EXITING WITH STATUS = 0
[14722.00] 15:10:02 (819365.001) INF - TAR RESTORED 3 OF 3 FILES SUCCESSFULLY
[14722.00] 15:10:02 (819365.001) INF - TAR KEPT 0 EXISTING FILES
[14722.00] 15:10:02 (819365.001) INF - TAR PARTIALLY RESTORED 0 FILES
[14722.00] 15:10:02 (819365.001) Status of restore from copy 2 of image created Sun May 19 05:02:24 2013 = the requested operation was successfully completed
BR0280I BRRESTORE time stamp: 2013-10-24 15.10.03
[14722.00] 15:10:03 INF - Server status = 0
[14722.00] 15:10:03 (819365.xxx) INF - Status = the requested operation was successfully completed.
********************************************************************************
BR0280I BRRESTORE time stamp: 2013-10-24 15.10.08
BR0374I 3 of 3 files restored by backup utility
BR0230I Backup utility called successfully
BR0406I End of file restore: remjoneo.rsa 2013-10-24 15.10.08
BR0280I BRRESTORE time stamp: 2013-10-24 15.10.08
BR0403I BRRESTORE completed successfully with warnings



Make sure sequence line formatting is similar as below , any additional hash will lead to BR0438W Redolog sequence number .. not found in /oracle/PRD/saparch/archPRD.log

#ARCHIVE.. 265933  /oracle/PRD/oraarch/PRDarch1_265933_759153586.arc  2013-10-19 04.57.39  30245888     7994205640697  1
#SAVED.... aelfptms svd  *VXF1368919944    2013-10-19 05.04.12 ........... ............
#COPIED... ........ ...  ................. .......... ........ ........... ............
#DELETED.. aelfptms svd  2013-10-19 05.04.12
#



2 comments:

  1. Is there any other solution?
    Because in archWCG.log required redologs date is within 30 days

    ReplyDelete