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
cp
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 ASMCMD-9463: operation failed due to lack of write permissions
ASMCMD-9463 Tried to copy a data file out of ASM, but it failed with ASMCMD-9463. [grid@primary01 grid]$ asmcmd cp +DATA/ORCLCDB/ORCLPDB/example_01.dbf /backup/example_01.dbf ASMCMD-9463: operation failed due… Read More »How to Resolve ASMCMD-9463: operation failed due to lack of write permissions
How to Resolve ORA-00308: cannot open archived log
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
How Oracle Backup Inventory
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
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
cp: The media surface is damaged
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
How to Copy Files Without Prompts on Enterprise Linux 6
As I can remember, command cp never asks you the copy operation for sure except that you add -i option to enter the interactive mode. But with… Read More »How to Copy Files Without Prompts on Enterprise Linux 6
Copy File from ASM to Filesystem or ASM
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
Duplicate a Standby Database (2/4) - With Backup-Based Duplication
Duplicate a Standby Database (1/4) - With Active Database Duplication Backup-Based duplication requires to connect to the target database, and one copy of database backups… Read More »Duplicate a Standby Database (2/4) - With Backup-Based Duplication