I'd be happy to do this...but, I have no choice in the
matter at this point. The people doing the application
on this box did it this was on their devel. box...and
insist at this time of keeping all files the same size
and in same directory structure...etc.
So, gotta figure how to compress this as best I can...
Kelly
--- Brian Mullin <[Email Address Removed] wrote:
> I'm not sure of the exact commands, but I'd create a
> new undo tablespace, point all transactions to it,
> drop the old one, rebuild the old one with smaller
> datafiles, then point all transactions to the new
> "old" undo tablespace and drop the temporary undo
> tablespace...if that's possible.
>
> -----Original Message-----
> From: K G [mailto:[Email Address Removed] Sent: Thursday, February 26, 2004 7:47 AM
> To: LazyDBA.com Discussion
> Subject: Cold Backup prob. How to tar/gzip 10Gig
> datafile??
>
>
> Hello all!!
>
> I'm trying to just get a simple cold backup going
> for
> a test database we have right now. The application
> install created one undo datafile that is 10G in
> size.
>
> I'm trying to get them to let me break it up, but,
> for
> now have to keep this way...they insist on mirroring
> their prototype model elsewhere while testing.
>
> Trouble is...when I tried zip -9 on the data
> files...that bombed.
>
> I then tried to tar them all...to pipe though gzip.
> However, tar blows up on this 10G file.
>
> Does anyone have any suggestions around this? Is
> there
> a version of tar that will handle larger file sizes?
>
> Thanks in advance!!
>
> Kelly
>
> =====
> ....Yeah...my other account is down...so, using this
> again.......
>
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
=====
....Yeah...my other account is down...so, using this again.......
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
Oracle LazyDBA home page