LOG_ARCHIVE_DEST Got an error "ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST" when I tried to set the parameter like this: SQL> alter system set… Read More »LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST are Mutually Exclusive
Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference.… Read More »Online Archived Logs vs Backup Archived Logs
Delete Trace Files Trace files have to be controlled and cleaned regularly, otherwise your disk space will be exhausted soon or later. But cleaning trace… Read More »How to Delete Trace Files in Oracle Database
Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. For Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora… Read More »The Default Location of SPFILE and PFILE for Linux and Windows
In my case, I plan to use SPFILE to startup the database instance which used to use a known PFILE to open. But the problem… Read More »How to Point to SPFILE in PFILE to Trick Scripts
If we need to change some values of parameters persistently, what should we start? First of all, we have to know whether the database started… Read More »Whether Database Started with SPFILE or PFILE?
I was planning to move a tempfile from one disk to another in a 9i database, but I got "ORA-01516: nonexistent log file, datafile, or… Read More »How to Resolve ORA-01516: nonexistent log file, datafile, or temporary file