热备份下不完全恢复

热备份下基于时间的恢复......

SQL> select *
2 from test.t_date1;

C1 C2
---------- -------------------
491369 2006-12-18 15:45:49
111 2006-12-18 15:52:21
492946 2006-12-18 15:55:54
222 2006-12-18 15:56:02
494453 2006-12-18 16:19:00
496031 2006-12-18 16:29:01

6 rows selected.

SQL> select *
2 from test.t_date2;

C1 C2
---------- -------------------
491369 2006-12-18 15:45:49
111 2006-12-18 15:52:21
492946 2006-12-18 15:55:54
222 2006-12-18 15:56:02
494453 2006-12-18 16:19:00
496031 2006-12-18 16:29:01

6 rows selected.

SQL> @E:dbdataopen_backup

...........

SQL> select * from test.t_date1;
491369 2006-12-18 15:45:49
111 2006-12-18 15:52:21
492946 2006-12-18 15:55:54
222 2006-12-18 15:56:02
494453 2006-12-18 16:19:00
496031 2006-12-18 16:29:01
497708 2006-12-18 16:39:08
499291 2006-12-18 16:49:13
SQL> select * from test.t_date2;
491369 2006-12-18 15:45:49
111 2006-12-18 15:52:21
492946 2006-12-18 15:55:54
222 2006-12-18 15:56:02
494453 2006-12-18 16:19:00
496031 2006-12-18 16:29:01
497708 2006-12-18 16:39:08
499291 2006-12-18 16:49:13
SQL> drop table test.t_date2;

......

SQL> shutdown immediate;

Copy 备份文件,不要覆盖当前重做日志

SQL> startup
ORACLE instance started.

Total System Global Area 76618332 bytes
Fixed Size 453212 bytes
Variable Size 62914560 bytes
Database Buffers 12582912 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> shutdown immeidate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 76618332 bytes
Fixed Size 453212 bytes
Variable Size 62914560 bytes
Database Buffers 12582912 bytes
Redo Buffers 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "TESTDB" NORESETLOGS ARCHIVELOG
2 -- SET STANDBY TO MAXIMIZE PERFORMANCE
3 MAXLOGFILES 50
4 MAXLOGMEMBERS 5
5 MAXDATAFILES 100
6 MAXINSTANCES 1
7 MAXLOGHISTORY 113
8 LOGFILE
9 GROUP 1 'C:ORACLEORADATATESTDBREDO01.LOG' SIZE 5M,
10 GROUP 2 'C:ORACLEORADATATESTDBREDO02.LOG' SIZE 5M,
11 GROUP 3 'C:ORACLEORADATATESTDBREDO03.LOG' SIZE 5M
12 -- STANDBY LOGFILE
13 DATAFILE
14 'C:ORACLEORADATATESTDBSYSTEM01.DBF',
15 'C:ORACLEORADATATESTDBUNDOTBS01.DBF',
16 'C:ORACLEORADATATESTDBDRSYS01.DBF',
17 'C:ORACLEORADATATESTDBEXAMPLE01.DBF',
18 'C:ORACLEORADATATESTDBINDX01.DBF',
19 'C:ORACLEORADATATESTDBODM01.DBF',
20 'C:ORACLEORADATATESTDBTOOLS01.DBF',
21 'C:ORACLEORADATATESTDBUSERS01.DBF',
22 'C:ORACLEORADATATESTDBXDB01.DBF',
23 'C:ORACLEORADATATESTDBTEST.ORA'
24 CHARACTER SET AL32UTF8
25 ;

Control file created.

SQL> recover database until time '2006-12-18 16:49:16';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

SQL> select * from test.t_date1;

C1 C2
---------- -------------------
491369 2006-12-18 15:45:49
111 2006-12-18 15:52:21
492946 2006-12-18 15:55:54
222 2006-12-18 15:56:02
494453 2006-12-18 16:19:00
496031 2006-12-18 16:29:01
497708 2006-12-18 16:39:08
499291 2006-12-18 16:49:13

8 rows selected.

SQL> select * from test.t_date2;

C1 C2
---------- -------------------
491369 2006-12-18 15:45:49
111 2006-12-18 15:52:21
492946 2006-12-18 15:55:54
222 2006-12-18 15:56:02
494453 2006-12-18 16:19:00
496031 2006-12-18 16:29:01
497708 2006-12-18 16:39:08
499291 2006-12-18 16:49:13

8 rows selected.

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

转载于:http://blog.itpub.net/45259/viewspace-134909/