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: 67743
Registered: March 2007
Location: Nanterre, France, http://...

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: Sat Feb 27 01:46:15 CST 2021