Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: The delay in backup controlfile as trace?

Re: The delay in backup controlfile as trace?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 27 Oct 2006 06:12:31 -0700
Message-ID: <1161954750.955485.131610@m7g2000cwm.googlegroups.com>

Ultra Kiasu wrote:
>
> Even sometimes, the current redo logs are not flushed to archive logs
> immediately when issue command "alter system switch logfile;"
>

Keep in mind this is not a blocking operation, so it may not have written the archived version of the online redo log when the statement completes (and may not for some time depending on I/O speed). Try 'alter system archive log current;' if you want to ensure it is written before your session "moves on".

HTH, Steve Received on Fri Oct 27 2006 - 08:12:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US