Re: newbie: cold backup questions

From: I hate Spam <tbf_at_cn.stam.dk>
Date: Mon, 18 Jun 2001 21:08:27 +0200
Message-ID: <96jsit8it6i9c3eas5jc8g6lig80gm3dm6@4ax.com>

On 18 Jun 2001 09:22:50 -0700, wonderinguy_at_hotmail.com (Wonderinguy) wrote:
>1. Shutdown database normal
>2. Issue OS level CP command on datafile,controlfile,redologs - UNIX
>syste,
>3. startup database.

If your database is shut down normal or immediate that method will provide a consistent backup, no problems

>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.

this is a mixture of steps necessary to make a hot backup (the "begin backup"/"end backup" parts), where you don't shutdown the database, and the cold backup where the database is shut down during the file copying, probably no harm done but really unnecessary. I guess the dd command is for raw devices, otherwise cp should be used. But I am not very experienced in Unix, I could be wrong.

Yours Hans Erik Busk
tbf_at_cn.stam.dk Received on Mon Jun 18 2001 - 14:08:27 CDT