dba_data_files ONLINE_STATUS=RECOVER
Hi,
We have a 10g (10.2.0.4) database on Windows 2003 Server
we have a bunch of table spaces that we keep switching between READ ONLY and READ WRITE
When we switch the table spaces to READ ONLY, we make backup of these table spaces using Transportable Tablespace option of data pump but we never back up these tablespaces as part of our hot backup even when the tablespace is in READ WRITE mode
so basically here is what we do
1. with tablespace set to READ ONLY, we make a data pump backup using TTS option
2. Make the table space READ WRITE
3. Peform purges against that table space
We have a 10g (10.2.0.4) database on Windows 2003 Server
we have a bunch of table spaces that we keep switching between READ ONLY and READ WRITE
When we switch the table spaces to READ ONLY, we make backup of these table spaces using Transportable Tablespace option of data pump but we never back up these tablespaces as part of our hot backup even when the tablespace is in READ WRITE mode
so basically here is what we do
1. with tablespace set to READ ONLY, we make a data pump backup using TTS option
2. Make the table space READ WRITE
3. Peform purges against that table space
0