Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle AllOther
  2. Suggest New Category

Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.

Question Posted / vivek tiwari

Answer Posted / vivek tiwari

Noarchivelog Mode
By default, a database is created in Noarchivelog mode. The
characteristics of operating a
database in Noarchivelog mode are as follows:
• Redo log files are used in a circular fashion.
• A redo log file can be reused immediately after a
checkpoint has taken place.
• After redo logs are overwritten, media recovery is only
possible to the last full backup.
Archivelog Mode
A filled redo log file cannot be reused until a checkpoint
has taken place and the redo log file
has been backed up by the ARCn background process. An entry
in the control file records the
log sequence number of the archived log file.
The most recent changes to the database are available at
any time for instance recovery, and
the archived redo log files can be used for media recovery.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Could you please let me know the interfaces in OM / FA??

2342

What do you mean by Oracle MEDIA RECOVERY?

1282

What is auto invoicing? Explain : oracle accounts receivable

1171

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2309

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2920

What is the difference between recovery and restoring of the oracle database?

1294

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7777

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2150

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1172

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2311

Give two methods you could use to determine what DDL changes have been made.

6855

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2338

What is db_recovery_file_dest in oracle? When do you need to set this value?

1166

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1322

can we use lexical perameter in oracle plsql if yes how

2377