XKYDR计划内停机业务系统维护过程

# prtconf
System Model: IBM,8202-E4B
Machine Serial Number: 06954CP
Processor Type: PowerPC_POWER7
Processor Implementation Mode: POWER 7
Processor Version: PV_7_Compat
Number Of Processors: 8
Processor Clock Speed: 3000 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 1 06-954CP
Memory Size: 15488 MB
Good Memory Size: 15488 MB
Platform Firmware level: AL720_090
Firmware Version: IBM,AL720_090
Console Login: enable
Auto Restart: true
Full Core: false

Network Information
        Host Name: db1
        IP Address: 192.168.15.104
        Sub Netmask: 255.255.255.0
        Gateway: 192.168.15.7
        Name Server:
        Domain Name:

Paging Space Information
        Total Paging Space: 32768MB
        Percent Used: 1%

Volume Groups Information
==============================================================================
rootvg:
PV_NAME           PV STATE          TOTAL PPs   FREE PPs    FREE DISTRIBUTION
hdisk0            active            546         272         54..00..00..109..109
==============================================================================

INSTALLED RESOURCE LIST

The following resources are installed on the machine.
+/- = Added or deleted from Resource List.
*   = Diagnostic support not available.

  Model Architecture: chrp
  Model Implementation: Multiple Processor, PCI bus

+ sys0                                                                          System Object
+ sysplanar0                                                                    System Planar
* vio0                                                                          Virtual I/O Bus
* vsa1             U78AA.001.WZSGD4A-P1-T2                                      LPAR Virtual Serial Adapter
* vty1             U78AA.001.WZSGD4A-P1-T2-L0                                   Asynchronous Terminal
* vsa0             U78AA.001.WZSGD4A-P1-T1                                      LPAR Virtual Serial Adapter
* vty0             U78AA.001.WZSGD4A-P1-T1-L0                                   Asynchronous Terminal
* pci6             U78AA.001.WZSGD4A-P1                                         PCI Express Bus
+ ent4             U78AA.001.WZSGD4A-P1-C7-T1                                   2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
+ ent5             U78AA.001.WZSGD4A-P1-C7-T2                                   2-Port 10/100/1000 Base-TX PCI-Express Adapter (14104003)
* pci5             U78AA.001.WZSGD4A-P1                                         PCI Express Bus
+ fcs0             U78AA.001.WZSGD4A-P1-C6-T1                                   4Gb FC PCI Express Adapter (df1000fe)
+ fscsi0           U78AA.001.WZSGD4A-P1-C6-T1                                   FC SCSI I/O Controller Protocol Device
* hdisk4           U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L3000000000000  MPIO Other DS4K Array Disk
* hdisk5           U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L4000000000000  MPIO Other DS4K Array Disk
* hdisk6           U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L5000000000000  MPIO Other DS4K Array Disk
* hdisk7           U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L6000000000000  MPIO Other DS4K Array Disk
* hdisk8           U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L7000000000000  MPIO Other DS4K Array Disk
* hdisk9           U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L8000000000000  MPIO Other DS4K Array Disk
* hdisk10          U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-L9000000000000  MPIO Other DS4K Array Disk
* hdisk11          U78AA.001.WZSGD4A-P1-C6-T1-W200400A0B850D3BB-LA000000000000  MPIO Other DS4K Array Disk
* sfwcomm0         U78AA.001.WZSGD4A-P1-C6-T1-W0-L0                             Fibre Channel Storage Framework Comm
* fcnet0           U78AA.001.WZSGD4A-P1-C6-T1                                   Fibre Channel Network Protocol Device
+ fcs1             U78AA.001.WZSGD4A-P1-C6-T2                                   4Gb FC PCI Express Adapter (df1000fe)
+ fscsi1           U78AA.001.WZSGD4A-P1-C6-T2                                   FC SCSI I/O Controller Protocol Device
* hdisk1           U78AA.001.WZSGD4A-P1-C6-T2-W200500A0B850D3BB-L0              MPIO Other DS4K Array Disk
* hdisk2           U78AA.001.WZSGD4A-P1-C6-T2-W200500A0B850D3BB-L1000000000000  MPIO Other DS4K Array Disk
* hdisk3           U78AA.001.WZSGD4A-P1-C6-T2-W200500A0B850D3BB-L2000000000000  MPIO Other DS4K Array Disk
* sfwcomm1         U78AA.001.WZSGD4A-P1-C6-T2-W0-L0                             Fibre Channel Storage Framework Comm
* fcnet1           U78AA.001.WZSGD4A-P1-C6-T2                                   Fibre Channel Network Protocol Device
* pci4             U78AA.001.WZSGD4A-P1                                         PCI Express Bus
* pci3             U78AA.001.WZSGD4A-P1                                         PCI Express Bus
* pci2             U78AA.001.WZSGD4A-P1                                         PCI Bus
* pci1             U78AA.001.WZSGD4A-P1                                         PCI Bus
+ usbhc0           U78AA.001.WZSGD4A-P1                                         USB Host Controller (33103500)
+ usbhc1           U78AA.001.WZSGD4A-P1                                         USB Host Controller (33103500)
+ usbhc2           U78AA.001.WZSGD4A-P1                                         USB Enhanced Host Controller (3310e000)
* pci0             U78AA.001.WZSGD4A-P1                                         PCI Bus
+ sissas0          U78AA.001.WZSGD4A-P1-T9                                      PCI-X266 Planar 3Gb SAS Adapter
* sas0             U78AA.001.WZSGD4A-P1-T9                                      Controller SAS Protocol
* sfwcomm2                                                                      SAS Storage Framework Comm
+ hdisk0           U78AA.001.WZSGD4A-P2-D1                                      SAS Disk Drive (146800 MB)
+ ses0             U78AA.001.WZSGD4A-P2-Y1                                      SAS Enclosure Services Device
+ ses1             U78AA.001.WZSGD4A-P2-Y1                                      SAS Enclosure Services Device
* sata0            U78AA.001.WZSGD4A-P1-T9                                      Controller SATA Protocol
+ cd0              U78AA.001.WZSGD4A-P2-D9                                      SATA DVD-RAM Drive
* lhea0            U78AA.001.WZSGD4A-P1                                         Logical Host Ethernet Adapter (l-hea)
+ ent3             U78AA.001.WZSGD4A-P1-C3-T4                                   Logical Host Ethernet Port (lp-hea)
+ ent2             U78AA.001.WZSGD4A-P1-C3-T3                                   Logical Host Ethernet Port (lp-hea)
+ ent1             U78AA.001.WZSGD4A-P1-C3-T2                                   Logical Host Ethernet Port (lp-hea)
+ ent0             U78AA.001.WZSGD4A-P1-C3-T1                                   Logical Host Ethernet Port (lp-hea)
+ L2cache0                                                                      L2 Cache
+ mem0                                                                          Memory
+ proc0                                                                         Processor
+ proc4                                                                         Processor
+ proc8                                                                         Processor
+ proc12                                                                        Processor
+ proc16                                                                        Processor
+ proc20                                                                        Processor
+ proc24                                                                        Processor
+ proc28                                                                        Processor
#

# lsattr -El sys0 -a realmem
realmem 15859712 Amount of usable physical memory in Kbytes False

# oslevel -s
6100-06-05-1115

# lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active  Auto  Type Chksum
hd6             hdisk0            rootvg       32768MB     1   yes   yes    lv     0

lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte \
xlC.aix61.rte

