Can I startup the database with a tablespace offline?
Hi All,
I have an oracle database running with NOARCHIVELOG mode. It has a big tablespace USER01_TS that I want to drop to reclaim the diskspace from the OS. But I need to make sure I really don't need anything inside that tablespace. Here is my approach:
1. execute: alter tablespace USER01_TS offline normal.
2. backup the associated physical datafiles of USER01_TS to tape, then remove those files from the OS level to reclaim the disk space.
3. Shutdown the database to do a cold backup.
4. Restart the database after the cold backup.
After step 4, I will run the database for 2 weeks before dropping the tablespace USER01_TS. If I find that I need the data in USER01_TS within 2 weeks, then I will restore those datafiles from tape and put the tablespace online again.
My question is: will this approach work? will I get any error in Step 3 or 4?
Thanks a lot,
Chris