Home » RDBMS Server » Backup & Recovery » Create backup (Oracle 10g)
Create backup [message #661585] Fri, 24 March 2017 04:50 Go to next message
Danny Freeman
Messages: 11
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?
Re: Create backup [message #661586 is a reply to message #661585] Fri, 24 March 2017 04:52 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
What do you mean by "bulk mode" and "normal mode"?
Re: Create backup [message #661587 is a reply to message #661586] Fri, 24 March 2017 04:56 Go to previous messageGo to next message
Danny Freeman
Messages: 11
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.
Re: Create backup [message #661588 is a reply to message #661586] Fri, 24 March 2017 04:57 Go to previous messageGo to next message
John Watson
Messages: 7150
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"?
Re: Create backup [message #661591 is a reply to message #661588] Fri, 24 March 2017 06:15 Go to previous messageGo to next message
BlackSwan
Messages: 25720
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
Re: Create backup [message #661592 is a reply to message #661591] Fri, 24 March 2017 06:32 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, 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...
Re: Create backup [message #661593 is a reply to message #661585] Fri, 24 March 2017 07:23 Go to previous message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
You want to take a backup during a bulk load? Why?
Previous Topic: Restoring Unencrypted Backups to a TDE Encrypted Database?
Next Topic: Recovery after incremental backup
Goto Forum:
  


Current Time: Fri Nov 24 17:47:12 CST 2017

Total time taken to generate the page: 0.01648 seconds