ORA-00031: session marked for kill

Let’s have look on the steps used to solve the error Error(ORA-00031: session marked for the kill) Let’s have look on the steps Phase – 1 Find out thread id that needed to be killed from OS level select vs.sid, vs.username, vs.osuser, vs.process fg_pid, vp.spid bg_pid from v$session vs, v$process vp where vs.paddr = vp.addr; If you know the user detail you can filter […]

Read More

RMAN Parallel Backup

Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup (datafile 1,2,3 channel c1) (archivelog all channel c2); } Create more allocate channel RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; […]

Read More

RMAN Script

Today we are going to have look on the most important topic “script”.  Being human being we are using the script from the long time ago. Before the start, our technical topic has some look use in normal life. Definition A script is any particular system of writing or the written means of human communication. Script originated as simply a […]

Read More

RMAN Image Copy And Compressed Backup

Let’s have look on the steps used for “RMAN Image Copy And Compressed Backup” Backing up Particular Datafile and System file: RMAN> run { allocate channel c1 type disk; copy datafile 1 to ‘D:\oracle\product\10.2.0\flash_recovery_area\DBA01\Image copy\SYSTEM01.DBF’, current controlfile to ‘D:\oracle\product\10.2.0\flash_recovery_area\DBA01\Image copy\CONTROL01.ctl’; } Backup Database: RMAN> backup as copy database; Compressed Backup: RMAN> backup as compressed backupset […]

Read More

Recover From Redo Log File (After Lost Data File))

Today we are going to have look on the steps which we are going to use in Oracle for ” Recover From Redo Log File (After Lost Data File)”. The loss is loss being DBA we well understand the cost of loss “CDR” Check archive list SQL> archive log list; Database log mode              No Archive Mode […]

Read More

RMAN Incremental Backup

We are aware RMAN plays an important role in backup strategies  Today we are going to have a look “RMAN Incremental Backup”. Let’s have look on the steps. Create table for testing purpose SQL> create table sat(id number) tablespace test; Table created. Create a incremental backup with tag option RMAN> run { allocate channel c1 type […]

Read More

RMAN Particular Datafile Backup

Let’s have look on the steps we use for “RMAN Particular Datafile Backup” Check the datafile SQL> select file_id,tablespace_name,file_name from dba_data_files; FILE_ID    TABLESPACE_NAME              FILE_NAME —————————————————————————————- 4   USERS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\USERS01.DBF 3   SYSAUX       D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\SYSAUX01.DBF 2   UNDOTBS1   D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\UNDOTBS01.DBF 1   SYSTEM       D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\SYSTEM01.DBF 6   CHEC            D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\CHECK01.DBF 5   TEST            D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\TEST02.DBF 6 rows selected Create a dummy table and insert some records. SQL> […]

Read More

RMAN Recovery From Missing All Control File

Today we are going to have look on the steps are used for “RMAN Recovery From Missing All Control File”. Take a DBID SQL> select dbid from v$database; DBID ———- 847839442 Check the RMAN configuration RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO […]

Read More

RMAN Backup With Archivelog

RMAN plays an important role n Oracle RDBMS. Let’s have look on the steps are used by Oracle during the “RMAN Backup With Archivelog” RMAN> run { allocate channel c1 type disk; backup database; backup(archivelog all); } RMAN> backup archivelog all delete input; Note: This will backup all archivelog file and delete those from target location. If […]

Read More