RE: re-archiving a redo log file

From: Miller, Jay <JayMiller_at_tdwaterhouse.com>
Date: Wed, 25 Jul 2001 11:02:44 -0700
Message-ID: <F001.00354E93.20010725112100@fatcity.com>

Hmm, would it work to do an OS level copy so long as you get to the redo log before it starts being written to again? Just a random thought...

-----Original Message-----
Sent: Wednesday, July 25, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L

I don't think, it's possible.
Most probably it checks 'archived' column in v$log. Also, it keeps track of archived files in v$archived_log.

Igor

Original Message ----- To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L Sent: Wednesday, July 25, 2001 11:55 AM

Is it possible to re-archive an already archived but still online redo log file?

the 8.1.6 sql*plus manual says it is, but I can't get the syntax down right apparently.

SQL> archive log 227

returns a ORA-16013 (does not need archiving) error and

SQL> archive log 227 to '/tmp'
returns
SP2-0718 illegal arhicve log option

Anybody done this?

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi.

Larry Wall (creator of Perl)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jul 25 2001 - 13:02:44 CDT