ADSM-L

SQL-Backtrack filespace deletion.

1999-12-22 15:33:11
Subject: SQL-Backtrack filespace deletion.
From: Sean McNamara <mcnams AT PJM DOT COM>
Date: Wed, 22 Dec 1999 15:33:11 -0500
Hello All,

        Over the past few days we have been seeing the following error message
during our nightly Oracle database backup using SQL-Backtrack:


02:31 backup of archived logs completed
02:32 backup of archived logs completed
[dtoexpire 15866] Object to be deleted is not found: /BACKTRACK:oracatalog
/OPER1 /archivelogs1-0.01-12-1999.02:20:47-34326!, error msg= ANS1302E (RC2)
No objects on server match query
[dtoexpire 15866] Object to be deleted is not found: /BACKTRACK:oracatalog
/OPER1 /archivelogs1-1.01-12-1999.02:20:47-34326!, error msg= ANS1302E (RC2)
No objects on server match query
[dtoexpire 15866] Object to be deleted is not found: /BACKTRACK:oracatalog
/OPER1 /archivelogs1-2.01-12-1999.02:20:47-34326!, error msg= ANS1302E (RC2)
No objects on server match query
[dtoexpire 15866] Object to be deleted is not found: /BACKTRACK:oracatalog
/OPER1 /archivelogs1-0.01-12-1999.02:24:01-32154!, error msg= ANS1302E (RC2)
No objects on server match query
[dtoexpire 15866] Object to be deleted is not found: /BACKTRACK:oracatalog
/OPER1 /archivelogs1-1.01-12-1999.02:24:01-32154!, error msg= ANS1302E (RC2)
No objects on server match query

        SQL-Backtrack is attempting to expire a backup that it no longer needs
and is asking ADSM to mark it as inactive.  ADSM is telling SQL-Backtrack that
it can not find the file  My take on it is that is an ownership problem.   If I
attempt to query the backups above as 'ORACLE', I cannot find any of them.  If I
query any of the backups above as 'ROOT', I find them without any problems. This
tells me that somewhere along the line the Backtrack backups are losing their
ownership and therefore can not be deleted during nightly processing.  Does any
of this make sense or am I gravely mistaken? Has anyone ever dealt with this
situation?

Environment - ADSM V3.1.2.40 running on AIX 4.2.1.  SQL-Backtrack V3.1.40

Any help is greatly appreciated,

Sean McNamara
PJM Interconnection L.L.C.
(610)666-4206
<Prev in Thread] Current Thread [Next in Thread>