Re: Oracle Backup

In article <D1MvHn.H1o_at_nntpa.cb.att.com> lou2_at_cbnews.cb.att.com (louis.avrami..jr) writes:
>In article <3dvdka$sgg_at_rainbow.rmii.com>,
>Sanford Zelkovitz <sandy_at_rmii.com> wrote:
>>
>>Does anyone have a public domain/share package that can do a database backup
>>on data that is stored in a raw partition? Please note that "dd" is not a
>>solution since the raw partition is 50 gigabytes in size and the data
>>only occupies a small fraction of the partition.
>>
>>Thanks,
>>Sanford <sandy> Zelkovitz
>
>Sanford,
>
> I am assuming that you are running some version of UNIX. Does it
>have the "volcopy" command? On SVR4, it's found in /usr/sbin. My raw
>partitions are much smaller than yours (only 250 Mb), but we've found that
>volcopy does a much faster job than dd.
>
> As a dirty alternative, is it practical to export whatever is in
>the partition to a file, and back it up as part of the file system? Or
>even export directly to tape, as another thread here has talked about?
>
>Lou Avrami ( attmail!lavrami )

	Sanford, I think you're screwed.
	As far as I know there is no way to perform an on-line backup of
	an oracle tablespace without copying the entire datafile.
	Your only alternative is to perform offline backups using
	exports.
	I would advise you to consider breaking this thing up into
	manageable sized pieces if possible.  It would enable you to
	set up a backup schedule that would back up a part of the database
	each day.
	\             ____       Chaz Sliger
	 \            ___\\        Portland, OR
	__\===\    __/_HD)\\<)       chaz_at_atlas.com
	 /   \ \==/ V V  /  \\ __      "Let the rough side drag,
	| (_at_) |_____###/     \/  \      Let the smooth side show..."
	 \___/  89 FXSTS      \__/        -Jesse Winchester
	==========================================================