Thursday, December 19, 2019

How to connect to a target oracle database without using a tnsnames.ora file

You are on a desktop and have say, oracle instantclient_18_5

Now, you are required to connect to a remote desktop

A)

One way is You can do with following syntax:-

sqlplus sys@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TARGET_IP_OR_HOSTNAME)(Port=1521))(CONNECT_DATA=(SID=TARGET_SID))) as sysdba


D:\ORACLE_SW\instantclient_18_5>sqlplus sys@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.27.72.160)(Port=1521))(CONNECT_DATA=(SID=ORCLTEST))) as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Dec 20 12:26:45 2019
Version 18.5.0.0.0

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

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SP2-0310: unable to open file "LOGIN.SQL"
SQL>



Now, you are connected to the Target Oracle Database


B) The other way is copy a sample tnsnames.ora file


ORCLTEST=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.27.72.160)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcltest)
    )
  )



C) Using SQL developer, just run the .sql file (complete path)


From the query builder, just execute, something like this :-

@D:\ADWC_share\instantclient_18_5\dbinfo.sql

Convert an Oracle database from READ-ONLY MODE to READ-WRITE MODE


Convert an oracle database from READ-ONLY MODE to READ-WRITE MODE

--------------------------------------------------------------------
A look into the trial and error we obtained while trying to open the database from READ-ONLY mode to READ-WRITE MODE

SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 2421825536 bytes
Fixed Size                  2230752 bytes
Variable Size             587204128 bytes
Database Buffers         1828716544 bytes
Redo Buffers                3674112 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> set serveroutput on
declare
v_return boolean;
begin
v_return:= dbms_tdb.check_db('Microsoft Windows x86 64-bit');
end;
/SQL>   2    3    4    5    6

PL/SQL procedure successfully completed.

SQL> declare
v_return boolean;
begin
v_return:= dbms_tdb.check_external;
end;
/
  2    3    4    5    6  The following external tables exist in the database:
SH.SALES_TRANSACTIONS_EXT
The following directories exist in the database:
SYS.SUBDIR, SYS.SS_OE_XMLDIR, SYS.TMP_DIR, SYS.MEDIA_DIR, SYS.LOG_FILE_DIR,
SYS.DATA_FILE_DIR, SYS.XMLDIR, SYS.DATA_PUMP_DIR, SYS.ORACLE_OCM_CONFIG_DIR
The following BFILEs exist in the database:
PM.PRINT_MEDIA

PL/SQL procedure successfully completed.

SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance


SQL> alter database open read write;
alter database open read write
*
ERROR at line 1:
ORA-01531: a database already open by the instance


SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter database  read write;
alter database  read write
                     *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL>



SQL> shu abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2421825536 bytes
Fixed Size                  2230752 bytes
Variable Size             587204128 bytes
Database Buffers         1828716544 bytes
Redo Buffers                3674112 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL>

Tuesday, December 10, 2019

Check the status of an Import Job


While Importing a job, if we want to check the status of the Import job we will have to follow below

