OraFAQ Forum: Backup & Recovery » Recovery from SQL

Home » RDBMS Server » Backup & Recovery » Recovery from SQL (Oracle 9i, 10g R2 on HP-UX)

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

Recovery from SQL [message #486538]

Thu, 16 December 2010 05:25

OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom

Senior Member

Hi

Which cases do we recover from SQL?
E.g.

recover automatic database until time 'yyyy-mm-dd:hh24:mi:ss' using backup controlfile;

Since we can do the Incomplete recovery even from RMAN what difference does recovery from SQL makes?

Regards,
OraKaran

Report message to a moderator

Re: Recovery from SQL [message #486541 is a reply to message #486538]

Thu, 16 December 2010 05:37

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

Senior Member
Account Moderator

No difference (although we encountered some weird cases, RMAN bug, where RMAN was unable to do it when SQL*Plus did).
Note that SQL*Plus comes far before RMAN existed, so why remove a feature from it because another product comes into play?

Regards
Michel

Report message to a moderator

Re: Recovery from SQL [message #486546 is a reply to message #486541]

Thu, 16 December 2010 07:39

OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom

Senior Member

Thanks Michel!

Regards,
OraKaran

Report message to a moderator

Previous Topic:	Redo Log changes not recovered in RMAN recovery after restoring control file
Next Topic:	Log file in ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG got deleted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 14 10:20:59 CDT 2026