# vmo -a
             ame_cpus_per_pool = n/a
               ame_maxfree_mem = n/a
           ame_min_ucpool_size = n/a
               ame_minfree_mem = n/a
               ams_loan_policy = n/a
  enhanced_affinity_affin_time = 1
enhanced_affinity_vmpool_limit = 10
                esid_allocator = 0
           force_relalias_lite = 0
             kernel_heap_psize = 65536
                  lgpg_regions = 0
                     lgpg_size = 0
               low_ps_handling = 1
                       maxfree = 1088
                       maxperm = 3439785
                        maxpin = 3196125
                       maxpin% = 80
                 memory_frames = 3964928
                 memplace_data = 0
          memplace_mapped_file = 0
        memplace_shm_anonymous = 0
            memplace_shm_named = 0
                memplace_stack = 0
                 memplace_text = 0
        memplace_unmapped_file = 0
                       minfree = 960
                       minperm = 114658
                      minperm% = 3
                     nokilluid = 0
                       npskill = 65536
                       npswarn = 262144
           num_locks_per_semid = 1
                     numpsblks = 8388608
               pinnable_frames = 3608544
           relalias_percentage = 0
                         scrub = 0
                      v_pinshm = 0
              vmm_default_pspa = 0
                vmm_klock_mode = 1
            wlm_memlimit_nonpg = 1

# no -a
                 arpqsize = 12
               arpt_killc = 20
              arptab_bsiz = 7
                arptab_nb = 149
                bcastping = 0
      clean_partial_conns = 0
                 delayack = 0
            delayackports = {}
   dgd_flush_cached_route = 0
         dgd_packets_lost = 3
            dgd_ping_time = 5
           dgd_retry_time = 5
       directed_broadcast = 0
                 fasttimo = 200
        icmp6_errmsg_rate = 10
          icmpaddressmask = 0
ie5_old_multicast_mapping = 0
                   ifsize = 256
           igmpv2_deliver = 0
               ip6_defttl = 64
                ip6_prune = 1
            ip6forwarding = 0
       ip6srcrouteforward = 1
       ip_ifdelete_notify = 0
                 ip_nfrag = 200
             ipforwarding = 0
                ipfragttl = 2
        ipignoreredirects = 0
                ipqmaxlen = 100
          ipsendredirects = 1
        ipsrcrouteforward = 1
           ipsrcrouterecv = 0
           ipsrcroutesend = 1
          llsleep_timeout = 3
                  lo_perf = 1
                lowthresh = 90
                 main_if6 = 0
               main_site6 = 0
                 maxnip6q = 20
                   maxttl = 255
                medthresh = 95
               mpr_policy = 1
              multi_homed = 1
                nbc_limit = 1982464
            nbc_max_cache = 131072
            nbc_min_cache = 1
         nbc_ofile_hashsz = 12841
                 nbc_pseg = 0
           nbc_pseg_limit = 3964928
           ndd_event_name = {all}
        ndd_event_tracing = 0
            ndp_mmaxtries = 3
            ndp_umaxtries = 3
                 ndpqsize = 50
                ndpt_down = 3
                ndpt_keep = 120
               ndpt_probe = 5
           ndpt_reachable = 30
             ndpt_retrans = 1
             net_buf_size = {all}
             net_buf_type = {all}
     net_malloc_frag_mask = {0}
        netm_page_promote = 1
           nonlocsrcroute = 0
                 nstrpush = 8
              passive_dgd = 0
         pmtu_default_age = 10
              pmtu_expire = 10
 pmtu_rediscover_interval = 30
              poolbuckets = 4
              psebufcalls = 20
                 psecache = 1
                psetimers = 20
           rfc1122addrchk = 0
                  rfc1323 = 1
                  rfc2414 = 1
             route_expire = 1
          routerevalidate = 0
     rtentry_lock_complex = 0
                 rto_high = 64
               rto_length = 13
                rto_limit = 7
                  rto_low = 1
                     sack = 0
                   sb_max = 1310720
       send_file_duration = 300
              site6_index = 0
               sockthresh = 85
                  sodebug = 0
              sodebug_env = 0
                somaxconn = 1024
                 strctlsz = 1024
                 strmsgsz = 0
                strthresh = 85
               strturncnt = 15
          subnetsarelocal = 1
       tcp_bad_port_limit = 0
                  tcp_ecn = 0
       tcp_ephemeral_high = 65535
        tcp_ephemeral_low = 32768
               tcp_fastlo = 0
     tcp_fastlo_crosswpar = 1
             tcp_finwait2 = 1200
           tcp_icmpsecure = 0
          tcp_init_window = 0
    tcp_inpcb_hashtab_siz = 24499
              tcp_keepcnt = 8
             tcp_keepidle = 14400
             tcp_keepinit = 150
            tcp_keepintvl = 150
     tcp_limited_transmit = 1
              tcp_low_rto = 0
             tcp_maxburst = 0
              tcp_mssdflt = 1460
          tcp_nagle_limit = 65535
        tcp_nagleoverride = 0
               tcp_ndebug = 100
              tcp_newreno = 1
           tcp_nodelayack = 0
        tcp_pmtu_discover = 1
            tcp_recvspace = 262144
            tcp_sendspace = 262144
            tcp_tcpsecure = 0
             tcp_timewait = 1
                  tcp_ttl = 60
           tcprexmtthresh = 3
             tcptr_enable = 0
                  thewall = 7929856
         timer_wheel_tick = 0
                tn_filter = 1
       udp_bad_port_limit = 0
       udp_ephemeral_high = 65535
        udp_ephemeral_low = 32768
    udp_inpcb_hashtab_siz = 24499
        udp_pmtu_discover = 1
            udp_recvspace = 262144
            udp_sendspace = 65536
                  udp_ttl = 30
                 udpcksum = 1
           use_sndbufpool = 1
#

mkgroup -'A' id='1000' adms='root' oinstall
mkgroup -'A' id='1100' adms='root' asmadmin
mkgroup -'A' id='1200' adms='root' dba
mkgroup -'A' id='1300' adms='root' asmdba
mkgroup -'A' id='1301' adms='root' asmoper
mkuser id='1100' pgrp='oinstall' groups='asmadmin,asmdba,asmoper' home='/home/grid' grid
mkuser id='1101' pgrp='oinstall' groups='dba,asmdba' home='/home/oracle' oracle

chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid

chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

grid:profile
export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid_1

export PATH=$ORACLE_HOME/bin:$PATH

oracle:profile
export ORACLE_SID=orcl2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORA_GRID_HOME=/u01/app/11.2.0/grid_1

export PATH=$ORACLE_HOME/bin:$ORA_GRID_HOME/bin:$PATH



chdev -l hdisk1 -a reserve_policy=no_reserve
chdev -l hdisk2 -a reserve_policy=no_reserve
chdev -l hdisk3 -a reserve_policy=no_reserve
chdev -l hdisk4 -a reserve_policy=no_reserve
chdev -l hdisk5 -a reserve_policy=no_reserve
chdev -l hdisk6 -a reserve_policy=no_reserve
chdev -l hdisk7 -a reserve_policy=no_reserve
chdev -l hdisk8 -a reserve_policy=no_reserve
chdev -l hdisk9 -a reserve_policy=no_reserve
chdev -l hdisk10 -a reserve_policy=no_reserve
chdev -l hdisk11 -a reserve_policy=no_reserve

chdev -l hdisk13 -a reserve_policy=no_reserve
chmod 660 /dev/rhdisk13
chown grid:asmadmin /dev/rhdisk13


