Thursday, November 29, 2012

, , , , , ,

Rman / Oracle / Backup

No comments  
rman target / catalog rman/pass@rmandb

>crosscheck archivelog all;

Related Posts:

  • ORACLE - [ spreport ] 1: SQL> exec perfstat.statspack.snap 2: SQL> exec perfstat.statspack.snap 3: SQL> @$ORACLE_HOME/rdbms/admin/spreport … Read More
  • Oracle - [ Alter Database Datafile ]  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 … Read More
  • ORACLE - NLS_LANG SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET', 'NLS_LANGUAGE', 'LANGUAGE', 'NLS_TERRITORY', 'TERRITORY') name, value from v$nl… Read More
  • ORACLE / RMAN - Statusset pages 120 set lines 120 column MEDIA format a10 column STATUS format a10 column OPERACAO format a10 select operation as "OPERACAO", object_type a… Read More
  • Oracle Rman Show Backups 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", ro… Read More

0 comentários:

Post a Comment