SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6
Current log sequence 8
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
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.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6
Next log sequence to archive 8
Current log sequence 8
SQL> create table c_backup(name varchar(100)) tablespace users;
Table created.
SQL> insert into c_backup values('****** INSERTED BEFORE BACKUP *******');
1 row created.
SQL> commit;
Commit complete.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
C:\>mkdir c:\c_backup
C:\>copy c:\oracle\product\10.2.0\oradata\dba20\* c:\c_backup\
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\TEST01.DBF
c:\oracle\product\10.2.0\oradata\dba20\USERS01.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 c_backup values('****** INSERTED AFTER BACKUP *******');
1 row created.
SQL> commit;
Commit complete.
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> alter database datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\USERS01.DBF' offline;
Database altered.
SQL> alter database open;
Database altered.
SQL> select * from c_backup;
select * from c_backup
ERROR at line 1:
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\USERS01.DBF'
C:\>copy c:\c_backup\USERS01.DBF c:\oracle\product\10.2.0\oradata\dba20\
1 file(s) copied.
SQL> recover datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\USERS01.DBF';
Media recovery complete.
SQL> alter database datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\USERS01.DBF' online;
Database altered.
SQL> select * from c_backup;
NAME
--------------------------------------------------------------------------------
****** INSERTED AFTER BACKUP *******
****** INSERTED BEFORE BACKUP *******