Tuesday, September 25, 2018

rman er2

unable to find archived log

archived log thread=1 sequence=96664

released channel: c1

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

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

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

RMAN-03002: failure of recover command at 02/27/2018 08:52:07

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

 

 

backup piece

backupset

 

 

select recid, stamp, sequence#, name from v$archived_log;

 

 

select recid, stamp, sequence#, name from v$archived_log where SEQUENCE#='96664';

 

restore archivelog sequence ='96664';

 

RESTORE ARCHIVELOG FROM SEQUENCE 96664 UNTIL cancel;

 

 

 

 

 

RMAN> alter database open resetlogs;

 

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

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

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

RMAN-03002: failure of alter db command at 02/27/2018 10:31:31

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

 

 

ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/GSTDB/app/hrist/archivelogs/control.sql' resetlogs ;

@/GSTDB/app/hrist/archivelogs/control.sql

 

 

 

RMAN> exit

 

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows

ORACLE error from target database:

ORA-03135: connection lost contact

Process ID: 24868

Session ID: 191 Serial number: 145

 

 

 

 

 

 

No comments:

Post a Comment

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files. I got the issue below wh...