MERCADOS FINANCIEROS

Track all markets on TradingView

jueves, 16 de julio de 2020

MONITOREAR TEMPERATURA

https://www.alcpu.com/CoreTemp/

Publicado por en No hay comentarios:

martes, 14 de julio de 2020

COMANDOS ASMCMD

Table 12-27 Summary of ASMCMD Disk group management commands
CommandDescription
chdgChanges a disk group (add, drop, or rebalance).
chkdgChecks or repairs a disk group.
dropdgDrops a disk group.
iostatDisplays I/O statistics for disks.
lsattrLists the attributes of a disk group.
lsdgLists disk groups and their information.
lsdskLists disks Oracle ASM disks.
lsodLists open devices.
md_backupCreates a backup of the metadata of mounted disk groups.
md_restoreRestores disk groups from a backup of the metadata.
mkdgCreates a disk group.
mountMounts a disk group.
offlineOfflines a disk or a failure group.
onlineOnlines a disk or a failure group.
rebalRebalances a disk group.
remapRelocates data in a range of physical blocks on a disk.
setattrSets attributes in a disk group.
umountDismounts a disk group.

ASMCMD>;  md_backup backup.bck -G data,fra
Publicado por en No hay comentarios:

RMAN MULTISECTION BACKUP

RMAN> report schema;

Report of database schema for database with db_unique_name ACME

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    790      SYSTEM               ***     +DATA/ACME/DATAFILE/system.266.1044480131
2    358      EXAMPLE              ***     +DATA/ACME/DATAFILE/example.257.1044478425
3    1190     SYSAUX               ***     +DATA/ACME/DATAFILE/sysaux.258.1044478471
4    90       UNDOTBS1             ***     +DATA/ACME/DATAFILE/undotbs1.260.848598093
5    100      TBS_1                ***     +DATA/ACME/DATAFILE/tbs_1.268.1043868835
6    5        USERS                ***     +DATA/ACME/DATAFILE/users.259.848598091

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    162      TEMP                 32767       +DATA/ACME/TEMPFILE/temp.265.848598163

RMAN> BACKUP DATAFILE 3 SECTION SIZE 200M TAG 'SECTION 200m';

Starting backup at 14-JUL-20
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 1 through 25600
channel ORA_DISK_1: starting piece 1 at 14-JUL-20
channel ORA_DISK_1: finished piece 1 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.296.1045766907 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 25601 through 51200
channel ORA_DISK_1: starting piece 2 at 14-JUL-20
channel ORA_DISK_1: finished piece 2 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.292.1045766921 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 51201 through 76800
channel ORA_DISK_1: starting piece 3 at 14-JUL-20
channel ORA_DISK_1: finished piece 3 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.297.1045766937 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 76801 through 102400
channel ORA_DISK_1: starting piece 4 at 14-JUL-20
channel ORA_DISK_1: finished piece 4 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.281.1045766953 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 102401 through 128000
channel ORA_DISK_1: starting piece 5 at 14-JUL-20
channel ORA_DISK_1: finished piece 5 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.282.1045766967 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 128001 through 152320
channel ORA_DISK_1: starting piece 6 at 14-JUL-20
channel ORA_DISK_1: finished piece 6 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.270.1045766975 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 14-JUL-20

Starting Control File and SPFILE Autobackup at 14-JUL-20
piece handle=+FRA/ACME/AUTOBACKUP/2020_07_14/s_1045766982.262.1045766983 comment=NONE
Finished Control File and SPFILE Autobackup at 14-JUL-20

RMAN> 

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
47      B  A  A DISK        14-JUL-20       1       1       NO         TAG20200714T182628
48      B  F  A DISK        14-JUL-20       1       1       NO         TAG20200714T182629
49      B  A  A DISK        14-JUL-20       1       1       NO         TAG20200714T182907
50      B  F  A DISK        14-JUL-20       1       1       NO         TAG20200714T182910
51      B  F  A DISK        14-JUL-20       6       1       NO         SECTION 200M
52      B  F  A DISK        14-JUL-20       1       1       NO         TAG20200714T184942

RMAN> list backupset 51;


RMAN> backup datafile 1 SECTION SIZE 100M TAG 'SYSTEM SECTION 100M';

