How to Check Archive Block Size ? To monitor the applying performance of a standby database, we usually make a query on V$MANAGED_STANDBY like this:… Read More »Oracle Archive Block Size
Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How Oracle Restore SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How Oracle Backup SPFILE
ORA-01523 Tried to rename a data file, but it failed with ORA-01523. SQL> alter database rename file '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/data_file_02.dbf' to '/oradata/ORCLCDB/ORCLPDB/data_file_01.dbf'; alter database rename file '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/data_file_02.dbf'… Read More »How to Resolve ORA-01523: cannot rename data file to