what is the role of archiever
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 |
Can a View based on another View in Oracle?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is the significance of having storage clause ?
What is the maximum number of Lock Processes used?
What is the OPTIMAL parameter ?
How will you swap objects into a different table space for an existing database?
What is the role of PCTFREE parameter is Storage clause ?
What is the function of ARCH?
How the space utilisation takes place within rollback segments?
What is a Control file ?
What is dictionary cache ?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,