Daily Archives: February 25, 2014
killing expdp/impdp job
step 1: take the job_name from below views select * from USER_DATAPUMP_JOBS; select * from DBA_DATAPUMP_SESSIONS; step 2: try to attach to that job_name which you find out in step1. oracle@aa: /u02/backups # impdp system/***** attach=test_DUMP11(job_name) step 3: stop job immediate impdp> STOP_JOB=IMMEDIATE impdp>kill_job
Creating a Recovery Catalog
$ sqlplus /nolog CONNECT SYS/passwd@OCM AS SYSDBA; CREATE TABLESPACE rman DATAFILE ‘/u02/app/oradata/rman/rman01.dbf’ size 100m; Create the Recovery Catalog Owner in the new database (OCM) CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman QUOTA UNLIMITED ON rman; SQL> GRANT connect, resource, recovery_catalog_owner TO rman; $ rman catalog rman/passwd@OCM Recovery Manager: Release 10.2.0.3.0 – Production on […]
anargodjaev.wordpress.com 