martes, 24 de mayo de 2016

Como crear un dispositivo de librería virtual en Oracle Secure Backup 12c- Pruebas?


root@lab1-db1:/opt/product/osb_vdevices# /usr/local/oracle/backup/osb_12.1.0.2.1_solaris.sparc64_release/bin/obtool -u admin
Password:

ob> mkdev -t library -v -S20 -I2 -o -B yes -a lab1-db1:/opt/product/osb_vdevices/vlib1 vlib1

ob> lsdev
library             lib              in service
  drive 1           drv              in service
library             vlib1            in service
ob> lsdev --long
lib:
    Device type:            library
    Model:                  STK_SL150
    Serial number:          [none]
    In service:             yes
    Debug mode:             no
    Barcode reader:         default (hardware-selected)
    Barcodes required:      yes
    Auto clean:             no
    Clean interval:         (not set)
    Clean using emptiest:   no
    Unload required:        yes
    Ejection type:          auto
    Min writable volumes:   0
    UUID:                   ec7702b6-f49c-1033-a856-b8a2b17acb39
    Attachment 1:
        Host:               lab1-db1
        Raw device:         /dev/scsi/changer/c5t500104F000DDE0ECd1
drv:
    Device type:            tape
    Model:                  [none]
    Serial number:          HUJ5374KRK
    In service:             yes
    Library:                lib
    DTE:                    1
    Automount:              yes
    Error rate:             8
    Position interval:      [undetermined]
    Debug mode:             no
    Blocking factor:        (default)
    Max blocking factor:    (default)
    Current tape:           [unknown]
    Use list:               all
    Drive usage:            [not set]
    Cleaning required:      [unknown]
    UUID:                   d243b748-f49e-1033-a856-b8a2b17acb39
    Attachment 1:
        Host:               lab1-db1
        Raw device:         /dev/scsi/sequential/c5t500104F000DDE0ECd0
vlib1:
    Device type:            library (virtual)
    Model:                  [none]
    Serial number:          [none]
    In service:             yes
    Debug mode:             no
    Barcode reader:         yes
    Barcodes required:      default (as per media policy)
    Auto clean:             no
    Clean interval:         (not set)
    Clean using emptiest:   no
    Ejection type:          auto
    Min writable volumes:   0
    UUID:                   609a2d08-ffa1-1033-ae9e-a26364fa8766
    Attachment 1:
        Host:               lab1-db1
        Raw device:         /opt/product/osb_vdevices/vlib1

ob> mkdev -t tape -v -o -l vlib1 -d1 -a lab1-db1://opt/product/osb_vdevices/vdrive1 vdrive1

ob> lsvol --long --library vlib1
Inventory of library vlib1:
    in    mte:           vacant
    in    1:             vacant
    in    2:             vacant
    in    3:             vacant
    in    4:             vacant
    in    5:             vacant
    in    6:             vacant
    in    7:             vacant
    in    8:             vacant
    in    9:             vacant
    in    10:            vacant
    in    11:            vacant
    in    12:            vacant
    in    13:            vacant
    in    14:            vacant
    in    15:            vacant
    in    16:            vacant
    in    17:            vacant
    in    18:            vacant
    in    19:            vacant
    in    20:            vacant
    in    iee1:          vacant
    in    iee2:          vacant
    in    dte:           vacant

ob> insertvol -L vlib1 unlabeled 1-20

