System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

vdump tru64 backups work only if database offline.

ABM Support Team
Occasional Contributor

vdump tru64 backups work only if database offline.

vdump tru64 backups work only if database offline. When database is online they always hang right at the end and do not complete.
We are running on a gs1280 server using an ibm san
6 REPLIES
Ivan Ferreira
Honored Contributor

Re: vdump tru64 backups work only if database offline.

I just wanna be sure about what is "database online" to you.

¿What is your procedure to backup your database online? Do you put the database in backup mode?
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
ABM Support Team
Occasional Contributor

Re: vdump tru64 backups work only if database offline.

database online is
users can fully use the systems and perform all functions transactions.
offline is we have to disable user access to database
Rob Leadbeater
Honored Contributor

Re: vdump tru64 backups work only if database offline.

Hi,

If the database is online, then the files will be in use, which is probably why vdump can't access them.

Try looking at clonefset to take a "copy" of the database files that can then be backed up...

Cheers,

Rob
Vladimir Fabecic
Honored Contributor

Re: vdump tru64 backups work only if database offline.

When database is opened for transactions, backup does not have sense.
These files are not usable for restore.
A good way to do it is what Rob said:
1. Put database in backup mode
2. Create snapshot with "clonefs"
3. Mount cloned file set
4. Put database in transaction mode
5. Do vdump of mounted cloned file set
6. Dismount and delete cloned file set
For doing this way, you must have license for advfs utilities.
If you do not have license for advfs utilities, you must:
1. Shutdown database or put it in backup mode
2. Do vdump backup
3. Start database or put it in transaction mode
If your database is Oracle, you can also use "rman" online backup.
In vino veritas, in VMS cluster
Ivan Ferreira
Honored Contributor

Re: vdump tru64 backups work only if database offline.

The key question before was ¿Do you put the database in backup mode?

By your answer, I can figure out that you are not doing that.

Follow the suggestions above or you will never get a working backup.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
ABM Support Team
Occasional Contributor

Re: vdump tru64 backups work only if database offline.

will reopen once all the information needed is available