OraFAQ Forum: Backup & Recovery » Tablespace point in time recovery

Home » RDBMS Server » Backup & Recovery » Tablespace point in time recovery (oracle 11g r2 ,linux 5)

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

Tablespace point in time recovery [message #663837]

Wed, 21 June 2017 04:26

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

hi i am performing tablespace point in time recovery using rman my default db block size is 8kb tablespace block size is 16kb big file tablespace i have increase db_16k_cache_size to 3 gb but no luck

Quote:

RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '+DATA/stndb/archivelog/2017_06_19/thread_2_seq_38229.1918.947109763'
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K

Report message to a moderator

Re: Tablespace point in time recovery [message #663850 is a reply to message #663837]

Wed, 21 June 2017 07:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

[oracle@vbgeneric ~]$ oerr ora 379
00379, 00000, "no free buffers available in buffer pool %s for block size %sK"
// *Cause:  All buffers in the specified buffer pool for the specified block size
//          are in use and no free buffers are available.
// *Action: Increase the number of buffers in the specified pool for the specified
//          block size
//

Report message to a moderator

Re: Tablespace point in time recovery [message #663862 is a reply to message #663837]

Wed, 21 June 2017 08:35

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

Senior Member
Account Moderator

Quote:

i have increase db_16k_cache_size to 3 gb

Are you sure this has be done?
Post the content of from v$sga_dynamic_components and v$sga_resize_ops.
Don't forget to format your post, read How to use [code] tags and make your code easier to read.

Report message to a moderator

Previous Topic:	RMAN connection
Next Topic:	Disaster recovery from SAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:38:52 CST 2025