What is possible to use this parameter Sometimes you may have your library in an inlet mode, and your online redo log is also currupted, your data file cannot complete complete recovery. And when you try to open the database, Oracle prompts you to use the ResetLogs option, oracle does not allow you to use this option when you use this option, in short, you want to open the database, you can't open.
1, it is best to do the full preparation of a physical library
2, use SQLPLUS boot library to Mount SQLPLUS / NOLOG SQL> Connect Internal SQL> Startup Mount 3, make sure all data files are in "end backup" SQL> SET PAGES 0 feedback off lines 132 SQL> Spool alter_df.sql sql> SELECT 'ALTER DATABASE DATAFILE' || File_name || 'End Backup;' from v $ datafile; sql> spool off sql> @ alter_df.sql 4, try to open the database SQL> ALTER DATABASE OPEN; if the database is successful, the rest You don't need to do it, until 5, if you are required to recover when you open, use "untric Cancel" to recover, then issue the ALTER DATABASE OPEN RESETLOGS this command SQL> Recover Database Until Cancel; SQL> ALTER Database Open ResetLogs; 6, if the database still can't open, drop the library down to SQL> Shutdown Immediate 7, add the following parameters in INIT
