Re: Hot backup

In article <4ec8pj$5g3_at_news.nyc.pipeline.com>,

   Sameer Utrankar <utrankar_at_nyc.pipeline.com> wrote:
>Usual examples of Hot backup scripts are :
>
>Alter tablespace1 begin backup
>backup tablespace1
>alter tablespace1 end backup
>
>alter tablespace2 begin backup
>..
>and so on ?
>
>It is a lot easier to setup and manage a script which does begin backup
>on all tablespaces, backups all and then does end backup on all of them.
>What is the problem in doing so ? Any downside ?
>

My understanding is that if you crash the system during this type of backup, then recovery will take longer (since there are more datafiles that will need recovery).

Lowell R. Snyder, Jr.             Lord Einar Sclater of Orkney
Network Manager                   Kingdom of Caid
Data Exchange Corp.               Society for Creative Anachronism
lowells_at_dex.com                   einar_at_dex.com