OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Create backup (Oracle 10g)

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

Create backup [message #661585]

Fri, 24 March 2017 04:50

Danny Freeman
Messages: 21
Registered: December 2015
Location: UK

Junior Member

Hello sir

I want to create backup but the archive log is not generated because of the bulk load. Any way to take backup without changing Bulk Mode to Normal mode because that would cause the performance degrade?

Report message to a moderator

Re: Create backup [message #661586 is a reply to message #661585]

Fri, 24 March 2017 04:52

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

What do you mean by "bulk mode" and "normal mode"?

Report message to a moderator

Re: Create backup [message #661587 is a reply to message #661586]

Fri, 24 March 2017 04:56

Danny Freeman
Messages: 21
Registered: December 2015
Location: UK

Junior Member

I am talking about Database Disaster Recovery box for database. I want to create backup but the archive log is not generated because of the bulk load
Any way to take backup without changing Bulk Mode to Normal mode because that would cause the performance degrade.

Report message to a moderator

Re: Create backup [message #661588 is a reply to message #661586]

Fri, 24 March 2017 04:57

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

John Watson wrote on Fri, 24 March 2017 09:52

What do you mean by "bulk mode" and "normal mode"?

Report message to a moderator

Re: Create backup [message #661591 is a reply to message #661588]

Fri, 24 March 2017 06:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I want to create backup but the archive log is not generated because of the bulk load.
DML always generates REDO

Report message to a moderator

Re: Create backup [message #661592 is a reply to message #661591]

Fri, 24 March 2017 06:32

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

I'm guessing they've taken it out of archivelog mode to do a data load. Hence, an online backup is not possible. However, the seconds sentence means nothing to me no matter how many times it's repeated...

Report message to a moderator

Re: Create backup [message #661593 is a reply to message #661585]

Fri, 24 March 2017 07:23

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You want to take a backup during a bulk load? Why?

Report message to a moderator

Previous Topic:	how get 12c data when windows 7 crashed
Next Topic:	Recovery after incremental backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:16:08 CST 2025