How to alter Database add Logfile correctly

 

Add a New Logfile Member

SQL> alter database add logfile '+DATA' to group 1;
alter database add logfile '+DATA/tansid_p2/redo01a.log' to group 1
                                                       *
ERROR at line 1:
ORA-00933: SQL command not properly ended


Error happened because missed MEMBER keyword.

SQL> alter database add logfile member '+DATA/TANSID_P2/redo01a.log','+DATA/TANSID_P2/redo01b.log' to group 1;

Database altered.

Multiple logfiles are allowable to be added in one statement as long as you use comma to delimit them.

Create a New Logfile Group

Need to specify THREAD then GROUP, logfile member follows.

SQL> alter database add logfile thread 1 group 5 ('+DATA/TANSID_P2/redo05a.log','+DATA/TANSID_p2/redo05b.log') size 10m;

Database altered.

SQL> alter database add logfile thread 2 group 6 ('+DATA/TANSID_p2/redo06a.log','+DATA/TANSID_p2/redo06b.log') size 10m;

Database altered.

Create a Standby Redo Log

alter database add standby logfile thread 1 group 13 '+DATA' size 200m;
alter database add standby logfile thread 1 group 14 '+DATA' size 200M;
alter database add standby logfile thread 2 group 15 '+DATA' size 200M;
alter database add standby logfile thread 2 group 16 '+DATA' size 200M ;
alter database add standby logfile thread 1 group 17 '+DATA' size 200M ;
alter database add standby logfile thread 2 group 18 '+DATA' size 200M ;
alter database add standby logfile thread 1 group 19 '+DATA' size 200M ;
alter database add standby logfile thread 2 group 20 '+DATA' size 200M ;


Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

PRVG-11250 : The check "RPM Package Manager database" was not performed because

ORA-00257:archiver error, connect internal only until freed

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

How to write to a CSV file using Oracle SQL*Plus

How to set up the Oracle Wallets in Oracle Database 19C

How to troubleshoot Long Running Concurrent Request in EBS 12.2

CPU Patch Analysis