Sample Oracle Trace File
Oracle on the AIX OS Configuration for Remote Volume Mirroring . . . . . . . . . . . . . . . . . . . . . . . . .
4-4
Remote Mirroring of an Oracle Database Using Data Replicator Software
Sample Oracle Trace File:
#-------------------------------------------------------------
# Start of /opt/LSI_ERM/db_suspend @ 10:30:27
#-------------------------------------------------------------
# su - oracle -c sqlplus -s / as sysdba @ /opt/LSI_ERM/
db_check_pfile.sql | tail -1
INFO: $SPFILE=/opt/oracle/product/10.2.0/dbs/spfileoradb.ora
# su - oracle -c sqlplus -s / as sysdba @ /opt/LSI_ERM/
db_backup_controlfile.sql
STATUS: 0
/opt/oracle/product/10.2.0/admin/oradb/udump/
oradb_ora_352336.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/product/10.2.0
System name:AIX
Node name:darien
Release:3
Version:5
Machine:000FB34A4C00
Instance name: oradb
Redo thread mounted by this instance: 1
Oracle process number: 16
Unix process pid: 352336, image: oracle@darien (TNS V1-V3)
*** SERVICE NAME:(SYS$USERS) 2007-03-22 10:30:29.174
*** SESSION ID:(153.294) 2007-03-22 10:30:29.174
*** 2007-03-22 10:30:29.174
INFO: $CNTRL_START=65
INFO: $CNTRL_END=102
# head -102 /opt/oracle/product/10.2.0/admin/oradb/udump/
oradb_ora_352336.trc | tail +65 | sed '/^--/d' > /opt/oracle/
product/10.2.0/admin/oradb/udump/remote_startup.sql
INFO: Oracle startup script = /opt/oracle/product/10.2.0/admin/
oradb/udump/remote_startup.sql
# su - oracle -c sqlplus -s / as sysdba @ /opt/LSI_ERM/
db_begin_backup.sql
STATUS: 0
INFO: Database oradb is now in backup mode (10:30:30)
#-------------------------------------------------------------
# End of /opt/LSI_ERM/db_suspend @ 10:30:31
#-------------------------------------------------------------
#-------------------------------------------------------------
# Start of /opt/LSI_ERM/db_resume @ 10:31:21
#-------------------------------------------------------------
# su - oracle -c sqlplus -s / as sysdba @ /opt/LSI_ERM/
db_end_backup.sql
STATUS: 0
INFO: Database oradb is now online (10:31:22)