Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN for vldb

510137May 1 2006 — edited May 12 2006
I have a 3.2TB database. The majority of the data resides in 18 partitioned tablespaces, 9 for data and 9 for index. The rest of the database is quite small, by comparison. Most of the data is input with no logging, but when in archivelog mode this database generates a huge amount of logs.

What we envision is to:

- put the database in archivelog mode, for the duration of the backup only.
- put the partitioned tablespaces in read-only mode
- export the data and index partitions as transportable tablespaces.
- copy the datafiles to a secondary disk location (takes about 15-20 hours)
- perform an incremental rman backup for the remaining database
- put the tablespaces back in read-write
- put the database in noarchivelog mode.

does this make sense? are there any serious flaws in the logic here?

all suggestions greatly appreciated.
.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2006
Added on May 1 2006
7 comments
636 views