You are currently browsing the Rick’s Blog weblog archives for April, 2008.

Rman recovery example

Recovery example SQL> select status, enabled, online_time, name from v$datafile order by name; STATUS ENABLED ONLINE_TI ——- ———- ——— NAME ——————————————————————————– RECOVER READ WRITE 13-AUG-07 +DATA01/cp04/datafile/bb_bb60_indx.281.630546303 ONLINE READ WRITE 13-AUG-07 +DATA01/cp04/datafile/bb_bb60_stats_data.282.630546385 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining [...]