Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recover Database in RMAN vs SQL*PLUS

Dude!Jan 7 2011 — edited Jan 7 2011

Hello,

Oracle 11.2.0.1, Oracle Linux 5.5 UEK.

I recently did a "recover database" in sql*plus, but an attempt to open the database gave ORA-01113, complaining the system tablespace requried more recovery. Then I used RMAN (nocatalog) and after the same "recover database" command I was able to open the database.

It seems there are differences between SQL*PLUS and RMAN "recover database" command. I have not been able to locate the chapter in the Oracle documentation that explains the difference. I have some ideas, but...

Thanks.

h3. Solution Summary:

The recover command in RMAN compared to SQL*Plus implements a more user friendly processing logic based on the current detected scenario. For instance, a RMAN recover database command may actually perform a "recover database using backup controlfile until cancel" and automatically apply all archived and online redo logs if available. The same can be achieved with the recover command in SQL*plus, but will have to be done manually.

Edited by: Dude on Jan 7, 2011 12:30 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2011

Added on Jan 7 2011

#general-database-discussions

12 comments

3,948 views