Database Backup and Recovery (MOSC)

MOSC Banner

User managed recovery - Read only Tablespaces involved

edited Nov 19, 2012 4:47AM in Database Backup and Recovery (MOSC) 2 commentsAnswered

Hi

We have a question on user managed backup for our 10.2.0.4 database.We are NOT using RMAN
In our database, we have 4 table spaces (2 READ WRITE and 2 READ ONLY) as below

These are READ WRITE tablespaces

RW_1   500 GB
RW_2   500 GB

These are READ ONLY tablespaces

RO_1    1 TB
RO_2    1 TB

On Sunday, November 11th we made a FULL backup of the database, excluding the READ ONLY tablespaces, because:

1) We made a hot backup after these 2 table spaces were made READ ONLY (about a month ago)

2) As part of that hot backup, we also backed up the control file (alter database backup controfile to <name>).

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