Hi All
I have a Solaris Server with multiple Oracle DBs. Snapcreator runs on a Windows Server 2008 R2.
Now I want to Backup the DBs with one ConfigFile. With independend ConfigFiles the Backup runs:
CofigFile1 Oracle section:
ORACLE_DATABASES=NETAPP20:smo
SQLPLUS_CMD=/netappt20/ora00/product/10.2.0/bin/sqlplus
CNTL_FILE_BACKUP_DIR=/data/ora99/arch1/NETAPP20/bkp_ctrl
ORA_TEMP=/data/ora99/arch1/NETAPP20/tmp
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=/netappt20/ora00/product/10.2.0
ORACLE_EXPORT_PARAMETERS=Y
CofigFile2 Oracle section:
ORACLE_DATABASES=NETAPP21:smo
SQLPLUS_CMD=/netappt21/ora00/product/10.2.0/bin/sqlplus
CNTL_FILE_BACKUP_DIR=/data/ora99/arch1/NETAPP21/bkp_ctrl
ORA_TEMP=/data/ora99/arch1/NETAPP21/tmp
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=/netappt21/ora00/product/10.2.0
ORACLE_EXPORT_PARAMETERS=Y
How I have to consolidate this 2 config in 1 Configfile?
I have tried following two Ways, but both do not Work:
First Try:
ORACLE_DATABASES=NETAPP20:smo
SQLPLUS_CMD=/netappt20/ora00/product/10.2.0/bin/sqlplus
CNTL_FILE_BACKUP_DIR=/data/ora99/arch1/NETAPP20/bkp_ctrl
ORA_TEMP=/data/ora99/arch1/NETAPP20/tmp
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=/netappt20/ora00/product/10.2.0
ORACLE_EXPORT_PARAMETERS=Y
ORACLE_DATABASES=NETAPP21:smo
SQLPLUS_CMD=/netappt21/ora00/product/10.2.0/bin/sqlplus
CNTL_FILE_BACKUP_DIR=/data/ora99/arch1/NETAPP21/bkp_ctrl
ORA_TEMP=/data/ora99/arch1/NETAPP21/tmp
ARCHIVE_LOG_ONLY=NO
ORACLE_HOME=/netappt21/ora00/product/10.2.0
ORACLE_EXPORT_PARAMETERS=Y
Second Try:
ORACLE_DATABASES=NETAPP20:smo;NETAPP21:smo
SQLPLUS_CMD=/netappt20/ora00/product/10.2.0/bin/sqlplus
CNTL_FILE_BACKUP_DIR=/data/ora99/arch1/NETAPP20/bkp_ctrl
ORA_TEMP=/data/ora99/arch1/NETAPP20/tmp
ARCHIVE_LOG_ONLY=N
ORACLE_HOME=/netappt20/ora00/product/10.2.0
ORACLE_EXPORT_PARAMETERS=Y
Both Configs generate following Error:
########## Application quiesce ##########
[Fri Feb 10 08:32:47 2012] [Server:9090(3.4.0.1)] INFO: Quiescing databases
[Fri Feb 10 08:32:47 2012] [Server:9090(3.4.0.1)] INFO: Quiescing database NETAPP21
[Fri Feb 10 08:32:47 2012] [Server:9090(3.4.0.1)] DEBUG: Verifying correct version of database NETAPP21
[Fri Feb 10 08:32:47 2012] [Server:9090(3.4.0.1)] DEBUG: Executing SQL sequence:
connect / as sysdba;
select * from v$version;
exit;
[Fri Feb 10 08:32:47 2012] [Server:9090(3.4.0.1)] DEBUG: Executing external sql script [/tmp/RtqUefo56r.sc] for database NETAPP21
[Fri Feb 10 08:32:48 2012] [Server:9090(3.4.0.1)] DEBUG: Command [/bin/su - smo -c "ORACLE_HOME=/netappt20/ora00/product/10.2.0;export ORACLE_HOME;ORACLE_SID=NETAPP21;export ORACLE_SID;/netappt20/ora00/product/10.2.0/bin/sqlplus /nolog @/tmp/RtqUefo56r.sc"] finished with
exit code: [0]
stdout: [Sun Microsystems Inc. SunOS 5.10 Generic January 2005
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 10 08:32:47 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
select * from v$version
*
ERROR at line 1:
ORA-01034: ORACLE not available
Disconnected]
stderr: []
[Fri Feb 10 08:32:48 2012] [Server:9090(3.4.0.1)] ERROR: [ora-00020] Oracle SQL*Plus command [/bin/su - smo -c "ORACLE_HOME=/netappt20/ora00/product/10.2.0;export ORACLE_HOME;ORACLE_SID=NETAPP21;export ORACLE_SID;/netappt20/ora00/product/10.2.0/bin/sqlplus /nolog @/tmp/RtqUefo56r.sc"] failed with return code [0] and message [Sun Microsystems Inc. SunOS 5.10 Generic January 2005
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 10 08:32:47 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
select * from v$version
*
ERROR at line 1:
ORA-01034: ORACLE not available
Disconnected
]
[Fri Feb 10 08:32:48 2012] [Server:9090(3.4.0.1)] DEBUG: Executing external sql script [/tmp/RtqUefo56r.sc] for database NETAPP21 finished successfully
[Fri Feb 10 08:32:48 2012] [Server:9090(3.4.0.1)] ERROR: [ora-00001] Verifying correct version of database NETAPP21 failed
[Fri Feb 10 08:32:49 2012] [Server:9090(3.4.0.1)] ERROR: [scf-00053] Application quiesce for plugin oracle failed with exit code 1, Exiting!
########## Application unquiesce ##########
[Fri Feb 10 08:32:51 2012] [Server:9090(3.4.0.1)] INFO: Unquiescing databases
[Fri Feb 10 08:32:51 2012] [Server:9090(3.4.0.1)] INFO: Unquiescing database NETAPP21
[Fri Feb 10 08:32:51 2012] [Server:9090(3.4.0.1)] DEBUG: Ending hot backup mode for database NETAPP21
[Fri Feb 10 08:32:51 2012] [Server:9090(3.4.0.1)] DEBUG: Executing SQL sequence:
connect / as sysdba;
alter database end backup;
alter system archive log current;
exit;
[Fri Feb 10 08:32:51 2012] [Server:9090(3.4.0.1)] ERROR: [ora-00010] Ending hot backup mode for database NETAPP21 failed
[Fri Feb 10 08:32:51 2012] ERROR: [scf-00054] Application unquiesce for plugin oracle failed with exit code 1, Exiting!
TIA
Thomas
