ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

SQL-Backtrack/w Oracle, all indication are good but no data backedup???

1998-02-17 10:05:34
Subject: SQL-Backtrack/w Oracle, all indication are good but no data backedup???
From: Tim White <twhite2 AT TUELECTRIC DOT COM>
Date: Tue, 17 Feb 1998 09:05:34 -0600 
We have and AIX server ver 4.2, ADSM server ver 3.1.0.1,
SQL BackTrack ver 2.3.1.5  and ADSM OBSI ver 2.2.1.
We, have completion with no error from the Oracle logs but no data
comes out in the files list. Hence no backup...
Help, help, help!!!

From the "q files"
CPRS01                         /BACKTRACK: SQL-BACK API:BACKT      0.0
0.0
                                tmp-contro  TRACK    RACK

                                l-dir

CPRS01                         /BACKTRACK: SQL-BACK API:BACKT      0.0
0.0
                                profiles    TRACK    RACK

CPRS01                         /BACKTRACK: SQL-BACK API:BACKT      0.0
0.0
                                prd1        TRACK    RACK


q files cprs01 f=d

                       Node Name: CPRS01
                  Filespace Name: /BACKTRACK:tmp-control-dir
                        Platform: SQL-BACKTRACK
                  Filespace Type: API:BACKTRACK
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time:
  Days Since Last Backup Started:
Last Backup Completion Date/Time:
Days Since Last Backup Completed:

                       Node Name: CPRS01
                  Filespace Name: /BACKTRACK:profiles
                        Platform: SQL-BACKTRACK
                  Filespace Type: API:BACKTRACK
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time:
  Days Since Last Backup Started:
Last Backup Completion Date/Time:
Days Since Last Backup Completed:

                       Node Name: CPRS01
                  Filespace Name: /BACKTRACK:prd1
                        Platform: SQL-BACKTRACK
                  Filespace Type: API:BACKTRACK
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time:
  Days Since Last Backup Started:
Last Backup Completion Date/Time:
Days Since Last Backup Completed:


More info. from the Oracle logs: (note this is a long file so I cut ut the
last few pages)
This may help you to no where we are.
09:11:17.09 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat10/nes_pcomp_01_010.dbf'
09:11:17.09 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat10/nes_pcomp_01_010.dbf'
09:11:17.12 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat11/nes_pcomp_01_011.dbf'
09:11:17.12 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat11/nes_pcomp_01_011.dbf'
09:11:17.15 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat12/nes_pcomp_01_012.dbf'
09:11:17.15 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat12/nes_pcomp_01_012.dbf'
09:11:17.18 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat13/nes_pcomp_01_013.dbf'
09:11:17.18 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat13/nes_pcomp_01_013.dbf'
09:11:17.21 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat14/nes_pcomp_01_014.dbf'
09:11:17.21 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat14/nes_pcomp_01_014.dbf'
09:11:17.24 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat15/nes_pcomp_01_015.dbf'
09:11:17.24 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat15/nes_pcomp_01_015.dbf'
09:11:17.28 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat16/nes_pcomp_01_016.dbf'
09:11:17.28 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat16/nes_pcomp_01_016.dbf'
09:11:17.31 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat17/nes_pcomp_01_017.dbf'
09:11:17.31 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat17/nes_pcomp_01_017.dbf'
09:11:17.35 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat18/nes_pcomp_01_018.dbf'
09:11:17.35 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat18/nes_pcomp_01_018.dbf'
09:11:17.39 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat19/nes_pcomp_01_019.dbf'
09:11:17.39 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat19/nes_pcomp_01_019.dbf'
09:11:17.43 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat20/nes_pcomp_01_020.dbf'
09:11:17.43 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat20/nes_pcomp_01_020.dbf'
09:11:17.46 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat21/nes_pcomp_01_021.dbf'
09:11:17.46 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat21/nes_pcomp_01_021.dbf'
09:11:17.49 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat22/nes_pcomp_01_022.dbf'
09:11:17.49 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat22/nes_pcomp_01_022.dbf'
09:11:17.53 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat23/nes_pcomp_01_023.dbf'
09:11:17.53 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat23/nes_pcomp_01_023.dbf'
09:11:17.56 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat24/nes_pcomp_01_024.dbf'
09:11:17.56 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat24/nes_pcomp_01_024.dbf'
09:11:17.59 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat25/nes_pcomp_01_025.dbf'
09:11:17.59 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat25/nes_pcomp_01_025.dbf'
09:11:17.62 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat26/nes_pcomp_01_026.dbf'
09:11:17.62 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat26/nes_pcomp_01_026.dbf'
09:11:17.67 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
FILE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE TABLESPACE_NAME =
'NES_PCOMP_IDX_01'
09:11:17.67 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
FILE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE TABLESPACE_NAME =
'NES_PCOMP_IDX_01'
09:11:17.83 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx01/nes_pcomp_01_001.idx'
09:11:17.83 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx01/nes_pcomp_01_001.idx'
09:11:17.86 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx02/nes_pcomp_01_002.idx'
09:11:17.86 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx02/nes_pcomp_01_002.idx'
09:11:17.89 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx03/nes_pcomp_01_003.idx'
09:11:17.89 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx03/nes_pcomp_01_003.idx'
09:11:17.93 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx04/nes_pcomp_01_004.idx'
09:11:17.93 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oraidx04/nes_pcomp_01_004.idx'
09:11:17.98 dtocheck[84750/70038.887641821](2854/oraquery.C): SELECT
GROUP#, STATUS, MEMBER FROM V$LOGFILE
09:11:17.98 dtoquery[65296/70038.887641821](2801/oraquery.C): SELECT
GROUP#, STATUS, MEMBER FROM V$LOGFILE
09:11:20.28 dtoquery[65296/70038.887641821]: ending on 02/16/98, rc=0
09:11:20.28 dtocheck[84750/70038.887641821]: ending on 02/16/98, rc=0
09:17:00.64 dtobackup[56386/70038.887641821]: starting on 02/16/98
09:17:00.65 dtobackup[56386/70038.887641821]: dtobackup -profiles
/tmp/datatools/profiles.prd1.70038.887641821 -online -full -status
-noredologs -nocheck -dbainfo /tmp/datatools/dbainfo.prd1.70038.887641821
-inner -inner_status
-inner -inner_status
09:17:00.98 dtoquery[78404/70038.887641821]: starting on 02/16/98
09:17:00.98 dtoquery[78404/70038.887641821]: starting on 02/16/98
09:17:00.98 dtoquery[78404/70038.887641821]:
/orabin/datatools/obacktrack-2.3.1.5/bin/dtoquery -inner -program dtobackup
 -pid 56386
