Re: Database Backups
2002-11-18 15:17:09
Do you have roll-forward mode enabled or database backup trigger enabled?
Do a 'Q ST' and see if you do. If so, you might have to set your database
backup trigger higher than its set now.
Rob.
From: "Taha, Hana" <Hana.Taha AT PARKERDRILLING DOT COM> on 11/18/2002 02:39 PM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Database Backups
Hello TSMers,
This is probably a very basic question to some of you, but one that has had
me going crazy for the last two weeks.
My problem is this.... I have two schedules to perform database backups.
One
is full and the other is incremental. See my schedules below.
Schedule Name ADSM_DATABASE_BACKUP
Description Full backup of ADSM Database
Command backup db dev=8mmexdev type=full
Priority 5
Start date 2002-06-24
Start time 06:00:00
Duration 10
Duration units MINUTES
Period 1
Period units DAYS
Day of Week MONDAY
Expiration -
Active? YES
Last Update Date/Time 2002-06-25 13:47:24.000000
Last Update by (administrator) HANA
Managing profile -
Schedule Name ADSM_DATABASE_BACKUP_INCR
Description Incremental Backup of ADSM Database on Thurs. ONLY
Command ba db dev=8mmexdev t=incr
Priority 5
Start date 2002-03-18
Start time 06:00:00
Duration 15
Duration units MINUTES
Period 1
Period units DAYS
Day of Week THURSDAY
Expiration -
Active? YES
Last Update Date/Time 2002-06-25 13:47:40.000000
Last Update by (administrator) HANA
Managing profile
-
My question is this: Why am I getting database backups on days that I am
not
supposed to get dbb's? On saturday, I logged in and I had delete 8 dbb's to
free up some tapes for our full backups. This mess is eating up all my
scratch tapes.
This morning, I logged in and I had a backup done on Sunday and two done
today.
I was only expecting to see one backup performed this morning at 6am.
So where am I going wrong. Is the schedule working as it should, or am I
correct that I have a problem?
Please review the Activity log below for more information.
Thanks in advance!
Date/Time: 11/17/02 08:00:11
Volume Type: BACKUPFULL
Backup Series: 396
Backup Operation: 0
Volume Seq: 1
Device Class: 8MMEXDEV
Volume Name: 00000021
Volume Location:
Command:
Date/Time: 11/18/02 06:00:10
Volume Type: BACKUPFULL
Backup Series: 397
Backup Operation: 0
Volume Seq: 1
Device Class: 8MMEXDEV
Volume Name: 00000050
Volume Location:
Command:
Date/Time: 11/18/02 08:00:04
Volume Type: BACKUPFULL
Backup Series: 398
Backup Operation: 0
Volume Seq: 1
Device Class: 8MMEXDEV
Volume Name: 00000076
Volume Location:
Command:
Operation Results
Date/Time Message
--------------------
----------------------------------------------------------
11/11/02 15:30:18 ANR2017I Administrator HANA issued command: QUERY
EVENT
ADSM_DATABASE_BACKUP TYPE=ADMIN BEGINDATE=11/11/2002
BEGINTIME=00:00 ENDDATE=11/11/2002 ENDTIME="15:30:06
" EXCEPTIONSONLY=NO FORMAT=STANDARD
11/12/02 08:00:12 ANR0984I Process 330 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:12.
11/12/02 08:00:12 ANR2280I Full database backup started as process 330.
11/12/02 08:01:50 ANR4554I Backed up 8496 of 68093 database pages.
11/12/02 08:01:57 ANR4554I Backed up 16992 of 68093 database pages.
11/12/02 08:02:03 ANR4554I Backed up 25488 of 68093 database pages.
11/12/02 08:02:11 ANR4554I Backed up 33984 of 68093 database pages.
11/12/02 08:02:17 ANR4554I Backed up 42480 of 68093 database pages.
11/12/02 08:02:24 ANR4554I Backed up 50976 of 68093 database pages.
11/12/02 08:02:30 ANR4554I Backed up 59472 of 68093 database pages.
11/12/02 08:02:50 ANR4554I Backed up 67968 of 68093 database pages.
11/12/02 08:02:59 ANR4550I Full database backup (process 330) complete,
68093 pages copied.
11/12/02 08:02:59 ANR0985I Process 330 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:02:59.
11/13/02 08:00:16 ANR0984I Process 337 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:16.
11/13/02 08:00:16 ANR2280I Full database backup started as process 337.
11/13/02 08:01:32 ANR4554I Backed up 8512 of 68099 database pages.
11/13/02 08:01:41 ANR4554I Backed up 17024 of 68099 database pages.
11/13/02 08:01:50 ANR4554I Backed up 25536 of 68099 database pages.
11/13/02 08:01:59 ANR4554I Backed up 34048 of 68099 database pages.
11/13/02 08:02:09 ANR4554I Backed up 42560 of 68099 database pages.
11/13/02 08:02:18 ANR4554I Backed up 51072 of 68099 database pages.
11/13/02 08:02:29 ANR4554I Backed up 59584 of 68099 database pages.
11/13/02 08:02:55 ANR4554I Backed up 68096 of 68099 database pages.
11/13/02 08:03:04 ANR4550I Full database backup (process 337) complete,
68099 pages copied.
11/13/02 08:03:04 ANR0985I Process 337 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:03:04.
11/14/02 06:00:15 ANR2750I Starting scheduled command
ADSM_DATABASE_BACKUP-
_INCR ( ba db dev=8mmexdev t=incr ).
11/14/02 06:00:25 ANR0984I Process 342 for DATABASE BACKUP started in
the
BACKGROUND at 06:00:25.
11/14/02 06:00:25 ANR2281I Incremental database backup started as
process
342.
11/14/02 06:00:25 ANR2753I (ADSM_DATABASE_BACKUP_INCR):ANR2281I
Incremental
database
11/14/02 06:00:25 ANR2753I (ADSM_DATABASE_BACKUP_INCR):backup started
as
process 342.
11/14/02 06:00:25 ANR2756I Scheduled command ADSM_DATABASE_BACKUP_INCR
started successfully.
11/14/02 06:01:30 ANR4554I Backed up 224 of 1891 database pages.
11/14/02 06:01:31 ANR4554I Backed up 448 of 1891 database pages.
11/14/02 06:01:31 ANR4554I Backed up 672 of 1891 database pages.
11/14/02 06:01:32 ANR4554I Backed up 896 of 1891 database pages.
11/14/02 06:01:32 ANR4554I Backed up 1120 of 1891 database pages.
11/14/02 06:01:33 ANR4554I Backed up 1344 of 1891 database pages.
11/14/02 06:01:34 ANR4554I Backed up 1568 of 1891 database pages.
11/14/02 06:01:34 ANR4554I Backed up 1792 of 1891 database pages.
11/14/02 06:01:44 ANR4551I Incremental database backup (process 342)
complete, 1891 pages copied.
11/14/02 06:01:44 ANR0985I Process 342 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
06:01:44.
11/14/02 08:00:12 ANR0984I Process 343 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:12.
11/14/02 08:00:12 ANR2280I Full database backup started as process 343.
11/14/02 08:01:30 ANR4554I Backed up 8512 of 68141 database pages.
11/14/02 08:01:37 ANR4554I Backed up 17024 of 68141 database pages.
11/14/02 08:01:44 ANR4554I Backed up 25536 of 68141 database pages.
11/14/02 08:01:51 ANR4554I Backed up 34048 of 68141 database pages.
11/14/02 08:01:58 ANR4554I Backed up 42560 of 68141 database pages.
11/14/02 08:02:04 ANR4554I Backed up 51072 of 68141 database pages.
11/14/02 08:02:10 ANR4554I Backed up 59584 of 68141 database pages.
11/14/02 08:02:30 ANR4554I Backed up 68096 of 68141 database pages.
11/14/02 08:02:40 ANR4550I Full database backup (process 343) complete,
68141 pages copied.
11/14/02 08:02:40 ANR0985I Process 343 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:02:40.
11/15/02 08:00:11 ANR0984I Process 348 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:11.
11/15/02 08:00:11 ANR2280I Full database backup started as process 348.
11/15/02 08:01:23 ANR4554I Backed up 8512 of 68200 database pages.
11/15/02 08:01:28 ANR4554I Backed up 17024 of 68200 database pages.
11/15/02 08:01:36 ANR4554I Backed up 25536 of 68200 database pages.
11/15/02 08:01:43 ANR4554I Backed up 34048 of 68200 database pages.
11/15/02 08:01:50 ANR4554I Backed up 42560 of 68200 database pages.
11/15/02 08:01:56 ANR4554I Backed up 51072 of 68200 database pages.
11/15/02 08:02:03 ANR4554I Backed up 59584 of 68200 database pages.
11/15/02 08:02:25 ANR4554I Backed up 68096 of 68200 database pages.
11/15/02 08:02:34 ANR4550I Full database backup (process 348) complete,
68200 pages copied.
11/15/02 08:02:35 ANR0985I Process 348 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:02:35.
11/16/02 08:00:12 ANR0984I Process 354 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:12.
11/16/02 08:00:12 ANR2280I Full database backup started as process 354.
11/16/02 08:01:26 ANR4554I Backed up 8528 of 68235 database pages.
11/16/02 08:01:34 ANR4554I Backed up 17056 of 68235 database pages.
11/16/02 08:01:43 ANR4554I Backed up 25584 of 68235 database pages.
11/16/02 08:01:53 ANR4554I Backed up 34112 of 68235 database pages.
11/16/02 08:02:03 ANR4554I Backed up 42640 of 68235 database pages.
11/16/02 08:02:12 ANR4554I Backed up 51168 of 68235 database pages.
11/16/02 08:02:22 ANR4554I Backed up 59696 of 68235 database pages.
11/16/02 08:02:50 ANR4554I Backed up 68224 of 68235 database pages.
11/16/02 08:02:59 ANR4550I Full database backup (process 354) complete,
68235 pages copied.
11/16/02 08:02:59 ANR0985I Process 354 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:02:59.
11/17/02 08:00:11 ANR0984I Process 359 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:11.
11/17/02 08:00:11 ANR2280I Full database backup started as process 359.
11/17/02 08:01:22 ANR4554I Backed up 8528 of 68253 database pages.
11/17/02 08:01:28 ANR4554I Backed up 17056 of 68253 database pages.
11/17/02 08:01:35 ANR4554I Backed up 25584 of 68253 database pages.
11/17/02 08:01:41 ANR4554I Backed up 34112 of 68253 database pages.
11/17/02 08:01:48 ANR4554I Backed up 42640 of 68253 database pages.
11/17/02 08:01:54 ANR4554I Backed up 51168 of 68253 database pages.
11/17/02 08:02:00 ANR4554I Backed up 59696 of 68253 database pages.
11/17/02 08:02:20 ANR4554I Backed up 68224 of 68253 database pages.
11/17/02 08:02:29 ANR4550I Full database backup (process 359) complete,
68253 pages copied.
11/17/02 08:02:29 ANR0985I Process 359 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:02:29.
11/18/02 06:00:00 ANR2750I Starting scheduled command
ADSM_DATABASE_BACKUP (
backup db dev=8mmexdev type=full ).
11/18/02 06:00:10 ANR0984I Process 362 for DATABASE BACKUP started in
the
BACKGROUND at 06:00:10.
11/18/02 06:00:10 ANR2280I Full database backup started as process 362.
11/18/02 06:00:10 ANR2753I (ADSM_DATABASE_BACKUP):ANR2280I Full
database
backup
11/18/02 06:00:10 ANR2753I (ADSM_DATABASE_BACKUP):started as process
362.
11/18/02 06:00:10 ANR2756I Scheduled command ADSM_DATABASE_BACKUP
started
successfully.
11/18/02 06:01:22 ANR4554I Backed up 8528 of 68256 database pages.
11/18/02 06:01:28 ANR4554I Backed up 17056 of 68256 database pages.
11/18/02 06:01:36 ANR4554I Backed up 25584 of 68256 database pages.
11/18/02 06:01:45 ANR4554I Backed up 34112 of 68256 database pages.
11/18/02 06:01:55 ANR4554I Backed up 42640 of 68256 database pages.
11/18/02 06:02:04 ANR4554I Backed up 51168 of 68256 database pages.
11/18/02 06:02:14 ANR4554I Backed up 59696 of 68256 database pages.
11/18/02 06:02:42 ANR4554I Backed up 68224 of 68256 database pages.
11/18/02 06:02:52 ANR4550I Full database backup (process 362) complete,
68256 pages copied.
11/18/02 06:02:52 ANR0985I Process 362 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
06:02:52.
11/18/02 08:00:04 ANR0984I Process 363 for DATABASE BACKUP started in
the
BACKGROUND at 08:00:04.
11/18/02 08:00:04 ANR2280I Full database backup started as process 363.
11/18/02 08:01:14 ANR4554I Backed up 8528 of 68238 database pages.
11/18/02 08:01:21 ANR4554I Backed up 17056 of 68238 database pages.
11/18/02 08:01:27 ANR4554I Backed up 25584 of 68238 database pages.
11/18/02 08:01:34 ANR4554I Backed up 34112 of 68238 database pages.
11/18/02 08:01:41 ANR4554I Backed up 42640 of 68238 database pages.
11/18/02 08:01:47 ANR4554I Backed up 51168 of 68238 database pages.
11/18/02 08:01:54 ANR4554I Backed up 59696 of 68238 database pages.
11/18/02 08:02:13 ANR4554I Backed up 68224 of 68238 database pages.
11/18/02 08:02:22 ANR4550I Full database backup (process 363) complete,
68238 pages copied.
11/18/02 08:02:22 ANR0985I Process 363 for DATABASE BACKUP running in
the
BACKGROUND completed with completion state SUCCESS
at
08:02:22.
11/18/02 13:17:33 ANR2017I Administrator HANA issued command: QUERY
ACTLOG
BEGINDATE=11/11/2002 BEGINTIME=NOW-1:00
ENDDATE=11/18/2-
002 ENDTIME=NOW SEARCH=Database ORIGINATOR=ALL
11/17/02 11:30:09 ANR2017I Administrator HANA issued command: DELETE
VOLHISTORY tod=today-2 t=dbb
11/17/02 11:30:09 ANR2467I DELETE VOLHISTORY: 6 sequential volume
history
entries were successfully deleted.
11/17/02 11:30:33 ANR2017I Administrator HANA issued command: DELETE
VOLHISTORY tod=today-1 t=dbb
11/17/02 11:30:34 ANR2467I DELETE VOLHISTORY: 1 sequential volume
history
entries were successfully deleted.
11/17/02 11:30:58 ANR2467I DELETE VOLHISTORY: 1 sequential volume
history
entries were successfully deleted.
Hana Taha
Parker Drilling Company
281.406.2486
|
|
|