OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » offline

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

offline [message #154868]

Wed, 11 January 2006 01:28

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

"The only time a tablespace backup is valid for a database in NOARCHIVELOG mode is when the tablespace is currently read-only or offline-normal "...

what is the meaning for above statement ??

and what is offline-normal ??

Report message to a moderator

Re: offline [message #154869 is a reply to message #154868]

Wed, 11 January 2006 01:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

OFFLINE NORMAL is the state of tablespace when it is not available.
quoting docs

Quote:

A tablespace can be taken offline normally if no error conditions exist for any of the datafiles of the tablespace. No datafile in the tablespace can be currently offline as the result of a write error. When OFFLINE NORMAL is specified, Oracle takes a checkpoint for all datafiles of the tablespace as it takes them offline. NORMAL is the default.
Making a tablespace read-only prevents write operations on the datafiles in the tablespace. The primary purpose of read-only tablespaces is to eliminate the need to perform backup and recovery of large, static portions of a database, but they also provide a means of completely protecting historical data so that no one can modify the data after the fact. Making a tablespace read-only prevents updates on all tables in the tablespace, regardless of a user's update privilege level.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#544

Report message to a moderator

Re: offline [message #154870 is a reply to message #154868]

Wed, 11 January 2006 01:38

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

thank u for giving the answer.....

Report message to a moderator

Previous Topic:	os crash
Next Topic:	dual processor NT server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 17:34:17 CST 2025