chmod 660 /dev/rhdisk1
chmod 660 /dev/rhdisk2
chmod 660 /dev/rhdisk3
chmod 660 /dev/rhdisk4
chmod 660 /dev/rhdisk5
chmod 660 /dev/rhdisk6
chmod 660 /dev/rhdisk7
chmod 660 /dev/rhdisk8
chmod 660 /dev/rhdisk9
chmod 660 /dev/rhdisk10
chmod 660 /dev/rhdisk11

chown grid:asmadmin /dev/rhdisk1
chown grid:asmadmin /dev/rhdisk2
chown grid:asmadmin /dev/rhdisk3
chown grid:asmadmin /dev/rhdisk4
chown grid:asmadmin /dev/rhdisk5
chown grid:asmadmin /dev/rhdisk6
chown grid:asmadmin /dev/rhdisk7
chown grid:asmadmin /dev/rhdisk8
chown grid:asmadmin /dev/rhdisk9
chown grid:asmadmin /dev/rhdisk10
chown grid:asmadmin /dev/rhdisk11

mkdir -p /u01/app/grid/11.2.0
mkdir -p /u01/app/oracle/product/11.2.0
mkdir -p /u01/app/11.2.0/grid
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01/app/11.2.0/grid
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app

./sshsetup/sshUserSetup.sh -user grid -hosts "db1 db2" -advanced noPromptPassphrase
./sshsetup/sshUserSetup.sh -user oracle -hosts "db1 db2" -advanced noPromptPassphrase


# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
# /u01/app/11.2.0/grid_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid_1/crs/install/crsconfig   _params
Creating trace directory
User ignored Prerequisites during installation
User grid has the required capabilities to run CSSD in realtime mode
OLR initialization - successful
  root wallet
  root wallet cert
  root cert export
  peer wallet
  profile reader wallet
  pa wallet
  peer wallet keys
  pa wallet keys
  peer cert request
  pa cert request
  peer cert
  pa cert
  peer root cert TP
  profile reader root cert TP
  pa root cert TP
  peer pa cert TP
  pa peer cert TP
  profile reader pa cert TP
  profile reader peer cert TP
  peer user cert
  pa user cert
Adding Clusterware entries to inittab
CRS-2672: Attempting to start 'ora.mdnsd' on 'db1'
CRS-2676: Start of 'ora.mdnsd' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'db1'
CRS-2676: Start of 'ora.gpnpd' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db1'
CRS-2672: Attempting to start 'ora.gipcd' on 'db1'
CRS-2676: Start of 'ora.cssdmonitor' on 'db1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'db1'
CRS-2672: Attempting to start 'ora.diskmon' on 'db1'
CRS-2676: Start of 'ora.diskmon' on 'db1' succeeded
CRS-2676: Start of 'ora.cssd' on 'db1' succeeded

ASM created and started successfully.

Disk Group DGCRS created successfully.

clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk aa1fc41dd57a4f2cbf12a168588e8d90.
Successfully replaced voting disk group with +DGCRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   aa1fc41dd57a4f2cbf12a168588e8d90 (/dev/rhdisk1) [DGCRS]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'db1'
CRS-2676: Start of 'ora.asm' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.DGCRS.dg' on 'db1'
CRS-2676: Start of 'ora.DGCRS.dg' on 'db1' succeeded
CRS-2672: Attempting to start 'ora.registry.acfs' on 'db1'
CRS-2676: Start of 'ora.registry.acfs' on 'db1' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
#

db2
***************************************************************************
# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
# /u01/app/11.2.0/grid_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid_1/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
User grid has the required capabilities to run CSSD in realtime mode
OLR initialization - successful
Adding Clusterware entries to inittab
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node db1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
#
*******************************************************************************


#
# /u01/app/oracle/product/11.2.0/db_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
#


$ srvctl add service -d orcl -s hbzyhis -r "orcl1,orcl2" -P basic



https://db1:1158/em

https://db1:5500/em


$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Sun May 12 23:36:26 2013

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

connected to target database: ORCL (DBID=1280539424)

RMAN> run
2> {
3> allocate channel d1 type disk;
4> backup database format '/u01bak/a/orcl-db-full%d%t%s%p' tag 'fullbackup';
5> backup format '/u01bak/a/orcl-archlog-%s-%p-5h' archivelog all;
6> backup format '/u01bak/a/ctl-%d-%s-%p' (current controlfile);
7> }

using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=1543 instance=orcl1 device type=DISK

Starting backup at 12-MAY-2013   23:40:35
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=+ORADATA/orcl/datafile/system.259.752758697
input datafile file number=00002 name=+ORADATA/orcl/datafile/sysaux.260.752758705
input datafile file number=00006 name=+ORADATA/orcl/datafile/lchis.268.752770829
input datafile file number=00007 name=+ORADATA/orcl/datafile/lchis.269.752770845
input datafile file number=00008 name=+ORADATA/orcl/datafile/lchis.270.752770861
input datafile file number=00009 name=+ORADATA/orcl/datafile/lchis.271.752770877
input datafile file number=00010 name=+ORADATA/orcl/datafile/lchis.272.752770893
input datafile file number=00011 name=+ORADATA/orcl/datafile/lchis2007.273.752770981
input datafile file number=00012 name=+ORADATA/orcl/datafile/lchis2008.274.752771167
input datafile file number=00013 name=+ORADATA/orcl/datafile/lchis2008.275.752771183
input datafile file number=00014 name=+ORADATA/orcl/datafile/lchis2008.276.752771201
input datafile file number=00015 name=+ORADATA/orcl/datafile/lchis2009.277.752771349
input datafile file number=00016 name=+ORADATA/orcl/datafile/lchis2009.278.752771365
input datafile file number=00017 name=+ORADATA/orcl/datafile/lchis2009.279.752771381
input datafile file number=00018 name=+ORADATA/orcl/datafile/lchis2010.280.752771443
input datafile file number=00019 name=+ORADATA/orcl/datafile/lchis2010.281.752771459
input datafile file number=00020 name=+ORADATA/orcl/datafile/lchis2010.282.752771473
input datafile file number=00021 name=+ORADATA/orcl/datafile/lchis2011.283.752771603
input datafile file number=00022 name=+ORADATA/orcl/datafile/lchis2011.284.752771619
input datafile file number=00023 name=+ORADATA/orcl/datafile/lchis2011.285.752771635
input datafile file number=00024 name=+ORADATA/orcl/datafile/lchis2011.286.752771651
input datafile file number=00025 name=+ORADATA/orcl/datafile/lchis2011.287.752771667
input datafile file number=00026 name=+ORADATA/orcl/datafile/lchis2012.288.752771845
input datafile file number=00027 name=+ORADATA/orcl/datafile/lchis2012.289.752771859
input datafile file number=00028 name=+ORADATA/orcl/datafile/lchis2012.290.752771875
input datafile file number=00029 name=+ORADATA/orcl/datafile/lchis2012.291.752771891
input datafile file number=00030 name=+ORADATA/orcl/datafile/lchis2012.292.752771907
input datafile file number=00031 name=+ORADATA/orcl/datafile/users.293.752771955
input datafile file number=00032 name=+ORADATA/orcl/datafile/users.294.752772049
input datafile file number=00033 name=+ORADATA/orcl/datafile/users.295.752772093
input datafile file number=00034 name=+ORADATA/orcl/datafile/users.296.752772239
input datafile file number=00035 name=+ORADATA/orcl/datafile/users.297.752772255
input datafile file number=00036 name=+ORADATA/orcl/datafile/users.298.752772271
input datafile file number=00037 name=+ORADATA/orcl/datafile/users.299.752772287
input datafile file number=00038 name=+ORADATA/orcl/datafile/users.300.752772303
input datafile file number=00039 name=+ORADATA/orcl/datafile/users.301.752772319
input datafile file number=00040 name=+ORADATA/orcl/datafile/users.302.752772335
input datafile file number=00041 name=+ORADATA/orcl/datafile/lchis2012.0908
input datafile file number=00042 name=+ORADATA/orcl/datafile/users.20120908
input datafile file number=00003 name=+ORADATA/orcl/datafile/undotbs1.261.752758709
input datafile file number=00004 name=+ORADATA/orcl/datafile/undotbs2.263.752758731
input datafile file number=00005 name=+ORADATA/orcl/datafile/users.264.752758739
channel d1: starting piece 1 at 12-MAY-2013   23:40:37
channel d1: finished piece 1 at 12-MAY-2013   23:50:43
piece handle=/u01bak/a/orcl-db-fullORCL81526923621061 tag=FULLBACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:10:06
Finished backup at 12-MAY-2013   23:50:43

