Re: re-archiving a redo log file

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 25 Jul 2001 09:47:25 -0700
Message-ID: <F001.00354B66.20010725084155@fatcity.com>

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
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Adams, Matthew (GEA, 088130) To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Wednesday, July 25, 2001 11:55
  AM
  Subject: re-archiving a redo log
  file

  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 <FONT   size=2>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' <FONT
  size=2>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. <FONT

  size=2>

Larry Wall (creator of Perl)

Received on Wed Jul 25 2001 - 11:47:25 CDT