On-line migration of Oracle 18c 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 18c Oracle database from an existing storage platform to a new storage array. Prepare ASM... Continue Reading →

Creating new Oracle 18c ASM Disk Groups

Creating New Volumes Create the new ASM volume(s) using your storage platform, for this blog I have created 3 volumes on a Pure FlashArray, simply providing names and sizes. Note the Volume serial numbers,  these will be used in the multipath configuration wwid (World Wide Identifier) SCSI storage device serial numbers are universally unique. Each... 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 ↑

%d bloggers like this: