Data Backup and Recovery Discussions

Multiple Oracle DBs with one Config

brauntvr2swiss

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

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

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

brauntvr2swiss

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

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

Regards,

Justin Skariah

brauntvr2swiss

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

regards

Thomas

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public