Alter Database Add Logfile Correctly
ALTER DATABASE ADD LOGFILE clause has two different functions, one is to add a new member to an existing group, the other is to create… Read More »Alter Database Add Logfile Correctly
ALTER DATABASE ADD LOGFILE MEMBER
How to Resolve ORA-00357: too many members
ORA-00357 Tried to add more redo log member to an existing group, but it failed with ORA-00357. SQL> alter database add logfile member '+DATA/ORCLCDB/redo01g.log' to… Read More »How to Resolve ORA-00357: too many members
How to Move Redo Log Location in Oracle
Rename Redo Log File To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive… Read More »How to Move Redo Log Location in Oracle