Archive log files are not being created

[mjm...@gmail.com]

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.

[epok...@gmail.com]

Perhaps "some records" needs to be changed to LOTS of records to force an "archiving". Your online redo files size could be large enough to handle quite a bit of database update activity before it's "full" and needs to do an archive.

[joel garry]

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
--
@home.com is bogus.
http://www.infoworld.com/d/security/oracle-release-128-patches-apps-database-and-middleware-216564

[mjm...@gmail.com]

Thanks to all respondents.
As suggested, I did not generate enough redo information to fill a redo log and therefore there was no writing of an archivelog.
After runnning "alter system switch logfile" an archive log was generated.
Thanks again.