Rman / Oracle / Backup

rman target / catalog rman/pass@rmandb

>crosscheck archivelog all;

Read More

Oracle [ db_recovery_file_dest_size ]

SQL> SELECT * FROM V$RECOVERY_FILE_DEST;

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------------------------------------------ ----------- ---------- ----------------- ---------------
/u01/app/oracle/FLASH_RECOVERY_AREA 3.2212E+10          0                 0               0


SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 30G

SQL> alter system set db_recovery_file_dest_size=100G;

System altered.


SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 100G

Read More

Oracle Tablespace [ Check +ASM | Add Tablespace]

Check +ASM

SQL> select name, total_mb, free_mb from v$asm_diskgroup;

Check Disk

SQL> show parameter create

Add Tablespace

SQL> alter tablespace users add datafile size 1000m autoextend on next 500m maxsize 8000m;

Check Tablespace autoextend

SQL> desc dba_data_files;

SQL> select Tablespace_name, file_name, bytes/1024/1024 mbytes, AUTOEXTENSIBLE, MAXBYTES/1024/1024 maxbytes, INCREMENT_BY nextmb

from dba_data_files

Read More

User in lock [ Oracle ]

sqlplus /nolog

connect sys as sysdba

select * from dba_users;

select * from dba_profiles;

alert user name account unlock;

Read More

WMI Work [ Windows ]

Info Disk

C:\Users\Administrador>wmic LOGICALDISK Get DeviceID,Caption,description,size,freespace
Caption  Description       DeviceID  FreeSpace   Size
C:       Local Fixed Disk  C:        6752161792  21472735232
D:       CD-ROM Disc       D:        0           40814592

Info Disk

C:\Users\Administrador>wmic logicaldisk get Caption, Description, Filesystem
Caption  Description       FileSystem
C:       Local Fixed Disk  NTFS
D:       CD-ROM Disc       CDFS

Info Task Memory

C:\Users\Administrador\Documents\IdaDB>wmic path win32_perfformatteddata_perfproc_process get IOReadOperationsPersec, IOWriteBytesPersec, Name, PercentProcessorTime, PercentUserTime, VirtualBytes, WorkingSet, WorkingSet, WorkingSetPeak, WorkingSetPrivate

Info Task Memory

C:\Users\Administrador\Documents\IdaDB>wmic path win32_perfformatteddata_perfproc_process

Read More

IdaDB for Windows

Modification

1
%s/chomp($date);/chomp($date); $date =\~ s\/\\\/\/\/g;/

2
%s/`date +\\%m\\%d\\%Y`/`echo \%DATE\%`/g

Read More

Windows [ Add Variables PATH ] Oracle

C:\Users\Administrador>sqlplus /nolog
'sqlplus' não é reconhecido como um comando interno
ou externo, um programa operável ou um arquivo em lotes.

C:\Users\Administrador>echo %PATH%
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\strawberry\c\bin;C:\s
trawberry\perl\site\bin;C:\strawberry\perl\bin;C:\Windows\System32\WindowsPowerS
hell\v1.0\

C:\Users\Administrador>set PATH=%PATH%;C:\oraclexe\app\oracle\product\11.2.0\ser
ver\bin

C:\Users\Administrador>echo %PATH%
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\strawberry\c\bin;C:\s
trawberry\perl\site\bin;C:\strawberry\perl\bin;C:\Windows\System32\WindowsPowerS
hell\v1.0\;C:\oraclexe\app\oracle\product\11.2.0\server\bin

C:\Users\Administrador>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Qua Nov 7 01:27:48 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect sys as sysdba
Informe a senha:
Conectado.
SQL>
SQL>

Read More

Oracle [ ADD USER ]

Create user CommandLine identified by password;

Grant dba to CommandLine;

Read More

Oracle [ Instance idle ]

1 - step

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL> startup
ORACLE instance started.
SQL> quit


2 - step

SQL> connect sys as sysdba
Enter password:
Connected.
SQL>
SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> quit

Read More

Oracle [ tnsnames.ora ]

File tnsnames.ora

$ORACLE_HOME/network/admin/tnsnames.ora

$tnsping alias_name

$sqlplus system/12345@alias_name_tnsnames.ora

SQL> select * from v$instance;

Read More

Oracle / Linux [ BASH Notify DB ]

[root@localhost notify]# cat notify.sh
sqlplus /nolog << EOF
connect system/12345
@names_sid.sql
quit
EOF

[root@localhost notify]# cat names_sid.sql
spool /home/siltech/name.log
select name from v$database
/
spool off

[root@localhost notify]# cat /home/siltech/name.log

NAME                                                                           
---------                                                                      
XE

Read More