Originally posted by: sajid1

Hi,

Can I use tar command while application is up.Example i have to run tar command for a directory where the base directory of application is located or same for Oracle Home?
Thanks

Originally posted by: sck

Hi,

You can use the tar command while application is up, but the data which got backed up will not be in consistent state.

Also tar command have some limitation such as files of more than 8GB size will not be backed up.

Instead you can use AIX native backup command which can help you to take backup of your hierarchical filesystems. For each filesystem it will create one tape record.

Correct Sequence of performing the backup
1. Stop the application
2. Perform the backup.

There are n no of applications such as Tivoli Storage Manager which can take the online backup of application data for that you have to pay extra.

Regards

Sunil C Khatri

Originally posted by: MarkTaylor

In the middle of that lot you could use backsnap to snapshot the filesystem, then bring the App back up, then back up the snapshot filesystem which is a point in time copy of the live filesystem ref:

http://publib.boulder.ibm.com/infocenter/aix/v6r1/index.jsp?topic=/com.ibm.aix.cmds/doc/aixcmds1/backsnap.htm

This means the app is down for a shorter period ..

Or, as with flashcopy technology and DB2 (not sure if Oracle supports this, but it probably does), you can freeze the database and commit all UOWs to give you a solid point for restore, then snapshot the filesystem (or flashcopy :) then unfreeze the database .. you will want to snapshot the logs at the same point too etc ..

HTH
Mark Taylor

Originally posted by: MohdFadzli

The best and ideal way to preserved the data consistency:
1. Stop application
2. Backup data. Either using:
- #smitty fs -> Backup a File System (If your data is in sigle /mountpoint)
- #smitty savevg (if you got several mount points in 1 VG)

Just my 2 cents here. Goodluck.