Media recovery is required to bring Tablespace online - Oracle Datafiles and Tempfiles

Q.  Your database is running in the ARCHIVELOG mode. You placed a tablespace tbs_1, offline with the immediate option. Which statement is correct in this scenario?
- Published on 12 Aug 15

a. The operation would fail if tbs_1 were a read-only tablespace
b. The operation would fail if tbs_1 were a read/write tablespace
c. The operation would fail if tbs_1 were the default tablespace for the database
d. If the above operation were successful, media recovery would be required to bring the Tablespace online

ANSWER: If the above operation were successful, media recovery would be required to bring the Tablespace online

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - You may want to take a tablespace offline for any of the following reasons:
    1. To make a portion of the database unavailable while allowing normal access to the remainder of the database
    2. To perform an offline tablespace backup (even though a tablespace can be backed up while online and in use)
    3. To make an application and its group of tables temporarily unavailable while updating or maintaining the application

    - When a tablespace is taken offline, Oracle takes all the associated files offline. The SYSTEM tablespace can never be taken offline.

    - IMMEDIATE - A tablespace can be taken offline immediately, without Oracle taking a checkpoint on any of the datafiles. When you specify OFFLINE IMMEDIATE, media recovery for the tablespace is required before the tablespace can be brought online.
    - You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