Home » RDBMS Server » Server Administration » Total No of files in FRA (oracle 10.2.0.1.0 - windows XP)
Total No of files in FRA [message #516292] Sat, 16 July 2011 04:03 Go to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hi All,

kindly anyone please clear my doubt.

From the view v$flash_recovery_area_usage, below output shows total no of files are 24+4=28.

FILE_TYPE NUMBER_OF_FILES
------------ ---------------
CONTROLFILE 0
ONLINELOG 0
ARCHIVELOG 24
BACKUPPIECE 4
IMAGECOPY 0
FLASHBACKLOG 0

From the view v$recovery_file_dest, it shows the no of files are 49.

NAME NUMBER_OF_FILES
------------ ----------------
/dba/backup 49

Why there is discrimination?

Regards & Thanks
Muktha
Re: Total No of files in FRA [message #516309 is a reply to message #516292] Sat, 16 July 2011 09:41 Go to previous message
Michel Cadot
Messages: 58636
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

2/
Database Reference

3/
Search in the version bugs.

Regards
Michel
Previous Topic: OracleCSServcie
Next Topic: ORA-02778: Name given for the log directory is invalid
Goto Forum:
  


Current Time: Thu Jul 31 15:07:12 CDT 2014

Total time taken to generate the page: 0.13994 seconds