Home » RDBMS Server » Backup & Recovery » Recovery from SQL (Oracle 9i, 10g R2 on HP-UX)
Recovery from SQL [message #486538] Thu, 16 December 2010 05:25 Go to next message
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
Re: Recovery from SQL [message #486541 is a reply to message #486538] Thu, 16 December 2010 05:37 Go to previous messageGo to next message
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
Re: Recovery from SQL [message #486546 is a reply to message #486541] Thu, 16 December 2010 07:39 Go to previous message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Thanks Michel!

Regards,
OraKaran
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:
  


Current Time: Sat Feb 27 01:46:15 CST 2021