Re: EXP Parameters to take backup of 110 GB database

On Fri, 03 Aug 2007 02:13:02 -0700, Jitendra <jpsingh1978_at_gmail.com> wrote:

>Hi All,
>
>I have to take backup of 110GB Database. I have taken physical backup
>on tape, now I want to take Logical backup of whole database.
>
>What parameters should I use in EXP command (Using 9i Exp) ?
>
>Thanks and Regards,
>Jitendra

I would exercise my TSPITR procedures. Exporting a 110 Gb database is just ridiculous. You are not going to IMP it ever, do you? How would you plan to deal with the redolog. TSPITR doesn't generate redolog.

-- 
Sybrand Bakker
Senior Oracle DBA