what is the role of archiever
- 4 Answers
- 6898 Views
- Baidu, Satyam, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sinha
Archiver [ARCn] writes the committed data from redo log file
to archive log file. Archive log file is used as backup for
recovery purpose if database crashes.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / ashok
archiver writes the data from redologs to archivefiles.
when log switch occur or redolog is full then log switch
occur automatically archiver writes from redo to
archiverfiles .manuvally dba can force logswitch alter
system switch logfile
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / karthickumar pillaiyarsamy
Archiever role is writes the data from online redolog file
to archieved file, but Archiever Should be enable.
In 10G,
Alter system set archieve/noarchieve mode
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mbujjibabu
archiver will maintain the Historical data from Master data
based on time.
this data will be used for planning and forecasting.
| Is This Answer Correct ? | 2 Yes | 10 No |
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is an Oracle SYSTEM tablespace and when is it Created?
what is the role of archiever
what is ORACLE MEMORY STRUCTURES
Teradata: How can we know the indexed column in a table?
What is the function of Redo Log in Oracle?
How will you swap objects into a different table space for an existing database?
What do Redo Log Buffers contain?
What is an Oracle Data Segment?
How does Space allocation table place within a block ?
When does LGWR write to the database?
When will be a segment released?
Oracle General 
