Noarchive log mode recovery without backup redo log files

最新推荐文章于 2025-08-08 12:35:56 发布

aicon

最新推荐文章于 2025-08-08 12:35:56 发布

阅读量651

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle EBS Oracle 文章标签： database system archive thread file sql

本文链接：https://blog.youkuaiyun.com/aicon/article/details/4235744

Oracle 同时被 2 个专栏收录

523 篇文章

订阅专栏

Oracle EBS

416 篇文章

订阅专栏

本文展示了如何使用备份的控制文件来恢复Oracle10g数据库，包括数据库挂载、使用备份控制文件进行恢复、打开数据库并重置日志等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle10g->cd /u01/oradata/orcl
oracle10g->ls
control01.ctl demo01.dbf    redo02.log sysaux01.dbf ts_rman.dbf
control02.ctl perfstat.dbf redo03.log system01.dbf undotbs01.dbf
control03.ctl redo01.log    rman01,dbf temp01.dbf    users01.dbf
oracle10g->rm -rf *.dbf
oracle10g->ls
control01.ctl control02.ctl control03.ctl redo01.log redo02.log redo03.log rman01,dbf
oracle10g->rm -rf *.ctl
oracle10g->rm -rf rman01,dbf
oracle10g->ls
redo01.log redo02.log redo03.log
oracle10g->pwd
/u01/oradata/orcl
oracle10g->cd ..
oracle10g->ls
log orcl orclbk
oracle10g->cd orclbk/
oracle10g->ls
control01.ctl demo01.dbf    redo02.log sysaux01.dbf ts_rman.dbf
control02.ctl perfstat.dbf redo03.log system01.dbf undotbs01.dbf
control03.ctl redo01.log    rman01,dbf temp01.dbf    users01.dbf
oracle10g->cp -a *dbf ../orcl/
oracle10g->sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 1 15:36:46 2009

SQL> conn / as sysdba
Connected to an idle instance.
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
ORA-00205: error in identifying control file, check alert log for more info

oracle10g->cd orclbk
oracle10g->ls
control01.ctl demo01.dbf redo02.log sysaux01.dbf ts_rman.dbf
control02.ctl perfstat.dbf redo03.log system01.dbf undotbs01.dbf
control03.ctl redo01.log rman01,dbf temp01.dbf users01.dbf
oracle10g->cp control* ../orcl/

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
-------------------------------- ------------------------
orcl STARTED

SQL> alter database mount;

Database altered.

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1754864 generated at 06/01/2009 04:47:40 needed for thread 1
ORA-00289: suggestion : /u01/oradata/log/1_13_687794642.dbf
ORA-00280: change 1754864 for thread 1 is in sequence #13

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
-------------------------------- ------------------------
orcl OPEN

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/oradata/log
Oldest online log sequence     1
Current log sequence           1
SQL>