OraFAQ Forum: Server Administration » Total No of files in FRA

Home » RDBMS Server » Server Administration » Total No of files in FRA (oracle 10.2.0.1.0 - windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Total No of files in FRA [message #516292]

Sat, 16 July 2011 04:03

muktha_22
Messages: 527
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

Report message to a moderator

Re: Total No of files in FRA [message #516309 is a reply to message #516292]

Sat, 16 July 2011 09:41

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:35:35 CST 2024