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.

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

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

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

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

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

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

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

Change Password in an Oracle Database