restore archive file on SAP

Question

I have some problem about restoring the Archive file (please see below message).

-------------------------------------------------------------------------------------------------
hq-ora-c01:oraprd 11% brrestore -a2 507000=/oracle/tstat/oradata/temp/arch1
BR401I BRRESTORE 6.10 (86)
BR169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored
for 'brarchive' - 'util_file' assumed
BR405I Start of file restore: rdvvjrte.rsa 2007-08-02 09.48.14

BR414I Offline redo log file for restore from database instance PRD: /oracle/tst
at/oradata/temp/arch1: 507000

BR280I Time stamp 2007-08-02 09.48.17
BR407I Restore of database: PRD
BR408I BRRESTORE action ID: rdvvjrte
BR409I BRRESTORE function ID: rsa
BR419I Files will be restored from backup: advtveee.cds 2007-07-25 03.57.56
BR416I 1 file found to restore, size 50.000 MB
BR442I Second copy of offline redo log files will be used for restore
BR421I Backup device type for restore: util_file
BR280I Time stamp 2007-08-02 09.48.17
BR256I Please enter 'cont' to continue, 'stop' to cancel the program:
cont
BR257I Your reply: 'cont'
BR280I Time stamp 2007-08-02 09.48.38
BR259I Program execution will be continued...

BR280I Time stamp 2007-08-02 09.48.38
BR229I Calling backup utility...
BR386E File /oracle/BCK/saparch/PRDarch1_507000.dbf reported as not found by bac
kup utility
BR280I Time stamp 2007-08-02 09.48.52
BR279E Return code from '/usr/sap/PRD/SYS/exe/run/backint -u PRD -f restore -i /
oracle/BCK/sapbackup/.rdvvjrte.lst -t file -p /oracle/QAS/817_64/dbs/initPRD.utl
': 2

BR374E 0 of 1 file restored by backup utility
BR280I Time stamp 2007-08-02 09.48.52
BR231E Backup utility call failed

BR406I End of file restore: rdvvjrte.rsa 2007-08-02 09.48.52
BR280I Time stamp 2007-08-02 09.48.52
BR404I BRRESTORE terminated with errors
hq-ora-c01:oraprd 12%

-----------------------------------------------------------------------------------------------------------
Many Thank.
Please suggesstion me.

suwanisa · Answer

Version of SAP is 4.6c

ble1 · Answer

Check if the file is backed up and browsable.

suwanisa · Answer

Note Message:The data on July 24, 2007 can't restore by brrestore (but backup completed) But the data on July 23, 26 2007 can restore by brrestore.

suwanisa · Answer

From log of SAP and Networker (savegrp) show successfull (completed).

But When I run NW user - GUI to browse for recovery, after click at saparch folder the mouse as sandglass which it still on 2-3 Hrs (can't browsable, not responding).

After that I has to used command line for recocery: see below,

recover> cd oracle
recover> cd BCK
recover> ls -l
drwxr-xr-x drwxr-xr-x drwxr-xr-x recover> cd saparch
recover> ls -l PRDarch1_50*.dbf
~
~
~
< Can't browse>

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

But when I change to another path :

C:\>recover -c hq-ora-c01
recover: No index was found for /C/. The current working directory is /.
recover> cd /
recover> ls
oracle
recover> cd oracle
recover>
recover>
recover>
recover> ls -l
total 5
drwxr-xr-x drwxrwxr-x drwxr-xr-x recover> cd QAS
recover> ls -l
total 1
drwxr-xr-x recover> cd 817*
recover> ls -l
total 1
drwxr-xr-x recover> cd dbs
recover> ls -l
total 44
-rwxr-xr-x -rwxr-xr-x -rwxr-xr-x -rwxr-xr-x -rwxr-xr-x -rwxr-xr-x -rwxr-xr-x -rwxr-xr-x recover>

It can browsable into file level

Which the data at I need into behind saparch folder.

ble1 · Answer

Could be some sort of corruption - did you try nsrck -L6 for that client?

suwanisa · Answer

I don't run nsrck -L6 but I has running index closs check by GUI but it same.I will try again with nsrck -L6.

suwanisa · Answer

I do running the nsrck -L6 but it has same error and I have to tries restore index from media but it same occurs.How I will do to next step?. Please suggestion.Thank.

ble1 · Answer

I would suggest to open that with support - something strange is going on there....

suwanisa · Answer

many Thank.Which we has open case to EMC support already but not any respone.I still waiting from they.

jsallila · Answer

Just use recover like this:recover -s backupservernamecd /oracle/BCK/saparchThen find the backup log for file(sve, svd etc) you want to recover and find there the exact end time for backing up archive logs. It's not the same time when backup session ends because same session is also backing up util files, backup logfiles etc. Then use changetime and file is browsable. I repeat that time must be exactly same as presented in backup log

suwanisa · Answer

I can't find or list file in that path.Can I use saveset recovery on Networker user?.Thank.

ble1 · Answer

You can use ssid recover with SAP depending what is your setting in util file for ssid format. And forget NetWorker User and start using CLI

jsallila · Answer

What confuses me little bit are these lines:

hq-ora-c01:oraprd 11% brrestore -a2 507000=/oracle/tstat/oradata/temp/arch1

Ok. You are restoring archive logs for instance PRD. I don't understand those options aftes brrestore -a. I personally use it like this: brrestore -a 507000 and that's it. Sometimes you have to specify the different util file if data is located on two different pools.

But...

BR386E File /oracle/BCK/saparch/PRDarch1_507000.dbf reported as not found by bac
kup utility

---Now the instance is /oracle/BCK..

and...

BR279E Return code from '/usr/sap/PRD/SYS/exe/run/backint -u PRD -f restore -i /
oracle/BCK/sapbackup/.rdvvjrte.lst -t file -p /oracle/QAS/817_64/dbs/initPRD.utl
': 2

Now the util file is under /oracle/QAS. Very confusing.

Can you just try brrestore -a 507000? What happens? I wonder are you using same pool for full backups and archive backups? Are you using initPRD.utl for archive backups? If not, you have to use the same util file for backups and restore.

NetWorker

restore archive file on SAP

Was this post helpful?