不完全恢復(fù)：- resetlogs
- using backup controlfile - 告訴Oracle，使用的controlfile是舊的
查詢(xún)一個(gè)table所屬的tablespace:
SQL> select tablespace_name from tabs where table_name = 'T';
TABLESPACE_NAME
------------------------------------------------------------
SYSTEM
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE 例程已經(jīng)啟動(dòng)。
Total System Global Area 2137886720 bytes
Fixed Size 2177456 bytes
Variable Size 1258292816 bytes
Database Buffers 872415232 bytes
Redo Buffers 5001216 bytes
SQL> alter database mount;
數(shù)據(jù)庫(kù)已更改。
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1249453
2 1249453
3 1249453
4 1249453
5 1249453
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1249453
2 1249453
3 1249453
4 1249453
5 1249453
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL> recover database using backup controlfile;
ORA-00279: ?? 1249453 (? 10/17/2012 20:58:40 ??) ???? 1 ????
ORA-00289: ??:
D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_10_17\O1_MF_1_36_8
7XC8NM5_.ARC
ORA-00280: ?? 1249453 (???? 1) ??? #36 ?
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_10_17\O1_MF_1_41_
%U_.ARC'
ORA-27041: unable to open file
OSD-04002: ????????????
O/S-Error: (OS 2) ??????????????????????
SQL> recover database using backup controlfile;
ORA-00279: ?? 1249853 (? 10/17/2012 21:06:30 ??) ???? 1 ????
ORA-00289: ??:
D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_10_17\O1_MF_1_41_%
U_.ARC
ORA-00280: ?? 1249853 (???? 1) ??? #41 ?
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\app\Administrator\oradata\orcl\REDO02.log
已應(yīng)用的日志。
完成介質(zhì)恢復(fù)。
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1250129
2 1250129
3 1250129
4 1250129
5 1250129
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1250129
2 1250129
3 1250129
4 1250129
5 1250129 SQL> alter database open resetlogs;
數(shù)據(jù)庫(kù)已更改。
恢復(fù)，永遠(yuǎn)都是恢復(fù)的數(shù)據(jù)文件：如果控制文件損壞了，但是數(shù)據(jù)文件沒(méi)有損壞；則在恢復(fù)的時(shí)候，僅僅就是驗(yàn)證數(shù)據(jù)文件，不會(huì)更改checkpoint_change#.
備份：- 完全脫機(jī)備份 - shutdown - 現(xiàn)實(shí)環(huán)境中，shutdown危機(jī)無(wú)限
- 部分脫機(jī)備份 - offline - system 等datafile無(wú)法offline備份
- 部分聯(lián)機(jī)備份 - online - 會(huì)產(chǎn)生很多的log file
都需要物理的copy，至于copy的file中有多少有用數(shù)據(jù)，備份不關(guān)心。
現(xiàn)實(shí)環(huán)境中，file可能GT級(jí)別，copy會(huì)占用很多時(shí)間。