Solved

db_recovery_file_dest file structures.

Posted on 2013-12-17
1
308 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
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.

734 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