This post is more than 5 years old
2 Intern
•
643 Posts
0
3661
Does Networker NSM support Oracle database back up in 'no archive log mode'?
Does Networker NSM support Oracle database backup in 'no archive log mode'?
Server1: AIX + Oracle 11g
Server2: Linux + Oracle 11g
Storage: VMAX 10K
DPAD: NetWorker8.1 + DD4500
jeff_browning
256 Posts
1
April 23rd, 2014 05:00
Simon:
When in noarchivelog mode, you cannot backup the database hot. You will need to do a cold backup. Networker can be used for that, though. See:
http://dbaworkshop.blogspot.com/2012/07/how-to-backup-database-in-noarchivelog_31.html
Regards,
Jeff
ble1
2 Intern
2 Intern
•
14.3K Posts
0
April 23rd, 2014 00:00
If using no archive log mode, it means no module is used (like NMDA). It also means that backup you would do would be kind of snapshot and then fs backup of the snapshot (and restore would be crash consistency restore in Oracle view).
kangw2
28 Posts
0
April 23rd, 2014 01:00
Do you have related documents or reference ?
ichakrab
27 Posts
0
April 23rd, 2014 02:00
If the backup is taken when the DB is running and the archivelog is OFF, the backup will be incosistent
ble1
2 Intern
2 Intern
•
14.3K Posts
1
April 23rd, 2014 04:00
I use previous method with PowerSnap and Oracle module. I would strongly suggest to enable archive logs as that is also Oracle suggestion and nowadays I can't imagine why would anyone run it without archive logs turned on.
zhaos2
2 Intern
2 Intern
•
643 Posts
0
April 23rd, 2014 19:00
Thanks Jeff!
My question is if 'Networker' support this sort of backup.
ble1
2 Intern
2 Intern
•
14.3K Posts
1
April 24th, 2014 00:00
NetWorker will do whatever you instruct it to do. Question is not if NetWorker supports it, but if Oracle supports it. With NSM - to go back to your original question - and no archivelog mode, this is not consistent and you may get lucky and may not. I doubt this will work ever for busy DB so forget it in such case (as you can't do shutdown due to availability requirements). If this is DB you can shutdown, then yes, it will be quick as snapshot takes little bit of time and you can either use RMAN approach or simple FS backup of the volume - it's your call. I would still insist t enable archive logs and do it "properly".