Archive log files are not being created
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