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
#
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
#
Is there any other solution?
ReplyDeleteBecause in archWCG.log required redologs date is within 30 days
thank you , it helped..
ReplyDelete