Explain How can we enable automatic archiving?
Submitted by: AdministratorShut the database
Backup the database
Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.
Start up the database.
To enable archiving
first shutdown the database in normal mode
then open ur parameter file and include a parameter
archive_log_dest=(give a OS level location)
then come out of it and at OS level create same directory which u have just mentioned in parameter file
then startup mount
then alter database archivelog
then alter database open
in order to know whether ur database is functioning in archive mode or not
type at sql promt
ARCHIVE LOGLIST;
Submitted by: Administrator
Backup the database
Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.
Start up the database.
To enable archiving
first shutdown the database in normal mode
then open ur parameter file and include a parameter
archive_log_dest=(give a OS level location)
then come out of it and at OS level create same directory which u have just mentioned in parameter file
then startup mount
then alter database archivelog
then alter database open
in order to know whether ur database is functioning in archive mode or not
type at sql promt
ARCHIVE LOGLIST;
Submitted by: Administrator
Read Online Database Security Oracle Job Interview Questions And Answers
Top Database Security Oracle Questions
☺ | Explain What is Privilege Auditing? |
☺ | Explain How you can secure our data in local area Network? |
☺ | Explain What are roles? How can you implement roles? |
☺ | What are the security features in Oracle? |
☺ | Explain How can we enable automatic archiving? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |