Re: BACKUPS....help!

"Kevin S. Smith" wrote:
>
> I am working (still) on getting my backups right. Take this datafile for
> instance. I put the tablespace in backup mode, then begin to copy the file
> to tape. It is my understanding that backup mode 'freezes' the headers for
> that data file until until the tar is finished, then catches up once it is
> taken out of backup mode. Does that mean "file changed as we read it" is
> just FYI. I mean it is a warm backup and it is expected to change isn't it?
> Also I don't know what "Error exit delayed from previous errors" means. I
> am unsure what previous errors they are refering to. As you can probably
> tell, I am new, but trying like hell to get this thing working right. So
> any help is appreciated.
>
> SVRMGR> alter tablespace pmapp_large begin backup;
> Statement processed.
> SVRMGR> !tar -cvf /dev/nst0 /u02/oradata/pmapp/pmapp_large.dbf
> tar: Removing leading `/' from member names
> u02/oradata/pmapp/pmapp_large.dbf
> tar: /u02/oradata/pmapp/pmapp_large.dbf: file changed as we read it
> tar: Error exit delayed from previous errors
> SVRMGR> alter tablespace pmapp_large end backup;
> Statement processed.
> SVRMGR>

Yes, the files do change while their tablespace is in backup mode. It is the head, specifici\ally the SCN number that is left unchanged.

For a fairly decent description of how this all works, see the latest SYSADMIN magazine.

As for your error, you need to look at the tar man pages and possibly read up on how tar works.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.