Home » RDBMS Server » Backup & Recovery » How to check archive log destination utilization in oracle 9i (RHEL 5)
How to check archive log destination utilization in oracle 9i [message #528271] Mon, 24 October 2011 01:14 Go to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Hi,
Is there any view in oracle 9i like V$RECOVERY_FILE_DEST where we can check the archive destination space utilization from database end ? Please help.

Thanks in advance.
Re: How to check archive log destination utilization in oracle 9i [message #528277 is a reply to message #528271] Mon, 24 October 2011 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No because there is no FRA in 9i.

Regards
Michel
Re: How to check archive log destination utilization in oracle 9i [message #528292 is a reply to message #528271] Mon, 24 October 2011 03:00 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Thanks. So is there no way to check the utilization from database end in 9i ?
Re: How to check archive log destination utilization in oracle 9i [message #528301 is a reply to message #528292] Mon, 24 October 2011 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can find a Java class on the web that allows you to get disk and directory space and embed it in your database.

Regards
Michel
Re: How to check archive log destination utilization in oracle 9i [message #528305 is a reply to message #528271] Mon, 24 October 2011 03:49 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
I did not know you are such an intelligent person... You should have developed your own database. Are you planning it ?
Re: How to check archive log destination utilization in oracle 9i [message #528307 is a reply to message #528305] Mon, 24 October 2011 03:57 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm a so intelligent person than I don't work with a database that is no more supported since years. Laughing

Regards
Michel
Previous Topic: RMAN-04025 when running TSPITR from command prompt
Next Topic: how catalog BACKUPPICE in Oracle9i
Goto Forum:
  


Current Time: Sun Apr 20 22:58:24 CDT 2014

Total time taken to generate the page: 0.04375 seconds