Starting backup at 12-MAY-2013   23:50:44
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3385 RECID=7066 STAMP=805305658
input archived log thread=2 sequence=3701 RECID=7068 STAMP=805333184
input archived log thread=1 sequence=3386 RECID=7067 STAMP=805333179
input archived log thread=1 sequence=3387 RECID=7069 STAMP=805379330
input archived log thread=2 sequence=3702 RECID=7071 STAMP=805419558
input archived log thread=1 sequence=3388 RECID=7070 STAMP=805419555
input archived log thread=1 sequence=3389 RECID=7072 STAMP=805471845
input archived log thread=2 sequence=3703 RECID=7074 STAMP=805505956
input archived log thread=1 sequence=3390 RECID=7073 STAMP=805505951
input archived log thread=1 sequence=3391 RECID=7075 STAMP=805561100
input archived log thread=2 sequence=3704 RECID=7077 STAMP=805592354
input archived log thread=1 sequence=3392 RECID=7076 STAMP=805592349
input archived log thread=1 sequence=3393 RECID=7078 STAMP=805656530
input archived log thread=2 sequence=3705 RECID=7080 STAMP=805678752
input archived log thread=1 sequence=3394 RECID=7079 STAMP=805678747
input archived log thread=1 sequence=3395 RECID=7081 STAMP=805730736
input archived log thread=2 sequence=3706 RECID=7083 STAMP=805765148
input archived log thread=1 sequence=3396 RECID=7082 STAMP=805765144
input archived log thread=1 sequence=3397 RECID=7084 STAMP=805788097
input archived log thread=2 sequence=3707 RECID=7086 STAMP=805851547
input archived log thread=1 sequence=3398 RECID=7085 STAMP=805851544
input archived log thread=1 sequence=3399 RECID=7087 STAMP=805910845
input archived log thread=2 sequence=3708 RECID=7090 STAMP=805937945
input archived log thread=1 sequence=3400 RECID=7088 STAMP=805915050
input archived log thread=1 sequence=3401 RECID=7089 STAMP=805937943
input archived log thread=1 sequence=3402 RECID=7093 STAMP=806024348
input archived log thread=2 sequence=3709 RECID=7091 STAMP=806018423
input archived log thread=2 sequence=3710 RECID=7092 STAMP=806024345
input archived log thread=2 sequence=3711 RECID=7096 STAMP=806067032
input archived log thread=1 sequence=3403 RECID=7094 STAMP=806067030
input archived log thread=1 sequence=3404 RECID=7095 STAMP=806067030
input archived log thread=2 sequence=3712 RECID=7097 STAMP=806113279
input archived log thread=2 sequence=3713 RECID=7098 STAMP=806191281
input archived log thread=1 sequence=3405 RECID=7100 STAMP=806197140
input archived log thread=2 sequence=3714 RECID=7099 STAMP=806197139
input archived log thread=2 sequence=3715 RECID=7101 STAMP=806282815
input archived log thread=1 sequence=3406 RECID=7103 STAMP=806283540
input archived log thread=2 sequence=3716 RECID=7102 STAMP=806283538
input archived log thread=1 sequence=3407 RECID=7105 STAMP=806369936
input archived log thread=2 sequence=3717 RECID=7104 STAMP=806344580
input archived log thread=2 sequence=3718 RECID=7106 STAMP=806369937
input archived log thread=1 sequence=3408 RECID=7109 STAMP=806456337
input archived log thread=2 sequence=3719 RECID=7107 STAMP=806392912
input archived log thread=2 sequence=3720 RECID=7108 STAMP=806456332
input archived log thread=2 sequence=3721 RECID=7111 STAMP=806542756
input archived log thread=1 sequence=3409 RECID=7110 STAMP=806526056
input archived log thread=1 sequence=3410 RECID=7112 STAMP=806542757
input archived log thread=1 sequence=3411 RECID=7113 STAMP=806616029
input archived log thread=2 sequence=3722 RECID=7114 STAMP=806629132
input archived log thread=1 sequence=3412 RECID=7115 STAMP=806629132
input archived log thread=1 sequence=3413 RECID=7116 STAMP=806683475
input archived log thread=2 sequence=3723 RECID=7118 STAMP=806715555
input archived log thread=1 sequence=3414 RECID=7117 STAMP=806715555
input archived log thread=1 sequence=3415 RECID=7119 STAMP=806774446
input archived log thread=2 sequence=3724 RECID=7121 STAMP=806801953
input archived log thread=1 sequence=3416 RECID=7120 STAMP=806801952
input archived log thread=1 sequence=3417 RECID=7123 STAMP=806888327
input archived log thread=2 sequence=3725 RECID=7122 STAMP=806888325
channel d1: starting piece 1 at 12-MAY-2013   23:50:47
channel d1: finished piece 1 at 12-MAY-2013   23:51:52
piece handle=/u01bak/a/orcl-archlog-2107-1-5h tag=TAG20130512T235044 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:05
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3418 RECID=7124 STAMP=806963748
input archived log thread=2 sequence=3726 RECID=7125 STAMP=806974745
input archived log thread=1 sequence=3419 RECID=7126 STAMP=806974746
input archived log thread=1 sequence=3420 RECID=7127 STAMP=807033647
input archived log thread=2 sequence=3727 RECID=7129 STAMP=807061122
input archived log thread=1 sequence=3421 RECID=7128 STAMP=807061119
input archived log thread=1 sequence=3422 RECID=7130 STAMP=807129111
input archived log thread=2 sequence=3728 RECID=7132 STAMP=807147521
input archived log thread=1 sequence=3423 RECID=7131 STAMP=807147517
input archived log thread=1 sequence=3424 RECID=7133 STAMP=807217099
input archived log thread=2 sequence=3729 RECID=7135 STAMP=807233919
input archived log thread=1 sequence=3425 RECID=7134 STAMP=807233916
input archived log thread=1 sequence=3426 RECID=7136 STAMP=807292836
input archived log thread=2 sequence=3730 RECID=7138 STAMP=807320315
input archived log thread=1 sequence=3427 RECID=7137 STAMP=807320314
input archived log thread=1 sequence=3428 RECID=7139 STAMP=807386417
input archived log thread=2 sequence=3731 RECID=7141 STAMP=807406715
input archived log thread=1 sequence=3429 RECID=7140 STAMP=807406713
input archived log thread=1 sequence=3430 RECID=7142 STAMP=807476447
input archived log thread=2 sequence=3732 RECID=7144 STAMP=807493114
input archived log thread=1 sequence=3431 RECID=7143 STAMP=807493110
input archived log thread=1 sequence=3432 RECID=7145 STAMP=807552008
input archived log thread=2 sequence=3733 RECID=7146 STAMP=807579511
input archived log thread=1 sequence=3433 RECID=7147 STAMP=807579513
input archived log thread=1 sequence=3434 RECID=7148 STAMP=807638413
input archived log thread=2 sequence=3734 RECID=7149 STAMP=807665934
input archived log thread=1 sequence=3435 RECID=7150 STAMP=807665934
input archived log thread=1 sequence=3436 RECID=7151 STAMP=807741903
input archived log thread=2 sequence=3735 RECID=7152 STAMP=807752312
input archived log thread=1 sequence=3437 RECID=7153 STAMP=807752312
input archived log thread=1 sequence=3438 RECID=7154 STAMP=807825628
input archived log thread=2 sequence=3736 RECID=7155 STAMP=807838712
input archived log thread=1 sequence=3439 RECID=7156 STAMP=807838712
input archived log thread=1 sequence=3440 RECID=7157 STAMP=807900504
input archived log thread=2 sequence=3737 RECID=7160 STAMP=807925107
input archived log thread=1 sequence=3441 RECID=7158 STAMP=807900504
input archived log thread=1 sequence=3442 RECID=7159 STAMP=807925105
input archived log thread=1 sequence=3443 RECID=7162 STAMP=808011503
input archived log thread=2 sequence=3738 RECID=7161 STAMP=807991226
input archived log thread=2 sequence=3739 RECID=7163 STAMP=808011505
input archived log thread=1 sequence=3444 RECID=7165 STAMP=808097902
input archived log thread=2 sequence=3740 RECID=7164 STAMP=808084843
input archived log thread=2 sequence=3741 RECID=7166 STAMP=808097903
input archived log thread=2 sequence=3742 RECID=7167 STAMP=808124432
input archived log thread=1 sequence=3445 RECID=7168 STAMP=808184299
input archived log thread=2 sequence=3743 RECID=7169 STAMP=808184299
input archived log thread=1 sequence=3446 RECID=7171 STAMP=808270698
input archived log thread=2 sequence=3744 RECID=7170 STAMP=808236126
input archived log thread=2 sequence=3745 RECID=7172 STAMP=808270699
input archived log thread=1 sequence=3447 RECID=7174 STAMP=808357097
input archived log thread=2 sequence=3746 RECID=7173 STAMP=808344009
input archived log thread=2 sequence=3747 RECID=7175 STAMP=808357098
input archived log thread=2 sequence=3748 RECID=7178 STAMP=808443496
input archived log thread=1 sequence=3448 RECID=7176 STAMP=808441228
input archived log thread=1 sequence=3449 RECID=7177 STAMP=808443492
input archived log thread=1 sequence=3450 RECID=7179 STAMP=808509632
input archived log thread=2 sequence=3749 RECID=7181 STAMP=808529895
input archived log thread=1 sequence=3451 RECID=7180 STAMP=808529892
input archived log thread=1 sequence=3452 RECID=7182 STAMP=808594381
channel d1: starting piece 1 at 12-MAY-2013   23:51:53
channel d1: finished piece 1 at 12-MAY-2013   23:52:58
piece handle=/u01bak/a/orcl-archlog-2108-1-5h tag=TAG20130512T235044 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:05
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=2 sequence=3750 RECID=7184 STAMP=808616291
input archived log thread=1 sequence=3453 RECID=7183 STAMP=808616290
input archived log thread=1 sequence=3454 RECID=7185 STAMP=808956017
input archived log thread=2 sequence=3751 RECID=7187 STAMP=808961917
input archived log thread=1 sequence=3455 RECID=7186 STAMP=808961912
input archived log thread=1 sequence=3456 RECID=7188 STAMP=809046032
input archived log thread=2 sequence=3752 RECID=7190 STAMP=809048314
input archived log thread=1 sequence=3457 RECID=7189 STAMP=809048310
input archived log thread=1 sequence=3458 RECID=7191 STAMP=809111559
input archived log thread=2 sequence=3753 RECID=7193 STAMP=809134714
input archived log thread=1 sequence=3459 RECID=7192 STAMP=809134709
input archived log thread=1 sequence=3460 RECID=7194 STAMP=809215248
input archived log thread=2 sequence=3754 RECID=7196 STAMP=809221087
input archived log thread=1 sequence=3461 RECID=7195 STAMP=809221083
input archived log thread=1 sequence=3462 RECID=7197 STAMP=809301623
input archived log thread=2 sequence=3755 RECID=7199 STAMP=809307486
input archived log thread=1 sequence=3463 RECID=7198 STAMP=809307482
input archived log thread=1 sequence=3464 RECID=7200 STAMP=809341861
input archived log thread=2 sequence=3756 RECID=7201 STAMP=809341862
input archived log thread=2 sequence=3757 RECID=7202 STAMP=809341862
input archived log thread=1 sequence=3465 RECID=7203 STAMP=809393888
input archived log thread=2 sequence=3758 RECID=7204 STAMP=809393889
input archived log thread=1 sequence=3466 RECID=7205 STAMP=809460043
input archived log thread=2 sequence=3759 RECID=7207 STAMP=809480303
input archived log thread=1 sequence=3467 RECID=7206 STAMP=809480301
input archived log thread=1 sequence=3468 RECID=7208 STAMP=809560819
input archived log thread=2 sequence=3760 RECID=7210 STAMP=809566702
input archived log thread=1 sequence=3469 RECID=7209 STAMP=809566700
input archived log thread=1 sequence=3470 RECID=7211 STAMP=809647239
input archived log thread=2 sequence=3761 RECID=7213 STAMP=809653076
input archived log thread=1 sequence=3471 RECID=7212 STAMP=809653073
input archived log thread=1 sequence=3472 RECID=7214 STAMP=809680219
input archived log thread=2 sequence=3762 RECID=7216 STAMP=809739497
input archived log thread=1 sequence=3473 RECID=7215 STAMP=809739495
input archived log thread=1 sequence=3474 RECID=7217 STAMP=809816459
input archived log thread=2 sequence=3763 RECID=7219 STAMP=809825897
input archived log thread=1 sequence=3475 RECID=7218 STAMP=809825893
input archived log thread=1 sequence=3476 RECID=7220 STAMP=809902819
input archived log thread=2 sequence=3764 RECID=7222 STAMP=809912270
input archived log thread=1 sequence=3477 RECID=7221 STAMP=809912267
input archived log thread=1 sequence=3478 RECID=7223 STAMP=809974860
input archived log thread=2 sequence=3765 RECID=7225 STAMP=809998670
input archived log thread=1 sequence=3479 RECID=7224 STAMP=809998667
input archived log thread=1 sequence=3480 RECID=7227 STAMP=810085066
input archived log thread=2 sequence=3766 RECID=7226 STAMP=810068435
input archived log thread=2 sequence=3767 RECID=7228 STAMP=810085067
input archived log thread=1 sequence=3481 RECID=7230 STAMP=810171465
input archived log thread=2 sequence=3768 RECID=7229 STAMP=810165635
input archived log thread=2 sequence=3769 RECID=7231 STAMP=810171466
input archived log thread=1 sequence=3482 RECID=7233 STAMP=810257862
input archived log thread=2 sequence=3770 RECID=7232 STAMP=810202726
input archived log thread=2 sequence=3771 RECID=7234 STAMP=810257864
input archived log thread=1 sequence=3483 RECID=7236 STAMP=810344262
input archived log thread=2 sequence=3772 RECID=7235 STAMP=810285995
input archived log thread=2 sequence=3773 RECID=7237 STAMP=810344262
input archived log thread=2 sequence=3774 RECID=7238 STAMP=810424827
input archived log thread=1 sequence=3484 RECID=7239 STAMP=810430658
input archived log thread=2 sequence=3775 RECID=7240 STAMP=810430661
input archived log thread=1 sequence=3485 RECID=7242 STAMP=810517056
input archived log thread=2 sequence=3776 RECID=7241 STAMP=810511223
channel d1: starting piece 1 at 12-MAY-2013   23:52:59
channel d1: finished piece 1 at 12-MAY-2013   23:54:04
piece handle=/u01bak/a/orcl-archlog-2109-1-5h tag=TAG20130512T235044 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:05
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=2 sequence=3777 RECID=7243 STAMP=810517061
input archived log thread=1 sequence=3486 RECID=7245 STAMP=810603456
input archived log thread=2 sequence=3778 RECID=7244 STAMP=810590548
input archived log thread=2 sequence=3779 RECID=7246 STAMP=810603457
input archived log thread=2 sequence=3780 RECID=7247 STAMP=810673917
input archived log thread=1 sequence=3487 RECID=7248 STAMP=810689877
input archived log thread=2 sequence=3781 RECID=7249 STAMP=810689880
input archived log thread=1 sequence=3488 RECID=7250 STAMP=810766839
input archived log thread=2 sequence=3782 RECID=7252 STAMP=810776254
input archived log thread=1 sequence=3489 RECID=7251 STAMP=810776250
input archived log thread=1 sequence=3490 RECID=7253 STAMP=810856848
input archived log thread=2 sequence=3783 RECID=7255 STAMP=810862651
input archived log thread=1 sequence=3491 RECID=7254 STAMP=810862647
input archived log thread=1 sequence=3492 RECID=7256 STAMP=810939622
input archived log thread=2 sequence=3784 RECID=7258 STAMP=810949049
input archived log thread=1 sequence=3493 RECID=7257 STAMP=810949045
input archived log thread=1 sequence=3494 RECID=7259 STAMP=811026955
input archived log thread=2 sequence=3785 RECID=7261 STAMP=811035473
input archived log thread=1 sequence=3495 RECID=7260 STAMP=811035467
input archived log thread=1 sequence=3496 RECID=7262 STAMP=811116045
input archived log thread=2 sequence=3786 RECID=7264 STAMP=811121871
input archived log thread=1 sequence=3497 RECID=7263 STAMP=811121865
input archived log thread=1 sequence=3498 RECID=7265 STAMP=811191611
input archived log thread=2 sequence=3787 RECID=7267 STAMP=811208267
input archived log thread=1 sequence=3499 RECID=7266 STAMP=811208263
input archived log thread=1 sequence=3500 RECID=7268 STAMP=811274435
input archived log thread=2 sequence=3788 RECID=7270 STAMP=811294643
input archived log thread=1 sequence=3501 RECID=7269 STAMP=811294638
input archived log thread=1 sequence=3502 RECID=7271 STAMP=811375242
input archived log thread=2 sequence=3789 RECID=7273 STAMP=811381064
input archived log thread=1 sequence=3503 RECID=7272 STAMP=811381059
input archived log thread=1 sequence=3504 RECID=7274 STAMP=811458022
input archived log thread=2 sequence=3790 RECID=7276 STAMP=811467439
input archived log thread=1 sequence=3505 RECID=7275 STAMP=811467433
input archived log thread=1 sequence=3506 RECID=7277 STAMP=811543576
input archived log thread=2 sequence=3791 RECID=7279 STAMP=811553835
input archived log thread=1 sequence=3507 RECID=7278 STAMP=811553832
input archived log thread=1 sequence=3508 RECID=7281 STAMP=811627228
input archived log thread=2 sequence=3792 RECID=7280 STAMP=811553839
input archived log thread=2 sequence=3793 RECID=7283 STAMP=811640234
input archived log thread=1 sequence=3509 RECID=7282 STAMP=811640230
input archived log thread=1 sequence=3510 RECID=7284 STAMP=811718234
input archived log thread=2 sequence=3794 RECID=7286 STAMP=811726630
input archived log thread=1 sequence=3511 RECID=7285 STAMP=811726627
input archived log thread=1 sequence=3512 RECID=7288 STAMP=811787292
input archived log thread=2 sequence=3795 RECID=7287 STAMP=811726633
input archived log thread=2 sequence=3796 RECID=7290 STAMP=811813030
input archived log thread=1 sequence=3513 RECID=7289 STAMP=811813027
input archived log thread=1 sequence=3514 RECID=7292 STAMP=811899427
input archived log thread=2 sequence=3797 RECID=7291 STAMP=811879207
input archived log thread=2 sequence=3798 RECID=7293 STAMP=811899428
input archived log thread=2 sequence=3799 RECID=7294 STAMP=811980026
input archived log thread=1 sequence=3515 RECID=7295 STAMP=811985822
input archived log thread=2 sequence=3800 RECID=7296 STAMP=811985824
input archived log thread=1 sequence=3516 RECID=7299 STAMP=812072244
input archived log thread=2 sequence=3801 RECID=7297 STAMP=812052335
input archived log thread=2 sequence=3802 RECID=7298 STAMP=812072243
input archived log thread=2 sequence=3803 RECID=7300 STAMP=812102406
input archived log thread=1 sequence=3517 RECID=7301 STAMP=812127962
input archived log thread=2 sequence=3804 RECID=7304 STAMP=812158646
input archived log thread=1 sequence=3518 RECID=7302 STAMP=812128596
input archived log thread=1 sequence=3519 RECID=7303 STAMP=812158643
input archived log thread=1 sequence=3520 RECID=7306 STAMP=812245023
channel d1: starting piece 1 at 12-MAY-2013   23:54:05
channel d1: finished piece 1 at 12-MAY-2013   23:55:20
piece handle=/u01bak/a/orcl-archlog-2110-1-5h tag=TAG20130512T235044 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:15
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=2 sequence=3805 RECID=7305 STAMP=812239243
input archived log thread=2 sequence=3806 RECID=7307 STAMP=812245024
input archived log thread=1 sequence=3521 RECID=7308 STAMP=812294031
input archived log thread=2 sequence=3807 RECID=7310 STAMP=812325650
input archived log thread=1 sequence=3522 RECID=7309 STAMP=812294032
input archived log thread=1 sequence=3523 RECID=7311 STAMP=812331417
input archived log thread=2 sequence=3808 RECID=7312 STAMP=812331421
input archived log thread=1 sequence=3524 RECID=7313 STAMP=812412025
input archived log thread=2 sequence=3809 RECID=7315 STAMP=812417814
input archived log thread=1 sequence=3525 RECID=7314 STAMP=812417814
input archived log thread=1 sequence=3526 RECID=7316 STAMP=812504213
input archived log thread=2 sequence=3810 RECID=7317 STAMP=812504215
input archived log thread=1 sequence=3527 RECID=7318 STAMP=812584828
input archived log thread=2 sequence=3811 RECID=7320 STAMP=812590615
input archived log thread=1 sequence=3528 RECID=7319 STAMP=812590610
input archived log thread=1 sequence=3529 RECID=7321 STAMP=812667082
input archived log thread=2 sequence=3812 RECID=7323 STAMP=812677012
input archived log thread=1 sequence=3530 RECID=7322 STAMP=812677008
input archived log thread=1 sequence=3531 RECID=7324 STAMP=812743633
input archived log thread=2 sequence=3813 RECID=7326 STAMP=812763412
input archived log thread=1 sequence=3532 RECID=7325 STAMP=812763407
input archived log thread=1 sequence=3533 RECID=7327 STAMP=812849808
input archived log thread=2 sequence=3814 RECID=7328 STAMP=812849809
input archived log thread=2 sequence=3815 RECID=7329 STAMP=812886612
input archived log thread=1 sequence=3534 RECID=7331 STAMP=812936207
input archived log thread=2 sequence=3816 RECID=7330 STAMP=812919609
input archived log thread=2 sequence=3817 RECID=7332 STAMP=812936208
input archived log thread=2 sequence=3818 RECID=7333 STAMP=813018584
input archived log thread=1 sequence=3535 RECID=7334 STAMP=813022604
input archived log thread=2 sequence=3819 RECID=7335 STAMP=813022604
input archived log thread=1 sequence=3536 RECID=7336 STAMP=813099616
input archived log thread=2 sequence=3820 RECID=7338 STAMP=813109001
input archived log thread=1 sequence=3537 RECID=7337 STAMP=813108999
input archived log thread=1 sequence=3538 RECID=7339 STAMP=813189630
input archived log thread=2 sequence=3821 RECID=7341 STAMP=813195403
input archived log thread=1 sequence=3539 RECID=7340 STAMP=813195397
input archived log thread=1 sequence=3540 RECID=7342 STAMP=813228993
input archived log thread=2 sequence=3822 RECID=7344 STAMP=813281797
input archived log thread=1 sequence=3541 RECID=7343 STAMP=813281796
input archived log thread=1 sequence=3542 RECID=7345 STAMP=813322853
input archived log thread=2 sequence=3823 RECID=7347 STAMP=813368197
input archived log thread=1 sequence=3543 RECID=7346 STAMP=813368193
input archived log thread=1 sequence=3544 RECID=7348 STAMP=813448826
input archived log thread=2 sequence=3824 RECID=7350 STAMP=813454597
input archived log thread=1 sequence=3545 RECID=7349 STAMP=813454591
input archived log thread=1 sequence=3546 RECID=7351 STAMP=813528009
input archived log thread=2 sequence=3825 RECID=7353 STAMP=813540998
input archived log thread=1 sequence=3547 RECID=7352 STAMP=813540992
input archived log thread=1 sequence=3548 RECID=7354 STAMP=813617107
input archived log thread=2 sequence=3826 RECID=7356 STAMP=813627388
input archived log thread=1 sequence=3549 RECID=7355 STAMP=813627387
input archived log thread=1 sequence=3550 RECID=7357 STAMP=813693619
input archived log thread=2 sequence=3827 RECID=7359 STAMP=813713791
input archived log thread=1 sequence=3551 RECID=7358 STAMP=813713786
channel d1: starting piece 1 at 12-MAY-2013   23:55:21
channel d1: finished piece 1 at 12-MAY-2013   23:56:36
piece handle=/u01bak/a/orcl-archlog-2111-1-5h tag=TAG20130512T235044 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:15
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3552 RECID=7360 STAMP=813798723
input archived log thread=2 sequence=3828 RECID=7362 STAMP=813800187
input archived log thread=1 sequence=3553 RECID=7361 STAMP=813800183
input archived log thread=1 sequence=3554 RECID=7363 STAMP=813870008
input archived log thread=2 sequence=3829 RECID=7365 STAMP=813886587
input archived log thread=1 sequence=3555 RECID=7364 STAMP=813886581
input archived log thread=1 sequence=3556 RECID=7366 STAMP=813924030
input archived log thread=2 sequence=3830 RECID=7368 STAMP=813972984
input archived log thread=1 sequence=3557 RECID=7367 STAMP=813972982
input archived log thread=1 sequence=3558 RECID=7369 STAMP=814056057
input archived log thread=2 sequence=3831 RECID=7371 STAMP=814059383
input archived log thread=1 sequence=3559 RECID=7370 STAMP=814059380
input archived log thread=1 sequence=3560 RECID=7372 STAMP=814142382
input archived log thread=2 sequence=3832 RECID=7374 STAMP=814145801
input archived log thread=1 sequence=3561 RECID=7373 STAMP=814145800
input archived log thread=1 sequence=3562 RECID=7375 STAMP=814302055
input archived log thread=2 sequence=3833 RECID=7377 STAMP=814318577
input archived log thread=1 sequence=3563 RECID=7376 STAMP=814318576
input archived log thread=1 sequence=3564 RECID=7378 STAMP=814392030
input archived log thread=2 sequence=3834 RECID=7380 STAMP=814404980
input archived log thread=1 sequence=3565 RECID=7379 STAMP=814404974
input archived log thread=1 sequence=3566 RECID=7381 STAMP=814485609
input archived log thread=2 sequence=3835 RECID=7383 STAMP=814491377
input archived log thread=1 sequence=3567 RECID=7382 STAMP=814491372
input archived log thread=1 sequence=3568 RECID=7385 STAMP=814577772
input archived log thread=2 sequence=3836 RECID=7384 STAMP=814547645
input archived log thread=2 sequence=3837 RECID=7386 STAMP=814577774
input archived log thread=1 sequence=3569 RECID=7389 STAMP=814664193
input archived log thread=2 sequence=3838 RECID=7387 STAMP=814604411
input archived log thread=2 sequence=3839 RECID=7388 STAMP=814664193
input archived log thread=1 sequence=3570 RECID=7391 STAMP=814750567
input archived log thread=2 sequence=3840 RECID=7390 STAMP=814744833
input archived log thread=2 sequence=3841 RECID=7392 STAMP=814750571
input archived log thread=1 sequence=3571 RECID=7393 STAMP=814836969
input archived log thread=2 sequence=3842 RECID=7394 STAMP=814836973
input archived log thread=2 sequence=3843 RECID=7397 STAMP=814923366
input archived log thread=1 sequence=3572 RECID=7395 STAMP=814909810
input archived log thread=1 sequence=3573 RECID=7396 STAMP=814923362
input archived log thread=1 sequence=3574 RECID=7398 STAMP=814994564
input archived log thread=2 sequence=3844 RECID=7400 STAMP=815009762
input archived log thread=1 sequence=3575 RECID=7399 STAMP=815009761
input archived log thread=1 sequence=3576 RECID=7401 STAMP=815090428
input archived log thread=2 sequence=3845 RECID=7403 STAMP=815096161
input archived log thread=1 sequence=3577 RECID=7402 STAMP=815096160
input archived log thread=1 sequence=3578 RECID=7404 STAMP=815162423
input archived log thread=2 sequence=3846 RECID=7406 STAMP=815182561
input archived log thread=1 sequence=3579 RECID=7405 STAMP=815182557
input archived log thread=1 sequence=3580 RECID=7407 STAMP=815249122
input archived log thread=2 sequence=3847 RECID=7409 STAMP=815263450
input archived log thread=1 sequence=3581 RECID=7408 STAMP=815263445
input archived log thread=1 sequence=3582 RECID=7411 STAMP=815268982
input archived log thread=2 sequence=3848 RECID=7410 STAMP=815268980
input archived log thread=2 sequence=3849 RECID=7413 STAMP=815269844
input archived log thread=1 sequence=3583 RECID=7412 STAMP=815269844
channel d1: starting piece 1 at 12-MAY-2013   23:56:37
channel d1: finished piece 1 at 12-MAY-2013   23:57:52
piece handle=/u01bak/a/orcl-archlog-2112-1-5h tag=TAG20130512T235044 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:15
Finished backup at 12-MAY-2013   23:57:52

