PFILE and SPFILE

Why SPFILE Does Not Work in RAC

Posted on
Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And I think you might create the SPFILE in the wrong places. Oracle 11g RAC stores all the shared files in ASM, including control files, SPFILE, data files. Thus, it starts all the instances […]
RMAN

How to Set NLS_DATE_FORMAT in RMAN

Posted on
After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log, which was too coarse to judge the actual time like this: 08-OCT-12 Set NLS_DATE_FORMAT for RMAN If you are using sqlplus, you can ALTER SESSION SET NLS_DATE_FORMAT to modify the date format, but […]
RMAN

3 Ways to Set RMAN Log Location

Posted on
RMAN Log Location RMAN is a client side utility like sqlplus used to interoperate with DB, we usually compose a script file or a batch file to run via cron job or schedule. If any problems result from RMAN, you can check the log file in order to debug them. There is no RMAN default […]
RMAN

When RMAN met Resource Manager

Posted on
Users notified DBA that they found AP responded longer than normal starting from 22:00 everyday, especially when a period of running RMAN on the host, we checked STATPACK report to search the root cause, RMAN was running fine, but there was a wait event utilizing too much resources, see the report summarized below: … Top […]
Archivelog Mode

How to Enable ARCHIVELOG Mode in Oracle 9i

Posted on
In this post, I will show you how to enable archivelog mode in 9i. For those who are using Oracle 10g onwards, you may take a look at my post for more: How to Enable Archivelog Mode in Oracle Create archive log destination directory and enter sqlplus [oracle@test ~]$ mkdir -p /u01/app/oracle/product/9.2.0/archivelog/oracle9i/ [oracle@test ~]$ sqlplus […]
Archivelog Mode

How to Enable ARCHIVELOG Mode in Oracle

Posted on
For 9i database or below, please refer to: How to Enable ARCHIVELOG Mode in Oracle 9i What is Archiving? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which enable ARCHIVELOG mode. It makes databases keep transaction history much longer than finite redo logs. […]