ob> lsvol -l -L vlib1
Inventory of library vlib1:
    in    mte:           vacant
    in    1:             unlabeled, barcode aabdca98ffa110384e4b3ef416d59af, oid 100
    in    2:             unlabeled, barcode aac1ce90ffa110384e4b3ef416d59af, oid 101
    in    3:             unlabeled, barcode aac6984effa110384e4b3ef416d59af, oid 102
    in    4:             unlabeled, barcode aac91178ffa110384e4b3ef416d59af, oid 103
    in    5:             unlabeled, barcode aacb8c50ffa110384e4b3ef416d59af, oid 104
    in    6:             unlabeled, barcode aace1380ffa110384e4b3ef416d59af, oid 105
    in    7:             unlabeled, barcode aad091b4ffa110384e4b3ef416d59af, oid 106
    in    8:             unlabeled, barcode aad308ccffa110384e4b3ef416d59af, oid 107
    in    9:             unlabeled, barcode aad58034ffa110384e4b3ef416d59af, oid 108
    in    10:            unlabeled, barcode aad7fdc8ffa110384e4b3ef416d59af, oid 109
    in    11:            unlabeled, barcode aada7a94ffa110384e4b3ef416d59af, oid 110
    in    12:            unlabeled, barcode aadd3c84ffa110384e4b3ef416d59af, oid 111
    in    13:            unlabeled, barcode aadfe8a8ffa110384e4b3ef416d59af, oid 112
    in    14:            unlabeled, barcode aae291e8ffa110384e4b3ef416d59af, oid 113
    in    15:            unlabeled, barcode aae54d70ffa110384e4b3ef416d59af, oid 114
    in    16:            unlabeled, barcode aae7ed0affa110384e4b3ef416d59af, oid 115
    in    17:            unlabeled, barcode aaea75caffa110384e4b3ef416d59af, oid 116
    in    18:            unlabeled, barcode aaed0038ffa110384e4b3ef416d59af, oid 117
    in    19:            unlabeled, barcode aaef81b4ffa110384e4b3ef416d59af, oid 118
    in    20:            unlabeled, barcode aaf44302ffa110384e4b3ef416d59af, oid 119
    in    iee1:          vacant
    in    iee2:          vacant
    in    dte:           vacant
ob>exit

-bash-4.1$ . oraenv
ORACLE_SID = [lab1] ? desa1
The Oracle base remains unchanged with value /opt/product/rdbms/12.1.0
-bash-4.1$ recov

Recovery Manager: Release 12.1.0.1.0 - Production on Thu May 19 06:26:10 2016

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DESA (DBID=3373992994)
connected to recovery catalog database

RMAN> run
{
allocate channel c1 device type sbt
parms 'ENV=(ob_device=drive1,
OB_MEDIA_FAMILY=OSB-CATALOG-MF)';
backup database include current controlfile;
backup archivelog all not backed up;
}2> 3> 4> 5> 6> 7> 8>

allocated channel: c1
channel c1: SID=362 instance=desa1 device type=SBT_TAPE
channel c1: Oracle Secure Backup

