rman target / catalog rman/pass@rmandb
>crosscheck archivelog a...
Thursday, November 29, 2012
Wednesday, November 28, 2012
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 ...
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...
Monday, November 12, 2012
User in lock [ Oracle ]
sqlplus /nolog
connect sys as sysdba
select * from dba_users;
select * from dba_profiles;
alert user name account unloc...
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 ...
Friday, November 9, 2012
IdaDB for Windows
Modification
1
%s/chomp($date);/chomp($date); $date =\~ s\/\\\/\/\/g;/
2
%s/`date +\\%m\\%d\\%Y`/`echo \%DATE\%...
Thursday, November 8, 2012
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...
Thursday, November 1, 2012
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
...
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;
...
Oracle / Linux [ BASH Notify DB ]
[root@localhost notify]# cat notify.sh sqlplus /nolog << EOFconnect system/12345@names_sid.sqlquitEOF
[root@localhost notify]# cat names_sid.sql spool /home/siltech/name.logselect name from v$database/spool off
[root@localhost notify]# cat /home/siltech/name.log NAME ...