Publicado por en No hay comentarios:

VALIDAR HERRAMIENTAS ORACLE UTILIZADAS DBA_FEATURE_USAGE_STATISTICS

select * from dba_feature_usage_statistics
Publicado por en No hay comentarios:

sábado, 11 de julio de 2020

BACKUP INCREMENTAL LEVEL 0 DATABASE

FAST RECOVERY AREA

RMAN> backup incremental level 0 database; 

FILE SYSTEM

RMAN> backup incremental level 0 database format '/u01/backup/%U'; 


RMAN> backup incremental level 1 database;

RMAN> backup incremental level 1 cumulative database;
Publicado por en No hay comentarios:

ALTER TABLESPACE READ ONLY ALTER TABLESPACE READ WRITE

SQL> alter tablespace example read only;

Tablespace altered.


SQL> alter tablespace example read write;

Tablespace altered.

SQL> alter tablespace example nologging;

RMAN> backup database skip readonly;

Starting backup at 11-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=59 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.258.1044478471
input datafile file number=00001 name=+DATA/ACME/DATAFILE/system.266.1044480131
input datafile file number=00002 name=+DATA/ACME/DATAFILE/example.257.1044478425
input datafile file number=00005 name=+DATA/ACME/DATAFILE/tbs_1.268.1043868835
input datafile file number=00004 name=+DATA/ACME/DATAFILE/undotbs1.260.848598093
input datafile file number=00006 name=+DATA/ACME/DATAFILE/users.259.848598091
channel ORA_DISK_1: starting piece 1 at 11-JUL-20

VALIDAR QUE ESTA EL TABLESPACE EN MODE READ ONLY

SQL> alter table hr.prueba move tablespace example;
alter table hr.prueba move tablespace example
               *
ERROR at line 1:
ORA-01647: tablespace 'EXAMPLE' is read-only, cannot allocate space in it


SQL> alter tablespace example read write;

Tablespace altered.

SQL> alter table hr.prueba move tablespace example;

Table altered.

SQL> 



Publicado por en No hay comentarios:

jueves, 9 de julio de 2020

RMAN DELETE EXPIRED NOPROMPT

RMAN> delete noprompt expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1       1       1   1   EXPIRED     DISK        /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194619_frcv6wdw_.bkp
2       2       1   1   EXPIRED     DISK        /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_nnndf_TAG20180828T194623_frcv709n_.bkp
3       3       1   1   EXPIRED     DISK        /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194929_frcvdssr_.bkp
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194619_frcv6wdw_.bkp RECID=1 STAMP=985376780
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_nnndf_TAG20180828T194623_frcv709n_.bkp RECID=2 STAMP=985376784
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194929_frcvdssr_.bkp RECID=3 STAMP=985376969
Deleted 3 EXPIRED objects


RMAN> delete noprompt expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    6       X 20-FEB-16
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_6_frcv6t05_.arc

2       1    7       X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_7_frcvds9r_.arc

3       1    8       X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_8_frcz7jfr_.arc

4       1    9       X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_9_frcz7ntb_.arc

5       1    10      X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_10_frcz7s4s_.arc

6       1    11      X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_30/o1_mf_1_11_frjys12v_.arc

7       1    12      X 30-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_12_fro2zcbg_.arc

8       1    13      X 01-SEP-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_13_fro33gkq_.arc

9       1    14      X 01-SEP-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_14_fro3xqsf_.arc

10      1    15      X 01-SEP-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_15_fro42vcv_.arc

deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_6_frcv6t05_.arc RECID=1 STAMP=985376779
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_7_frcvds9r_.arc RECID=2 STAMP=985376969
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_8_frcz7jfr_.arc RECID=3 STAMP=985380896
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_9_frcz7ntb_.arc RECID=4 STAMP=985380900
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_10_frcz7s4s_.arc RECID=5 STAMP=985380905
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_30/o1_mf_1_11_frjys12v_.arc RECID=6 STAMP=985544273
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_12_fro2zcbg_.arc RECID=7 STAMP=985679647
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_13_fro33gkq_.arc RECID=8 STAMP=985679778
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_14_fro3xqsf_.arc RECID=9 STAMP=985680617
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_15_fro42vcv_.arc RECID=10 STAMP=985680779
Deleted 10 EXPIRED objects


