Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie: cold backup questions
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:04 CDT