SQL> create table cold_back(name varchar(100));
Table created.
SQL> insert into cold_back values('********* DATA INSERTED BEFORE BACKUP ***********');
1 row created.
SQL> commit;
Commit complete.
SQL> select name from v$datafile
union
select name from v$controlfile
union
select member from v$logfile;
NAME
--------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL01.CTL
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL02.CTL
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL03.CTL
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\REDO01.LOG
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\REDO02.LOG
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\REDO03.LOG
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\SYSAUX01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\SYSTEM01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\TEST01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\UNDOTBS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\USERS01.DBF
11 rows selected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
C:\>mkdir c:\cold_back
C:\>copy c:\oracle\product\10.2.0\oradata\dba20\* c:\cold_back
c:\oracle\product\10.2.0\oradata\dba20\SYSAUX01.DBF
c:\oracle\product\10.2.0\oradata\dba20\UNDOTBS01.DBF
c:\oracle\product\10.2.0\oradata\dba20\CONTROL01.CTL
c:\oracle\product\10.2.0\oradata\dba20\CONTROL02.CTL
c:\oracle\product\10.2.0\oradata\dba20\CONTROL03.CTL
c:\oracle\product\10.2.0\oradata\dba20\REDO01.LOG
c:\oracle\product\10.2.0\oradata\dba20\REDO02.LOG
c:\oracle\product\10.2.0\oradata\dba20\REDO03.LOG
c:\oracle\product\10.2.0\oradata\dba20\TEMP01.DBF
c:\oracle\product\10.2.0\oradata\dba20\SYSTEM01.DBF
c:\oracle\product\10.2.0\oradata\dba20\USERS01.DBF
c:\oracle\product\10.2.0\oradata\dba20\TEST01.DBF
12 file(s) copied.
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> insert into cold_back values('********* DATA INSERTED AFTER BACKUP ***********');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from cold_back;
NAME
--------------------------------------------------------------------------------
********* DATA INSERTED BEFORE BACKUP ***********
********* DATA INSERTED AFTER BACKUP ***********
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
C:\>del C:\oracle\product\10.2.0\oradata\dba20\USERS01.DBF
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 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\DBA20\USERS01.DBF'
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
C:\>copy /Y c:\cold_back\* c:\oracle\product\10.2.0\oradata\dba20\
c:\cold_back\SYSAUX01.DBF
c:\cold_back\UNDOTBS01.DBF
c:\cold_back\CONTROL01.CTL
c:\cold_back\CONTROL02.CTL
c:\cold_back\CONTROL03.CTL
c:\cold_back\REDO01.LOG
c:\cold_back\REDO02.LOG
c:\cold_back\REDO03.LOG
c:\cold_back\TEMP01.DBF
c:\cold_back\SYSTEM01.DBF
c:\cold_back\USERS01.DBF
c:\cold_back\TEST01.DBF
12 file(s) copied.
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> select * from cold_back;
NAME
-----------------------------------------------------------------------------
********* DATA INSERTED BEFORE BACKUP ***********