All-in-one Oracle DBA Scripts Quotes

Rate this book
Clear rating
All-in-one Oracle DBA Scripts: Collection of real-time dba scripts that will help you in your everyday administration tasks All-in-one Oracle DBA Scripts: Collection of real-time dba scripts that will help you in your everyday administration tasks by Arun Kumar
4 ratings, 3.75 average rating, 0 reviews
Open Preview
All-in-one Oracle DBA Scripts Quotes Showing 1-2 of 2
“- 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
“- 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