rman err3

archived log file name=/GSTDB/orahris/archivelogs/1_96395_906911169.dbf thread=1 sequence=96395

unable to find archived log

archived log thread=1 sequence=96396

released channel: c1

released channel: c2

released channel: c3

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/28/2018 14:21:29

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 96396 and starting SCN of 12402434240750

　

RMAN> alter database open resetlogs;

　

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 02/28/2018 14:23:54

ORA-00349: failure obtaining block size for '/TJTGHRP/app/otjtghrp/oradata/TJTGHRP/redo01.log'

ORA-27041: unable to open file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 9

　

RMAN> exit

　

　

Recovery Manager complete.

[orahris@TJPSB007 rman]$

[orahris@TJPSB007 rman]$ sqlplus / as sysdba

　

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 28 14:24:32 2018

　

Copyright (c) 1982, 2013, Oracle. All rights reserved.

　

　

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

　

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-00392: log 3 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 3 thread 1:

'/TJTGHRP/app/otjtghrp/oradata/TJTGHRP/redo03.log'

　

　

SQL>

SQL> select name from v$logfile;

select name from v$logfile

*

ERROR at line 1:

ORA-00904: "NAME": invalid identifier

　

　

SQL> select member from v$logfile;

　

MEMBER

--------------------------------------------------------------------------------

/TJTGHRP/app/otjtghrp/oradata/TJTGHRP/redo01.log

/TJTGHRP/app/otjtghrp/oradata/TJTGHRP/redo02.log

/TJTGHRP/app/otjtghrp/oradata/TJTGHRP/redo03.log

　

SQL>

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Product ion

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[orahris@TJPSB007 rman]$

[orahris@TJPSB007 rman]$ cd /TJTGHRP/app/otjtghrp/oradata/TJTGHRP/

-bash: cd: /TJTGHRP/app/otjtghrp/oradata/TJTGHRP/: No such file or directory