ORA-16433: The database must be opened in read/write mode
来源:互联网 发布:ubuntu邮件服务器 编辑:程序博客网 时间:2024/05/16 14:32
SQL> startup force;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> @$HOME/recctl_orcl3.sql
CREATE CONTROLFILE REUSE DATABASE "ORCL2" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01100: database already mounted
SQL> startup force nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
SQL> @$HOME/recctl_orcl3.sql
Control file created.
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;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00279: change 104646296 generated at 03/13/2017 01:04:21 needed for thread
1
ORA-00289: suggestion :
/home/oracle/app/oracle/fast_recovery_area1/ORCL2/log_archive_dest/1_1_938480657
.dbf
ORA-00280: change 104646296 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/home/oracle/app/oracle/oradata/orcl2/redo01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> @$HOME/recctl_orcl3.sql
CREATE CONTROLFILE REUSE DATABASE "ORCL2" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01100: database already mounted
SQL> startup force nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
SQL> @$HOME/recctl_orcl3.sql
Control file created.
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;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00279: change 104646296 generated at 03/13/2017 01:04:21 needed for thread
1
ORA-00289: suggestion :
/home/oracle/app/oracle/fast_recovery_area1/ORCL2/log_archive_dest/1_1_938480657
.dbf
ORA-00280: change 104646296 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/home/oracle/app/oracle/oradata/orcl2/redo01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>
0 0
- ORA-16433: The database must be opened in read/write mode
- Mysql ./ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700:DATABASE MUST BE OPENED WITH UPGRADE OPTION
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700:DATABASE MUST BE OPENED WITH UPGRADE OPTION
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700:database must be opened with UPGRADE option
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700: database must be opened with UPGRADE option
- not an error (code 0): Could not open the database in read/write mode.的解决办法
- SQLiteException: not an error (code 0): Could not open the database in read/write mode
- ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
- ORACLE11.2.0.4 版本升级ORA-39700: database must be opened with UPGRADE option问题解决记录
- powerdesigner打开某个pdm,提示”the model will be opened in read-only mode“,导致对pdm修改的时候保存不上,
- 290. Word Pattern
- 我的杭电oj之旅——1003
- android7.0新特性--Android for Work
- ubuntu14安装火狐浏览器(firefox)中国版
- 分布式应用程序结构简单理解
- ORA-16433: The database must be opened in read/write mode
- Ajax的基本理解
- 字符串算式计算简化--python学习eval()
- Java中For-Each循环的使用
- Spring发展过程中的主要阶段
- 继承与多态,动态绑定,final,abstract
- Code for Anomaly Detection
- 常用汇编寄存器
- android studio install windows