把数据文件TAR进对应目录下.然后restore,重装数据库
解决方案 »
- ORACLE透明网关问题请教
- oracle 表空间问题
- 问下,在Windows xp系统下安装完了oracle 10G之后,建了一个orcl数据库之后,如何做才能让java应用程序能访问数据库orcl并且进行insert、update、delete等呢?
- 优化
- oracle pro*c 中如何正确显示__LINE__
- 如何将组合查询条件放到一个变量中呢?在线等!
- 急:怎样判断一个字符串不能转换为数字?在线等
- 需求oracle.jdbc.driver.OracleDriver
- ORACLE 有没有 SQL SERVER 里的 “应用程序角色“,或者相同的解决方法???
- 各位大哥,烦劳您帮忙拉小弟一把,
- 在线等,急救,solorias卸载和重装oracle
- 紧急求救:ORACLE数据库恢复...............
先冷备份;得到最初的全部文件:数据/控制/联机
然后启动归档模式;切换日志:ARC00002.001
然后做些误操作(scott用户truncate table a);ARC00003.001归档日志文件;
(此时的联机日志文件你是没有保证的~)
看看完全/不完全恢复怎么做呢?~1、单个文件损坏:
restore/recover即可;
ORA-01113: 文件 8 需要介质恢复
ORA-01110: 数据文件 8: 'D:\ORACLE\ORADATA\ORA9I\TOOLS01.DBF'
SQL> recover datafile 8;
完成介质恢复。
SQL> alter database open;
数据库已更改。2、损坏所有数据文件:
SQL> recover database;
完成介质恢复。
SQL> alter database open;
数据库已更改。3、丢失日志文件:4、丢失控制文件:
5、所有文件:
只要把所有的数据文件还原,然后手工创建控制文件,来recover until cancel/open resetlogs;
sql> startup nomount;
SQL> CREATE CONTROLFILE REUSE DATABASE "ora9i" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 454
7 LOGFILE
8 GROUP 1 'D:\oracle\oradata\ora9i\REDO01.LOG' SIZE 100M,
9 GROUP 2 'D:\oracle\oradata\ora9i\REDO02.LOG' SIZE 100M,
10 GROUP 3 'D:\oracle\oradata\ora9i\REDO03.LOG' SIZE 100M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'D:\oracle\oradata\ora9i\CWMLITE01.DBF',
14 'D:\oracle\oradata\ora9i\DRSYS01.DBF',
15 'D:\oracle\oradata\ora9i\EXAMPLE01.DBF',
16 'D:\oracle\oradata\ora9i\INDX01.DBF',
17 'D:\oracle\oradata\ora9i\ODM01.DBF',
18 'D:\oracle\oradata\ora9i\SYSTEM01.DBF',
19 'D:\oracle\oradata\ora9i\TOOLS01.DBF',
20 'D:\oracle\oradata\ora9i\UNDOTBS01.DBF',
21 'D:\oracle\oradata\ora9i\USER02.ORA',
22 'D:\oracle\oradata\ora9i\USERS01.DBF',
23 'D:\oracle\oradata\ora9i\XDB01.DBF'
24 CHARACTER SET ZHS16GBK
25 ;控制文件已创建SQL> recover database until cancel;
ORA-00283: ??????????
ORA-01610: ?? BACKUP CONTROLFILE ??????????
SQL> recover database using backup controlfile until cancel;
ORA-00279: ?? 247200 (? 01/27/2005 10:09:08 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\LOG\ARC00002.001
ORA-00280: ?? 247200 ???? 1 ???? # 2 ???
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\log\ARC00002.001
ORA-00279: ?? 247809 (? 02/02/2005 14:38:28 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\LOG\ARC00003.001
ORA-00280: ?? 247809 ???? 1 ???? # 3 ???
ORA-00278: ??????????? 'D:\oracle\log\ARC00002.001'
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\log\ARC00003.001
ORA-00279: ?? 247896 (? 02/02/2005 14:38:55 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\LOG\ARC00004.001
ORA-00280: ?? 247896 ???? 1 ???? # 4 ???
ORA-00278: ??????????? 'D:\oracle\log\ARC00003.001'
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
cancel;
ORA-00308: ???????? 'cancel;'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND<~
O/S-Error: (OS 2) O5M3UR2;5=V86(5DND<~!#
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
介质恢复已取消。
SQL> recover database using backup controlfile until cancel;
ORA-00279: ?? 247896 (? 02/02/2005 14:38:55 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\LOG\ARC00004.001
ORA-00280: ?? 247896 ???? 1 ???? # 4 ???
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: ???????? 'D:\ORACLE\LOG\ARC00004.001'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND<~
O/S-Error: (OS 2) O5M3UR2;5=V86(5DND<~!#
ORA-00308: ???????? 'D:\ORACLE\LOG\ARC00004.001'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND<~
O/S-Error: (OS 2) O5M3UR2;5=V86(5DND<~!#
SQL> recover database using backup controlfile until cancel;
ORA-00279: ?? 247896 (? 02/02/2005 14:38:55 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\LOG\ARC00004.001
ORA-00280: ?? 247896 ???? 1 ???? # 4 ???
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\log\ARC00002.001
ORA-00310: ???????? 2????? 4
ORA-00334: ????: 'D:\ORACLE\LOG\ARC00002.001'
SQL> recover database using backup controlfile until cancel;
ORA-00279: ?? 247896 (? 02/02/2005 14:38:55 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\LOG\ARC00004.001
ORA-00280: ?? 247896 ???? 1 ???? # 4 ???
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\log\ARC00003.001
ORA-00310: ???????? 3????? 4
ORA-00334: ????: 'D:\ORACLE\LOG\ARC00003.001'
SQL> alter database open resetlogs;数据库已更改。SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL>