OraFAQ Forum: Backup & Recovery » RMAN backup issue

Home » RDBMS Server » Backup & Recovery » RMAN backup issue

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

RMAN backup issue [message #274191]

Mon, 15 October 2007 00:30

kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi

Member

I have oracle 10g on solaris. I have configured RMAN on windows machine and need to take the backup of database through RMAN.
My database size is 700GB and currently the bulk load is running on the database through automated process. This load actually drop the tablespace and then recreate the tablespace and then insert the data through sqlloader.
Now my question is " Whether the backup will fail when at the time backup is running and simultaneously one of the process is dropping the tablespace"
If the backup failed then what is the alternative solution.
Currently archive log size is more than 1.5TB and per day, it is generating around 150GB archive log files and now it became very hard to manage the archive log files.

Please suggest to solve the issue

Thanks in Advance
Gulshan

Report message to a moderator

Re: RMAN backup issue [message #274197 is a reply to message #274191]

Mon, 15 October 2007 01:11

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

Senior Member
Account Moderator

It is recommended to make backup out of peak hours.
So don't do it during this bulk load.
You will benefit of higher performances and no more have to worry about this kind of absurdity to backup during database structure modification.

Regards
Michel

Report message to a moderator

Re: RMAN backup issue [message #274219 is a reply to message #274191]

Mon, 15 October 2007 02:20

kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi

Member

We are using ArcServ backup agents for taking the backup of Database and two times our backup failed just because of some structural modifications. It failed by throwing the below error:

controlfile fixed table inconsistent due to concurrent updates

The other thing is that how should i handle archive log files as it is generating around 150GB of archivelog files in a single day. I cannot provide that much amount of space as i have already given 1.5 TB of space for storing archivelog files.

Till now i did not find the best way to handle this situation.

Please provide your valuable input on the above.

Thanks
Gulshan

Report message to a moderator

Re: RMAN backup issue [message #274226 is a reply to message #274219]

Mon, 15 October 2007 02:41

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

Senior Member
Account Moderator

This is what I said: don't backup during database structure modification.

Why are you keeping 1.5Tb of archived logs? You only need those since the beginning of the last backup (or last 2 or 3 depending on you policy).

Regards
Michel

Report message to a moderator