Database Backup and Recovery (MOSC)

MOSC Banner

RMAN backup and restore of read only tablespaces

edited Oct 20, 2009 2:16AM in Database Backup and Recovery (MOSC) 11 commentsAnswered
Due to the size (3 TB+, 650 tablespaces, 700 datafiles) of the database, and hardware throughput issues, it currently takes us over 16 hours to do a full compressed cold backup of our data warehouse. We are not archivelogging at the present time, but plan to start doing that soon (it was a space issue). We do have about 175 tablespaces (most of which have 1 datafile) that could be set to read only. What we have in mind (if possible) is to do a backup of of those tablespaces, then after it completes, set them to read only status. Then,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center