Oracle backup: archivelog and tablespaces
Posted on 2009-07-08
We have an ORACLE 11g and we are planning his online backup.
We have 3 tablespaces but 2 not need to be backed up. Now we have the database in NOARCHIVELOG but we are planning to move to ARCHIVELOG.
First question: Can be ARCHIVELOG activated at tablespace level or only at whole database? Why I ask it? Because when we activate the ARCHIVELOG mode, the database performance goes down (in some moments we have a lot of bulk operations).
Second question if the answer to the first question is not: Can I use the NOLOGGING attribute for a tablespaces not required to be backep up. It's a good strategy?
There are other methods to make the same online backup?
As you can see, ower goal is make an online backup for noly one tablespace and mantein as good performance as posible.
Thanks in advance.