C:\oracle\product\10.2.0\oradata\maggie>dir
Volume in drive C is IBM_PRELOAD
Volume Serial Number is F8E4-3D36
Directory of C:\oracle\product\10.2.0\oradata\maggie
04/12/2008 11:23 AM 7,061,504 CONTROL01.CTL
04/12/2008 11:23 AM 7,061,504 CONTROL02.CTL
04/12/2008 11:23 AM 7,061,504 CONTROL03.CTL
04/10/2008 09:22 PM 52,429,312 REDO01.LOG
04/10/2008 09:22 PM 52,429,312 REDO02.LOG
04/10/2008 09:22 PM 52,429,312 REDO03.LOG
04/12/2008 11:34 AM 262,152,192 SYSAUX01.DBF
04/10/2008 09:22 PM 503,324,672 SYSTEM01.DBF
04/12/2008 11:26 AM 20,979,712 TEMP01.DBF
04/10/2008 09:22 PM 26,222,592 UNDOTBS01.DBF
04/10/2008 09:22 PM 6,561,792 USERS01.DBF
11 File(s) 997,713,408 bytes
2 Dir(s) 1,843,929,088 bytes free
C:\oracle\product\10.2.0\oradata\maggie>del USERS01.DBF
C:\oracle\product\10.2.0\oradata\maggie\USERS01.DBF
The process cannot access the file because it is being used by another process.
C:\oracle\product\10.2.0\oradata\maggie>del USERS01.DBF
C:\oracle\product\10.2.0\oradata\maggie>dir
Volume in drive C is IBM_PRELOAD
Volume Serial Number is F8E4-3D36
Directory of C:\oracle\product\10.2.0\oradata\maggie
04/12/2008 11:48 AM 7,061,504 CONTROL01.CTL
04/12/2008 11:48 AM 7,061,504 CONTROL02.CTL
04/12/2008 11:48 AM 7,061,504 CONTROL03.CTL
04/12/2008 11:48 AM 52,429,312 REDO01.LOG
04/12/2008 11:48 AM 52,429,312 REDO02.LOG
04/12/2008 11:48 AM 52,429,312 REDO03.LOG
04/12/2008 11:48 AM 262,152,192 SYSAUX01.DBF
04/12/2008 11:48 AM 503,324,672 SYSTEM01.DBF
04/12/2008 11:48 AM 20,979,712 TEMP01.DBF
04/12/2008 11:48 AM 26,222,592 UNDOTBS01.DBF
10 File(s) 991,151,616 bytes
2 Dir(s) 1,850,486,784 bytes free
SQL> startup
ORACLE instance started.
Total System Global Area 452984832 bytes
Fixed Size 1249536 bytes
Variable Size 92278528 bytes
Database Buffers 356515840 bytes
Redo Buffers 2940928 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGGIE\USERS01.DBF'
C:\>rman
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Apr 12 11:54:15 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target
connected to target database: MAGGIE (DBID=3734094194, not open)
RMAN> startup force mount;
Oracle instance started
database mounted
Total System Global Area 452984832 bytes
Fixed Size 1249536 bytes
Variable Size 92278528 bytes
Database Buffers 356515840 bytes
Redo Buffers 2940928 bytes
RMAN> restore database;
Starting restore at 12-APR-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGGIE\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGGIE\UNDOTBS01.DB
F
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGGIE\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGGIE\USERS01.DBF
channel ORA_DISK_1: reading from backup piece C:\ORACLE\PRODUCT\10.2.0\FLASH_REC
OVERY_AREA\MAGGIE\BACKUPSET\2008_04_09\O1_MF_NNND0_TAG20080409T190502_3ZTLX1L2_.
BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\MAGGIE\BACKUPSET\2008_
04_09\O1_MF_NNND0_TAG20080409T190502_3ZTLX1L2_.BKP tag=TAG20080409T190502
channel ORA_DISK_1: restore complete, elapsed time: 00:01:47
Finished restore at 12-APR-08
RMAN> recover database;
Starting recover at 12-APR-08
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:20
Finished recover at 12-APR-08
RMAN> alter database open;
database opened
RMAN>
C:\oracle\product\10.2.0\oradata\maggie>dir
Volume in drive C is IBM_PRELOAD
Volume Serial Number is F8E4-3D36
Directory of C:\oracle\product\10.2.0\oradata\maggie
04/12/2008 11:55 AM 7,061,504 CONTROL01.CTL
04/12/2008 11:55 AM 7,061,504 CONTROL02.CTL
04/12/2008 11:55 AM 7,061,504 CONTROL03.CTL
04/12/2008 11:48 AM 52,429,312 REDO01.LOG
04/12/2008 11:48 AM 52,429,312 REDO02.LOG
04/12/2008 11:48 AM 52,429,312 REDO03.LOG
04/12/2008 11:58 AM 262,152,192 SYSAUX01.DBF
04/12/2008 11:58 AM 503,324,672 SYSTEM01.DBF
04/12/2008 11:48 AM 20,979,712 TEMP01.DBF
04/12/2008 11:58 AM 26,222,592 UNDOTBS01.DBF
04/12/2008 11:58 AM 6,561,792 USERS01.DBF
11 File(s) 997,713,408 bytes
2 Dir(s) 1,843,961,856 bytes free
C:\oracle\product\10.2.0\oradata\maggie>