Starting backup at 12-MAY-2013   23:57:52
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
including current control file in backup set
channel d1: starting piece 1 at 12-MAY-2013   23:57:53
channel d1: finished piece 1 at 12-MAY-2013   23:57:54
piece handle=/u01bak/a/ctl-ORCL-2113-1 tag=TAG20130512T235752 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 12-MAY-2013   23:57:54

Starting Control File and SPFILE Autobackup at 12-MAY-2013   23:57:54
piece handle=/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/c-1280539424-20130512-03 comment=NONE
Finished Control File and SPFILE Autobackup at 12-MAY-2013   23:57:55
released channel: d1

RMAN>

***********************************************************************************************

RMAN> run
2> {
3> allocate channel d1 type disk;
4> restore controlfile from '/u01bak/a/ctl-ORCL-2113-1';
5> }

allocated channel: d1
channel d1: SID=667 instance=orcl1 device type=DISK

Starting restore at 12-MAY-13

channel d1: restoring control file
channel d1: restore complete, elapsed time: 00:00:02
output file name=+DGDATA/orcl/controlfile/current.260.815135043
output file name=+DGARCH/orcl/controlfile/current.256.815135043
Finished restore at 12-MAY-13
released channel: d1

RMAN> run
2> {
3> allocate channel d1 type disk;
4> restore database from tag='fullbackup';
5> }

