Hi friends,
Help me clear my doubts in choosing a backup mode.
My database(its going to be a 24 x 7) contains 276 tablespaces. I am interested in having backup of only one of the tablespaces.
Cold backup is not being considered. I wanted to do online backup for the particular tablespace, and also carryout an export at table level for the concerned tables in that tablespace.
My doubt is, what is the performance degradation when i run the database in Archieve mode, just for the sake of one tablespace which forms less than 1% of the total database size?And, if it is considerable, how good is to depend on export/import as a primary way of backup?
Thanks
manjunath