Saturday, September 06, 2008

recover database until time

1. alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
2. recover database until time 'yyyy-mm-dd hh24:mi:ss';
3.alter database open resetlogs.

No comments: