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

Teradata: How can we know the indexed column in a table?

0 Answers   CTS, HSBC,


What is the function of Redo Log in Oracle?

0 Answers  


how oracle will recognise its space is 100gb if 100gb is allocated for it...

1 Answers   Baidu,


What is an Integrity Constrains in Oracle?

0 Answers  


What is the function of Dispatcher (Dnnn)?

4 Answers  






What are disadvanteges of having raw devices ?

1 Answers  


What is SGA?

3 Answers  


How to find the current session sid

3 Answers   Baidu,


What is the functionality of SYSTEM table space ?

3 Answers  


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

4 Answers   Baidu, HCL, Yashu Systems,


How will you monitor the space allocation ?

3 Answers  


What is meant by free extent ?

2 Answers  


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)