Re: Backing up ONLINE redo logs -- select?

J.,

If it is a hot backup you don't backup the online redo logs. While the database is open the redo logs are constantly changing and you will most likely get an inconsistent copy. Best practice is to not copy the redo logs in order to reduce the possible confusion during a recovery.

Who asked you to backup the redo logs during a hot backup?

Steven

On 6/10/05, J. Dex <cemail_219_at_hotmail.com> wrote:
> As part of a hot backup script for an Oracle 8.1.7 database, I've been as=
ked
> to backup the archive logs AND the online redo logs. How would you back=
up
> the ONLINE redo logs?
>=20
> The current script which I was asked to alter gathers the data, puts it i=
nto
> a table and then spools out the actual script that will run. Below is th=
e
> statement it runs for the archivelogs, but I need to know what to do for =
the
> ONLINE redo logs. What should the select statement for online redo logs
> look like?
>=20
> insert into hot_backup_script (select '!cp '||name||' $BACKUPS/archivelog=
'
> from v$archived_log);
>=20
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE=
!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l