Re: Backup Oracle ? Online Redo Log.

Han,

Yes, you can use Hot Backups to recover from. However, 'Hot Backup' means in the sense Oracle allows you to take a hot backup --- not just copying the file with an OS command.
You issue an
ALTER TABLESPACE <tablespacename> BEGIN BACKUP; before you start copying the files _of_that_tablespace_! with an OS command ("copy", "cp", "dd", "tar", ... whatever and an
ALTER TABLESPACE <tablespacename> END BACKUP;

You had better read up on the Backup and Recovery procedures well. You could also use Oracle RMAN to do your Hot Backups.

Hemant K Chitale

"Han Thomas" <han_at_royal.net> wrote in message news:k7454uk11sh045cetuliqqjmdeqvjsr4ac_at_4ax.com...
> On 13 Jan 2002 18:13:49 -0800, in comp.databases.oracle.server you wrote:
>
> >> >1) Restore of my hot backup of the night ( DATAFILES )
> >>
> >> Hold on, can you do that? I thought you needed cold backup files to
start
> >> with, then apply the archived log files??
> >
> >Yes, you can. No, you dont. Why cant you restore from hot backup and
> >apply the archived logfiles ? What is the point of a hot backup if you
> >always need a cold backup to start with.
>
> Well I thought you kept one cold set and just keep storing redo-logfiles
> forever. Then if your server crashes a year later you'd have to apply one
year
> of redo logs. So that isn't the case I guess.. And you can use regular
> operating system commands to do the hot backup? A regular copy of all the
> datafiles?
>
> Then I understand the control files only have to be backed up after
structural
> changes are made to the database, such as adding or removing tablespaces
and
> datafiles?
>
> Thansk a lot!
> Han.
Received on Mon Jan 14 2002 - 08:31:53 CST