*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\SYSTEM01.DBF'
SQL> select open_mode from v$database;
OPEN_MODE
------------------------------
MOUNTED
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL>
SQL>
SQL>
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
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: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\SYSTEM01.DBF'
SQL>
SQL>
SQL>
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount:
SP2-0714: invalid combination of STARTUP options
SQL>
SQL>
SQL>
SQL> startup mount;
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter databse open resetlogs;
alter databse open resetlogs
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter database open resetlogs
2 /
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\SYSTEM01.DBF'
SQL>
SQL>
SQL>
SQL> startup mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL>
SQL>
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL>
SQL>
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1507588748 generated at 10/10/2019 08:43:46 needed for thread
1
ORA-00289: suggestion :
E:\ORACLE\PRODUCT\10.2.0\DB_2\FLASH_RECOVERY_AREA\PHARMA\ARCHIVELOG\2019_10_10\
1_MF_1_1060_%U_.ARC
ORA-00280: change 1507588748 for thread 1 is in sequence #1060
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'E:\ORACLE\PRODUCT\10.2.0\DB_2\FLASH_RECOVERY_AREA\PHARMA\ARCHIVELOG\2019_10_10
O1_MF_1_1060_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\SYSTEM01.DBF'
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: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\SYSTEM01.DBF'
SQL> select instance_name, status from v$instance;
INSTANCE_NAME
------------------------------------------------
STATUS
------------------------------------
pharma
MOUNTED
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL>
SQL>
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL> startup nomount
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL>
SQL>
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS 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: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\SYSTEM01.DBF'
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
///
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\DKS-USER>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 10 10:50:01 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PHARMA (DBID=4176128437, not open)
RMAN> recover database;
Starting recover at 10-OCT-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
starting media recovery
archive log thread 1 sequence 1060 is already on disk as file E:\ORACLE\PRODUCT\
10.2.0\ORADATA\PHARMA\REDO03.LOG
archive log thread 1 sequence 1061 is already on disk as file E:\ORACLE\PRODUCT\
10.2.0\ORADATA\PHARMA\REDO01.LOG
archive log filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\REDO03.LOG thread=1
sequence=1060
archive log filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\PHARMA\REDO01.LOG thread=1
sequence=1061
media recovery complete, elapsed time: 00:00:02
Finished recover at 10-OCT-19
RMAN> exit
Recovery Manager complete.
C:\Users\DKS-USER>sqlplus / as sysdba
C:\Users\DKS-USER>sqlplus / as sysdba
C:\Users\DKS-USER>sqlplus
C:\Users\DKS-USER>sqlplus
C:\Users\DKS-USER>
C:\Users\DKS-USER>sqlplus / as sysdba
C:\Users\DKS-USER>sqlplus / as sysdba
C:\Users\DKS-USER>sqlplus
C:\Users\DKS-USER>sqlplus
^C
///
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 10 10:55:05 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> ALTER DATABASE OPEN RESETLOGS;
Database altered.
SQL> conn jpldba/j@pharma
Connected.
SQL>
SQL>
SQL>
http://jnmurthy.blogspot.com/2017/11/ora-01589-must-use-resetlogs-or.html
No comments:
Post a Comment