09:17:02.84 dtoquery[78404/70038.887641821](2801/oraquery.C): SELECT ROLE
FROM SESSION_ROLES
09:17:19.01 dtodump[64702/70038.887641821]: starting on 02/16/98
09:17:19.01 dtodump[64702/70038.887641821]: dtodump -archivelog -online
-dbainfo /tmp/datatools/dbainfo.prd1.70038.887641821 -thread '1:4957-4957'
-to adsm.pool:
-to adsm.pool:
09:17:22.96 dtodump[64702/70038.887641821]: ending on 02/16/98, rc=0
09:17:22.96 dtodump[64702/70038.887641821]: ending on 02/16/98, rc=0
09:17:24.31 dtobackup[56386/70038.887641821](2854/oraquery.C): SELECT
TO_CHAR(CHECKPOINT_CHANGE#) FROM V$DATABASE
09:17:24.31 dtoquery[78404/70038.887641821](2801/oraquery.C): SELECT
TO_CHAR(CHECKPOINT_CHANGE#) FROM V$DATABASE
09:17:24.40 dtodump[45558/70038.887641821]: starting on 02/16/98
09:17:24.40 dtodump[45558/70038.887641821]: dtodump -controlfile -online
-dbainfo /tmp/datatools/dbainfo.prd1.70038.887641821 -to adsm.pool:
09:17:26.21 dtodump[45558/70038.887641821](2801/oraquery.C): ALTER DATABASE
09:17:26.21 dtodump[45558/70038.887641821](2801/oraquery.C): ALTER DATABASE
 BACKUP CONTROLFILE TO '/tmp/datatools/dtodump_controlfile45558.ctl' REUSE
09:17:44.80 dtodump[45558/70038.887641821]: ending on 02/16/98, rc=0
09:17:45.98 dtobackup[56386/70038.887641821](2854/oraquery.C): ALTER
TABLESPACE SYS_ORATRAINING BEGIN BACKUP
09:17:45.98 dtoquery[78404/70038.887641821](2801/oraquery.C): ALTER
TABLESPACE SYS_ORATRAINING BEGIN BACKUP
09:18:07.31 dtobackup[56386/70038.887641821](2854/oraquery.C): SELECT
V.STATUS FROM SYS.DBA_DATA_FILES D, V$BACKUP V WHERE V.FILE#=D.FILE_ID AND
D.TABLESPACE_NAME='SYS_ORATRAINING'
09:18:07.31 dtoquery[78404/70038.887641821](2801/oraquery.C): SELECT
V.STATUS FROM SYS.DBA_DATA_FILES D, V$BACKUP V WHERE V.FILE#=D.FILE_ID AND
D.TABLESPACE_NAME='SYS_ORATRAINING'
09:18:07.60 dtobackup[56386/70038.887641821](2854/oraquery.C): SELECT
TO_CHAR(CHECKPOINT_CHANGE#) FROM V$DATAFILE WHERE FILE# = 13 AND NAME IS
NOT NULL
09:18:07.60 dtoquery[78404/70038.887641821](2801/oraquery.C): SELECT
TO_CHAR(CHECKPOINT_CHANGE#) FROM V$DATAFILE WHERE FILE# = 13 AND NAME IS
NOT NULL
09:18:07.96 dtodump[32166/70038.887641821]: starting on 02/16/98
09:18:07.96 dtodump[32166/70038.887641821]: dtodump -noalter -datafiles
-file /oradat01/oratraining_01.dbf -online -dbainfo
/tmp/datatools/dbainfo.prd1.70038.887641821 -new_statistics
/tmp/datatools/dbainfo.prd1.70038.887641821 -new_statistics
/orabin/datatools/profiles/prd1/SYS_ORATRAINING/.oratraining_01.dbf.fn.13-1
998-02-16.56386.stat.temp -to adsm.pool:
09:18:09.64 dtodump[32166/70038.887641821](2801/oraquery.C): SELECT
TABLESPACE_NAME, FILE_ID FROM SYS.DBA_DATA_FILES WHERE FILE_NAME =
'/oradat01/oratraining_01.dbf'
09:18:09.87 dtodump[32166/70038.887641821](2801/oraquery.C): SELECT
BLOCK_ID, BLOCKS FROM SYS.DBA_FREE_SPACE WHERE FILE_ID = 13
09:18:10.30 dtodump[32166/70038.887641821]: ending on 02/16/98, rc=0
09:18:10.37 dtobackup[56386/70038.887641821](2854/oraquery.C): ALTER
TABLESPACE SYS_ORATRAINING END BACKUP
09:18:10.37 dtoquery[78404/70038.887641821](2801/oraquery.C): ALTER
TABLESPACE SYS_ORATRAINING END BACKUP
09:18:25.51 dtobackup[56386/70038.887641821](2854/oraquery.C): SELECT
TO_CHAR(FHBCP_SCN), FHBCP_TIM FROM dto$kcvfh WHERE HXFIL = 13
09:18:25.51 dtoquery[78404/70038.887641821](2801/oraquery.C): SELECT
TO_CHAR(FHBCP_SCN), FHBCP_TIM FROM dto$kcvfh WHERE HXFIL = 13
09:18:26.95 dtobackup[56386/70038.887641821](2854/oraquery.C): ALTER SYSTEM
 ARCHIVE LOG ALL
09:18:26.95 dtoquery[78404/70038.887641821](2801/oraquery.C): ALTER SYSTEM
ARCHIVE LOG ALL
09:18:26.96 dtobackup[56386/70038.887641821](2854/oraquery.C): ALTER SYSTEM
 ARCHIVE LOG CURRENT
09:18:26.96 dtoquery[78404/70038.887641821](2801/oraquery.C): ALTER SYSTEM
ARCHIVE LOG CURRENT
09:18:45.47 dtodump[53308/70038.887641821]: starting on 02/16/98
09:18:45.48 dtodump[53308/70038.887641821]: dtodump -archivelog -online
-dbainfo /tmp/datatools/dbainfo.prd1.70038.887641821 -thread '1:4958-4958'
-to adsm.pool:
-to adsm.pool:
09:18:48.64 dtodump[53308/70038.887641821]: ending on 02/16/98, rc=0
09:18:48.64 dtodump[53308/70038.887641821]: ending on 02/16/98, rc=0
09:18:50.03 dtodump[53388/70038.887641821]: starting on 02/16/98
09:18:50.03 dtodump[53388/70038.887641821]: dtodump -parmfile -online
-dbainfo /tmp/datatools/dbainfo.prd1.70038.887641821 -to adsm.pool:
09:18:51.88 dtodump[53388/70038.887641821]: ending on 02/16/98, rc=0
09:18:51.88 dtodump[53388/70038.887641821]: ending on 02/16/98, rc=0
09:18:53.06 dtoquery[78404/70038.887641821]: ending on 02/16/98, rc=0
09:18:53.06 dtobackup[56386/70038.887641821]: ending on 02/16/98, rc=0
09:32:28.27 dtoquery[85404/70038.887641821]: ending on 02/16/98, rc=0
09:32:28.27 obacktrack[70038]: ending on 02/16/98, rc=0




Timothy White, P.E. - CPSES Information Technology, Tech Support

V-Mail: (254) 897-6897      Fax: (254) 897-6777      E-Mail:
        twhite2 AT tuelectric DOT com      PROFS: IWIF2

Pager: (817) 432-4402       Pager E-Mail: 8174324402 AT alphapage.airtouch DOT 
com



                         Keep God in your life...
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
  • SQL-Backtrack/w Oracle, all indication are good but no data backedup???, Tim White <=
Previous by Date:  Re: Central logging for client errors, Prather, Wanda
Next by Date:  Re: SQL-Backtrack/w Oracle, all indication are good but no d, Andrew Raibeck
Previous by Thread:  show volumeusage, Sanders, David
Next by Thread:  Re: SQL-Backtrack/w Oracle, all indication are good but no d, Andrew Raibeck
Indexes:  [Date] [Thread] [Top] [All Lists]