Oracle Backup-Control-based full recovery

Accidentally delete tablespace (with backup), use Backup control file recovery

First, the simulation environment

07:59:14 sql> Select COUNT (*) from SCOTT.DEPT2;

COUNT (*)

----------

12

07:59:50 sql> drop tablespace lxtbs1 including contents and datafiles;

Tablespace dropped.

07:59:56 sql> Shutdown Immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

08:00:58 sql>!

Fri Mar 23 18:50:06 2012

Drop tablespace cuug including contents and datafiles

Fri Mar 23 18:50:08 2012

Deleted file/u01/app/oracle/oradata/anny/cuug01.dbf

Completed:drop tablespace cuug including contents and datafiles

Second, dump all data files

[Oracle@cuug14 ~]$ CP/ORABAK/ORCL/COLD_BAK/*.DBF/DISK1/ORADATA/ORCL

08:03:26 sql> recover database until time ' 2012-02-12 07:59:53 ' using Backup controlfile;

Ora-01034:oracle Not available

08:04:12 sql> Startup Mount

ORACLE instance started.

Total System Global area 167772160 bytes

Fixed Size 1218316 bytes

Variable Size 75499764 bytes

Database buffers 88080384 bytes

Redo buffers 2973696 bytes

Database mounted.

Third, recover database

08:04:36 sql> recover database until time ' 2012-02-12 07:59:53 ' using Backup controlfile;

Ora-00279:change 831098 generated at 02/12/2012 06:32:28 for thread 1

Ora-00289:suggestion:/arch/orcl/arch_1_6_775023202.log

Ora-00280:change 831098 for thread 1 was in sequence #6

08:04:45 Specify log: {<ret>=suggested | AUTO | CANCEL}

Auto

Ora-00279:change 832010 generated at 02/12/2012 07:55:37 for thread 1

Ora-00289:suggestion:/arch/orcl/arch_1_1_775036537.log

Ora-00280:change 832010 for thread 1 was in sequence #1

Ora-00279:change 832995 generated at 02/12/2012 07:58:39 for thread 1

Ora-00289:suggestion:/arch/orcl/arch_1_2_775036537.log

Ora-00280:change 832995 for thread 1 was in sequence #2

Ora-00278:log file '/arch/orcl/arch_1_1_775036537.log ' no longer needed for this recovery

Ora-00279:change 832997 generated at 02/12/2012 07:58:40 for thread 1

Ora-00289:suggestion:/arch/orcl/arch_1_3_775036537.log

Ora-00280:change 832997 for thread 1 was in sequence #3

Ora-00278:log file '/arch/orcl/arch_1_2_775036537.log ' no longer needed for this recovery

Ora-00279:change 833000 generated at 02/12/2012 07:58:43 for thread 1

Ora-00289:suggestion:/arch/orcl/arch_1_4_775036537.log

Ora-00280:change 833000 for thread 1 was in sequence #4

Ora-00278:log file '/arch/orcl/arch_1_3_775036537.log ' no longer needed for this recovery

Ora-00279:change 833017 generated at 02/12/2012 07:59:13 for thread 1

Ora-00289:suggestion:/arch/orcl/arch_1_5_775036537.log

Ora-00280:change 833017 for thread 1 was in sequence #5

Ora-00278:log file '/arch/orcl/arch_1_4_775036537.log ' no longer needed for this recovery

Ora-00279:change 833019 generated at 02/12/2012 07:59:14 for thread 1

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/