Oracle database Recover under UNIX-AIX platform!

[pappetta]

Hy guy,
I'm very new to Legato! My problem is How can I recover an oracle database from a legato backup under UNIX platform! I managed to run full backup of the oracle database (online backup), but I don't know what to do with the backup to restore the database! When I run nwrecover tool I'm not be able to find the way to choose the backup I have done and restore it!
My baseline is : AIX 4.3.3.0 , Networker 5.1 , EBU 2.1.2 and finally Oracle Server 7.3.4 ( with all needed patches applied)
Thank in advance!

 

[gowder]

Hi
I cannot give you the straight answe, but an hint. The data base cannot be restored like a regular files using the nwrecover. You need to run the backup utility that you used to backup the database. I can give you on exanple of Informix. To backup Informix databse, an Informix tool called ONBAR is used. So same can be restored using ONBAR with -r for restore flag.

Bye

 

[bigkatt]

Patetta,
If you are looking to restore an Oracle database you need to make sure that the backup you are trying to restore was 1) a cold full backup, or 2) you backup the database hot but use scripts to put the files in a quiescent mode. If you can not recover from a Legato backup one might ask themselves why back it up in the first place.
As the backup administrator you might want to get to know your Oracle administrator so you can work closely to ensure all backups are successful.
Is it my understanding that you login to the Oracle machine, cd to the dir that you want to recover, set the display back to your box, run recover or nwrecover, change the date to browse and you see nothing? If that is the case you might want to look at your /nsr/logs/daemon.log file and verify that you did have a successful backup.
I hope some of this information helps. Let me know.

BK