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!

oracle sqlplus recover until time

Guess2Nov 17 2011 — edited Dec 1 2011

When I google oracle recovery, all I get is rman... I need to do a manual recovery(and its been since I did this). I have not done this in a while. I found the sqlplus reference with the wire diagram. Before I do it, I want to make sure my command is correct. Is this right?
Then oracle should prompt me for any missing archive logs?

We are taking a BCV copy, then I need to do a manual application of the logs. Its been a while since I have done this.

recovery database until time 'YYYY-MM-DD:HH24:MI:SS';

do i need to do

alter session set nls_date_format='YYYY=MM-DD:HH24:MI:SS';

before I do the recovery?

This post has been answered by LKBrwn_DBA on Nov 18 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2011

Added on Nov 17 2011

#general-database-discussions

5 comments

6,525 views