Re: newbie: cold backup questions

Oh, one note. I'd do a shutdown immediate rather than a shutdown normal. That way, any lingering sessions will be disconnected automatically.

Regards,
Dave

David Sisk <davesisk_at_ipass.net> wrote in message news:88wX6.150481$e34.20046510_at_typhoon.southeast.rr.com...
> Method #1 will work fine for cold backups (assuming you're using cooked
 disk
> rather than raw disk). Ignore whatever idiot gave you the steps for
 method
> #2.
>
> Regards,
> Dave
>
> Wonderinguy <wonderinguy_at_hotmail.com> wrote in message
> news:6950e82.0106180822.795d44ec_at_posting.google.com...
> > Folks, I am pretty new to oracle and I would appreciate your opinion
> > on this issue. I have setup a cold backup script which basically does
> > this :
> >
> > 1. Shutdown database normal
> > 2. Issue OS level CP command on datafile,controlfile,redologs - UNIX
> > syste,
> > 3. startup database.
> >
> > Recently I have been told, that the way I take the backup is wrong,
> > and chance of block corruption can occur or can go undetected by this.
> > The way it should be done is :
> >
> > 1. Alter the table to either begin backup or read only
> > 2. shutdown the database
> > 3. use DD instead of CP
> > 4. startup database
> > 5. alter the tablespace backup to end backup or read write mode.
> >
> >
> > I have not found so far any major error in the way I use to backup. Is
> > there anything wrong the first method ? I do not have problem
> > switching to second method, if the first one is not the best way.
> >
> > Thanks in advance.
>
>
Received on Mon Jun 18 2001 - 18:28:52 CDT