Home » RDBMS Server » Backup & Recovery » rman can't backup (strange satuation) (merged) (11g)
rman can't backup (strange satuation) (merged) [message #437618] Tue, 05 January 2010 04:50 Go to next message
shazia12
Messages: 2
Registered: January 2010
Junior Member
i am facing problem in rman backup. my database size is 1Tb .4 days ago i take the compress backup sucessfuly and take the size 700gb of hard drive but from since last 3 days i trying daily backup but it exceed the 1.5 Tb hard drive but not completed and give me error of size, my database size still same as before 4 days ago.
command is
run { backup as compressed backupset format 'F:\BISPBACKUP\fullbackup_%d_%U_%t.bkp'
database plus archivelog delete input;}

kindly guid e me how i solve that problem of backup
Re: rman can't backup (strange satuation) [message #437619 is a reply to message #437618] Tue, 05 January 2010 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Your database may have the same size but more blocks are used.

Regards
Michel
rman taking 3 days time in backup of small database [message #437837 is a reply to message #437618] Wed, 06 January 2010 03:51 Go to previous messageGo to next message
shazia12
Messages: 2
Registered: January 2010
Junior Member
i am facing very hard problem, 1 weak ago i took backup in 2.30 hours by RMAN but now it is taking 3 days but still in process
kindly solve my problem and guide me how i solve that problem

this problem come when i took ist time compress backup then after this it giving me that problem
please
Re: rman taking 3 days time in backup of small database [message #437925 is a reply to message #437837] Wed, 06 January 2010 09:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on a lot of factors.
CPU, I/O and your rman settings.
RMAN 11g compression algorithm is very different (better) than previous versions.
icon6.gif  Re: rman taking 3 days time in backup of small database [message #437958 is a reply to message #437837] Wed, 06 January 2010 10:43 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Perhaps you need to tune the backup, check out the "Tuning RMAN Performance" chapter in the fine Oracle® Database Backup and Recovery User's Guide.
Razz
Previous Topic: RMAN archive log backup
Next Topic: Flashback Eight data retention
Goto Forum:
  


Current Time: Sun Nov 24 18:48:30 CST 2024