Data Backup and Recovery
Data Backup and Recovery
After reviewing the logs I noticed the following error in the section connecting to the DB:
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
stderr: [ORACLE_HOME=/oracle/SBW/: Command not found
export: Command not found
ORACLE_SID=SBW: Command not found
export: Command not found]
[Fri Jun 3 11:45:16 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/QDGwEXTyn4.sc] for database SBW finished successfully
[Fri Jun 3 11:45:16 2011] [leopard:9090(3.3.0.1)] DEBUG: Verifying correct of database SBW finished successfully
[Fri Jun 3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Database SBW is running Oracle 11
[Fri Jun 3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Verifying RAC status for database SBW
[Fri Jun 3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing SQL sequence:
connect / as sysdba;
show parameter CLUSTER_DATABASE;
exit;
[Fri Jun 3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/Ik7BkO_7jm.sc] for database SBW
[Fri Jun 3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Command [/bin/su - orasbw -c "ORACLE_HOME=/oracle/SBW/;export ORACLE_HOME;ORACLE_SID=SBW;export ORACLE_SID;/oracle/SBW/112_64/bin/sqlplus /nolog @/tmp/Ik7BkO_7jm.sc"] finished with
exit code: [0]
stdout: [Oracle Corporation SunOS 5.10 Generic Patch January 2005
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 11:45:17 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected.
--------------------------------------------------------------------------------
Is this an issue? It appears to connect to the DB correctly...
########## Application unquiesce ##########
[Fri Jun 3 11:45:19 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing databases
[Fri Jun 3 11:45:19 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing database SBW
[Fri Jun 3 11:45:19 2011] [leopard:9090(3.3.0.1)] DEBUG: Ending hot backup mode for database SBW
[Fri Jun 3 11:45:19 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing SQL sequence:
connect / as sysdba;
alter database end backup;
alter system archive log current;
exit;
[Fri Jun 3 11:45:19 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/V5oCPvyXPz.sc] for database SBW
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Command [/bin/su - orasbw -c "ORACLE_HOME=/oracle/SBW/;export ORACLE_HOME;ORACLE_SID=SBW;export ORACLE_SID;/oracle/SBW/112_64/bin/sqlplus /nolog @/tmp/V5oCPvyXPz.sc"] finished with
exit code: [0]
stdout: [Oracle Corporation SunOS 5.10 Generic Patch January 2005
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 11:45:20 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected.
Database altered.
System altered.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
stderr: [ORACLE_HOME=/oracle/SBW/: Command not found
export: Command not found
ORACLE_SID=SBW: Command not found
export: Command not found]
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/V5oCPvyXPz.sc] for database SBW finished successfully
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Ending hot backup mode for database SBW finished successfully
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Creating a backup controlfile for SBW to /oracle/SBW/origlogA/cntrl/netapp/SBW_postBackup_trace
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing SQL sequence:
connect / as sysdba;
alter database backup controlfile to trace as '/oracle/SBW/origlogA/cntrl/netapp/SBW_postBackup_trace' reuse;
exit;
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/yyr7jr9Odz.sc] for database SBW
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Command [/bin/su - orasbw -c "ORACLE_HOME=/oracle/SBW/;export ORACLE_HOME;ORACLE_SID=SBW;export ORACLE_SID;/oracle/SBW/112_64/bin/sqlplus /nolog @/tmp/yyr7jr9Odz.sc"] finished with
exit code: [0]
stdout: [Oracle Corporation SunOS 5.10 Generic Patch January 2005
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 11:45:20 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected.
Database altered.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
stderr: [ORACLE_HOME=/oracle/SBW/: Command not found
export: Command not found
ORACLE_SID=SBW: Command not found
export: Command not found]
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/yyr7jr9Odz.sc] for database SBW finished successfully
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Creating a backup controlfile for SBW to /oracle/SBW/origlogA/cntrl/netapp/SBW_postBackup_trace finished successfully
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing database SBW finished successfully
[Fri Jun 3 11:45:20 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing databases finished successfully
########## POST APPLICATION UNQUIESCE COMMANDS ##########
The SC oracle plugin does export of ORACLE_HOME and ORACLE_SID and the export command does not appear to be in the path, never seen that before but add export command to path so when you do "export ORACLE_HOME=/oracle/SBW" it works.
Regards,
Keith
They are using CSH. vs KSH/SH/BASH. That explains why 'export' does not work. Not sure why they are using CSH, they currently source all of their environment variables for Oracle via the .cshrc, etc... Have not seen this for about 15 years. I have a feeling since the entire environment is set up this way for Oracle they are going to be reluctant to change.
Everything appears to have ran from what I can see in the logs. How important is it that these vars are exported? Since the DB operations are successful....
Thanks,
Jerry
As long as everything else is working and we can connect / perform sqlplus operations they can be safely ignored, it isnt hurting anything if ORACLE_SID and ORACLE_HOME are set.
Keith