Oracle OCP 1Z0 053 Q559(Alter Database Begin Backup)

559.Another DBA issues a shutdown abort command on a database on which you were running an online
backup. What will happen when you try to restart the database?
A. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and
then open the database.
B. Oracle will automatically take the datafile out of hot backup mode and then open the database.
C. Oracle will generate an error when trying to open the database, indicating that a datafile is in hot
backup mode.
You will need to correct this error before you can open the database.
D. The database will open with the file in hot backup mode. You can restart the backup at any time.
E. The datafile in hot backup mode will be corrupted and you will have to recover it.
Answer: C

重啟時，提示SYSTEM表空間資料檔案處於備份模式之下

SQL> alter database begin backup;


Database altered.


SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area  413372416 bytes
Fixed Size                  2253784 bytes
Variable Size             314575912 bytes
Database Buffers           88080384 bytes
Redo Buffers                8462336 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '/u01/app/oracle/oradata/catdb/system01.dbf'




SQL> alter database end backup;


Database altered.


SQL> alter database open;


Database altered.


SQL> 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074527/，如需轉載，請註明出處，否則將追究法律責任。