Oracle Dba Quotes

Oracle 12c Enterprise or Standard Edition – building on Oracle’s unique ability to deliver Grid Computing, 12c gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

- ASM file can be copied to remote asm instance(diskgroup) using asmcmd command. SYNTAX - asmcmd> cp - -port asm_port file_name remote_asm_user/remote_asm_pwd@remote_host:Instancce_name:TARGET _ASM_PATH ASMCMD> cp --port 1521 s_srv_new21.dbf sys/oracle@172.20.17.69.+ASM1:+ARCL/s_srv_new21.dbf

- For mount a diskgroup,(This is instance specific, for mounting on all nodes, run the same on all nodes) SQL>alter diskgroup DATA mount;  or asmcmd>mount DATA -- For umount a diskgroup,(This is instance specific, for unmounting on all nodes, run the same on all nodes) SQL>alter diskgroup DATA dismount; Or asmcmd>umount DATA -- To mount/Dismount all the diskgroups SQL>alter diskgroup ALL mount;  SQL>alter diskgroup ALL dismount;

select log_id, log_date, owner, job_name from ALL_SCHEDULER_JOB_LOG where job_name like 'RMAN_B%' and log_date > sysdate-2; select log_id,log_date, owner, job_name, status, ADDITIONAL_INFO from ALL_SCHEDULER_JOB_LOG where log_id=113708;

SELECT SID, SERIAL#, USERNAME, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE TOTALWORK != 0 AND SOFAR <> TOTALWORK;

FOR c1 IN (SELECT OWNER,table_name, constraint_name FROM dba_constraints WHERE constraint_type = 'R' and owner=upper('&shema_name')) LOOP EXECUTE IMMEDIATE 'ALTER TABLE '||' "'||c1.owner||'"."'||c1.table_name||'" DROP CONSTRAINT ' || c1.constraint_name; END LOOP; FOR c1 IN (SELECT owner,object_name,object_type FROM dba_objects where owner=upper('&shema_name')) LOOP BEGIN IF c1.object_type = 'TYPE' THEN EXECUTE IMMEDIATE 'DROP '||c1.object_type||' "'||c1.owner||'"."'||c1.object_name||'" FORCE'; END IF; IF c1.object_type != 'DATABASE LINK' THEN EXECUTE IMMEDIATE 'DROP '||c1.object_type||' "'||c1.owner||'"."'||c1.object_name||'"'; END IF; EXCEPTION WHEN OTHERS THEN NULL; END;