-
Recent Posts
Recent Comments
Archives
Categories
Meta
Category Archives: ORACLE
Backup Rman Incremental SCRIPTS Use Name days for tag
Set retention policy to recovery window to 7 days. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; Script for Backup Level 0 backup_0.sh ORACLE_BASE=/oracle ORACLE_HOME=$ORACLE_BASE/orahome ORACLE_SID=orcl export ORACLE_BASE ORACLE_HOME ORACLE_SID export PATH=$PATH:/$ORACLE_HOME/bin rman target=’system/bagbag’ cmdfile=’/oracle/rman_script/rman_backup0.cmd’ log=’/oracle/rman_script/backup-level0.log’ currentdate=`date ‘+%y%m%d_%H%M’` file_name=hr_db_DC$currentdate.dmp … Continue reading
Import Data Pump performance problem
The import with DataPump of tables into an Oracle11g Release 11.2.0.4 database takes almost 45 minutes, while the same import into Oracle10g Release 10.2.0.4 only take 2 minutes. The slow Import Data Pump performance problem might also reproduce in other … Continue reading
How to Handle RMAN – 06023
Part of my daily tasks is to perform RMAN backup and recovery scenarios in my test environment , to be familiar with every possible situation that can happen. During performing this task I have an error Rman-06023 I have backup … Continue reading
Daily Activities of Oracle Database Administrator
Daily Work of DBA: Check the Database Availability Check the Listener Availability Monitoring space Availability Viewing the Alert log file to analyze the ORA errors if any. Check tablespaces should not be used more that 95%. Viewing the temporary files, … Continue reading
Posted in ORACLE
Leave a comment
Deleting the Archive log Using RMAN
Once you are connected, then you can use the following to delete archivelogs with one of the following commands. You can choose the commands depending on your situation. To delete all Archivelogs withou backing them up: delete archivelog all; To … Continue reading
RMAN Delete old archivelogs
delete force noprompt archivelog all completed before ‘sysdate-7′; If you want to delete archive logs older than few hours: Verify the time like how many hours older than you want to delete. SQL> alter session set nls_date_format=’MM/DD/YYYY HH24:MI:SS’; Session altered. … Continue reading
Oracle Rman Delete archivelog file older than N-day
rman target / run{ allocate channel D1 type disk; delete noprompt archivelog until time ‘SYSDATE-<N>‘; release channel D1; } ; Example 2 day run{ allocate channel D1 type disk; delete noprompt archivelog until time ‘SYSDATE-2’; release channel D1; } ;
Move or Rename the Tempfile in Oracle
1. Login as SYSDBA 2. Check the Tempfile status SQL> SELECT v.file#, t.file_name, v.status 2 FROM dba_temp_files t, v$tempfile v 3 WHERE t.file_id = v.file#; FILE# FILE_NAME STATUS ———- ————————- ——- 1 /u01/temp01.dbf ONLINE 2 /u02/temp02.dbf ONLINE 3 /u02/temp03.dbf ONLINE … Continue reading
ORA-00020: maximum number of processes … exceeded
First check your sessions, processes and transactions system parameter. Check Current Setting of Parameters sql> show parameter sessions sql> show parameter processes sql> show parameter transactions A basic formula for determining these parameter values is as follows: processes=x sessions=x*1.1+5 transactions=sessions*1.1 … Continue reading
ORA-00020 maximum number of processes exceeded
ORA-00020 maximum number of processes exceeded Cause: All process state objects are in use. Action: Increase the value of the PROCESSES initialization parameter. ORA-00020 comes under “Oracle Database Server Messages”. These messages are generated by the Oracle database server when … Continue reading