Home » RDBMS Server » Backup & Recovery » v$recovery_file_dest don't show actual space usage (oracle 12.1.0.2,Windows Server 2014)
v$recovery_file_dest don't show actual space usage [message #662151] Wed, 19 April 2017 01:32 Go to next message
chad_2000
Messages: 23
Registered: February 2017
Junior Member
Hi,

Value of "db_recovery_file_dest_size" is 3T and actual space usage is 2.4T(seen from os, more space usage is for backups), but v$recovery_file_dest don't show actual space usage:

Select * from v$recovery_file_dest

F:\FRA	3298534883328	725639152120	133098700	1499	0

Select * from v$flash_recovery_area_usage

CONTROL FILE	0	0	1	0
REDO LOG	0	0	0	0
ARCHIVED LOG	1.19	0	1458	0
BACKUP PIECE	1.01	0	40	0
IMAGE COPY	0	0	0	0
FLASHBACK LOG	0	0	0	0
FOREIGN ARCHIVED LOG	0	0	0	0
AUXILIARY DATAFILE COPY	0	0	0	0

Note:I have run CrossCheck command in rman for updating rman repository(controlfile).

crosscheck backupset;
crosscheck backup;
crosscheck archivelog;
Could anyone explain whats is the reason?

Thanks in advance.
Re: v$recovery_file_dest don't show actual space usage [message #662154 is a reply to message #662151] Wed, 19 April 2017 02:28 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
One common reason is that the FRA is full of stuf that the database has "forgotten" about, because you have set your control_file_record_keepp_time too low. Check this by running CATALOG START WITH....

Alternatively, you may have put files in the FRA directory manually.
Re: v$recovery_file_dest don't show actual space usage [message #662157 is a reply to message #662154] Wed, 19 April 2017 06:20 Go to previous messageGo to next message
chad_2000
Messages: 23
Registered: February 2017
Junior Member
Thank you for your reply,

Quote:
Alternatively, you may have put files in the FRA directory manually.
Yes, You are right, This is the backup command:

run {
allocate channel oem_backup_ch1 type disk ;allocate channel oem_backup_ch2 type disk BACKUP FORMAT 'F:\FRA\ORCL\BACKUPSET\2017_03_14\DB_%d_D_%T_%u_s%s_p%p.BKP' TAG 'DB_Backup' keep until time 'sysdate+60'  DATABASE;RELEASE CHANNEL oem_backup_ch1;RELEASE CHANNEL oem_backup_ch2;
 }

do you mean that our mistake is that when we specified backup path(a path to FRA) in command?(FORMAT 'F:\FRA\ORCL\BACKUPSET\2017_03_14\DB_%d_D_%T_%u_s%s_p%p.BKP')

Is there anyway for updating rman repository and FRA?
Re: v$recovery_file_dest don't show actual space usage [message #662161 is a reply to message #662157] Wed, 19 April 2017 06:54 Go to previous messageGo to next message
EdStevens
Messages: 848
Registered: September 2013
Senior Member
chad_2000 wrote on Wed, 19 April 2017 06:20
Thank you for your reply,

Quote:
Alternatively, you may have put files in the FRA directory manually.
Yes, You are right, This is the backup command:

run {
allocate channel oem_backup_ch1 type disk ;allocate channel oem_backup_ch2 type disk BACKUP FORMAT 'F:\FRA\ORCL\BACKUPSET\2017_03_14\DB_%d_D_%T_%u_s%s_p%p.BKP' TAG 'DB_Backup' keep until time 'sysdate+60'  DATABASE;RELEASE CHANNEL oem_backup_ch1;RELEASE CHANNEL oem_backup_ch2;
 }

do you mean that our mistake is that when we specified backup path(a path to FRA) in command?(FORMAT 'F:\FRA\ORCL\BACKUPSET\2017_03_14\DB_%d_D_%T_%u_s%s_p%p.BKP')
Exactly. The FRA is just a bookkeeping mechanism. If you put stuff in an FRA directory without using FRA methods, that usage does not get recorded as such.

Quote:
Is there anyway for updating rman repository and FRA?
Re: v$recovery_file_dest don't show actual space usage [message #662163 is a reply to message #662157] Wed, 19 April 2017 08:16 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Is there anyway for updating rman repository and FRA?
Yes, I have already told you: CATALOG START WITH...
Re: v$recovery_file_dest don't show actual space usage [message #662260 is a reply to message #662151] Sat, 22 April 2017 05:14 Go to previous message
chad_2000
Messages: 23
Registered: February 2017
Junior Member
Quote:
Exactly. The FRA is just a bookkeeping mechanism. If you put stuff in an FRA directory without using FRA methods, that usage does not get recorded as such.
Thanks.

Quote:
Yes, I have already told you: CATALOG START WITH...
Thank you for your useful reply.
Previous Topic: Error ORA - 19870 error while restoring backup piece ...
Next Topic: Not able to open database in Oracle
Goto Forum:
  


Current Time: Mon Nov 20 09:16:19 CST 2017

Total time taken to generate the page: 0.05623 seconds