Wednesday, February 3, 2021

ORA-12203: TNS:unable to connect to destination

 


*
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
By at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...