Home / Oracle Database Material (page 2)

Oracle Database Material

How to Find and repair Corrupt block in database

How to Find and repair Corrupt block in database   Step 1: Below query will show if there is any corrupted block SELECT *  FROM   v$database_block_corruption — will show if any corruped block  Step 2: Below query can give …

Read More »

RMAN backup and logical backup With Different User

RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY  TABLESPACE temp PROFILE DEFAULT;  GRANT CONNECT TO bkp_user;  GRANT exp_full_database TO bkp_user;  GRANT imp_full_database TO bkp_user;  GRANT recovery_catalog_owner TO bkp_user;  GRANT select_catalog_role TO bkp_user;  GRANT CREATE SESSION TO bkp_user;  Step 2: Connect RMAN with the Above Created User …

Read More »