User managed recovery - Read only Tablespaces involved
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>).
0