Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

candidate disk

How we will find the candidate disk..
want to find out the unused disk  
which command..
v$asm_disk  ----?
of lsdg from asmcmd

Please advice..
0
tonydba
Asked:
tonydba
  • 3
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
Quick toss while I read for a better answer:

"SELECT
 NVL(a.name, '[CANDIDATE]') disk_group_name
 , b.path disk_file_path
 , b.name disk_file_name
 , b.failgroup disk_file_fail_group
 FROM
 v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
 ORDER BY
 a.name;"

From http://oracleracdba1.wordpress.com/2012/10/12/how-to-add-disk-to-asm/
0
 
tonydbaAuthor Commented:
Actually there is an error when I ran it

SELECT NVL(a.name, '[CANDIDATE]') disk_group_name
, b.path disk_file_path
, b.name disk_file_name
, b.failgroup disk_file_fail_group
FROM v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b
on a.group_number=b.group_number
ORDER BY a.name;

Because of error I modified as above..

still not working
0
 
DavidSenior Oracle Database AdministratorCommented:
Which error, where marked (run it in sqlplus and look for the parse mark *)?  You have permissions to select on the views?
0
 
tonydbaAuthor Commented:
the query is displayed followed by   1 2 3 4 5.

no error messages..
0
 
tonydbaAuthor Commented:
yes unused disk
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now