Oracle Archive Block Size
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
File
How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP
RMAN-06509 When we tried to restore a datafile from a backup piece in RMAN, we saw error RMAN-06509. RMAN> restore datafile 1 from '/home/oracle/datafile-0a1r6qon_1_1'; ...… Read More »How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP
How to Resolve ORA-19697: standby control file not found in backup set
ORA-19697 Tried to restore controlfile from a backup set by RMAN, but it failed with ORA-19697. RMAN> restore controlfile from '/home/oracle/031r656h_1_1'; ... ORA-19697: standby control… Read More »How to Resolve ORA-19697: standby control file not found in backup set
How to Resolve ORA-19687: SPFILE not found in backup set
ORA-19687 Tried to restore SPFILE from a backup set by RMAN, but it failed with ORA-19687. RMAN> restore spfile from '/backup/rman/051r6emh_1_1'; ... ORA-19687: SPFILE not… Read More »How to Resolve ORA-19687: SPFILE not found in backup set
How Oracle Restore SPFILE
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
How Oracle Backup 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
How to Resolve ORA-01523: cannot rename data file to
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
How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use
ORA-32001 ORA-32001 means that the database cannot write SPFILE at this moment, you should make sure that it has been using by the instance. Let's… Read More »How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use
How to Resolve ORA-32589: unable to drop minimal supplemental logging
ORA-32589 Tried to drop the minimal supplemental logging from the database, but it failed with ORA-32589. SQL> alter database drop supplemental log data; alter database… Read More »How to Resolve ORA-32589: unable to drop minimal supplemental logging
How to Resolve ORA-31541: Supplemental logging is not enabled in CDB$ROOT.
ORA-31541 Tried to enable flashback transaction query starting from adding minimal supplemental logs, but it failed with ORA-31541. SQL> alter database add supplemental log data;… Read More »How to Resolve ORA-31541: Supplemental logging is not enabled in CDB$ROOT.