Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What happens when Tablespace offline when noarchivelogmode

787588Sep 7 2012 — edited Sep 8 2012

Hello,

My Database version is 11.2.0.1 on Linux 64bit

I have a doubt How able to online tablespace when performed offline and online if it is in Noarchivelog mode

Steps

1) Noarchivelog mode
2) One of tablespace kept offline (to move one datafile) - USERS
3) copied datafile at OS level
4) Now performed rename of datafile
5) performed checkpoints to test
6) again Tablespace kept ONLINE. - USERS

Now my question is, when we put tablespace in offline mode, Other datafile headers SCN will be updated and no updates will be done on "USERS" tablespace because its OFFLINE,

Now when i put USERS tablespace ONLINE, how it able to Sync with other SCN's ? Normally it has to perform recovery until all SCN's are synchronized.

Please describe your ideas.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2012

Added on Sep 7 2012

#general-database-discussions

7 comments

1,865 views