Home » RDBMS Server » Backup & Recovery » RMAN How to restore completed backup without recover archive redo log (Oracle 12c, Oracle Linux Enterprise 7.2)  () 1 Vote
RMAN How to restore completed backup without recover archive redo log [message #649729] Mon, 04 April 2016 21:36 Go to next message
Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh
Junior Member

Hi,

I have some concerns about restore completed backup database in Oracle.

In this case, I have already backed up on 23:00, so If I need that backup (this time only 23:00) to restore on my testing server, do I need to RECOVER DATABASE or not after restore database?

thank
Re: RMAN How to restore completed backup without recover archive redo log [message #649734 is a reply to message #649729] Tue, 05 April 2016 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If the backup was a hot one (database open), yes you need it; if it was a cold one (database closed), no.

Re: RMAN How to restore completed backup without recover archive redo log [message #649739 is a reply to message #649734] Tue, 05 April 2016 01:45 Go to previous messageGo to next message
Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh
Junior Member

Can you explain more detail?

My concern is if I restored full database without add more archive redo log, it is possible or not?

thank
Re: RMAN How to restore completed backup without recover archive redo log [message #649740 is a reply to message #649739] Tue, 05 April 2016 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If it was a cold backup, yes; if it was a hot backup, no.

Re: RMAN How to restore completed backup without recover archive redo log [message #649757 is a reply to message #649739] Tue, 05 April 2016 06:49 Go to previous messageGo to next message
EdStevens
Messages: 887
Registered: September 2013
Senior Member
Puthearith wrote on Tue, 05 April 2016 01:45
Can you explain more detail?

My concern is if I restored full database without add more archive redo log, it is possible or not?

thank


In more detail -- follow this programming logic :

IF
Backup was a "hot" backup
THEN
at least some recovery of redo is required
ELSE
No recovery of redo is required
END-IF


Further explanation
1- "hot" backup means backup was taken while database was fully open.
2- with a hot backup, the backed up files are in an inconsistent state, thus requiring application of redo (referred to as 'recovery') to a consistent SCN
3- Assuming availability of necessary redo, recovery can be to any point in time from the end of the backup to the latest transaction in the online redo.

Re: RMAN How to restore completed backup without recover archive redo log [message #649770 is a reply to message #649757] Tue, 05 April 2016 20:48 Go to previous message
Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh
Junior Member

Thank for your full explanation.
Previous Topic: why we need redo log files when transaction is commited
Next Topic: how to recover corrupted datafile
Goto Forum:
  


Current Time: Tue Jan 16 16:19:21 CST 2018

Total time taken to generate the page: 0.04805 seconds