what is the role of archiever

Answers were Sorted based on User's Feedback



what is the role of archiever..

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

what is the role of archiever..

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

what is the role of archiever..

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

what is the role of archiever..

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

Post New Answer

More Oracle Architecture Interview Questions

Can a View based on another View in Oracle?

0 Answers  


List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  


What is the significance of having storage clause ?

1 Answers  


What is the maximum number of Lock Processes used?

1 Answers  


What is the OPTIMAL parameter ?

1 Answers   TCS,






How will you swap objects into a different table space for an existing database?

2 Answers  


What is the role of PCTFREE parameter is Storage clause ?

2 Answers  


What is the function of ARCH?

3 Answers  


How the space utilisation takes place within rollback segments?

2 Answers  


What is a Control file ?

4 Answers  


What is dictionary cache ?

2 Answers  


What is the maximum size of a row in oracle 9i?

4 Answers   Baidu, HCL, Yashu Systems,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)