Highlighted
3 Cadmium

Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

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

Labels (1)
0 Kudos
1 Solution

Accepted Solutions
Highlighted
3 Argentum

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

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

View solution in original post

7 Replies
Highlighted
7 Thorium

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

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).

0 Kudos
Highlighted
2 Bronze

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

Do you have related documents or reference ?

0 Kudos
Highlighted
7 Thorium

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

kangw2 wrote:

Do you have related documents or reference ?

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.

Highlighted
2 Bronze

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

If the backup is taken when the DB is running and the archivelog is OFF, the backup will be incosistent

0 Kudos
Highlighted
3 Argentum

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

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

View solution in original post

Highlighted
3 Cadmium

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

Thanks Jeff!

My question is if 'Networker' support this sort of backup.

0 Kudos
Highlighted
7 Thorium

Re: Does Networker NSM support Oracle database back up in 'no archive log mode'?

Jump to solution

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".