# Backup of ADABAS for OpenSystems using Veritas .... etc

**URL:** <https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\
**Created:** [April 24, 2006, 7:05am UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961 "2006-04-24T07:05:03Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_J\_Mather](https://avatars.discourse-cdn.com/v4/letter/d/f1d935/32.png) [@David\_J\_Mather](https://techcommunity.softwareag.com/u/David_J_Mather)\
**Post date:** [April 24, 2006, 7:05am UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/1 "2006-04-24T07:05:03Z")

</div>

Customer is a big Veritas user and wants to do on-line backups of the ADA/NAT environment on OS.

1. Can we do this.
2. Has anyone done it ?

Thanks…DaveM

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [April 24, 2006, 12:53pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/2 "2006-04-24T12:53:10Z")

</div>

> [@](#):
>
> 1. Has anyone done it ?

Yes, I did!  
I think there are 3 possiblilities:

1. Do a ONLINE-backup of the ASSO- and DATA-Files on the filesystem (I guess that’s the way Veritas would do it):  
This method cannot be recommended. If you backup the ASSO/DATA-Files on the Filesystem, you’ll get an inconsistent Database if you make a restore. Another Disadvantage is, that you’ll backup all empty Adabas-Blocks as well.
2. Do one Offline-Backup via ADABCK. The next Backups can be done using the PLOG-Option. That means:

- force a new Plog
- Backup the old Plog-File

1. Do an ONLINE-backup using ADABCK:  
This is a consistent method to do a online Backup. But you can run into trouble in case of a ET\_SYNC. Please see  
[http://adabas.forums.softwareag.com/viewtopic.php?t=795](http://adabas.forums.softwareag.com/viewtopic.php?t=795)  
and the ADABAS-Documentation of ADABCK.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 24, 2006, 6:18pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/3 "2006-04-24T18:18:14Z")

</div>

Possibility 1: Inconsistent database blocks can be avoided by using the ADAOPR EXT\_BACKUP functionality.

Wolfgang

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [April 24, 2006, 6:34pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/4 "2006-04-24T18:34:58Z")

</div>

> [@Wolfgang Obmann](#):
>
> Possibility 1: Inconsistent database blocks can be avoided by using the ADAOPR EXT\_BACKUP functionality.

Interesting Feature! The Documentation says:

```auto
The keyword PREPARE prepares the database for backup. During this phase, the following restrictions apply: 
- new transactions will be stalled 
```

So my question is: What is the advantage of ADAOPR EXT\_BACKUP over ADABCK EXU\_DUMP? If I understand the whole thing correctly, both ways are locking the Database for the users.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 26, 2006, 6:48pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/5 "2006-04-26T18:48:19Z")

</div>

Modern storage systems allow creating a (logical) copy of data in a very short time. This means that you can get a consistent copy of your containers by doing the following:  
adaopr ext\_backup=prepare  
Save the containers with the storage system functionality  
adaopr ext\_backup=continue

Note that ADABAS is blocked for updates between adaopr ext\_backup=prepare and adaopr ext\_backup=continue. Therefore it is not recommended using this feature for saving the database with a real physical copy operation.

On the other hand, ADABCK will lock the database only for a short time for update when the whole database has already been written to the backup file do do a final synchronization. If database blocks are updated while ADABCK is running, they are written to the backup file a second time if they have already been written to the backup file before.

Wolfgang

---

<div class="post-metadata">

**Author:** ![Axt](https://avatars.discourse-cdn.com/v4/letter/a/b2d939/32.png) [@Axt](https://techcommunity.softwareag.com/u/Axt)\
**Post date:** [November 2, 2011, 3:43pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/6 "2011-11-02T15:43:58Z")

</div>

I’m trying to use this features to clone ( using storage utility ) adabas ( v.6.x.x. more or less 300GB of DATA/ASSO/WORK CONTAINER ) on linux platform.  
Sometimes adaopr db=xx ext\_backup=prepare takes a long time to complete ( more then 1 houres ).  
Can it depends on TT or TNAE parameters?  
Can someone help me on this topic?  
Thanks,  
Antonio.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [November 4, 2011, 10:00am UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/7 "2011-11-04T10:00:57Z")

</div>

It is not clear to me if EXT\_BACKUP=PREPARE is performing ET synchronization? If seems not because there is not ET\_SYNC\_WAIT parameter like for ADABCK. If ET synchronisation is performed this could be the reason for your 1 hour wait time (TT has to expire). But then new transactions can also not start in the meantime which can be a big problem.

If it is not performing ET synchronisation I don’t understand why the example in the manual is not including WORK in the external backup:

> [@](#):
>
> tar cvf backup.tar ASSO\* DATA\* # external dump

Perhaps Wolfgang can clarify this?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [November 15, 2011, 11:45am UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/8 "2011-11-15T11:45:31Z")

</div>

Yes, of course an ET synchronization is necessary. The idea of ADAOPR EXT\_BACKUP is to create a consistent state of the containers on disk. Additionally to the ET synchronization also a buffer flush is necessary. For ADAOPR EXT\_BACKUP no ET\_SYNC\_WAIT parameter is provided, but you can set TT to a smaller value before performing EXT\_BACKUP, for example:  
adaopr db=…tt=20 ext\_backup=prepare  
When you continue processing after saving the containers you should set TT back to its original value, for example:  
adaopr db=… ext\_backup=continue tt=3600

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [November 16, 2011, 11:26am UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/9 "2011-11-16T11:26:03Z")

</div>

Thanks Wolfgang.

So it is very likely it is your TT value that takes your prepare long time to complete. It is just waiting for ET-synchronization.  
I highly recommend you to lower TT before the prepare because new transactions cannot start while waiting for this synchronzstion. And set it back again afterwards.

The considerations is the same as running online adabck.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [December 1, 2011, 3:09pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/10 "2011-12-01T15:09:30Z")

</div>

Hi,

Found a chapter in documentation about this topic → [url][http://techcommunity.softwareag.com/ecosystem/documentation/adabas/ada63os/admin/ebs.htm#ebs[/url]](http://techcommunity.softwareag.com/ecosystem/documentation/adabas/ada63os/admin/ebs.htm#ebs%5B/url%5D)

If all else fails, consult the documentation. 😉

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:38pm UTC](https://techcommunity.softwareag.com/t/backup-of-adabas-for-opensystems-using-veritas-etc/57961/11 "2021-04-02T14:38:58Z")

</div>


