OraFAQ Forum: Backup & Recovery » RMAN How to restore completed backup without recover archive redo log

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

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN How to restore completed backup without recover archive redo log [message #649729]

Mon, 04 April 2016 21:36

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

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

EdStevens
Messages: 1376
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.

Report message to a moderator

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

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

Thank for your full explanation.

Report message to a moderator

Previous Topic:	why we need redo log files when transaction is commited
Next Topic:	how to recover corrupted datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 02:36:49 CST 2024