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>
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2074527/