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-00308 Found ORA-00308: cannot open archived log during performing a database point-in-time recovery (DBPITR) by RMAN. ORA-00308: cannot open archived log '/oradata/ORCL/ARCH/ORCL_1_294150.arc' ORA-27037: unable to… Read More »How to Resolve ORA-00308: cannot open archived log
Using cp You don't have to tar or zip all of Oracle central inventory, because the inventory is pretty small, normally, it's in several megabytes.… Read More »How Oracle Backup Inventory
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
Let me rewind the incident.I was copying a pretty big file to another place.While I was waiting for the copying to complete, I found some… Read More »cp: The media surface is damaged
ASMCMD ASM in Oracle 11g grid infrastructure has been improved a lot on the storage operations. For instance, the utility ASMCMD (ASM Command-Line) offers several… Read More »Copy File from ASM to Filesystem or ASM