OraFAQ Forum: Backup & Recovery » v$recovery_file_dest don't show actual space usage

Home » RDBMS Server » Backup & Recovery » v$recovery_file_dest don't show actual space usage (oracle 12.1.0.2,Windows Server 2014)

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

v$recovery_file_dest don't show actual space usage [message #662151]

Wed, 19 April 2017 01:32

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.

Report message to a moderator

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

John Watson
Messages: 8965
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.

Report message to a moderator

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

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?

Report message to a moderator

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

EdStevens
Messages: 1376
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?

Report message to a moderator

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

John Watson
Messages: 8965
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...

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Not able to open database in Oracle
Next Topic:	Rman -6207

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 01:04:52 CST 2025