Interested to Buy Any Domain ? << Click Here >> for more details...
How can you enable automatic archiving ?
- 2 Answers
- 5963 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Shut the database
Backup the database
Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.
Start up the databse.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / smtia
1. shutdown the database with normal/emmidiate/transactional
2. modify/include the parameter log_archive_start=true,
log_archive_dest= (location to which the redo log file
group is archived), log_archive_format=(in which format you
want to apper the archive log file)
3. start up the database
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a trace file and how is it created ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
What are the responsibilities of a Database Administrator ?
Differentiate simple and complex, snapshots ?
What is user Account in Oracle database ?
What are the system resources that can be controlled through Profile ?
What is default tablespace ?
what is snapshot log ?
What are the benefits of distributed options in databases ?
What is the use of ANALYZE command ?
what is meant by physical order and logical order in clustered index and non clustered index.
How to prevent unauthorized use of privileges granted to a Role ?
Oracle General 
