Backing up ONLINE redo logs -- select?

From: J. Dex <cemail_219_at_hotmail.com>
Date: Fri, 10 Jun 2005 14:30:07 -0400
Message-ID: <BAY106-F62CED6139CA4873688806A5FF0@phx.gbl>

As part of a hot backup script for an Oracle 8.1.7 database, I've been asked to backup the archive logs AND the online redo logs. How would you backup the ONLINE redo logs?

The current script which I was asked to alter gathers the data, puts it into a table and then spools out the actual script that will run. Below is the 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?

insert into hot_backup_script (select '!cp '||name||' $BACKUPS/archivelog' from v$archived_log);

---

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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

Received on Fri Jun 10 2005 - 14:35:11 CDT