Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?
Submitted by: AdministratorTo 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;
Submitted by: Administrator
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;
Submitted by: Administrator
Read Online Oracle Security Job Interview Questions And Answers
Top Oracle Security Questions
| ☺ | What is snapshots? |
| ☺ | How to specify the Archived log file name format and destination? |
| ☺ | Explain What are the dictionary tables used to monitor a database spaces? |
| ☺ | How to prevent unauthorized use of privileges granted to a Role? |
| ☺ | Explain snapshot log? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Forms Reports Interview Questions. |
