Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps to switch a database's archiving mode
between NO ARCHIVELOG and ARCHIVELOG mode ?
- 1 Answers
- 5815 Views
- I also Faced
- E-Mail Answers
Answer / radha
To check database is in which mode
1. Conn sys/sys as sysdba
2. select log_mode from v$database
To set database in Archivelog mode
1. shutdown immediate;
2. startup mount;
3. alter database archivelog;
4. alter database open;
To set database in NoArchivelog Mode
1. shutdown immediate;
2. startup mount;
3. alter database noarchivelog;
4. alter database open;
| Is This Answer Correct ? | 13 Yes | 0 No |
What are the roles and user accounts created automatically with the database ?
what is meant by physical order and logical order in clustered index and non clustered index.
what is snapshot log ?
What is a profile ?
What are the database administrators utilities avaliable ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
What are the dictionary tables used to monitor a database spaces ?
What are the use of Roles ?
What are the different Levels of Auditing ?
What is the use of ANALYZE command ?
What are the system resources that can be controlled through Profile ?
What are the responsibilities of a Database Administrator ?
Oracle General 
