Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Backing up ONLINE redo logs -- select?
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-lReceived on Fri Jun 10 2005 - 14:50:15 CDT