Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> newbie: cold backup questions

newbie: cold backup questions

From: Wonderinguy <wonderinguy_at_hotmail.com>
Date: 18 Jun 2001 09:22:50 -0700
Message-ID: <6950e82.0106180822.795d44ec@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 - 11:22:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US