Home » Oracle » 1z0-497 v.2 » Which database operation do you need the database to be in MOUNT state?
For which database operation do you need the database to be in MOUNT state?
A. renaming the control files
B. re-creating the control files
C. dropping a user in your database
D. dropping a tablespace in your database
E. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode
Correct Answer: E
Explanation/Reference:
Explanation:
To enable or disable archiving, the database must be mounted but not open.
Note: See step 5 below.
Changing the Database Archiving Mode
To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges (AS SYSDBA).
The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:
1.Shut down the database instance 2.Back up the database.
3.Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files
4.Start a new instance and mount, but do not open, the database.
STARTUP MOUNT To enable or disable archiving, the database must be mounted but not open.
5.Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN;
6.Shut down the database.
SHUTDOWN IMMEDIATE
7.Back up the database.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
