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 options
bash-3.00$ rman
Recovery Manager: Release 10.2.0.3.0 - Production on Sat Apr 5 18:09:42 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target
connected to target database: CP04 (DBID=429165704)
RMAN> sql 'alter database datafile 9 offline';
using target database control file instead of recovery catalog
sql statement: alter database datafile 9 offline
RMAN> recover datafile 9;
Starting recover at 05-APR-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=50 instance=cp041 devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:06
Finished recover at 05-APR-08
RMAN> sql 'alter database datafile 9 online';
sql statement: alter database datafile 9 online
RMAN>
