Discussion:
Question about logging mode and databases
(too old to reply)
Marcos Fontana
2016-11-29 17:14:26 UTC
Permalink
Hello Everybody!!!!

I'm new here. Thank you for your attention in advance!

I have a simple question regarding backups. I received some informix instances to manage. I saw that some Instances have databases with nologging. Is it possible to make online backups of these instances? I need to put all databases inside an Instance in logging mode before making backups? This is prerequisite? Sorry, I'm an Oracle DBA and I got this instances to manage without any training. I read a lot of documentation before asking this question and I didn't find any information about this. Thinking in Oracle, I believe that all databases must be in logging mode to enable online backups. Is it correct?

Best Regards!

Marcos Fontana
Marcos Fontana
2016-11-29 18:21:58 UTC
Permalink
Post by Marcos Fontana
Hello Everybody!!!!
I'm new here. Thank you for your attention in advance!
I have a simple question regarding backups. I received some informix instances to manage. I saw that some Instances have databases with nologging. Is it possible to make online backups of these instances? I need to put all databases inside an Instance in logging mode before making backups? This is prerequisite? Sorry, I'm an Oracle DBA and I got this instances to manage without any training. I read a lot of documentation before asking this question and I didn't find any information about this. Thinking in Oracle, I believe that all databases must be in logging mode to enable online backups. Is it correct?
Best Regards!
Marcos Fontana
One more question. In case of be possible to making backups of an Instance with databases with and without logging, is it possible to recover databases without logging?

Regards,

Marcos Fontana
Erik Stahlhut
2016-11-30 08:59:13 UTC
Permalink
Post by Marcos Fontana
Hello Everybody!!!!
I'm new here. Thank you for your attention in advance!
I have a simple question regarding backups. I received some informix instances to manage. I saw that some Instances have databases with nologging. Is it possible to make online backups of these instances? I need to put all databases inside an Instance in logging mode before making backups? This is prerequisite? Sorry, I'm an Oracle DBA and I got this instances to manage without any training. I read a lot of documentation before asking this question and I didn't find any information about this. Thinking in Oracle, I believe that all databases must be in logging mode to enable online backups. Is it correct?
Best Regards!
Marcos Fontana
Hi Marcos,

you can do an online backup with ontape or onbar of databases with or without logging. Databases without logging have no transaction logging, so it´ s only possible to restore the data to the time of the last physical backup. Be aware that you backup your complete instance with all databases in it.

Cheers
Erik
Doug Lawry
2016-11-30 11:00:50 UTC
Permalink
Post by Marcos Fontana
Hello Everybody!!!!
I'm new here. Thank you for your attention in advance!
I have a simple question regarding backups. I received some informix instances to manage. I saw that some Instances have databases with nologging. Is it possible to make online backups of these instances? I need to put all databases inside an Instance in logging mode before making backups? This is prerequisite? Sorry, I'm an Oracle DBA and I got this instances to manage without any training. I read a lot of documentation before asking this question and I didn't find any information about this. Thinking in Oracle, I believe that all databases must be in logging mode to enable online backups. Is it correct?
Best Regards!
Marcos Fontana
Hi Marcos.

Online backups are known as "archives", and can be made with or without database logging. You can choose between level 0 (full) or 1/2 (incremental). The simplest tool is "ontape". For unlogged databases, you can only restore from the archive (as at when it started), whereas logged databases can be rolled-forward through the logical logs after a restore.

Regards,
Doug
Marcos Fontana
2016-11-30 13:04:05 UTC
Permalink
Thank you everybody for the answers. They were very useful!

Regards,

Marcos Fontana
Post by Doug Lawry
Post by Marcos Fontana
Hello Everybody!!!!
I'm new here. Thank you for your attention in advance!
I have a simple question regarding backups. I received some informix instances to manage. I saw that some Instances have databases with nologging. Is it possible to make online backups of these instances? I need to put all databases inside an Instance in logging mode before making backups? This is prerequisite? Sorry, I'm an Oracle DBA and I got this instances to manage without any training. I read a lot of documentation before asking this question and I didn't find any information about this. Thinking in Oracle, I believe that all databases must be in logging mode to enable online backups. Is it correct?
Best Regards!
Marcos Fontana
Hi Marcos.
Online backups are known as "archives", and can be made with or without database logging. You can choose between level 0 (full) or 1/2 (incremental). The simplest tool is "ontape". For unlogged databases, you can only restore from the archive (as at when it started), whereas logged databases can be rolled-forward through the logical logs after a restore.
Regards,
Doug
Loading...