561st questions, 053561 questions
561. If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,
What will be the result when you issue the command alter database archivelog?
A. The alter database archivelog command will fail.
B. The alter database archivelog inconsistent command must be used to put the database in
ARCHIVELOG mode.
C. The alter database archivelog command will succeed.
D. The alter database archivelog command will ask if you want to make the database consistent first.
E. There is no alter database archivelog command. The correct command is alter database alterlogging.
Answer:A
The experiment is as follows:
SQL>Shutdown abort;
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.
Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 738197968 bytes
Database Buffers 327155712 bytes
Redo Buffers 4603904 bytes
The database has been loaded.
SQL> alter database archievelog;
Alter database archievelog
*
Row 3 has an error:
ORA-02231: the alter database option is missing or invalid
SQL> alter database archivelog;
Alter database archivelog
*
Row 3 has an error:
ORA-00265: requires instance recovery and cannot set ARCHIVELOG Mode
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.