Esto lo pongo para que no se me olviden algunos comandos . . .
export ORACLE_SID=+ASM1
sqlplus / as sysdba
SQL> desc v$asm_diskgroup;
SQL> desc v$asm_disk;
SQL> select PATH,LABEL,NAME from v$asm_disk where GROUP_NUMBER=2;
SQL> select NAME,PATH from v$asm_disk where PATH='/dev/rhdiskpower144';
SQL> select PATH from v$asm_disk where GROUP_NUMBER=3;
SQL> select group_number, name from v$asm_diskgroup;
Puff que noche tan pesada !!! . . .
Saturday, July 30, 2011
ALLDATA . ALLFRA ?
Esto lo pongo para que no se me olviden algunos comandos . . .
export ORACLE_SID=+ASM1
sqlplus / as sysdba
SQL> desc v$asm_diskgroup;
SQL> desc v$asm_disk;
SQL> select PATH,LABEL,NAME from v$asm_disk where GROUP_NUMBER=2;
SQL> select NAME,PATH from v$asm_disk where PATH='/dev/rhdiskpower144';
SQL> select PATH from v$asm_disk where GROUP_NUMBER=3;
SQL> select group_number, name from v$asm_diskgroup;
Puff que noche tan pesada !!! . . .
export ORACLE_SID=+ASM1
sqlplus / as sysdba
SQL> desc v$asm_diskgroup;
SQL> desc v$asm_disk;
SQL> select PATH,LABEL,NAME from v$asm_disk where GROUP_NUMBER=2;
SQL> select NAME,PATH from v$asm_disk where PATH='/dev/rhdiskpower144';
SQL> select PATH from v$asm_disk where GROUP_NUMBER=3;
SQL> select group_number, name from v$asm_diskgroup;
Puff que noche tan pesada !!! . . .
Subscribe to:
Posts (Atom)