Backup-info

From: Joya M. Sharif <joya_at_mhd1.moorhead.msus.edu>
Date: 2 Aug 94 14:55:31 -0500
Message-ID: <1994Aug2.145532.711_at_msus1.msus.edu>

Hi EverBody:
How can I know that my oracle datafile has been backedup. I am doing online tablespace backup. Also Archievelog is on too.       

I am try tar to see, do not know how?

SU% dbfsize /usr/users2/oracle_woda/d_asp_ts.dbf Database file: /usr/users2/oracle_woda/d_asp_ts.dbf Database file type: file system
Database size: 7680 2048 byte blocks

-----------------Script start here--------------------------------

/usr/users/oracle/bin/sqldba <<!
connect internal;
alter tablespace ASPHALTTS begin backup; host dd if=/usr/users2/oracle_woda/d_asp_ts.dbf of=/dev/rmt0h bs=2k count=7681 alter tablespace ASPHALTTS end backup;
exit;
!       

SQL*DBA: Release 7.0.15.4.2 - Production on Tue Aug 2 14:12:51 1994 ORACLE7 Server Release 7.0.15.4.2 - Production With the procedural and distributed options

SQLDBA> Connected.
SQLDBA> Statement processed.
SQLDBA> 7681+0 records in

7681+0 records out
SQLDBA> Statement processed.
SQLDBA> 2> 3> 4> 5> 6> SQL*DBA complete.
root#
root# tar tvf /dev/rmt0h /usr/users2/oracle_woda tar: blocksize = 4
root#
root# tar tvf /dev/rmt0h /usr/users2/oracle_woda/d_asp_ts.dbf tar: blocksize = 4
root# tar t

Will appreciate any help!
Thanks
joya joya_at_mhd1.moorhead.msus.edu (joya_at_134.29.97.1) Received on Tue Aug 02 1994 - 21:55:31 CEST