Friday, April 24, 2015

Add a log file in ASM

ALTER DATABASE ADD LOGFILE Instance 'DHODS1' GROUP 5
 SIZE 4096 M;

This simple commands adds redo log file with 2 members of size 4g. One member is located in a disk group and mirrored in other disk group if you have normal redundancy. No need to specify path. Please verify once done.

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...