Data Backup and Recovery

Multiple Oracle DBs with one Config

brauntvr2swiss
3,500 Views

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

1 ACCEPTED SOLUTION

justints
3,500 Views

Could you try setting

ORACLE_HOME_NETAPP20=/netappt20/ora00/product/10.2.0

ORACLE_HOME_NETAPP21=/netappt21/ora00/product/10.2.0

and removing

ORACLE_HOME=/netappt20/ora00/product/10.2.0 from the config files.

It should be

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_NETAPP20=/netappt20/ora00/product/10.2.0

ORACLE_HOME_NETAPP21=/netappt21/ora00/product/10.2.0

ORACLE_EXPORT_PARAMETERS=Y


Regards,
Justin Skariah

View solution in original post

4 REPLIES 4

justints
3,501 Views

Could you try setting

ORACLE_HOME_NETAPP20=/netappt20/ora00/product/10.2.0

ORACLE_HOME_NETAPP21=/netappt21/ora00/product/10.2.0

and removing

ORACLE_HOME=/netappt20/ora00/product/10.2.0 from the config files.

It should be

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_NETAPP20=/netappt20/ora00/product/10.2.0

ORACLE_HOME_NETAPP21=/netappt21/ora00/product/10.2.0

ORACLE_EXPORT_PARAMETERS=Y


Regards,
Justin Skariah

brauntvr2swiss
3,500 Views

Hi Justin

You are my hero of this friday :-)... Can I change the other variables too, eg:

ORACLE_DATABASES=NETAPP20:smo;NETAPP21:smo

SQLPLUS_CMD_NETAPP20=/netappt20/ora00/product/10.2.0/bin/sqlplus

SQLPLUS_CMD_NETAPP21=/netappt21/ora00/product/10.2.0/bin/sqlplus

CNTL_FILE_BACKUP_DIR_NETAPP20=/data/ora99/arch1/NETAPP20/bkp_ctrl

CNTL_FILE_BACKUP_DIR_NETAPP21=/data/ora99/arch1/NETAPP21/bkp_ctrl

ORA_TEMP_NETAPP20=/data/ora99/arch1/NETAPP20/tmp

ORA_TEMP_NETAPP21=/data/ora99/arch1/NETAPP21/tmp

ARCHIVE_LOG_ONLY=N

ORACLE_HOME_NETAPP20=/netappt20/ora00/product/10.2.0

ORACLE_HOME_NETAPP21=/netappt21/ora00/product/10.2.0

ORACLE_EXPORT_PARAMETERS=Y

Thanks a lot

Thomas

justints
3,500 Views

I am afraid not ORACLE_HOME_<DB> should do the job.

Regards,

Justin Skariah

brauntvr2swiss
3,500 Views

Yes with ORACLE_HOME_<DB> it works perfectly...

regards

Thomas

Public