Re: Archive log files are not being created

From: joel garry <joel-garry_at_home.com>
Date: Tue, 16 Apr 2013 08:48:54 -0700 (PDT)
Message-ID: <35ed5a62-07a7-4489-8977-fda56e1141cb_at_id10g2000pbc.googlegroups.com>

On Apr 15, 11:42 pm, mjms..._at_gmail.com wrote:
> I am doing some testing of the backup and recovery of our databases.
>
> I have a database which is in archive log mode.
>
> I have added some records to a table and I am expecting to see some archive files
> being written to but nothing is being produced.
>
> We are running Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
>
> The current archive information is as follows :
>
> SQL> archive log list;
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination USE_DB_RECOVERY_FILE_DEST
> Oldest online log sequence 1
> Next log sequence to archive 3
> Current log sequence 3
>
> SQL> show parameter db_recovery_file_dest;
>
> NAME TYPE VALUE
>
> --------------------------------------------------------------------------------
> -----------
> --------------------------------------------------------------------------------
>  db_recovery_file_dest string /export/flash_recovery_area
>
> When I look in the directory as indicated above I see no files :
>
> cd /export/flash_recovery_area/MRESTORE/archivelog/2013_04_16
> (no files)
>
> I'm wondering if I am missing something obvious here.
>
> Thank you in advance.

You can change an init.ora parameter archive_lag_target to force redo to switch and archive. See http://docs.oracle.com/cd/E14072_01/server.112/e10820/initparams009.htm

You can also manually switch logs.

jg

--
_at_home.com is bogus.
http://www.infoworld.com/d/security/oracle-release-128-patches-apps-database-and-middleware-216564

Received on Tue Apr 16 2013 - 17:48:54 CEST