Database recovery with READ ONLY tablespace
Hi,
we have a 10g R2 database with couple of tablespace (R01 and R02) that we need to make READ ONLY
we are NOT using RMAN and using the conventional hot backup
We have some questions on backing up and recovering the these 2 tablespace if the need arise
let us assume the following scenario
1. We put these 2 TS in read only mode on SATURDAY and made an online hot backup
(Since we cannot put a Read only TS in backup mode, I guess all we need to do is to physically copy the data files. correct?)
After the backup, we copied the database files of these 2 Read only Tablespace to an archived location
we have a 10g R2 database with couple of tablespace (R01 and R02) that we need to make READ ONLY
we are NOT using RMAN and using the conventional hot backup
We have some questions on backing up and recovering the these 2 tablespace if the need arise
let us assume the following scenario
1. We put these 2 TS in read only mode on SATURDAY and made an online hot backup
(Since we cannot put a Read only TS in backup mode, I guess all we need to do is to physically copy the data files. correct?)
After the backup, we copied the database files of these 2 Read only Tablespace to an archived location
0