Kindly differentiate Redo, undo, Roll back and Roll forward

musa

• Aug 1st, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

What to do when tempdb logsegment is full in production server?

What is the difference between Roll back and Roll forward process?

ashok

• Oct 6th, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Raju

• Nov 24th, 2016

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Answer Question  Select Best Answer

If there was a abnormal termination, upon startup smon performs instance recovery and rolls forward and rollbacks committed and uncomitted transaction. But if this happens before startup the DB files are not open before startup then how does smon carry out recovery.

harshini

• Oct 8th, 2017

Secondary Backup Server

Answer Question  Select Best Answer

What is the solution if some users are encountering slow performance in production db?

Abbey

• Feb 16th, 2018

Scan for virus first

Shalu

• Dec 4th, 2016

Check the query that is running in database, try to optimize the query by using correct hint and indexes"oracle8 SELECT department_id, last_name, salary FROM employees WHERE ...

Answer Question  Select Best Answer

How to take RMAN Backup for the Specific time period like (01-JAN-2016 to 31-DEC-2017)?

How to schedule Daily, Monthly and Weekly automatic backup in RMAN?