Cold backup and recovery the broken data file

-- Create testing data

SQL> create table t01 tablespace ts_auto as select sysdate col01 from dual;

Table created.

SQL> select * from t01;

COL01

---------

20-AUG-10

-- Full cold backup

[oracle@centos-4 workarea]$ ./cold_backup.sh

[@more@]

-- Insert new datas, and use redo log files to recovery

SQL> insert into t01 select sysdate from dual;

1 row created.

SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t01;

COL01

---------

20-AUG-10

20-AUG-10

20-AUG-10

-- Simulate breaking data files

[oracle@centos-4 workarea]$ rm /u01/oradata/shenzhen/ts_auto.dbf

[oracle@centos-4 workarea]$ sqlplus / as sysdba

SQL> startup force;

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 155190864 bytes

Database Buffers 125829120 bytes

Redo Buffers 2973696 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01110: data file 6: '/u01/oradata/shenzhen/ts_auto.dbf'

-- Recovery

SQL> alter database datafile 6 offline drop;

Database altered.

SQL> alter database open;

Database altered.

[oracle@centos-4 workarea]$ cp /u01/backup/cold/20100820/ts_auto.dbf /u01/oradata/shenzhen/

[oracle@centos-4 workarea]$ sqlplus / as sysdba

SQL> recover datafile 6;

Media recovery complete.

SQL> alter database datafile 6 online;

Database altered.

SQL> select * from t01;

COL01

---------

20-AUG-10

20-AUG-10

20-AUG-10

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12472709/viewspace-1037123/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12472709/viewspace-1037123/