How to timestamp main backup directories

[Haitham Hamad]

I am using fbackup to backup oracle and users directories to tape. I need to find out how much time the oracle directores takes for backup so that I can estimate time to open the database before the full backup ends. My graph looks like

i /oradisk1
i /oradisk2
i /oradisk3
i /userdata1
i /userdata2

Do I have to change to cpio? TIA Haitham

[Vincenzo Restuccia]

Fbackup is ok but the best is Omniback.

[Volker Borowski · Accepted solution]

Hello,

I do not think it is a good idea to do this on a time-based approach. If the DBA extends the database, or even if data is filled into prevois empty tablespaces, the time may change, as the compressratio changes.

What about a small script, that watches the progress of your backup by analyzing the logfile of fbackup. Should be like this:

- Loop and Wait for fbackup logfile to apear
- Loop and Wait for /oradisk1 token to apear
- Loop and Wait for /userdata1 token to apear
- wait 2 minutes to be safe
- start oracle

The check could be done with

tail -n 1 logfile | grep oradisk

or use a more sofisticated awk program.

Hope this helps
Volker

[Haitham Hamad]

Thanks volker for your concern. This is a temporary solution till my client purchase more disk.