Question:
How can you enable automatic archiving ?
Answer:
Shut the database Backup the database Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file. Start up the database. Source: CoolInterview.com
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; Source: CoolInterview.com
Answered by: ilyas | Date: 9/11/2008
| Contact ilyas
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|