Which statement about the DATA1 tablespace is true?

Your database is running in ARCHIVELOG mode. You are performing a user-managed
backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by
issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate
abnormally.
Which statement about the DATA1 tablespace is true?

Your database is running in ARCHIVELOG mode. You are performing a user-managed
backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by
issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate
abnormally.
Which statement about the DATA1 tablespace is true?

A.
The DATA1 tablespace is automatically taken out of backup mode when the instance
aborts.

B.
If you restart the database, the DATA1 tablespace will be automatically taken out of
backup mode when the database is opened.

C.
If you restart the database, the DATA1 tablespace will be automatically taken out of
backup mode when the database is mounted.

D.
If you restart the database, the database will not be opened.

Explanation:
After database instance failure, the BEGIN BACKUP option would not obtain the tablespace
online, it will be OFFLINE mode. so that the instance cannot load the database file online.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Eamon

Eamon

Yes the answer is D.

However the explanation is wrong, as this is not a case of whether the datafile is ONLINE or not but a question of the STATUS of the datafile as stated in the V$BACKUP view, which can be seen in
http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1044.htm#REFRN30017

I suggest reading …
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osbackup.htm#BRADV90001
and paying attention to the sections titled …
Ending a Backup After an Instance Failure or SHUTDOWN ABORT
Ending Backup Mode with the ALTER DATABASE END BACKUP Statement
Ending Backup Mode with the SQL*Plus RECOVER Command