Link to home
Start Free TrialLog in
Avatar of amolghadge
amolghadgeFlag for Netherlands

asked on

Oracle - read only Tablespace

What happens  internally in Oracle   .... when we put tablespace in read only mode ?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

well:
* all queries on that tablespace don't need to get any locks
* the data files don't get updated with the SCN any longer
* updates are not allowed on such a tablespace
Avatar of amolghadge

ASKER

Considering  the second point :- the data files don't get updated with the SCN any longer .

At this point of time I  bring down the database and take a backup .

1) While bringing up the database--> will not there be a inconsistency in SCN of these files compared to others ?


2) What if I am using this backup and recovering on later dates using archivelogs ?






ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MohanKNair
MohanKNair

The following links may give some info

Riddles of Read-Only Tablespace
http://www.orafaq.com/papers/readonly.doc

The benefits and drawbacks of having read-only tablespaces as well as several recovery scenarios
http://www.fors.com/orasupp/rdbms/dba/33402_1.HTM

Oracle Features for the Data Warehouse
http://www.remote-dba.net/tp_Oracle_read-only_tablespace.htm