make_tape_recovery or make_recovery

[Leigh Shook]

Background - L-class, HP-UX 11.0, Oracle8i DB, HP Vantage-Point and Remedy ARS
The other day I ran a make_recovery with our application up and running, and it was noticed that a message in the vantage-point browser did not create a Remedy ticket as it should. Does anyone know if make_recovery performs file-locking during the tape creation? One of my collegues thought the make_recovery was cause for the interruption in Remedy. My thoughts were that if make_recovery does use file-locking, it may have caused the DB to be unavailable during the ticket creation process.

Leigh Shook - AT&T Govt. Solutions

[Steven E. Protter]

make_recovery is obsolete

You should stop using it.

Attaching a working make_tape_recovery script.

make_tape_recovery can not reliably back up an open oracle database.

SEP

[twang]

Hi Leigh,
You cannot backup oracle datafiles using make_recovery/make_tape_recovery if the oracle database is opening.
To backup oracle database, you can performs a closed database backup, you can perform it using OS command, such as tar, cpio, dd...
Or if you want to an open database backup, you can use user-managed backup(tablespace, datafile backup...) or RMAN.

twang

[Jeff Schussele]

Hi Leigh,

That would be possible (and probable) ONLY if Remedy or the DB resides in vg00 which is a definite no-no.
One should not load 3rd-party SW in a dir that lives in vg00.
Yes make_recovery *does* lock files for the time it takes to read them.
And as mentioned you should upgrade your Ignite & start using make_tape_recovery.

Rgds,
Jeff

[Tim D Fulford]

make_recovery is obsolete & it will fire off the relavent make_tape_recovery (& tells you so)

regards

Tim

[Leigh Shook]

Thanks Jeff, and to all that responded.
This is exactly the info. I was looking for.