Archive log files are not being created

From: <mjmstud_at_gmail.com>
Date: Mon, 15 Apr 2013 23:42:17 -0700 (PDT)
Message-ID: <a82c1633-a5ed-4073-85e5-c4b145bcbe4e_at_googlegroups.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.       Received on Tue Apr 16 2013 - 08:42:17 CEST