ignite-ux

[Rommel T. Misa_2]

I have a two-disk rx1620 system. I had the boot disk mirrored for availability. I am running a small Oracle db on my vg00 with HP-UX. I just have this question. If I make an Ignite-UX backup, would my Oracle filesystems be included in the Ignite backup? This is critical if I would have to restore my entire system in the event of a system down.

Hope you guys could respond soon.

Thanks,
Rommel

[Patrick Wallek]

It depends on how you run your Ignite backup.

If you include your entire VG00, then yes your Oracle filesystems would be included. HOWEVER -- UNLESS your Oracle DB is shut down completely, or is in BACKUP mode, the Oracle backup will be USELESS. Your $ORACLE_BASE will be OK, BUT you datafiles will be useless. And it is the data files you really care about, right?

I would recommend that you EXCLUDE the filesystem with the Oracle datafiles when you run your Ignite backup. You really should be backing those up nightly via some other means.

If your Oracle datafiles are in /u01, I would do the following when running Ignite (this also assumes your tape drive is /dev/rmt/0mn):

# make_tape_recovery -a /dev/rmt/0mn -I -v -x inc_entire=vg00 -x exclude=/u01

[perumal_2]

Hi Rommel

You have an option including your entire vg00 in your ignite backup.
The comman used is
make_tape_recovery -x inc_entire=vg00
When you restore the system using the ignite tape you had created with above command you can restore the entire vg00 with out any loss.
Hope your data files are in different vg than the vg00. If the data files are alos in the same vg you may need to shutdown your oracale before you take the ignite backup. Otherwise your data consistency won't be there, though you have all the data files in the ignite tape you can't bring your DB up. It will ask for the media recovery.

Hope this clarifies your question.

TQ
Perumal