Hello Everybody!!!!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.
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
Best Regards!
Marcos Fontana
Hello Everybody!!!!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.
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
Best Regards!
Marcos Fontana
On Tuesday, 29 November 2016 17:14:28 UTC, Marcos Fontana wrote: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.
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
when it started), whereas logged databases can be rolled-forward through the logical logs after a restore.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
Regards,
Doug
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 54:17:40 |
Calls: | 6,650 |
Calls today: | 2 |
Files: | 12,200 |
Messages: | 5,330,613 |