online Full system backup procedure ?

[Petr Simik_1]

I need to do full system backup on DB cluster. Without stoping the package. I don't have JFS Online. This is simple ORACLE DB Cluster + Application = 2Nclass servers. Each server has it's own internal disk Unix + shared disk array. This array contains Oracle DB + Oracle bin + App bin. Active node has mounted this array.
Until now we stoped cluster mounted shared array to last active node and performed fbackup on both. Now we cannot stop package and we are looking for procedure how to do flackup without stopin cluster.
Do you have any tips ??

Thank you Petr

[Steve Steel]

Hi

fbackup will not save open files so you cannot do it safely


If the array is mirrored then you could break the mirror and backup up the copy and then rebuild the mirror

Steve Steel

[Petr Simik_1]

We have online backup every night we switch oracle db to archive mode and perform backup of datafiles to disk.
We can combine this online backup with full system backup.

I think of procedure like this.
1. Ignite backup VG00
2. Full system backup binaries all
3. Online backup database.
Than restore 1.2.3

Using mirror brake is good idea but does it solve the problem with opened files?

[Sanjay Kumar Suri]

1. Ignite backup need to be taken every time there is a change at OS level like patches/upgrade etc.

2. Full FS (OS binaries and DB files) can be taken using mirror brake. If possible this should be an offline backup (after shutting down the database for a moment).

3. Database has to be ARCHIVELOG mode (at least production system) for taking online backup. In this backups one need to ensure the safty of archive log files for complete database recovery.

sks

[Robert-Jan Goossens]

Hi Petr,

Maybe you need to investigate in some additional products like Omniback/Legato, in combination with an online backup/restore facility for Oracle like rman.

Hope this helps,
Robert-Jan

[Petr Simik_1]

Sanjay I like your idea stop app+db for a little while and brake mirrors than backup. This might be possible.

But does anyone know procedure to do it without any outage?


Concerning Omniback : yes we allready thought of this solution but this is moreless centralized and we have 7 cluster in different places in our country. We cannot transfer big amount of data via network.

[Sanjay Kumar Suri]

Broadly I can suggest the following:

1. Shutdown the database.
2. Resync the Business Copy volumes (BC). BC is used in XP kind of arrays.
3. Split the mirror once the volumes are in PAIR.
4. Startup the database.
5. Take FS backups of the mirrored volumes.

sks

[Ravi_8]

Hi,

if you can't stop the cluster then
1.Break the mirror
2.perform the full backup(fbackup wouldn't backup opened files)
3. recreate the mirror.

[Petr Simik_1]

thank you, I'll check the possibilities. Thank you for your tips.
If you find solution for backuping server withou stopping package.

Do you know what are the backup/restore steps for common DB cluster?

[Sanjay Kumar Suri]

Check this thread as well:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=304987

Some links from Net:

http://www.cise.ufl.edu/help/database/oracle-docs/rac.920/a96596/backup.htm#470925
http://ftp.support.veritas.com/pub/support/products/Database_Edition_for_Oracle/dbed_212_dbag_240500.pdf

sks