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...

what is the difference between re-do and mirror log?
How it is related with database backup?
Please explain the database backup concept in detail.

Thanks in advance.:)
regards
preeti.

Answer Posted / annabathula

Redo Log:-

Redo log management plays a part in the following actions

During execution of a modifying transaction, the redo log entries are included in the log queue. The log writer writes the

log pages from the log queue to the log area.

During a Structure linklog backup, information is obtained on whether entries from the log area are to be backed up, and if

so, how many.
In the case of a restart or recovery, the required redo log entries are read from the log area.
The database parameters and other internal information that controls logging are stored in the log area and updated at

regular intervals.


Mirroring:-

It is essential to mirror the online redo log files in database. This procedure describes how you can check the mirroring

with BRSPACE. Also, the system check in BRCONNECT checks mirroring.
If you lose one or more online redo log files, you can no longer recover the database changes recorded in them. This means

that you can only recover the database up to the first gap in the online redo log records. For this reason, we strongly

recommend that you mirror the online redo log files. We recommend that you make at least one copy.
If an online redo log file of a group is lost, the database remains in operation. Oracle then uses the remaining member (or

members) of this group to log the database changes. In such a case, you must recover the original mirroring of the online

redo log files as quickly as possible.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Have you done any up gradations?

2248


what is the common storage file for oracle ?

2101


if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days

2057


How will go about doing a client copy ?

1082


Do? If another user wants to share that lock but the user using that

1745


How to analysis abap dumps?

1106


Where do you check transport request logs?

1130


How you can disable the ‘import all’ button on stms for the queues?

1172


If a background job runs more than the time it should be completed normally then what actions will u take?

1818


Where will you change the parameters in three profiles?

1206


Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri

1826


How to lock or unlock a transaction code using sm01?

2125


Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate

2109


What is oracle Architecture?

2127


what are the pros and cons of auto extend of table spaces?

2193