RMAN> delete expired backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=49 device type=DISK

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
64      64      1   1   EXPIRED     DISK        /u01/backup/22v4t31i_1_1
66      66      1   1   EXPIRED     DISK        /u01/backup/26v4t3je_1_1
67      66      1   2   EXPIRED     DISK        /u01/backup/26v4t3je_1_2

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u01/backup/22v4t31i_1_1 RECID=64 STAMP=1045335091
deleted backup piece
backup piece handle=/u01/backup/26v4t3je_1_1 RECID=66 STAMP=1045335662
deleted backup piece
backup piece handle=/u01/backup/26v4t3je_1_2 RECID=67 STAMP=1045335662
Deleted 3 EXPIRED objects


RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=49 device type=DISK
specification does not match any archived log in the repository

RMAN> 



Publicado por en No hay comentarios:

RMAN LIMITAR TAMAÑO PIEZAS MAXPIECESIZE

$ rman target /

RMAN> report schema;

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    900      SYSTEM               ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hhqvrdhj_.dbf
2    358      EXAMPLE              ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_hhqvv3w9_.dbf
3    1500     SYSAUX               ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_9qwm8fym_.dbf
4    75       UNDOTBS1             ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_9qwmf6kp_.dbf
5    100      SYSTEM               ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hgr0bw9h_.dbf
6    5        USERS                ***     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_hhqvv3ws_.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    252      TEMP                 32767       /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_9qwmhgnm_.tmp

 NOTA:

SE RECOMIENDA LIMITAR EL TAMAÑO DE LAS PIEZAS DE BACKUP EN POCOS GIGAS

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50M;

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50 M;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> backup datafile 1;       

Starting backup at 09-JUL-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=78 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hhqvrdhj_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUL-20
channel ORA_DISK_1: finished piece 1 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr1s0_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 2 at 09-JUL-20
channel ORA_DISK_1: finished piece 2 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr8rq_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 3 at 09-JUL-20
channel ORA_DISK_1: finished piece 3 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrhrx_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 4 at 09-JUL-20
channel ORA_DISK_1: finished piece 4 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrls5_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 5 at 09-JUL-20
channel ORA_DISK_1: finished piece 5 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrmt5_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 6 at 09-JUL-20
channel ORA_DISK_1: finished piece 6 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrpt3_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 7 at 09-JUL-20
channel ORA_DISK_1: finished piece 7 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrqtt_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 8 at 09-JUL-20
channel ORA_DISK_1: finished piece 8 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrtto_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 9 at 09-JUL-20
channel ORA_DISK_1: finished piece 9 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrvvd_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 10 at 09-JUL-20
channel ORA_DISK_1: finished piece 10 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdryvg_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 11 at 09-JUL-20
channel ORA_DISK_1: finished piece 11 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrzw1_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 12 at 09-JUL-20
channel ORA_DISK_1: finished piece 12 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds2x7_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 13 at 09-JUL-20
channel ORA_DISK_1: finished piece 13 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds5x9_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 14 at 09-JUL-20
channel ORA_DISK_1: finished piece 14 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds6ws_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:38
Finished backup at 09-JUL-20

Starting Control File and SPFILE Autobackup at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2020_07_09/o1_mf_s_1045336536_hjhds8gl_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUL-20

