Solved

db_recovery_file_dest file structures.

Posted on 2013-12-17
1
299 Views
Last Modified: 2014-02-21
Hi,

  I have two database instances ( instance_a and instance_b ).    Both instances have the following configuration.  :

db_recovery_file_dest                                  string                                       U:\FRA
db_recovery_file_dest_size big                          integer                                  500G


  When i go into the directory U:\FRA  i found a directory U:\FRA\instance_a\BACKUPSET also U:\FRA\QMS01DEV\DATAFILE and U:\FRA\QMS01DEV\ONLINELOG

   But for instance_b there is nothing created.

  When does the database create this file structures ?  

  It is created by RMAN or by ?

  When it is created ?
 
  Regards,
0
Comment
Question by:joe_echavarria
1 Comment
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 39724973
Not sure, but I believe ONLINELOG is created by archiver and BACKUPSET by rman.

And DATAFILE should not be under FRA unless you specifically created dbf files under the 'FRA' directory instead of the "oradata" (your db data directory).
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now