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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Backing up ONLINE redo logs -- select?

Re: Backing up ONLINE redo logs -- select?

From: Paul Drake <bdbafh_at_gmail.com>
Date: Fri, 10 Jun 2005 14:45:07 -0400
Message-ID: <910046b4050610114567a54333@mail.gmail.com>


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?

by performing a (full) cold backup (physical).

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

the sound of one hand clapping
this should work:

SQL> select null from dual;

-bdbafh

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 10 2005 - 14:50:15 CDT

Original text of this message

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