RMAN> 

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
49      B  0  A DISK        30-JUN-20       1       1       NO         TAG20200630T190839
50      B  1  A DISK        30-JUN-20       1       1       NO         TAG20200630T190839
52      B  1  A DISK        30-JUN-20       1       1       NO         TAG20200630T203911
53      B  F  A DISK        30-JUN-20       1       1       NO         TAG20200630T203947
54      B  F  A DISK        02-JUL-20       1       1       NO         TAG20200702T204640
55      B  A  A DISK        04-JUL-20       1       1       NO         BEFORE UPGRADE
56      B  F  A DISK        04-JUL-20       1       1       NO         TAG20200704T112235
57      B  A  A DISK        04-JUL-20       1       1       NO         BEFORE UPGRADE
58      B  F  A DISK        04-JUL-20       1       1       NO         TAG20200704T112847
59      B  F  A DISK        04-JUL-20       1       1       NO         CONTROLFILE
60      B  F  A DISK        04-JUL-20       1       1       NO         TAG20200704T113807
61      B  F  A DISK        09-JUL-20       1       1       NO         TAG20200709T184559
62      B  A  A DISK        09-JUL-20       1       1       NO         TAG20200709T184635
63      B  F  A DISK        09-JUL-20       1       1       NO         TAG20200709T184721
64      B  A  A DISK        09-JUL-20       1       1       NO         TAG20200709T185130
65      B  F  A DISK        09-JUL-20       1       1       NO         TAG20200709T185236
66      B  F  A DISK        09-JUL-20       1       2       NO         TAG20200709T190102
67      B  F  A DISK        09-JUL-20       1       1       NO         TAG20200709T190105
68      B  F  A DISK        09-JUL-20       1       1       NO         TAG20200709T191033
69      B  F  A DISK        09-JUL-20       14      1       NO         TAG20200709T191457
70      B  F  A DISK        09-JUL-20       1       1       NO         TAG20200709T191536

RMAN> list backupset 69;

    List of Backup Pieces for backup set 69 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    70      1   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr1s0_.bkp
    71      2   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr8rq_.bkp
    72      3   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrhrx_.bkp
    73      4   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrls5_.bkp
    74      5   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrmt5_.bkp
    75      6   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrpt3_.bkp
    76      7   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrqtt_.bkp
    77      8   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrtto_.bkp
    78      9   AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrvvd_.bkp
    79      10  AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdryvg_.bkp
    80      11  AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrzw1_.bkp
    81      12  AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds2x7_.bkp
    82      13  AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds5x9_.bkp
    83      14  AVAILABLE   /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds6ws_.bkp

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK clear;


Publicado por en No hay comentarios:

martes, 7 de julio de 2020

SRVCTL BAJAR Y SUBIR INSTANCIA ORACLE - GRID INFRAESTRUCTURE

$ srvctl stop database -d acme -o immediate
$ srvctl start database -d acme -o open

[oracle@localhost ~]$ srvctl stop database -d acme -o immediate
[oracle@localhost ~]$ ps -fea | grep pmon
oracle    3522     1  0 Nov13 ?        00:02:33 asm_pmon_+ASM
oracle    5516     1  0 Nov13 ?        00:02:23 ora_pmon_orcl
oracle   26152  3769  0 21:34 pts/3    00:00:00 grep pmon
[oracle@localhost ~]$ 
[oracle@localhost ~]$ srvctl start database -d acme -o open
[oracle@localhost ~]$ ps -fea | grep pmon
oracle    3522     1  0 Nov13 ?        00:02:33 asm_pmon_+ASM
oracle    5516     1  0 Nov13 ?        00:02:23 ora_pmon_orcl
oracle   26188     1  0 21:34 ?        00:00:00 ora_pmon_acme
oracle   26316  3769  0 21:35 pts/3    00:00:00 grep pmon
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [orcl] ? acme
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Nov 23 21:35:23 2020

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> select open_mode from v$database;  

OPEN_MODE
--------------------
READ WRITE

Publicado por en No hay comentarios:

sábado, 4 de julio de 2020

CHECK LIST DBA ADMINISTRACION ORACLE DATABASE 12C

CHECK LIST


1. Verificar Objetos Invalidos utlrp.sql
2. Mantener Actualizadas las Estadisticas de las Tablas Mensual
3. Mantener Actualizadas las Estadisticas de los Indices Mensual
4. Generar el DDL de Tablas e Indices (Diccionario Datos).
5. Multiplexar los Archivos de Control y Redologs
6. RMAN Activar la copia automatica del backup del Archivo Control
7. Aumentar el Numero de db_files Archivos de Datafile
8. Configurar adecuadamente los Parametros del Kernel
9. Ejecutar el Validate Database desde RMAN Validacion de Base de Datos.
10. Validar los Parametros de Undo_retention
11. Configurar el retention Guarantee en el tablespace undo.
12. Activar el parametro temp_undo_enabled.
13. Validate database RMAN
14, RMAN Restore Database Validate
15. Purging SQL Plan Management Space Budget Percent Tablespace SYSAUX


Publicado por en No hay comentarios:
Suscribirse a: Entradas (Atom)