Re: Backing up ONLINE redo logs -- select?
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx
- Date: Fri, 10 Jun 2005 14:45:07 -0400
On 6/10/05, J. Dex <cemail_219@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
