RMAN

How to Pass Date Format into RMAN

Posted on
After you set RMAN log location (2 Ways to Set RMAN Log Location), the next problem you will meet is the format of timestamp in the log, which could be too coarse to judge the actual time like this:08-OCT-12If you are using sqlplus, you can alter the session and set NLS_DATE_FORMAT to modify the format, […]
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
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. Which means that you can have larger recovery point objective (RPO) than usual whenever data lost, […]