1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • Question about logging mode and databases

    From Marcos Fontana@21:1/5 to All on Tue Nov 29 09:14:26 2016
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Marcos Fontana@21:1/5 to All on Tue Nov 29 10:21:58 2016
    Em terça-feira, 29 de novembro de 2016 15:14:28 UTC-2, Marcos Fontana escreveu:
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Erik Stahlhut@21:1/5 to All on Wed Nov 30 00:59:13 2016
    Am Dienstag, 29. November 2016 18:14:28 UTC+1 schrieb 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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Marcos Fontana@21:1/5 to All on Wed Nov 30 05:04:05 2016
    Thank you everybody for the answers. They were very useful!

    Regards,

    Marcos Fontana

    Em quarta-feira, 30 de novembro de 2016 09:00:51 UTC-2, Doug Lawry escreveu:
    On Tuesday, 29 November 2016 17:14:28 UTC, Marcos Fontana wrote:
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)