Hi all,

we encountered a strange situation:

we are running baan Vc, Sp9 and Oracle 8.1.7.

We use the recovery manager of oracle to do a online backup.

The following happens:
I login into baan. no problem. then i start the recovery manager in oracle. the already logged-in user is able to continue working in baan (queries & updates ...).
BUT:
if a new user wants to login we get the baan error 510 (db not on) and oracle error #01034 (oracle not available).

weired, because the logged-in user can work ...

after stopping / restarting oracle, login is possible again.
as we want to perform an online backup, shutting down oracle is not an option.

can anybody give some advice ???
thanx,
jochen

Hi Jochen,

Thats certainly a strange problem you have there.

Do you have a separate database for your RMAN recovery catalog? My guess is that somehow the RMAN database environment is being set and incorrectly being picked up by your Baan environment during your online backup.

ORA-01034 may imply one of your Oracle variables is not set correctly.

Check to see what your backup script is doing.

REM orarman.bat
REM rman starten und Sicherung durchfuehren
REM 15.0.82002 Martin Quintus
REM
REM net start ORACLEServiceBERP
set ORACLE_SID=BERP
echo on
spool on orarman.log
rman @f:\oracle\ora81\orarman.sql
spool off
REM net stop ORACLEServiceBERP
REM net start ORACLEServiceBERP

and there is the sql-batchfile

connect target baan/baan
connect catalog baan/baan
run {
allocate channel "dev_0" type "sbt_tape"
parms "ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=BERP,OB2BARLIST=oracle-gorilla-donnerstag)";
backup
incremental Level 0
filesperset 1
database;}
exit

Hy James

after starting the RMAN you can also not login on the DBA-Studio in Oracle.

kind regards

Jochen

Hi Jochen,

you try to use the same Database as target and catalog database. thats not possible.
THE RECOVERY CATALOG
DATABASE CANNOT BE USED TO CATALOG BACKUPS OF ITSELF.

Martin

Hy Martin

that helped me a lot, now the Backup is o.k. and you can also login

regards


Jochen & Martin