Arun Kumar > Quotes

“If you believe someone believe blindly either you get a good relation or a good lesson”
― Arun Kumar

“- 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;”
― Arun Kumar, All-in-one Oracle DBA Scripts: Collection of real-time dba scripts that will help you in your everyday administration tasks

“SELECT SID, SERIAL#, USERNAME, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE TOTALWORK != 0 AND SOFAR <> TOTALWORK;”
― Arun Kumar, Oracle DBA Quick Scripts: Oracle dba scripts collection used by expert database administrators everyday. Must have dba scripts for your daily activities!

“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;”
― Arun Kumar, Oracle DBA Quick Scripts: Oracle dba scripts collection used by expert database administrators everyday. Must have dba scripts for your daily activities!

“- 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”
― Arun Kumar, All-in-one Oracle DBA Scripts: Collection of real-time dba scripts that will help you in your everyday administration tasks

“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;”
― Arun Kumar, Oracle DBA Quick Scripts: Oracle dba scripts collection used by expert database administrators everyday. Must have dba scripts for your daily activities!