Skip to Main Content

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!

Tablespace offline/online

3152166Jan 22 2016 — edited Jan 27 2016

Hi,

Is there any query to find date of  tablespace brought offline or online??

I just verified alert log but i didn't find any alter/offline/online statements.

Scenario

=======

There was RMAN clone, later we found that one tablespace didn't get refreshed and when we verified segment sizes there is difference in prod and cloned database sizes.

So now we suspect is that tablespace was offline on clone date? or anything else

Thanks in advance.!

-vnkt

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2016
Added on Jan 22 2016
14 comments
1,287 views