Hi,
When I try to config one single profile (SC 3.4) with two or more Oracles databases (11g), I'm facing the following problem when I run the backup:
alter database begin backup
*
ERROR at line 1:
ORA-01146: cannot start online backup - file 1 is already in backup
ORA-01110: data file 1: 'D:\DEMO3\SYSTEM01.DBF'
In this configuration there are two Oracle databases in the same profile (VM + Aplication Consistent). Both databases share the same Oracle Home directory. (this is a VMware VM housed alone in a NFS datastore).
I think the first "begin backup" command put all databases in backup mode, thus further "begin backup" will fail.
Due a lack of information, I don't know how to config this profile properly.
Here my config (both were built through GUI):
(DB #1)
ORACLE_DATABASES=demo2:sys / as sysdba
SQLPLUS_CMD=C:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus.exe
CNTL_FILE_BACKUP_DIR=d:\demo2
ORA_TEMP=d:\demo2
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_1
ORACLE_EXPORT_PARAMETERS=Y
(DB #2)
ORACLE_DATABASES=demo3:sys / as sysdba
SQLPLUS_CMD=C:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus.exe
CNTL_FILE_BACKUP_DIR=d:\demo3
ORA_TEMP=d:\demo3
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_1
ORACLE_EXPORT_PARAMETERS=Y
Do you have any suggestion?
Thanks!!!