Home » RDBMS Server » Backup & Recovery » Tablespace point in time recovery (oracle 11g r2 ,linux 5)
Tablespace point in time recovery [message #663837] Wed, 21 June 2017 04:26 Go to next message
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
Re: Tablespace point in time recovery [message #663850 is a reply to message #663837] Wed, 21 June 2017 07:02 Go to previous messageGo to next message
BlackSwan
Messages: 25719
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
//
Re: Tablespace point in time recovery [message #663862 is a reply to message #663837] Wed, 21 June 2017 08:35 Go to previous message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: Disaster recovery from SAN
Next Topic: Retention Policy with RMAN Incremental Backups
Goto Forum:
  


Current Time: Wed Nov 22 21:45:49 CST 2017

Total time taken to generate the page: 0.03038 seconds