Get the name of the job from the import log file
------------------------------------------------------
;;;
Import: Release 12.2.0.1.0 - Production on Tue Dec 10 11:04:29 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  /******** AS SYSDBA directory=e_dump dumpfile=CLOUD.DMP logfile=imp_test.log full=y


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

Execute the following, to know the details of the Import Job

C:\Users\Administrator>impdp attach=SYS_IMPORT_FULL_01

Import: Release 12.2.0.1.0 - Production on Mon Dec 9 21:39:02 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production

Job: SYS_IMPORT_FULL_01
  Owner: SYS
  Operation: IMPORT
  Creator Privs: TRUE
  GUID: 47827DEC7C844D00874BD53C0EE3F22A
  Start Time: Tuesday, 10 December, 2019 11:04:41
  Mode: FULL
  Instance: orcllrde
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 26
  Endianness: LITTLE
  NLS character set: WE8MSWIN1252
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        /******** AS SYSDBA directory=data_pump_dir logfile=c
loud.log dumpfile=cloud.dmp schemas=ipms,prod,ebms,hr,ibms,coq
     TRACE                 0
  IMPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        /******** AS SYSDBA directory=e_dump dumpfile=CLOUD.D
MP logfile=imp_test.log full=y
     TRACE                 0
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 1
  Dump File: E:\dump\CLOUD.DMP

Worker 1 Status:
  Instance ID: 1
  Instance name: orcllrde
  Host name: WIN-L138RQ35J62
  Object start time: Monday, 09 December, 2019 21:39:05
  Object status at: Monday, 09 December, 2019 21:39:05
  Process Name: DW00
  State: EXECUTING
  Object Schema: IPMS
  Object Name: TDSCHARGESLINE
  Object Type: SCHEMA_EXPORT/TABLE/TABLE
  Completed Objects: 1,488
  Worker Parallelism: 1

Import>

ARC1: All Archive destinations made inactive due to error 742

During the datapump import job in the database, got an error in alert log

Issue :-

1. Check the alert log:

2019-12-10T02:20:21.150375-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 202468352 bytes disk space from 10009706496 bytes limit
ARC1: Error 19809 Creating archive log file to 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_%U_.ARC'
2019-12-10T02:20:21.416377-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 10009706496 bytes is 100.00% used, and has 0 remaining bytes available.
2019-12-10T02:20:21.416377-08:00

2.
There is no space in db_recovery_file_dest_size. He cannot extend it more as he has already extended it.

RMAN>select * from v$flash_recovery_area_usage;

RMAN>crosscheck archivelog all;

RMAN>delete expired archivelog all;

RMAN> list expired archivelog all;

RMAN>DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';

RMAN> delete archivelog all;

3. Check the alert log

2019-12-10T02:20:21.416377-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 202476032 bytes disk space from 10009706496 bytes limit
ARC2: Error 19809 Creating archive log file to 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_52_%U_.ARC'
2019-12-10T02:20:25.759706-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T02:20:25.759706-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWC5F0_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWC5F0_.ARC
2019-12-10T02:20:26.322995-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T02:20:41.166087-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T02:20:41.166087-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWCBHY_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWCBHY_.ARC
2019-12-10T02:20:44.541408-08:00

4.
Clear the redo log files having issue due to power failure or unclean shutdown of database

SQL> SELECT * FROM V$LOG;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID
---------------- ------------- --------- ------------ --------- ----------
         1          1         61  209715200        512          1 YES
ACTIVE                 1691153 10-DEC-19      1711124 10-DEC-19          0

         2          1         62  209715200        512          1 NO
CURRENT                1711124 10-DEC-19   1.8447E+19                    0

         3          1         24  209715200        512          1 NO
INACTIVE               1650895 09-DEC-19      1651256 09-DEC-19          0


SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

Database altered.

SQL> SELECT * FROM V$LOG;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID
---------------- ------------- --------- ------------ --------- ----------
         1          1          0  209715200        512          1 YES
UNUSED                 1691153 10-DEC-19      1711124 10-DEC-19          0

         2          1         62  209715200        512          1 NO
CURRENT                1711124 10-DEC-19   1.8447E+19                    0

         3          1         24  209715200        512          1 NO
INACTIVE               1650895 09-DEC-19      1651256 09-DEC-19          0


SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;

Database altered.

SQL> SELECT * FROM V$LOG;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID
---------------- ------------- --------- ------------ --------- ----------
         1          1         63  209715200        512          1 NO
CURRENT                1720939 10-DEC-19   1.8447E+19                    0

         2          1          0  209715200        512          1 YES
UNUSED                 1711124 10-DEC-19      1720939 10-DEC-19          0

         3          1         24  209715200        512          1 NO
INACTIVE               1650895 09-DEC-19      1651256 09-DEC-19          0


SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Database altered.

SQL> SELECT * FROM V$LOG;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID
---------------- ------------- --------- ------------ --------- ----------
         1          1         63  209715200        512          1 YES
INACTIVE               1720939 10-DEC-19      1721180 10-DEC-19          0

         2          1         64  209715200        512          1 NO
ACTIVE                 1721180 10-DEC-19      1722867 10-DEC-19          0

         3          1         65  209715200        512          1 NO
CURRENT                1722867 10-DEC-19   1.8447E+19                    0


SQL>



5.

The alert log files showed this

ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8KXM_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8KXM_.ARC
2019-12-10T03:10:18.432542-08:00
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
2019-12-10T03:10:27.775964-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:27.775964-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8RHG_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8RHG_.ARC
2019-12-10T03:10:28.213479-08:00
Clearing online log 1 of thread 1 sequence number 61
2019-12-10T03:10:41.417428-08:00
Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
2019-12-10T03:10:44.573227-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:44.573227-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ96MW_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ96MW_.ARC
2019-12-10T03:10:45.088707-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T03:10:49.697689-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:49.697689-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9OHG_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9OHG_.ARC
2019-12-10T03:10:53.854743-08:00
Thread 1 cannot allocate new log, sequence 63
Private strand flush not complete
  Current log# 2 seq# 62 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO02.LOG
2019-12-10T03:10:56.838529-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:56.838529-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9TQR_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9TQR_.ARC
2019-12-10T03:10:57.353847-08:00
Thread 1 advanced to log sequence 63 (LGWR switch)
  Current log# 1 seq# 63 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO01.LOG
2019-12-10T03:11:09.745125-08:00
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2
2019-12-10T03:11:10.198201-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:10.198201-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZB20B_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZB20B_.ARC
2019-12-10T03:11:19.400551-08:00
WARNING! CLEARING REDO LOG WHICH HAS NOT BEEN ARCHIVED. BACKUPS TAKEN
    BEFORE 12/10/2019 03:10:57 (CHANGE 1720939) CANNOT BE USED FOR RECOVERY.
Clearing online log 2 of thread 1 sequence number 62
2019-12-10T03:11:22.369535-08:00
ARC2: Log 2 mismatch, expected sequence 62 found T-1.S-0
2019-12-10T03:11:25.291800-08:00
Resize operation completed for file# 9, old size 13915072K, new size 13980608K
2019-12-10T03:11:27.197839-08:00
Resize operation completed for file# 201, old size 110592K, new size 111616K
2019-12-10T03:11:34.729530-08:00
Resize operation completed for file# 201, old size 111616K, new size 112640K
2019-12-10T03:11:38.056820-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:38.056820-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZBRF1_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZBRF1_.ARC
2019-12-10T03:11:38.510755-08:00
Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2
2019-12-10T03:11:38.525518-08:00
Resize operation completed for file# 201, old size 112640K, new size 113664K
2019-12-10T03:11:39.229419-08:00
Resize operation completed for file# 9, old size 13980608K, new size 14046144K
2019-12-10T03:11:42.432593-08:00
Resize operation completed for file# 9, old size 14046144K, new size 14111680K
2019-12-10T03:11:44.713119-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:44.713119-08:00
ARC2: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCC9M_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCC9M_.ARC
2019-12-10T03:11:45.777131-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T03:11:52.135063-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:52.135063-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCL8M_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCL8M_.ARC
2019-12-10T03:11:57.978651-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:57.978651-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCSLD_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCSLD_.ARC
2019-12-10T03:12:02.932461-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:02.932461-08:00
ARC2: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCZ5P_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCZ5P_.ARC
2019-12-10T03:12:11.088332-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:11.088332-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZD47O_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZD47O_.ARC
2019-12-10T03:12:17.620212-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:17.620212-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDD09_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDD09_.ARC
2019-12-10T03:12:26.963343-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:26.963343-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDMPB_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDMPB_.ARC
2019-12-10T03:12:34.713728-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:34.713728-08:00
ARC2: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDWDK_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDWDK_.ARC
2019-12-10T03:12:39.463415-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:39.463415-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF35O_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF35O_.ARC
2019-12-10T03:12:46.713674-08:00
Thread 1 advanced to log sequence 64 (LGWR switch)
  Current log# 2 seq# 64 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO02.LOG
2019-12-10T03:12:47.619886-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:47.619886-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF85P_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF85P_.ARC
2019-12-10T03:12:47.948187-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T03:13:04.510268-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:13:04.510268-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZFSG0_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZFSG0_.ARC
2019-12-10T03:13:10.619983-08:00
Archived Log entry 62 added for T-1.S-63 ID 0x3339731c LAD:1
2019-12-10T03:13:17.556869-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:13:17.556869-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZG6WN_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZG6WN_.ARC
2019-12-10T03:13:18.447372-08:00
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3
2019-12-10T03:13:23.291905-08:00
WARNING! CLEARING REDO LOG WHICH HAS NOT BEEN ARCHIVED. BACKUPS TAKEN
    BEFORE 12/09/2019 21:55:07 (CHANGE 1651256) CANNOT BE USED FOR RECOVERY.
Clearing online log 3 of thread 1 sequence number 24
2019-12-10T03:13:25.416820-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:13:25.416820-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZGG56_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZGG56_.ARC
ARC3: Log 3 mismatch, expected sequence 24 found T-1.S-0
2019-12-10T03:13:42.182171-08:00
Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3
2019-12-10T03:13:48.104281-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
krsd_check_stuck_arch: stuck archiver condition cleared
2019-12-10T03:13:57.198035-08:00
Thread 1 advanced to log sequence 65 (LGWR switch)
  Current log# 3 seq# 65 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG
2019-12-10T03:14:14.385493-08:00
Archived Log entry 64 added for T-1.S-64 ID 0x3339731c LAD:1
2019-12-10T03:16:30.276361-08:00
Thread 1 advanced to log sequence 66 (LGWR switch)
  Current log# 1 seq# 66 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO01.LOG
2019-12-10T03:16:49.463925-08:00
Archived Log entry 65 added for T-1.S-65 ID 0x3339731c LAD:1
2019-12-10T03:16:52.510273-08:00
Resize operation completed for file# 9, old size 14111680K, new size 14119872K
2019-12-10T03:16:53.619613-08:00
Resize operation completed for file# 9, old size 14119872K, new size 14185408K
2019-12-10T03:16:54.886085-08:00
Resize operation completed for file# 9, old size 14185408K, new size 14250944K
2019-12-10T03:16:56.275849-08:00
Resize operation completed for file# 9, old size 14250944K, new size 14316480K
2019-12-10T03:16:57.635433-08:00
Resize operation completed for file# 9, old size 14316480K, new size 14382016K
2019-12-10T03:16:58.713797-08:00
Resize operation completed for file# 9, old size 14382016K, new size 14447552K
2019-12-10T03:17:00.400782-08:00
Resize operation completed for file# 9, old size 14447552K, new size 14513088K
2019-12-10T03:17:01.824416-08:00
Resize operation completed for file# 9, old size 14513088K, new size 14578624K
2019-12-10T03:17:03.306924-08:00
Resize operation completed for file# 9, old size 14578624K, new size 14644160K
Resize operation completed for file# 9, old size 14644160K, new size 14709696K
2019-12-10T03:17:05.494588-08:00
Resize operation completed for file# 9, old size 14709696K, new size 14775232K
2019-12-10T03:17:06.635738-08:00
Resize operation completed for file# 9, old size 14775232K, new size 14840768K
2019-12-10T03:17:20.182022-08:00
Starting control autobackup

2019-12-10T03:17:24.744426-08:00
Control autobackup written to DISK device

handle 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\AUTOBACKUP\2019_12_10\O1_MF_S_1026616640_GYYZP3R8_.BKP'

2019-12-10T03:17:46.166232-08:00
Thread 1 advanced to log sequence 67 (LGWR switch)
  Current log# 2 seq# 67 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO02.LOG
2019-12-10T03:17:47.229675-08:00
The value (163) of MAXTRANS parameter ignored.
The value (163) of MAXTRANS parameter ignored.
2019-12-10T03:17:57.745105-08:00
Archived Log entry 66 added for T-1.S-66 ID 0x3339731c LAD:1
2019-12-10T03:18:41.073644-08:00
Resize operation completed for file# 201, old size 113664K, new size 114688K
Resize operation completed for file# 201, old size 114688K, new size 115712K
Resize operation completed for file# 201, old size 115712K, new size 116736K
Resize operation completed for file# 201, old size 116736K, new size 117760K
Resize operation completed for file# 201, old size 117760K, new size 118784K
Resize operation completed for file# 201, old size 118784K, new size 119808K
Resize operation completed for file# 201, old size 119808K, new size 120832K
Resize operation completed for file# 201, old size 120832K, new size 121856K
Resize operation completed for file# 201, old size 121856K, new size 122880K
2019-12-10T03:18:42.197839-08:00
Resize operation completed for file# 201, old size 122880K, new size 123904K
Resize operation completed for file# 201, old size 123904K, new size 124928K
Resize operation completed for file# 201, old size 124928K, new size 125952K
Resize operation completed for file# 201, old size 125952K, new size 126976K
Resize operation completed for file# 201, old size 126976K, new size 128000K
Resize operation completed for file# 201, old size 128000K, new size 129024K
Resize operation completed for file# 201, old size 129024K, new size 130048K
Resize operation completed for file# 201, old size 130048K, new size 131072K
Resize operation completed for file# 201, old size 131072K, new size 132096K
Resize operation completed for file# 201, old size 132096K, new size 133120K
Resize operation completed for file# 201, old size 133120K, new size 134144K
Resize operation completed for file# 201, old size 134144K, new size 135168K
Resize operation completed for file# 201, old size 135168K, new size 136192K
Resize operation completed for file# 201, old size 136192K, new size 137216K
2019-12-10T03:18:43.307514-08:00
Resize operation completed for file# 201, old size 137216K, new size 138240K
Resize operation completed for file# 201, old size 138240K, new size 139264K
Resize operation completed for file# 201, old size 139264K, new size 140288K
Resize operation completed for file# 201, old size 140288K, new size 141312K
Resize operation completed for file# 201, old size 141312K, new size 142336K
Resize operation completed for file# 201, old size 142336K, new size 143360K
2019-12-10T03:18:44.338653-08:00
Resize operation completed for file# 201, old size 143360K, new size 144384K
Resize operation completed for file# 201, old size 144384K, new size 145408K
Resize operation completed for file# 201, old size 145408K, new size 146432K
Resize operation completed for file# 201, old size 146432K, new size 147456K
Resize operation completed for file# 201, old size 147456K, new size 148480K
Resize operation completed for file# 201, old size 148480K, new size 149504K
Resize operation completed for file# 201, old size 149504K, new size 150528K
Resize operation completed for file# 201, old size 150528K, new size 151552K
Resize operation completed for file# 201, old size 151552K, new size 152576K
Resize operation completed for file# 201, old size 152576K, new size 153600K
Resize operation completed for file# 201, old size 153600K, new size 154624K
Resize operation completed for file# 201, old size 154624K, new size 155648K
2019-12-10T03:18:46.870284-08:00
Thread 1 advanced to log sequence 68 (LGWR switch)
  Current log# 3 seq# 68 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG
2019-12-10T03:19:00.353989-08:00
Archived Log entry 67 added for T-1.S-67 ID 0x3339731c LAD:1
2019-12-10T03:19:22.354183-08:00
Resize operation completed for file# 201, old size 155648K, new size 156672K
Resize operation completed for file# 201, old size 156672K, new size 157696K
Resize operation completed for file# 201, old size 157696K, new size 158720K
Resize operation completed for file# 201, old size 158720K, new size 159744K
Resize operation completed for file# 201, old size 159744K, new size 160768K
Resize operation completed for file# 201, old size 160768K, new size 161792K
Resize operation completed for file# 201, old size 161792K, new size 162816K
Resize operation completed for file# 201, old size 162816K, new size 163840K
Resize operation completed for file# 201, old size 163840K, new size 164864K
Resize operation completed for file# 201, old size 164864K, new size 165888K
Resize operation completed for file# 201, old size 165888K, new size 166912K
Resize operation completed for file# 201, old size 166912K, new size 167936K
Resize operation completed for file# 201, old size 167936K, new size 168960K
Resize operation completed for file# 201, old size 168960K, new size 169984K
Resize operation completed for file# 201, old size 169984K, new size 171008K
Resize operation completed for file# 201, old size 171008K, new size 172032K
Resize operation completed for file# 201, old size 172032K, new size 173056K
Resize operation completed for file# 201, old size 173056K, new size 174080K
Resize operation completed for file# 201, old size 174080K, new size 175104K
Resize operation completed for file# 201, old size 175104K, new size 176128K
Resize operation completed for file# 201, old size 176128K, new size 177152K
2019-12-10T03:19:23.385545-08:00
Resize operation completed for file# 201, old size 177152K, new size 178176K
Resize operation completed for file# 201, old size 178176K, new size 179200K
Resize operation completed for file# 201, old size 179200K, new size 180224K
Resize operation completed for file# 201, old size 180224K, new size 181248K
Resize operation completed for file# 201, old size 181248K, new size 182272K
Resize operation completed for file# 201, old size 182272K, new size 183296K
2019-12-10T03:19:27.307488-08:00
Resize operation completed for file# 201, old size 183296K, new size 184320K
Resize operation completed for file# 201, old size 184320K, new size 185344K
Resize operation completed for file# 201, old size 185344K, new size 186368K
Resize operation completed for file# 201, old size 186368K, new size 187392K
Resize operation completed for file# 201, old size 187392K, new size 188416K
Resize operation completed for file# 201, old size 188416K, new size 189440K
Resize operation completed for file# 201, old size 189440K, new size 190464K
Resize operation completed for file# 201, old size 190464K, new size 191488K
Resize operation completed for file# 201, old size 191488K, new size 192512K
Resize operation completed for file# 201, old size 192512K, new size 193536K
Resize operation completed for file# 201, old size 193536K, new size 194560K
Resize operation completed for file# 201, old size 194560K, new size 195584K
Resize operation completed for file# 201, old size 195584K, new size 196608K
Resize operation completed for file# 201, old size 196608K, new size 197632K
Resize operation completed for file# 201, old size 197632K, new size 198656K
Resize operation completed for file# 201, old size 198656K, new size 199680K
Resize operation completed for file# 201, old size 199680K, new size 200704K
Resize operation completed for file# 201, old size 200704K, new size 201728K
Resize operation completed for file# 201, old size 201728K, new size 202752K
Resize operation completed for file# 201, old size 202752K, new size 203776K
Resize operation completed for file# 201, old size 203776K, new size 204800K
Resize operation completed for file# 201, old size 204800K, new size 205824K
Resize operation completed for file# 201, old size 205824K, new size 206848K
Resize operation completed for file# 201, old size 206848K, new size 207872K
Resize operation completed for file# 201, old size 207872K, new size 208896K
2019-12-10T03:19:28.369410-08:00
Resize operation completed for file# 201, old size 208896K, new size 209920K
Resize operation completed for file# 201, old size 209920K, new size 210944K
Resize operation completed for file# 201, old size 210944K, new size 211968K
Resize operation completed for file# 201, old size 211968K, new size 212992K
Resize operation completed for file# 201, old size 212992K, new size 214016K
Resize operation completed for file# 201, old size 214016K, new size 215040K
Resize operation completed for file# 201, old size 215040K, new size 216064K
Resize operation completed for file# 201, old size 216064K, new size 217088K
Resize operation completed for file# 201, old size 217088K, new size 218112K
Resize operation completed for file# 201, old size 218112K, new size 219136K
Resize operation completed for file# 201, old size 219136K, new size 220160K
Resize operation completed for file# 201, old size 220160K, new size 221184K
Resize operation completed for file# 201, old size 221184K, new size 222208K
Resize operation completed for file# 201, old size 222208K, new size 223232K
Resize operation completed for file# 201, old size 223232K, new size 224256K
Resize operation completed for file# 201, old size 224256K, new size 225280K
Resize operation completed for file# 201, old size 225280K, new size 226304K
Resize operation completed for file# 201, old size 226304K, new size 227328K
Resize operation completed for file# 201, old size 227328K, new size 228352K
Resize operation completed for file# 201, old size 228352K, new size 229376K
Resize operation completed for file# 201, old size 229376K, new size 230400K
Resize operation completed for file# 201, old size 230400K, new size 231424K
Resize operation completed for file# 201, old size 231424K, new size 232448K
Resize operation completed for file# 201, old size 232448K, new size 233472K
Resize operation completed for file# 201, old size 233472K, new size 234496K
Resize operation completed for file# 201, old size 234496K, new size 235520K
Resize operation completed for file# 201, old size 235520K, new size 236544K
Resize operation completed for file# 201, old size 236544K, new size 237568K
Resize operation completed for file# 201, old size 237568K, new size 238592K
Resize operation completed for file# 201, old size 238592K, new size 239616K
Resize operation completed for file# 201, old size 239616K, new size 240640K
Resize operation completed for file# 201, old size 240640K, new size 241664K
Resize operation completed for file# 201, old size 241664K, new size 242688K
Resize operation completed for file# 201, old size 242688K, new size 243712K
Resize operation completed for file# 201, old size 243712K, new size 244736K
Resize operation completed for file# 201, old size 244736K, new size 245760K
Resize operation completed for file# 201, old size 245760K, new size 246784K
Resize operation completed for file# 201, old size 246784K, new size 247808K
2019-12-10T03:19:29.384977-08:00
Resize operation completed for file# 201, old size 247808K, new size 248832K
Resize operation completed for file# 201, old size 248832K, new size 249856K
Resize operation completed for file# 201, old size 249856K, new size 250880K
Resize operation completed for file# 201, old size 250880K, new size 251904K
Resize operation completed for file# 201, old size 251904K, new size 252928K
Resize operation completed for file# 201, old size 252928K, new size 253952K
Resize operation completed for file# 201, old size 253952K, new size 254976K
Resize operation completed for file# 201, old size 254976K, new size 256000K
Resize operation completed for file# 201, old size 256000K, new size 257024K
Resize operation completed for file# 201, old size 257024K, new size 258048K
Resize operation completed for file# 201, old size 258048K, new size 259072K
Resize operation completed for file# 201, old size 259072K, new size 260096K
Resize operation completed for file# 201, old size 260096K, new size 261120K
2019-12-10T03:19:33.338869-08:00
Resize operation completed for file# 201, old size 261120K, new size 262144K
Resize operation completed for file# 201, old size 262144K, new size 263168K
Resize operation completed for file# 201, old size 263168K, new size 264192K
Resize operation completed for file# 201, old size 264192K, new size 265216K
Resize operation completed for file# 201, old size 265216K, new size 266240K
Resize operation completed for file# 201, old size 266240K, new size 267264K
Resize operation completed for file# 201, old size 267264K, new size 268288K
Resize operation completed for file# 201, old size 268288K, new size 269312K
Resize operation completed for file# 201, old size 269312K, new size 270336K
2019-12-10T03:19:34.400918-08:00
Resize operation completed for file# 201, old size 270336K, new size 271360K
Resize operation completed for file# 201, old size 271360K, new size 272384K
Resize operation completed for file# 201, old size 272384K, new size 273408K
Resize operation completed for file# 201, old size 273408K, new size 274432K
Resize operation completed for file# 201, old size 274432K, new size 275456K
Resize operation completed for file# 201, old size 275456K, new size 276480K
Resize operation completed for file# 201, old size 276480K, new size 277504K
2019-12-10T03:19:35.401399-08:00
Resize operation completed for file# 201, old size 277504K, new size 278528K
Resize operation completed for file# 201, old size 278528K, new size 279552K
Resize operation completed for file# 201, old size 279552K, new size 280576K
Resize operation completed for file# 201, old size 280576K, new size 281600K
Resize operation completed for file# 201, old size 281600K, new size 282624K
Resize operation completed for file# 201, old size 282624K, new size 283648K
Resize operation completed for file# 201, old size 283648K, new size 284672K
Resize operation completed for file# 201, old size 284672K, new size 285696K
Resize operation completed for file# 201, old size 285696K, new size 286720K
Resize operation completed for file# 201, old size 286720K, new size 287744K
Resize operation completed for file# 201, old size 287744K, new size 288768K
Resize operation completed for file# 201, old size 288768K, new size 289792K
Resize operation completed for file# 201, old size 289792K, new size 290816K
Resize operation completed for file# 201, old size 290816K, new size 291840K
Resize operation completed for file# 201, old size 291840K, new size 292864K
Resize operation completed for file# 201, old size 292864K, new size 293888K
Resize operation completed for file# 201, old size 293888K, new size 294912K
Resize operation completed for file# 201, old size 294912K, new size 295936K
Resize operation completed for file# 201, old size 295936K, new size 296960K
Resize operation completed for file# 201, old size 296960K, new size 297984K
2019-12-10T03:19:36.416795-08:00
Resize operation completed for file# 201, old size 297984K, new size 299008K
Resize operation completed for file# 201, old size 299008K, new size 300032K
Resize operation completed for file# 201, old size 300032K, new size 301056K
Resize operation completed for file# 201, old size 301056K, new size 302080K
Resize operation completed for file# 201, old size 302080K, new size 303104K
Resize operation completed for file# 201, old size 303104K, new size 304128K
Resize operation completed for file# 201, old size 304128K, new size 305152K
Resize operation completed for file# 201, old size 305152K, new size 306176K
Resize operation completed for file# 201, old size 306176K, new size 307200K
Resize operation completed for file# 201, old size 307200K, new size 308224K
Resize operation completed for file# 201, old size 308224K, new size 309248K
Resize operation completed for file# 201, old size 309248K, new size 310272K
Resize operation completed for file# 201, old size 310272K, new size 311296K
Resize operation completed for file# 201, old size 311296K, new size 312320K
Resize operation completed for file# 201, old size 312320K, new size 313344K
Resize operation completed for file# 201, old size 313344K, new size 314368K
Resize operation completed for file# 201, old size 314368K, new size 315392K
Resize operation completed for file# 201, old size 315392K, new size 316416K
Resize operation completed for file# 201, old size 316416K, new size 317440K
Resize operation completed for file# 201, old size 317440K, new size 318464K
Resize operation completed for file# 201, old size 318464K, new size 319488K
Resize operation completed for file# 201, old size 319488K, new size 320512K
Resize operation completed for file# 201, old size 320512K, new size 321536K
Resize operation completed for file# 201, old size 321536K, new size 322560K
Resize operation completed for file# 201, old size 322560K, new size 323584K
Resize operation completed for file# 201, old size 323584K, new size 324608K
Resize operation completed for file# 201, old size 324608K, new size 325632K
Resize operation completed for file# 201, old size 325632K, new size 326656K
Resize operation completed for file# 201, old size 326656K, new size 327680K
2019-12-10T03:19:37.432280-08:00
Resize operation completed for file# 201, old size 327680K, new size 328704K
Resize operation completed for file# 201, old size 328704K, new size 329728K
Resize operation completed for file# 201, old size 329728K, new size 330752K
Resize operation completed for file# 201, old size 330752K, new size 331776K
Resize operation completed for file# 201, old size 331776K, new size 332800K
Resize operation completed for file# 201, old size 332800K, new size 333824K
Resize operation completed for file# 201, old size 333824K, new size 334848K
Resize operation completed for file# 201, old size 334848K, new size 335872K
Resize operation completed for file# 201, old size 335872K, new size 336896K
Resize operation completed for file# 201, old size 336896K, new size 337920K
Resize operation completed for file# 201, old size 337920K, new size 338944K
Resize operation completed for file# 201, old size 338944K, new size 339968K
Resize operation completed for file# 201, old size 339968K, new size 340992K
Resize operation completed for file# 201, old size 340992K, new size 342016K
2019-12-10T03:19:39.541305-08:00
Resize operation completed for file# 9, old size 14840768K, new size 14906304K
2019-12-10T03:19:42.088389-08:00
Resize operation completed for file# 9, old size 14906304K, new size 14971840K
2019-12-10T03:19:45.322521-08:00
Resize operation completed for file# 9, old size 14971840K, new size 15037376K
2019-12-10T03:19:48.151545-08:00
Resize operation completed for file# 9, old size 15037376K, new size 15102912K
2019-12-10T03:19:52.776158-08:00
Resize operation completed for file# 9, old size 15102912K, new size 15168448K
2019-12-10T03:19:56.104915-08:00
Resize operation completed for file# 9, old size 15168448K, new size 15233984K
2019-12-10T03:19:58.682216-08:00
Resize operation completed for file# 9, old size 15233984K, new size 15299520K
2019-12-10T03:20:01.401175-08:00
Resize operation completed for file# 9, old size 15299520K, new size 15365056K
2019-12-10T03:20:04.901382-08:00
Resize operation completed for file# 9, old size 15365056K, new size 15430592K
2019-12-10T03:20:07.074033-08:00
Resize operation completed for file# 9, old size 15430592K, new size 15496128K
2019-12-10T03:20:11.213864-08:00
Resize operation completed for file# 9, old size 15496128K, new size 15561664K
2019-12-10T03:20:14.354094-08:00
Resize operation completed for file# 9, old size 15561664K, new size 15627200K
2019-12-10T03:20:17.791629-08:00
Thread 1 advanced to log sequence 69 (LGWR switch)
  Current log# 1 seq# 69 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO01.LOG
2019-12-10T03:20:18.119626-08:00
Resize operation completed for file# 9, old size 15627200K, new size 15692736K
2019-12-10T03:20:35.088832-08:00
Archived Log entry 68 added for T-1.S-68 ID 0x3339731c LAD:1
2019-12-10T03:20:51.541569-08:00
Resize operation completed for file# 201, old size 342016K, new size 343040K
Resize operation completed for file# 201, old size 343040K, new size 344064K
2019-12-10T03:20:54.072519-08:00

Sunday, December 8, 2019

e2fsck cannot continue aborting

I had added a partition in /etc/fstab and it was not in proper format.

I went to rescue mode as follows

Press "e" when we get the below screen

Press "e" on this line

in this line change "ro" to "rw"
execute the below
mount -o remount,rw /
now, 
#vi /etc/fstab
remove the added line of additional file system
reboot the system
You may watch the video here!

https://youtu.be/7E3ugR445Lk 

Saturday, December 7, 2019

OHUC-1026 Using orahomeuserctl updpwd to Change the Oracle Home Users Password

When you try to reset the ORACLE_HOME password as below you may get the ERROR as 
OHUC-1026 Using orahomeuserctl updpwd to Change the Oracle Home Users Password.

If you're observing this error although you've set ORACLE_HOME properly as below



Then, you may have to check the below settings in your local users and groups in Windows Server

Make sure, user cannot changed the password is unchecked.