Starting backup at 19-MAY-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00078 name=+DATA/DESA/DATAFILE/sib.715.907007973
input datafile file number=00007 name=+DATA/DESA/DATAFILE/banaclima_idx.644.907007955
input datafile file number=00017 name=+DATA/DESA/DATAFILE/conta_idx.654.907007959
input datafile file number=00124 name=+DATA/DESA/DATAFILE/agp_idx.761.907007985
input datafile file number=00051 name=+DATA/DESA/DATAFILE/pra_idx.688.907007967
input datafile file number=00047 name=+DATA/DESA/DATAFILE/planfca_idx.684.907007965
input datafile file number=00060 name=+DATA/DESA/DATAFILE/sap.697.907007969
input datafile file number=00024 name=+DATA/DESA/DATAFILE/cxp.661.907007959
input datafile file number=00014 name=+DATA/DESA/DATAFILE/cheques.651.907007957
input datafile file number=00015 name=+DATA/DESA/DATAFILE/cheques_idx.652.907007957
input datafile file number=00054 name=+DATA/DESA/DATAFILE/rec.691.907007967
input datafile file number=00080 name=+DATA/DESA/DATAFILE/sip.717.907007973
input datafile file number=00030 name=+DATA/DESA/DATAFILE/fito.667.907007961
input datafile file number=00048 name=+DATA/DESA/DATAFILE/planilla.685.907007965
input datafile file number=00070 name=+DATA/DESA/DATAFILE/seb.707.907007971
input datafile file number=00099 name=+DATA/DESA/DATAFILE/recibos.736.907007979
input datafile file number=00004 name=+DATA/DESA/DATAFILE/bec.635.910972947
input datafile file number=00012 name=+DATA/DESA/DATAFILE/cef.649.907007955
input datafile file number=00021 name=+DATA/DESA/DATAFILE/cus_idx.658.907007959
input datafile file number=00026 name=+DATA/DESA/DATAFILE/des_nat.663.907007961
input datafile file number=00029 name=+DATA/DESA/DATAFILE/exp_idx.666.907007961
input datafile file number=00034 name=+DATA/DESA/DATAFILE/inc.671.907007963
input datafile file number=00039 name=+DATA/DESA/DATAFILE/leg_idx.676.907007963
input datafile file number=00044 name=+DATA/DESA/DATAFILE/pcs.681.907007965
input datafile file number=00053 name=+DATA/DESA/DATAFILE/qui_idx.690.907007967
input datafile file number=00064 name=+DATA/DESA/DATAFILE/scl.701.907007969
input datafile file number=00067 name=+DATA/DESA/DATAFILE/scv_idx.704.907007971
input datafile file number=00072 name=+DATA/DESA/DATAFILE/sei.709.907007971
input datafile file number=00075 name=+DATA/DESA/DATAFILE/ste_idx.712.907007973
input datafile file number=00081 name=+DATA/DESA/DATAFILE/sip_idx.718.907007973
input datafile file number=00084 name=+DATA/DESA/DATAFILE/spc.721.907007975
input datafile file number=00089 name=+DATA/DESA/DATAFILE/votos_idx.726.907007975
input datafile file number=00092 name=+DATA/DESA/DATAFILE/clt.729.907007977
input datafile file number=00095 name=+DATA/DESA/DATAFILE/cxc_viejo_idx.732.907007977
input datafile file number=00098 name=+DATA/DESA/DATAFILE/fondos_ley_idx.735.907007979
input datafile file number=00102 name=+DATA/DESA/DATAFILE/sca_idx.739.907007979
input datafile file number=00105 name=+DATA/DESA/DATAFILE/ssu.742.907007979
input datafile file number=00108 name=+DATA/DESA/DATAFILE/sue_idx.745.907007981
input datafile file number=00112 name=+DATA/DESA/DATAFILE/auditoria_idx.749.907007981
input datafile file number=00115 name=+DATA/DESA/DATAFILE/ger_apex.752.907007983
input datafile file number=00118 name=+DATA/DESA/DATAFILE/side_acf.755.907007983
input datafile file number=00121 name=+DATA/DESA/DATAFILE/side_ind_acf.758.907007983
input datafile file number=00126 name=+DATA/DESA/DATAFILE/dti_apex.763.907007985
input datafile file number=00129 name=+DATA/DESA/DATAFILE/apex_ban.766.907007985
input datafile file number=00132 name=+DATA/DESA/DATAFILE/per.769.907007987
input datafile file number=00135 name=+DATA/DESA/DATAFILE/dev_mds.772.907007987
input datafile file number=00138 name=+DATA/DESA/DATAFILE/dev_oam.775.907007989
input datafile file number=00142 name=+DATA/DESA/DATAFILE/olts_attrstore.779.907007989
input datafile file number=00145 name=+DATA/DESA/DATAFILE/bio.782.907007989
input datafile file number=00148 name=+DATA/DESA/DATAFILE/sci.785.907007991
input datafile file number=00151 name=+DATA/DESA/DATAFILE/bdi_idx.788.907007991
input datafile file number=00154 name=+DATA/DESA/DATAFILE/apex_per.637.911470385
channel c1: starting piece 1 at 19-MAY-16
channel c1: starting piece 1 at 19-MAY-16
channel c1: finished piece 1 at 19-MAY-16
piece handle=05r5v5sd_1_1 tag=TAG20160519T062618 comment=API Version 2.0,MMS Version 12.1.0.2
channel c1: backup set complete, elapsed time: 00:01:25
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/DESA/DATAFILE/sysaux.632.907007209
input datafile file number=00079 name=+DATA/DESA/DATAFILE/sib_idx.716.907007973
input datafile file number=00001 name=+DATA/DESA/DATAFILE/system.633.907007305
input datafile file number=00046 name=+DATA/DESA/DATAFILE/planfca.683.907007965
input datafile file number=00050 name=+DATA/DESA/DATAFILE/pra.687.907007967
input datafile file number=00037 name=+DATA/DESA/DATAFILE/inventario_idx.674.907007963
input datafile file number=00059 name=+DATA/DESA/DATAFILE/saf_idx.696.907007969
input datafile file number=00155 name=+DATA/DESA/DATAFILE/undotbs1.832.912164755
input datafile file number=00071 name=+DATA/DESA/DATAFILE/seb_idx.708.907007971
input datafile file number=00040 name=+DATA/DESA/DATAFILE/ncd.677.907007963
input datafile file number=00058 name=+DATA/DESA/DATAFILE/saf.695.907007969
input datafile file number=00009 name=+DATA/DESA/DATAFILE/bitacoras_idx.646.907007955
input datafile file number=00022 name=+DATA/DESA/DATAFILE/cxc.659.907007959
input datafile file number=00041 name=+DATA/DESA/DATAFILE/ncd_idx.678.907007965
input datafile file number=00057 name=+DATA/DESA/DATAFILE/retencion_idx.694.907007967
input datafile file number=00087 name=+DATA/DESA/DATAFILE/vehiculos_idx.724.907007975
input datafile file number=00006 name=+DATA/DESA/DATAFILE/users.634.907007411
input datafile file number=00011 name=+DATA/DESA/DATAFILE/cab_idx.648.907007955
input datafile file number=00020 name=+DATA/DESA/DATAFILE/cus.657.907007959
input datafile file number=00025 name=+DATA/DESA/DATAFILE/cxp_idx.662.907007961
input datafile file number=00028 name=+DATA/DESA/DATAFILE/exp.665.907007961
input datafile file number=00033 name=+DATA/DESA/DATAFILE/general_idx.670.907007963
input datafile file number=00038 name=+DATA/DESA/DATAFILE/leg.675.907007963
input datafile file number=00043 name=+DATA/DESA/DATAFILE/nema_idx.680.907007965
input datafile file number=00049 name=+DATA/DESA/DATAFILE/planilla_idx.686.907007965
input datafile file number=00063 name=+DATA/DESA/DATAFILE/sbl_idx.700.907007969
input datafile file number=00066 name=+DATA/DESA/DATAFILE/scv.703.907007971
input datafile file number=00069 name=+DATA/DESA/DATAFILE/sdi_idx.706.907007971
input datafile file number=00074 name=+DATA/DESA/DATAFILE/ste.711.907007973
input datafile file number=00077 name=+DATA/DESA/DATAFILE/sgd_idx.714.907007973
input datafile file number=00083 name=+DATA/DESA/DATAFILE/soporte_idx.720.907007975
input datafile file number=00088 name=+DATA/DESA/DATAFILE/votos.725.907007975
input datafile file number=00091 name=+DATA/DESA/DATAFILE/cheque_viejo_idx.728.907007977
input datafile file number=00094 name=+DATA/DESA/DATAFILE/cxc_viejo.731.907007977
input datafile file number=00097 name=+DATA/DESA/DATAFILE/fondos_ley.734.907007977
input datafile file number=00101 name=+DATA/DESA/DATAFILE/sca.738.907007979
input datafile file number=00104 name=+DATA/DESA/DATAFILE/sin_idx.741.907007979
input datafile file number=00107 name=+DATA/DESA/DATAFILE/sue.744.907007981
input datafile file number=00111 name=+DATA/DESA/DATAFILE/auditoria.748.907007981
input datafile file number=00114 name=+DATA/DESA/DATAFILE/sf1_idx.751.907007983
input datafile file number=00117 name=+DATA/DESA/DATAFILE/side_seg.754.907007983
input datafile file number=00120 name=+DATA/DESA/DATAFILE/side_gen.757.907007983
input datafile file number=00125 name=+DATA/DESA/DATAFILE/dev_ias_iau.762.907007985
input datafile file number=00128 name=+DATA/DESA/DATAFILE/apex_ger.765.907007985
input datafile file number=00131 name=+DATA/DESA/DATAFILE/cf1_idx.768.907007987
input datafile file number=00134 name=+DATA/DESA/DATAFILE/dev_oim_lob.771.907007987
input datafile file number=00137 name=+DATA/DESA/DATAFILE/dev_ias_orasdpm.774.907007987
input datafile file number=00141 name=+DATA/DESA/DATAFILE/olts_battrstore.778.907007989
input datafile file number=00144 name=+DATA/DESA/DATAFILE/olts_ct_store.781.907007989
input datafile file number=00147 name=+DATA/DESA/DATAFILE/odac.784.907007991
input datafile file number=00150 name=+DATA/DESA/DATAFILE/bdi.787.907007991
input datafile file number=00153 name=+DATA/DESA/DATAFILE/bec_idx.638.910973217
channel c1: starting piece 1 at 19-MAY-16
channel c1: finished piece 1 at 19-MAY-16
piece handle=06r5v5v4_1_1 tag=TAG20160519T062618 comment=API Version 2.0,MMS Version 12.1.0.2
channel c1: backup set complete, elapsed time: 00:01:15
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/DESA/DATAFILE/banaclima.643.907007953
input datafile file number=00016 name=+DATA/DESA/DATAFILE/conta.653.907007957
input datafile file number=00008 name=+DATA/DESA/DATAFILE/bitacoras.645.907007955
input datafile file number=00061 name=+DATA/DESA/DATAFILE/sap_idx.698.907007969
input datafile file number=00123 name=+DATA/DESA/DATAFILE/agp.760.907007985
input datafile file number=00055 name=+DATA/DESA/DATAFILE/rec_idx.692.907007967
input datafile file number=00002 name=+DATA/DESA/DATAFILE/undotbs2.640.907007491
input datafile file number=00018 name=+DATA/DESA/DATAFILE/credito.655.907007959
input datafile file number=00036 name=+DATA/DESA/DATAFILE/inventario.673.907007963
input datafile file number=00019 name=+DATA/DESA/DATAFILE/credito_idx.656.907007959
input datafile file number=00056 name=+DATA/DESA/DATAFILE/retencion.693.907007967
input datafile file number=00110 name=+DATA/DESA/DATAFILE/apex.747.907007981
input datafile file number=00032 name=+DATA/DESA/DATAFILE/general.669.907007961
input datafile file number=00052 name=+DATA/DESA/DATAFILE/qui.689.907007967
input datafile file number=00086 name=+DATA/DESA/DATAFILE/vehiculos.723.907007975
input datafile file number=00139 name=+DATA/DESA/DATAFILE/dev_oim.776.907007989
input datafile file number=00010 name=+DATA/DESA/DATAFILE/cab.647.907007955
input datafile file number=00013 name=+DATA/DESA/DATAFILE/cef_idx.650.907007957
input datafile file number=00023 name=+DATA/DESA/DATAFILE/cxc_idx.660.907007959
input datafile file number=00027 name=+DATA/DESA/DATAFILE/des_nat_idx.664.907007961
input datafile file number=00031 name=+DATA/DESA/DATAFILE/fito_idx.668.907007961
input datafile file number=00035 name=+DATA/DESA/DATAFILE/inc_idx.672.907007963
input datafile file number=00042 name=+DATA/DESA/DATAFILE/nema.679.907007965
input datafile file number=00045 name=+DATA/DESA/DATAFILE/pcs_idx.682.907007965
input datafile file number=00062 name=+DATA/DESA/DATAFILE/sbl.699.907007969
input datafile file number=00065 name=+DATA/DESA/DATAFILE/scl_idx.702.907007969
input datafile file number=00068 name=+DATA/DESA/DATAFILE/sdi.705.907007971
input datafile file number=00073 name=+DATA/DESA/DATAFILE/sei_idx.710.907007973
input datafile file number=00076 name=+DATA/DESA/DATAFILE/sgd.713.907007973
input datafile file number=00082 name=+DATA/DESA/DATAFILE/soporte.719.907007975
input datafile file number=00085 name=+DATA/DESA/DATAFILE/spc_idx.722.907007975
input datafile file number=00090 name=+DATA/DESA/DATAFILE/cheque_viejo.727.907007977
input datafile file number=00093 name=+DATA/DESA/DATAFILE/clt_idx.730.907007977
input datafile file number=00096 name=+DATA/DESA/DATAFILE/cxp_viejo.733.907007977
input datafile file number=00100 name=+DATA/DESA/DATAFILE/recibos_idx.737.907007979
input datafile file number=00103 name=+DATA/DESA/DATAFILE/sin.740.907007979
input datafile file number=00106 name=+DATA/DESA/DATAFILE/ssu_idx.743.907007981
input datafile file number=00109 name=+DATA/DESA/DATAFILE/webutil.746.907007981
input datafile file number=00113 name=+DATA/DESA/DATAFILE/sf1.750.907007981
input datafile file number=00116 name=+DATA/DESA/DATAFILE/segweb.753.907007983
input datafile file number=00119 name=+DATA/DESA/DATAFILE/side_con.756.907007983
input datafile file number=00122 name=+DATA/DESA/DATAFILE/side_ind_adm.759.907007985
input datafile file number=00127 name=+DATA/DESA/DATAFILE/apex_sat.764.907007985
input datafile file number=00130 name=+DATA/DESA/DATAFILE/cf1.767.907007987
input datafile file number=00133 name=+DATA/DESA/DATAFILE/per_idx.770.907007987
input datafile file number=00136 name=+DATA/DESA/DATAFILE/dev_soainfra.773.907007987
input datafile file number=00140 name=+DATA/DESA/DATAFILE/olts_default.777.907007989
input datafile file number=00143 name=+DATA/DESA/DATAFILE/olts_svrmgstore.780.907007989
input datafile file number=00146 name=+DATA/DESA/DATAFILE/bio_idx.783.907007991
input datafile file number=00149 name=+DATA/DESA/DATAFILE/sci_idx.786.907007991
input datafile file number=00152 name=+DATA/DESA/DATAFILE/pruebas_apex.792.907008337
channel c1: starting piece 1 at 19-MAY-16
channel c1: starting piece 1 at 19-MAY-16
channel c1: finished piece 1 at 19-MAY-16
piece handle=07r5v61h_1_1 tag=TAG20160519T062618 comment=API Version 2.0,MMS Version 12.1.0.2
channel c1: backup set complete, elapsed time: 00:01:15
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 19-MAY-16
channel c1: finished piece 1 at 19-MAY-16
piece handle=08r5v63s_1_1 tag=TAG20160519T062618 comment=API Version 2.0,MMS Version 12.1.0.2
channel c1: backup set complete, elapsed time: 00:00:15
Finished backup at 19-MAY-16

Starting backup at 19-MAY-16
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=860 RECID=1 STAMP=912234642
input archived log thread=2 sequence=1404 RECID=2 STAMP=912234643
channel c1: starting piece 1 at 19-MAY-16
channel c1: finished piece 1 at 19-MAY-16
piece handle=09r5v64l_1_1 tag=TAG20160519T063045 comment=API Version 2.0,MMS Version 12.1.0.2
channel c1: backup set complete, elapsed time: 00:00:16
Finished backup at 19-MAY-16
released channel: c1


RMAN>


No hay comentarios:

Publicar un comentario

Te agradezco tus comentarios. Te esperamos de vuelta.

Todos los Sábados a las 8:00PM

Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar