On-line migration of Oracle 18c/19c filesystem datafiles to Oracle ASM

Background Prior to Oracle 12c moving non-ASM data files required taking data files ‘offline’ and negotiating an outage with the business, since Oracle 12c this is has no longer been the case. I was recently challenged with moving a good size filesystem 19c Oracle database from an existing storage platform to a new storage array. Prepare ASM... Continue Reading →

Oracle 18c disable / enable Archive Log Mode

Disable Archive Log Mode [oracle@z-fbhost2 ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 - Production on Wed Aug 8 10:17:47 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to an idle instance. # Open database in mount state SQL> startup mount ORACLE instance started. Total System Global Area 1.4227E+11 bytes Fixed... Continue Reading →

Create a website or blog at WordPress.com

Up ↑