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 >> DB Administration
  2. Suggest New Category

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

Question Posted / pv bhaskar

Answer Posted / pv bhaskar

Archivelog mode : We can recover the database at any point
in time.


No Archivelog mode : There is no Recovery Process.

Because Online Redologs are overwritten. so there is no
Archives in this mode.

If there is Media Failure(loss of Disks or files) in this
mode we can restore from a backup but we will loss all
changes made to the database,After the backup was performed.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why would you call update statistics? : sql server DBA

994

what is grd?

1101

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1940

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2570

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2306

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2067

What the different components in replication and what is their use? : sql server DBA

1055

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2625

Why does Oracle not permit the use of PCTUSED with indexes?

2947

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1108

What is fill factor? : sql server DBA

1255

how can you initialize log miner?

1153

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2446

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1295

Which autogrowth database setting is good? : sql server DBA

1163