Re: Backup Procedure

From: O'Brien Paddy (Paddy.O'Brien_at_transgrid.com.au)
Date: 06/18/05 

Date: Sat, 18 Jun 2005 19:01:58 +1000

From: Dave Greenwood on behalf of Dave Greenwood

[snips]

>I'd go with the $ SET NOON suggestion mentioned earlier in this
>thread. Put it just before the first BACKUP command.

Yes -- and multiple exclamation marks.

>My guess is that either BACKUP is returning an error status and your
>procedure is exiting on the implied "$ ON ERROR THEN EXIT", or BACKUP
>is returning a warning status and you have a "$ ON WARNING THEN EXIT"
>somewhere. Note that BACKUP will return a warning status if it tries
>to record the backup date and a file has been deleted between the
>actual backup and the recording passes. Also, BACKUP will return a
>warning status (%BACKUP-W-ACCONFLICT) if it encounters a file that's
>open for write by another process.

Also, (I have not seen any comment regarding this in this thread) although BACKUP returns only a warning for the ACCONFLICT, the final $status returned from BACKUP for that saveset is %X10A38410. This is an error status. I have not looked up what the text for this error is -- not sure which help/message file to look in.

Since I backup/image nightly all disks (180GB) on my production machine to one SDLT tape, SET NOON is the first command in my backup command file.

Regards, Paddy

***********************************************************************

"This electronic message and any attachments may contain privileged
and confidential information intended only for the use of the
addressees named above. If you are not the intended recipient of
this email, please delete the message and any attachment and advise
the sender. You are hereby notified that any use, dissemination,
distribution, reproduction of this email is prohibited.

If you have received the email in error, please notify TransGrid
immediately. Any views expressed in this email are those of the
individual sender except where the sender expressly and with
authority states them to be the views of TransGrid. TransGrid uses
virus-scanning software but excludes any liability for viruses
contained in any attachment.

Please note the email address for TransGrid personnel is now
firstname.lastname@transgrid.com.au"

***********************************************************************

Relevant Pages

  • Re: strange backup behavior
    ... But the tape must be being rewound between each BACKUP save operation. ... The procedure loops thru the disks, ... backup command on each disk. ...
    (comp.os.vms)
  • Re: DFHSM QUESTION - RELEASE BACKUP COMMAND
    ... DFHSM QUESTION - RELEASE BACKUP COMMAND ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ... Search the archives at http://bama.ua.edu/archives/ibm-main.html ...
    (bit.listserv.ibm-main)
  • Re: RMAN question
    ... >> the RMAN client's server. ... >the database server, so that the backup disks must be ... How about the normal Oracle Backup command? ...
    (comp.databases.oracle.server)
  • Re: How to backup/restore entire database in easiest way?
    ... The backup command are always ... executed on the server regardless of where you initiated the command. ... But the backup command is always executed under the context of the account ... SQL Server under a Domain account with rights to that share to do that. ...
    (microsoft.public.sqlserver.programming)
  • RE: sneak preview - BACKUP/REPAIR
    ... - especially code as old as VMS BACKUP, ... "This electronic message and any attachments may contain privileged ... If you have received the email in error, please notify TransGrid ... individual sender except where the sender expressly and with ...
    (comp.os.vms)
Loading