Monday, February 18, 2013

Thursday, February 7, 2013

, ,

Windows / FORFILES - [ To delete old archives ]

No comments  

command : Forfiles
-p  = PATH
-d  = DAYS
-m = REGEX
-c  = NEW COMMAND


C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl

"IdaDB_03122012.pl"
"IdaDB_Windows_SRV.pl"
"IdaDB_Windows_SRV_03122012.pl"
"tmp1.pl"

C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl -c "cmd /c del /f /q @path"

C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl
ERRO: Nenhum arquivo encontrado com os critérios de pesquisa especificados.

Wednesday, February 6, 2013

, , , , , , ,

ORACLE - NLS_LANG

No comments  

SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

NAME          VALUE
------------- ----------------------------------------------------------------
LANGUAGE      AMERICAN
TERRITORY     AMERICA
CHARACTER SET WE8ISO8859P1

SQL> exit

NLS_LANG=<LANGUAGE>_<TERRITORY>.<CHARACTER SET>

C:\>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

C:\>echo %NLS_LANG%
AMERICAN_AMERICA.WE8ISO8859P1

Tuesday, February 5, 2013

, , , , , , ,

Rman catalog - Time Retention

No comments  

SQL> show parameter keep

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep                     string
control_file_record_keep_time        integer     7
db_keep_cache_size                   big integer 0


, , , , , , ,

Oracle Rman Show Backups

No comments  

select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation = 'BACKUP'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time
SQL> /

OPERACAO   TIPO          STATUS     MEDIA      DATA                TAMANHO(MB)
---------- ------------- ---------- ---------- ------------------- -----------
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   04-02-2013 09:17:55       19.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   04-02-2013 12:05:11        6.48
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   05-02-2013 00:06:20        3.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   05-02-2013 12:05:38        8.61

, , , , ,

ORACLE / RMAN - Status

No comments  
set pages 120
set lines 120
column MEDIA format a10
column STATUS format a10
column OPERACAO format a10

select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation <> 'CATALOG'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time;



OPERACAO   TIPO          STATUS     MEDIA DATA                TAMANHO(MB)
---------- ------------- ---------- ----- ------------------- -----------
BACKUP     ARCHIVELOG    COMPLETED  SBT_T 04-02-2013 09:17:55       19.87
APE
RMAN                     COMPLETED        04-02-2013 09:17:56       19.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_T 04-02-2013 12:05:11        6.48
APE
RMAN                     COMPLETED        04-02-2013 12:05:11        6.48
LIST       DB FULL       COMPLETED        04-02-2013 18:15:50           0
RMAN                     COMPLETED        04-02-2013 18:22:16           0
LIST       DB FULL       COMPLETED        04-02-2013 18:22:48           0
RMAN                     COMPLETED        04-02-2013 18:27:21           0

---------------------------------------------------////---------------------------------------------------------------


[oracle@Linux ~]$ export NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS"
[oracle@Linux ~]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Feb 5 07:47:28 2013

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

connected to target database: RM (DBID=2664802127)

RMAN> list backup ;


Monday, February 4, 2013

, , , , , , ,

Oracle - [ Alter Database Datafile ]

No comments  

 1* select file_id,file_name,bytes/1024/1024,maxbytes/1024/1024 from dba_data_files order by file_id
SQL> /

   FILE_ID FILE_NAME  BYTES/1024/1024 MAXBYTES/1024/1024
---------- ------------------------------ --------------- ------------------
1 +DSKDATA/oralee/datafile/syste      740  32767.9844
  m.334.783430381

2 +DSKDATA/oralee/datafile/sysau      810  32767.9844
  x.335.783430383

3 +DSKDATA/oralee/datafile/undot      815  32767.9844
  bs1.336.783430385

4 +DSKDATA/oralee/datafile/algor     4000 8000
  .338.783430389

5 +DSKDATA/oralee/datafile/algor     4000 8000
  _indices.339.783430395

6 +DSKDATA/oralee/datafile/undot      200  32767.9844
  bs2.340.783430401

7 +DSKDATA/oralee/datafile/users   161.25  32767.9844
  .341.783430401

SQL> alter database datafile 1 autoextend on next 500m maxsize 8000m;

Database altered.

SQL> alter database datafile 2 autoextend on next 500m maxsize 8000m;

Database altered.

SQL> l
  1* alter database datafile 2 autoextend on next 500m maxsize 8000m
SQL> c/2/3/
  1* alter database datafile 3 autoextend on next 500m maxsize 8000m
SQL> /

Database altered.

SQL> c/3/4/
  1* alter database datafile 4 autoextend on next 500m maxsize 8000m
SQL> c/4/6/
  1* alter database datafile 6 autoextend on next 500m maxsize 8000m
SQL> /

Database altered.

SQL> c/6/7/
  1* alter database datafile 7 autoextend on next 500m maxsize 8000m
SQL> /

Database altered.

SQL> set pages 120
SQL> set lines 100
SQL> column file_name format a30
SQL> /

   FILE_ID FILE_NAME  BYTES/1024/1024 MAXBYTES/1024/1024
---------- ------------------------------ --------------- ------------------
1 +DSKDATA/oralee/datafile/syste      740 8000
  m.334.783430381

2 +DSKDATA/oralee/datafile/sysau      810 8000
  x.335.783430383

3 +DSKDATA/oralee/datafile/undot      815 8000
  bs1.336.783430385

4 +DSKDATA/oralee/datafile/algor     4000 8000
  .338.783430389

5 +DSKDATA/oralee/datafile/algor     4000 8000
  _indices.339.783430395

6 +DSKDATA/oralee/datafile/undot      200 8000
  bs2.340.783430401

7 +DSKDATA/oralee/datafile/users   161.25 8000
  .341.783430401


7 rows selected.