allocated channel: d1
channel d1: SID=667 instance=orcl1 device type=DISK

Starting restore at 12-MAY-13
Starting implicit crosscheck backup at 12-MAY-13
Crosschecked 47 objects
Finished implicit crosscheck backup at 12-MAY-13

Starting implicit crosscheck copy at 12-MAY-13
Finished implicit crosscheck copy at 12-MAY-13

searching for all files in the recovery area
cataloging files...
no files cataloged


channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 00001 to +ORADATA/orcl/datafile/system.259.752758697
channel d1: restoring datafile 00002 to +ORADATA/orcl/datafile/sysaux.260.752758705
channel d1: restoring datafile 00003 to +ORADATA/orcl/datafile/undotbs1.261.752758709
channel d1: restoring datafile 00004 to +ORADATA/orcl/datafile/undotbs2.263.752758731
channel d1: restoring datafile 00005 to +ORADATA/orcl/datafile/users.264.752758739
channel d1: restoring datafile 00006 to +ORADATA/orcl/datafile/lchis.268.752770829
channel d1: restoring datafile 00007 to +ORADATA/orcl/datafile/lchis.269.752770845
channel d1: restoring datafile 00008 to +ORADATA/orcl/datafile/lchis.270.752770861
channel d1: restoring datafile 00009 to +ORADATA/orcl/datafile/lchis.271.752770877
channel d1: restoring datafile 00010 to +ORADATA/orcl/datafile/lchis.272.752770893
channel d1: restoring datafile 00011 to +ORADATA/orcl/datafile/lchis2007.273.752770981
channel d1: restoring datafile 00012 to +ORADATA/orcl/datafile/lchis2008.274.752771167
channel d1: restoring datafile 00013 to +ORADATA/orcl/datafile/lchis2008.275.752771183
channel d1: restoring datafile 00014 to +ORADATA/orcl/datafile/lchis2008.276.752771201
channel d1: restoring datafile 00015 to +ORADATA/orcl/datafile/lchis2009.277.752771349
channel d1: restoring datafile 00016 to +ORADATA/orcl/datafile/lchis2009.278.752771365
channel d1: restoring datafile 00017 to +ORADATA/orcl/datafile/lchis2009.279.752771381
channel d1: restoring datafile 00018 to +ORADATA/orcl/datafile/lchis2010.280.752771443
channel d1: restoring datafile 00019 to +ORADATA/orcl/datafile/lchis2010.281.752771459
channel d1: restoring datafile 00020 to +ORADATA/orcl/datafile/lchis2010.282.752771473
channel d1: restoring datafile 00021 to +ORADATA/orcl/datafile/lchis2011.283.752771603
channel d1: restoring datafile 00022 to +ORADATA/orcl/datafile/lchis2011.284.752771619
channel d1: restoring datafile 00023 to +ORADATA/orcl/datafile/lchis2011.285.752771635
channel d1: restoring datafile 00024 to +ORADATA/orcl/datafile/lchis2011.286.752771651
channel d1: restoring datafile 00025 to +ORADATA/orcl/datafile/lchis2011.287.752771667
channel d1: restoring datafile 00026 to +ORADATA/orcl/datafile/lchis2012.288.752771845
channel d1: restoring datafile 00027 to +ORADATA/orcl/datafile/lchis2012.289.752771859
channel d1: restoring datafile 00028 to +ORADATA/orcl/datafile/lchis2012.290.752771875
channel d1: restoring datafile 00029 to +ORADATA/orcl/datafile/lchis2012.291.752771891
channel d1: restoring datafile 00030 to +ORADATA/orcl/datafile/lchis2012.292.752771907
channel d1: restoring datafile 00031 to +ORADATA/orcl/datafile/users.293.752771955
channel d1: restoring datafile 00032 to +ORADATA/orcl/datafile/users.294.752772049
channel d1: restoring datafile 00033 to +ORADATA/orcl/datafile/users.295.752772093
channel d1: restoring datafile 00034 to +ORADATA/orcl/datafile/users.296.752772239
channel d1: restoring datafile 00035 to +ORADATA/orcl/datafile/users.297.752772255
channel d1: restoring datafile 00036 to +ORADATA/orcl/datafile/users.298.752772271
channel d1: restoring datafile 00037 to +ORADATA/orcl/datafile/users.299.752772287
channel d1: restoring datafile 00038 to +ORADATA/orcl/datafile/users.300.752772303
channel d1: restoring datafile 00039 to +ORADATA/orcl/datafile/users.301.752772319
channel d1: restoring datafile 00040 to +ORADATA/orcl/datafile/users.302.752772335
channel d1: restoring datafile 00041 to +ORADATA/orcl/datafile/lchis2012.0908
channel d1: restoring datafile 00042 to +ORADATA/orcl/datafile/users.20120908
channel d1: reading from backup piece /u01bak/a/orcl-db-fullORCL81526923621061
channel d1: piece handle=/u01bak/a/orcl-db-fullORCL81526923621061 tag=FULLBACKUP
channel d1: restored backup piece 1
channel d1: restore complete, elapsed time: 00:30:45
Finished restore at 12-MAY-13
released channel: d1

RMAN>




SQL> alter database rename file '+ORADATA/orcl/datafile/lchis2012.0908' to '+DGDATA/orcl/datafile/lchis2012.0908';

Database altered.

SQL> alter database rename file '+ORADATA/orcl/datafile/users.20120908' to '+DGDATA/orcl/datafile/users.20120908';

Database altered.


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值