RS
Hello ARIS community,
I'm working on a backup/recovery concept for a larger ARIS application.
As the application should be used regularely, recovery in case of disaster should be fast and contents should be recovered in the most actual state.
Now my question.
Of course if just the ARIS database is corrupt I would import a backup *.adb and the backed up configuration files.The ARIS databases are backed up every night.
Now it is possible that the internal database objects ARIS creates in the Oracle database during installation is corrupted. In this case an import of the *.adb would not work. In this case it would be useful to recover the database by means of Oracle recovery.
Also if the database runs in archive mode it would be possible to recover the most actual state of the ARIS content and not just the state of the last ARIS backup. Which would mean for us we could recover not only the content of the day before, which was backed up in the ARIS *.adb file at night, but the work results of the actual day as well.
A test scenario could be to remove manually the datafile the ARIS tablespaces are in, recover it by database means and after that I would expect ARIS business server and ARIS business publisher server are in the state as before the crash.
Has anybody tested this scenario? Is there anything to consider?
Regards and thank you in advance
R.
The ARIS application is running on windows 2008 on Oracle 11.2 g database; the database, Business server, and business publisher are running each on a different server.
