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 !!! . . .

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 !!! . . .