Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!r29g2000hsg.googlegroups.com!not-for-mail
From:  bfogarty@gaports.com
Newsgroups: comp.databases.oracle.server
Subject: Archived Redo Logs Written After Creation of a Flash Recovery Area
Date: Wed, 10 Oct 2007 15:11:38 -0700
Organization: http://groups.google.com
Lines: 43
Message-ID: <1192054298.029610.288160@r29g2000hsg.googlegroups.com>
NNTP-Posting-Host: 70.158.121.62
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1192054298 8617 127.0.0.1 (10 Oct 2007 22:11:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 10 Oct 2007 22:11:38 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: r29g2000hsg.googlegroups.com; posting-host=70.158.121.62;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.server:436191
X-Received-Date: Wed, 10 Oct 2007 18:11:38 EDT (text.usenetserver.com)

I am converting a preexisting 10gR2 database to use a flash recovery
area and am confused about the creation of archived redo logs.

My spfile.ora parameters are:

*.db_recovery_file_dest='/orabackt/EIST'
*.db_recovery_file_dest_size=10G

*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY
REOPEN=60'
*.log_archive_dest_10=''
*.log_archive_dest_2='LOCATION=/t13/admin/EIST/arch'
*.log_archive_format='EIST_%t_%s_%r.arc'

After converting to the flash recovery area the archived redo logs
written to log_archive_dest_2 are:
/t13/admin/EIST/arch $ ls -ltr
-rw-r-----   1 oracle   dba         2619904 Oct 10 17:05
EIST_1_4596_463323396.arc
-rw-r-----   1 oracle   dba          216064 Oct 10 17:17
EIST_1_4597_463323396.arc
Their names follow the format defined by parameter log_archive_format.

The archived redo logs written to the flash recovery area are:
/orabackt/EIST/EIST/archivelog/2007_10_10 $ ls -ltr
-rw-r----- 1 oracle  dba  2619904 Oct 10 17:05
o1_mf_1_4596_3jthmvww_.arc
-rw-r----- 1 oracle  dba   216064 Oct 10 17:17
o1_mf_1_4597_3jtjcxgf_.arc


I had expected the archived redo logs to be written to /orabackt/EIST,
since that was the value assigned to db_recovery_file_dest. Is it
normal for these additional levels of subdirectories to be defined?
/orabackt/EIST/EIST/archivelog/2007_10_10

Is it normal for the archived redo logs in these two destinations to
have different file names?
EIST_1_4596_463323396.arc  vs.  o1_mf_1_4596_3jthmvww_.arc

Thank you,
Bill