How to lock / unlock oracle database user account
To unlock a user Run the following sql as administrator …
How to lock / unlock oracle database user account Read More »
How to enable the Fast Recovery Area in Oracle 12c
If you haven’t already done so, enabling your system to …
How to enable the Fast Recovery Area in Oracle 12c Read More »
How To Delete Specific Archivelogs and Backups Using RMAN
As part of the regular backup file log maintenance, the …
How To Delete Specific Archivelogs and Backups Using RMAN Read More »
ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′
After incomplete recovery of my one of the database, I …
ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′ Read More »
Useful sql scripts for Oracle DBA
Note: These scripts runs with SYSDBA privileges cpu_usage.sql – Show …
RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE
Ensuring that the system has been backed up and is …
RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE Read More »
How to put oracle database to archivelog
Shutdown the database. Exclusive start. Turn on archivelog. Check archive …