Version of SAP is 4.6c

Check if the file is backed up and browsable.

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.

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.

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

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.

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.

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

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

Just use recover like this:

recover -s backupservername

cd /oracle/BCK/saparch

Then 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

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

Thank.

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

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.