ORA-16433: The database must be opened in readwrite mode

    xiaoxiao2021-03-25  84

    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> 
    转载请注明原文地址: https://ju.6miu.com/read-38270.html

    最新回复(0)