不知道更新的时间你是否记得,如果不记得,那么使用logminer察看你刚才操作的时间需要一个以前的备份,如果没有备份,重建一个相同的数据库If the database is opened, shut it down by using either the NORMAL
or IMMEDIATE or TRANSACTIONAL options.
2 Mount the database.
3 Restore all data files from backup (the most recent if possible):
4 You may need to restore archived logs. If there is enough space
available, restore to the LOG_ARCHIVE_DEST location or use the
ARCHIVE SYSTEM ARCHIVE LOG START TO <LOCATION>
or SET LOGSOURCE <LOCATION> to change the location.
5 Recover the database:
SQL> recover database until time ‘1999-03-
09:11:44:00’;
6 To synchronize data files with control files and redo logs, open
database by using RESETLOGS option:
SQL> alter database open resetlogs;
or IMMEDIATE or TRANSACTIONAL options.
2 Mount the database.
3 Restore all data files from backup (the most recent if possible):
4 You may need to restore archived logs. If there is enough space
available, restore to the LOG_ARCHIVE_DEST location or use the
ARCHIVE SYSTEM ARCHIVE LOG START TO <LOCATION>
or SET LOGSOURCE <LOCATION> to change the location.
5 Recover the database:
SQL> recover database until time ‘1999-03-
09:11:44:00’;
6 To synchronize data files with control files and redo logs, open
database by using RESETLOGS option:
SQL> alter database open resetlogs;
解决方案 »
- Oracle9i中,如何将一个CLOB变量(就是一个XML),如何转换成一个Varchar对象?
- 同样的sql语句与数据量9i比10g慢很多,求解!
- 我在Debian 3.0_R1下安装了 Oracle 9.2.0, 无法运行图形管理界面。
- 哪有Linux下载Oracle站点
- 我想在Oracle查找擅自修改数据内容,该怎么办?
- 急!
- 那位高手解释一下在oracle中设计表的,时候为什么oracle公司不提供自动增长的功能的好处是什么?如果在设计的表的如何设置主关键键字(id)
- 求助:如何用表A某一行数据更新表B某一行数据
- oracle密码到期,会导致sqluld2无法导出数据么?
- 关于筛选每天距八点时间最近数据的问题
- RMAN的问题,control文件没备份,该如何办?急
- 请教大家关于rman的问题(键入rman后没有反应)
http://www.oradb.net/err/error_008.htm