Forum Stats

  • 3,724,396 Users
  • 2,244,747 Discussions
  • 7,850,993 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

RMAN Script in Solaris

Fahd.Mirza
Fahd.Mirza Member Posts: 2,984 Bronze Trophy
Hi,
I am running Following rman script through shell in Solaris 10.2 to validate the database:

[email protected] # cat rman_validate.sh

#!/bin/bash
ORACLE_HOME=/u01/app/oracle/product/10g
PATH=$ORACLE_HOME/bin:$PATH
ORACLE_SID=mtcedwp
export ORACLE_HOME ORACLE_SID PATH
rman target / <<EOF
CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
ALLOCATE CHANNEL d1 DEVICE TYPE DISK;
ALLOCATE CHANNEL d2 DEVICE TYPE DISK;
ALLOCATE CHANNEL d3 DEVICE TYPE DISK;
ALLOCATE CHANNEL d4 DEVICE TYPE DISK;
ALLOCATE CHANNEL d5 DEVICE TYPE DISK;
ALLOCATE CHANNEL d6 DEVICE TYPE DISK;
ALLOCATE CHANNEL d7 DEVICE TYPE DISK;
ALLOCATE CHANNEL d8 DEVICE TYPE DISK;
BACKUP VALIDATE DATABASE;
RELEASE CHANNEL d1;
RELEASE CHANNEL d2;
RELEASE CHANNEL d3;
RELEASE CHANNEL d4;
RELEASE CHANNEL d5;
RELEASE CHANNEL d6;
RELEASE CHANNEL d7;
RELEASE CHANNEL d8;
EOF



I am executing this script as follows:

[email protected] # nohup ./rman_validate.sh &

Then I receive following errors in the nohup.out file:


input datafile fno=00125 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.385.702198275
input datafile fno=00081 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.340.695129943
input datafile fno=00090 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.349.695475749
input datafile fno=00120 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads.380.700249057
input datafile fno=00142 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.402.707084055
input datafile fno=00131 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads.391.704194625
input datafile fno=00093 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ods1.352.696598449
input datafile fno=00099 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ods1.358.696598613
input datafile fno=00124 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ods1.384.700933397
input datafile fno=00070 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_rds.329.676059403
input datafile fno=00111 name=+MTCDATA_GRP/mtcedwp/datafile/atbitdscdrpart.370.697290733
input datafile fno=00002 name=+MTCDATA_GRP/mtcedwp/datafile/undotbs1.261.654101459
input datafile fno=00071 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ods_sbscrbr_hist_jan07.330.680708683
input datafile fno=00072 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ods_sbscrbr_hist_jan07.331.680708755
input datafile fno=00008 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_rpstry.268.654113363
input datafile fno=00051 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_dds.310.662492431
input datafile fno=00067 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_rds_tapin.326.667722723
channel ORA_DISK_8: starting compressed full datafile backupset
channel ORA_DISK_8: specifying datafile(s) in backupset
input datafile fno=00004 name=+MTCDATA_GRP/mtcedwp/datafile/users.264.654101503
input datafile fno=00146 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.406.707084307
input datafile fno=00084 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.343.695237005
input datafile fno=00075 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.334.695040959
input datafile fno=00080 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.339.695129765
input datafile fno=00153 name=+MTCDATA_GRP/mtcedwp/datafile/users.413.708271033
input datafile fno=00014 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads.274.654113499
input datafile fno=00130 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads.390.704194583
input datafile fno=00145 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.405.707084139
input datafile fno=00096 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ods1.355.696598533
input datafile fno=00149 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_tds.409.707569511
input datafile fno=00106 name=+MTCDATA_GRP/mtcedwp/datafile/undotbs1.366.696693453
input datafile fno=00117 name=+MTCDATA_GRP/mtcedwp/datafile/atbitdscdrpart.377.697290949
input datafile fno=00016 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_olap.276.654113543
input datafile fno=00013 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_dds.273.654113489
input datafile fno=00035 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads_indexes.295.654113845
input datafile fno=00064 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads_tapout.323.667722723
input datafile fno=00126 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads_tapout.386.701419275
input datafile fno=00134 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_ads_tapout.394.704728861
input datafile fno=00055 name=+MTCDATA_GRP/mtcedwp/datafile/atbi_dds.314.662492689
channel ORA_DISK_1: backup set complete, elapsed time: 00:54:31
channel ORA_DISK_3: backup set complete, elapsed time: 01:10:07
channel ORA_DISK_2: backup set complete, elapsed time: 01:11:23
channel ORA_DISK_4: backup set complete, elapsed time: 01:12:08
channel ORA_DISK_6: backup set complete, elapsed time: 01:12:52
channel ORA_DISK_7: backup set complete, elapsed time: 01:12:52
channel ORA_DISK_8: backup set complete, elapsed time: 01:14:27
channel ORA_DISK_5: backup set complete, elapsed time: 01:30:23
Finished backup at 09-APR-10

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d1
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d2
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d3
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d4
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d5
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d6
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d7
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: d8
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, c
onfigure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, ren
ormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>

Recovery Manager complete.

regards

Answers

  • Lubiez Jean-Valentin
    Lubiez Jean-Valentin Member Posts: 2,737
    edited April 2010
    Hello,


    You need to execute ALLOCATE CHANNEL only within the braces of a RUN command.

    So for instance:
    RUN
    {
    ALLOCATE CHANNEL d1 DEVICE TYPE DISK;
    ...
    BACKUP VALIDATE DATABASE;
    RELEASE CHANNEL d1;
    ...
    }
    Hope this help.
    Best regards,
    Jean-Valentin
  • Fahd.Mirza
    Fahd.Mirza Member Posts: 2,984 Bronze Trophy
    edited April 2010
    Is the following script right?
    #!/bin/bash
    ORACLE_HOME=/u01/app/oracle/product/10g
    PATH=$ORACLE_HOME/bin:$PATH
    ORACLE_SID=mtcedwp
    export ORACLE_HOME ORACLE_SID PATH
    rman target / &lt;&lt;EOF
    run
    {
    CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
    ALLOCATE CHANNEL d1 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d2 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d3 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d4 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d5 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d6 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d7 DEVICE TYPE DISK;
    ALLOCATE CHANNEL d8 DEVICE TYPE DISK;
    BACKUP VALIDATE DATABASE;
    RELEASE CHANNEL d1;
    RELEASE CHANNEL d2;
    RELEASE CHANNEL d3;
    RELEASE CHANNEL d4;
    RELEASE CHANNEL d5;
    RELEASE CHANNEL d6;
    RELEASE CHANNEL d7;
    RELEASE CHANNEL d8;
    }
    EOF
    Edited by: Fahd Mirza on Apr 10, 2010 1:24 PM

    Edited by: Fahd Mirza on Apr 10, 2010 1:25 PM
  • Lubiez Jean-Valentin
    Lubiez Jean-Valentin Member Posts: 2,737
    Hello,


    Yes, it looks nice.


    Best regards,
    Jean-Valentin
    Lubiez Jean-Valentin
  • Fahd.Mirza
    Fahd.Mirza Member Posts: 2,984 Bronze Trophy
    Thanks, please clear one more thing. I am running this script on a machine with 16 CPUs. Will this script be run in parrallel by 8 channels, which I specified?

    regards
  • sb92075
    sb92075 Member Posts: 42,196
    Will this script be run in parrallel by 8 channels, which I specified?
    When you run the script, what do you observe?
  • Fahd.Mirza
    Fahd.Mirza Member Posts: 2,984 Bronze Trophy
    Can you please tell me how to monitor this thing?

    regards
  • sb92075
    sb92075 Member Posts: 42,196
  • Fahd.Mirza
    Fahd.Mirza Member Posts: 2,984 Bronze Trophy
    edited April 2010
    Thanks for the help.

    The command has finished now and I didn't get a chance to check the ps -ef command.

    As you see in my original post, I am using nohup to run the script in the background and its sending its output to nohup.out file. But in the content of nohup.out file, there is no mention of report generated by RMAN regarding how many blocks it found. Output is as follows:
    [email protected] # more nohup.out
    
    Recovery Manager: Release 10.2.0.3.0 - Production on Sat Apr 10 10:45:28 2010
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    connected to target database: TEST (DBID=978723866)
    
    RMAN&gt; 2&gt; 3&gt; 4&gt; 5&gt; 6&gt; 7&gt; 8&gt; 9&gt; 10&gt; 11&gt; 12&gt; 13&gt; 14&gt; 15&gt; 16&gt; 17&gt; 18&gt; 19&gt; 20&gt; 21&gt;
    using target database control file instead of recovery catalog
    old RMAN configuration parameters:
    CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
    new RMAN configuration parameters:
    CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
    new RMAN configuration parameters are successfully stored
    
    allocated channel: d1
    channel d1: sid=208 devtype=DISK
    
    allocated channel: d2
    channel d2: sid=427 devtype=DISK
    
    allocated channel: d3
    channel d3: sid=198 devtype=DISK
    
    allocated channel: d4
    channel d4: sid=448 devtype=DISK
    
    allocated channel: d5
    channel d5: sid=127 devtype=DISK
    
    allocated channel: d6
    channel d6: sid=434 devtype=DISK
    
    allocated channel: d7
    channel d7: sid=143 devtype=DISK
    
    allocated channel: d8
    channel d8: sid=430 devtype=DISK
    
    Starting backup at 10-APR-10
    channel d1: starting compressed full datafile backupset
    channel d1: specifying datafile(s) in backupset
    input datafile fno=00108 name=+TEST_GRP/TEST/datafile/undotbs1.368.696699605
    input datafile fno=00040 name=+TEST_GRP/TEST/datafile/TEST_tds.300.656367299
    input datafile fno=00085 name=+TEST_GRP/TEST/datafile/TEST_tds.344.695237023
    input datafile fno=00076 name=+TEST_GRP/TEST/datafile/TEST_tds.335.695041023
    input datafile fno=00046 name=+TEST_GRP/TEST/datafile/TEST_tds.305.662491879
    input datafile fno=00039 name=+TEST_GRP/TEST/datafile/TEST_ads.299.654710687
    input datafile fno=00048 name=+TEST_GRP/TEST/datafile/TEST_ads.307.662492133
    input datafile fno=00049 name=+TEST_GRP/TEST/datafile/TEST_ads.308.662492197
    input datafile fno=00107 name=+TEST_GRP/TEST/datafile/undotbs1.367.696699507
    input datafile fno=00098 name=+TEST_GRP/TEST/datafile/TEST_ods1.357.696598585
    input datafile fno=00150 name=+TEST_GRP/TEST/datafile/TEST_tds.410.707569569
    input datafile fno=00155 name=+TEST_GRP/TEST/datafile/TEST_ads.415.709551523
    input datafile fno=00113 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.373.697290733
    input datafile fno=00003 name=+TEST_GRP/TEST/datafile/sysaux.262.654101493
    input datafile fno=00001 name=+TEST_GRP/TEST/datafile/system.260.654101443
    input datafile fno=00010 name=+TEST_GRP/TEST/datafile/TEST_lds.270.654113411
    channel d2: starting compressed full datafile backupset
    channel d2: specifying datafile(s) in backupset
    input datafile fno=00086 name=+TEST_GRP/TEST/datafile/TEST_tds.345.695237043
    input datafile fno=00136 name=+TEST_GRP/TEST/datafile/TEST_tds.396.705247353
    input datafile fno=00128 name=+TEST_GRP/TEST/datafile/TEST_tds.388.702478685
    input datafile fno=00087 name=+TEST_GRP/TEST/datafile/TEST_tds.346.695237103
    input datafile fno=00078 name=+TEST_GRP/TEST/datafile/TEST_tds.337.695129727
    input datafile fno=00045 name=+TEST_GRP/TEST/datafile/TEST_tds.304.662491639
    input datafile fno=00119 name=+TEST_GRP/TEST/datafile/TEST_ads.379.700249037
    input datafile fno=00050 name=+TEST_GRP/TEST/datafile/TEST_ads.309.662492253
    input datafile fno=00132 name=+TEST_GRP/TEST/datafile/TEST_ads.392.704194655
    input datafile fno=00101 name=+TEST_GRP/TEST/datafile/TEST_ods1.360.696598703
    input datafile fno=00097 name=+TEST_GRP/TEST/datafile/TEST_ods1.356.696598559
    input datafile fno=00127 name=+TEST_GRP/TEST/datafile/TEST_ods1.387.701852257
    input datafile fno=00077 name=+TEST_GRP/TEST/datafile/users.336.695041119
    input datafile fno=00116 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.376.697290909
    input datafile fno=00006 name=+TEST_GRP/TEST/datafile/owbindex.266.654113339
    input datafile fno=00066 name=+TEST_GRP/TEST/datafile/TEST_rds_post_paid_cdr.325.667722723
    input datafile fno=00068 name=+TEST_GRP/TEST/datafile/TEST_rds_tapout.327.667722823
    input datafile fno=00109 name=+TEST_GRP/TEST/datafile/TEST_tds_user.372.696949827
    input datafile fno=00110 name=+TEST_GRP/TEST/datafile/uat_users.371.697117641
    input datafile fno=00033 name=+TEST_GRP/TEST/datafile/TEST_tds_indexes.293.654113827
    channel d3: starting compressed full datafile backupset
    channel d3: specifying datafile(s) in backupset
    input datafile fno=00057 name=+TEST_GRP/TEST/datafile/undotbs1.365.696688443
    input datafile fno=00140 name=+TEST_GRP/TEST/datafile/TEST_tds.400.707083997
    input datafile fno=00083 name=+TEST_GRP/TEST/datafile/TEST_tds.342.695130467
    input datafile fno=00074 name=+TEST_GRP/TEST/datafile/TEST_tds.333.695040881
    input datafile fno=00079 name=+TEST_GRP/TEST/datafile/TEST_tds.338.695129749
    input datafile fno=00152 name=+TEST_GRP/TEST/datafile/users.412.707602603
    input datafile fno=00047 name=+TEST_GRP/TEST/datafile/TEST_ads.306.662492079
    input datafile fno=00133 name=+TEST_GRP/TEST/datafile/TEST_ads.393.704194691
    input datafile fno=00091 name=+TEST_GRP/TEST/datafile/TEST_ods1.350.696598015
    input datafile fno=00100 name=+TEST_GRP/TEST/datafile/TEST_ods1.359.696598683
    input datafile fno=00105 name=+TEST_GRP/TEST/datafile/TEST_ods1.364.696598825
    input datafile fno=00012 name=+TEST_GRP/TEST/datafile/TEST_sds.272.654113455
    input datafile fno=00069 name=+TEST_GRP/TEST/datafile/TEST_rds.328.676059355
    input datafile fno=00115 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.375.697290875
    input datafile fno=00118 name=+TEST_GRP/TEST/datafile/TEST_sds.378.698406119
    input datafile fno=00059 name=+TEST_GRP/TEST/datafile/TEST_tds_post_paid_cdr.318.667722719
    input datafile fno=00060 name=+TEST_GRP/TEST/datafile/TEST_ods_post_paid_cdr.319.667722719
    input datafile fno=00061 name=+TEST_GRP/TEST/datafile/TEST_ods_tapout.320.667722721
    input datafile fno=00062 name=+TEST_GRP/TEST/datafile/TEST_ods_tapin.321.667722721
    input datafile fno=00063 name=+TEST_GRP/TEST/datafile/TEST_ads_post_paid_cdr.322.667722721
    channel d4: starting compressed full datafile backupset
    channel d4: specifying datafile(s) in backupset
    input datafile fno=00154 name=+TEST_GRP/TEST/datafile/users.414.708271719
    input datafile fno=00135 name=+TEST_GRP/TEST/datafile/TEST_tds.395.705247313
    input datafile fno=00042 name=+TEST_GRP/TEST/datafile/TEST_tds.302.656520125
    input datafile fno=00073 name=+TEST_GRP/TEST/datafile/TEST_tds.332.695040819
    input datafile fno=00082 name=+TEST_GRP/TEST/datafile/TEST_tds.341.695130447
    input datafile fno=00147 name=+TEST_GRP/TEST/datafile/TEST_tds.407.707084333
    input datafile fno=00122 name=+TEST_GRP/TEST/datafile/TEST_ads.382.700249099
    input datafile fno=00144 name=+TEST_GRP/TEST/datafile/TEST_tds.404.707084111
    input datafile fno=00038 name=+TEST_GRP/TEST/datafile/TEST_ads.298.654710453
    input datafile fno=00102 name=+TEST_GRP/TEST/datafile/TEST_ods1.361.696598723
    input datafile fno=00094 name=+TEST_GRP/TEST/datafile/TEST_ods1.353.696598467
    input datafile fno=00044 name=+TEST_GRP/TEST/datafile/undotbs1.271.696679255
    input datafile fno=00015 name=+TEST_GRP/TEST/datafile/TEST_rds.275.654113509
    input datafile fno=00065 name=+TEST_GRP/TEST/datafile/TEST_ads_tapin.324.667722723
    input datafile fno=00031 name=+TEST_GRP/TEST/datafile/TEST_rds_dly_act_smry_jan07.291.654113807
    input datafile fno=00032 name=+TEST_GRP/TEST/datafile/TEST_rds_dly_act_smry_maxval.292.654113817
    input datafile fno=00036 name=+TEST_GRP/TEST/datafile/TEST_rds_indexes.296.654113879
    input datafile fno=00037 name=+TEST_GRP/TEST/datafile/dbatemp.297.654113889
    input datafile fno=00043 name=+TEST_GRP/TEST/datafile/TEST_ods_sbscrbr_hist.303.656530541
    input datafile fno=00058 name=+TEST_GRP/TEST/datafile/TEST_tds_post_paid_src.317.667722667
    channel d5: starting compressed full datafile backupset
    channel d5: specifying datafile(s) in backupset
    input datafile fno=00011 name=+TEST_GRP/TEST/datafile/dba_activity.316.696605947
    input datafile fno=00104 name=+TEST_GRP/TEST/datafile/TEST_ods1.363.696598773
    input datafile fno=00151 name=+TEST_GRP/TEST/datafile/TEST_ads.411.707569675
    input datafile fno=00123 name=+TEST_GRP/TEST/datafile/TEST_ods1.383.700933365
    input datafile fno=00056 name=+TEST_GRP/TEST/datafile/TEST_rds.315.662492837
    input datafile fno=00112 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.369.697290733
    input datafile fno=00007 name=+TEST_GRP/TEST/datafile/owbuser.267.654113349
    input datafile fno=00017 name=+TEST_GRP/TEST/datafile/TEST_olap_audit.277.654113553
    input datafile fno=00018 name=+TEST_GRP/TEST/datafile/TEST_ods_cdr.278.654113587
    input datafile fno=00019 name=+TEST_GRP/TEST/datafile/TEST_ods_edr.279.654113597
    input datafile fno=00020 name=+TEST_GRP/TEST/datafile/TEST_ods_sms.280.654113631
    input datafile fno=00021 name=+TEST_GRP/TEST/datafile/TEST_ods_sbscrbr_hist.281.654113639
    input datafile fno=00023 name=+TEST_GRP/TEST/datafile/TEST_ods_sbscrbr_hist_maxval.283.654113657
    input datafile fno=00024 name=+TEST_GRP/TEST/datafile/TEST_ads_actvty_cube.284.654113691
    input datafile fno=00025 name=+TEST_GRP/TEST/datafile/TEST_ads_actvty_cube_jan07.285.654113701
    input datafile fno=00026 name=+TEST_GRP/TEST/datafile/TEST_ads_actvty_cube_maxval.286.654113711
    input datafile fno=00027 name=+TEST_GRP/TEST/datafile/TEST_ads_subss_status_fact.287.654113719
    input datafile fno=00028 name=+TEST_GRP/TEST/datafile/TEST_ads_subs_stts_fct_jan07.288.654113729
    input datafile fno=00029 name=+TEST_GRP/TEST/datafile/TEST_ads_subs_stts_fct_maxval.289.654113763
    input datafile fno=00030 name=+TEST_GRP/TEST/datafile/TEST_rds_dly_actvty_smry.290.654113773
    channel d6: starting compressed full datafile backupset
    channel d6: specifying datafile(s) in backupset
    input datafile fno=00089 name=+TEST_GRP/TEST/datafile/TEST_tds.348.695475571
    input datafile fno=00138 name=+TEST_GRP/TEST/datafile/TEST_tds.398.706176093
    input datafile fno=00041 name=+TEST_GRP/TEST/datafile/TEST_tds.301.656463415
    input datafile fno=00009 name=+TEST_GRP/TEST/datafile/TEST_tds.269.654113401
    input datafile fno=00088 name=+TEST_GRP/TEST/datafile/TEST_tds.347.695475473
    input datafile fno=00141 name=+TEST_GRP/TEST/datafile/TEST_tds.401.707084029
    input datafile fno=00121 name=+TEST_GRP/TEST/datafile/TEST_ads.381.700249081
    input datafile fno=00143 name=+TEST_GRP/TEST/datafile/TEST_tds.403.707084083
    input datafile fno=00092 name=+TEST_GRP/TEST/datafile/TEST_ods1.351.696598425
    input datafile fno=00095 name=+TEST_GRP/TEST/datafile/TEST_ods1.354.696598497
    input datafile fno=00103 name=+TEST_GRP/TEST/datafile/TEST_ods1.362.696598755
    input datafile fno=00148 name=+TEST_GRP/TEST/datafile/TEST_tds.408.707569461
    input datafile fno=00156 name=+TEST_GRP/TEST/datafile/TEST_rds.257.714381137
    input datafile fno=00114 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.374.697290735
    input datafile fno=00034 name=+TEST_GRP/TEST/datafile/TEST_ods_indexes.294.654113835
    input datafile fno=00022 name=+TEST_GRP/TEST/datafile/TEST_ods_sbscrbr_hist_jan07.282.654113649
    input datafile fno=00053 name=+TEST_GRP/TEST/datafile/TEST_dds.312.662492551
    input datafile fno=00052 name=+TEST_GRP/TEST/datafile/TEST_dds.311.662492489
    input datafile fno=00054 name=+TEST_GRP/TEST/datafile/TEST_dds.313.662492619
    input datafile fno=00005 name=+TEST_GRP/TEST/datafile/owbdata.265.654113297
    channel d7: starting compressed full datafile backupset
    channel d7: specifying datafile(s) in backupset
    input datafile fno=00137 name=+TEST_GRP/TEST/datafile/TEST_tds.397.706176033
    input datafile fno=00139 name=+TEST_GRP/TEST/datafile/TEST_tds.399.706176127
    input datafile fno=00129 name=+TEST_GRP/TEST/datafile/TEST_tds.389.702542715
    input datafile fno=00125 name=+TEST_GRP/TEST/datafile/TEST_tds.385.702198275
    input datafile fno=00081 name=+TEST_GRP/TEST/datafile/TEST_tds.340.695129943
    input datafile fno=00090 name=+TEST_GRP/TEST/datafile/TEST_tds.349.695475749
    input datafile fno=00120 name=+TEST_GRP/TEST/datafile/TEST_ads.380.700249057
    input datafile fno=00142 name=+TEST_GRP/TEST/datafile/TEST_tds.402.707084055
    input datafile fno=00131 name=+TEST_GRP/TEST/datafile/TEST_ads.391.704194625
    input datafile fno=00093 name=+TEST_GRP/TEST/datafile/TEST_ods1.352.696598449
    input datafile fno=00099 name=+TEST_GRP/TEST/datafile/TEST_ods1.358.696598613
    input datafile fno=00124 name=+TEST_GRP/TEST/datafile/TEST_ods1.384.700933397
    input datafile fno=00070 name=+TEST_GRP/TEST/datafile/TEST_rds.329.676059403
    input datafile fno=00111 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.370.697290733
    input datafile fno=00002 name=+TEST_GRP/TEST/datafile/undotbs1.261.654101459
    input datafile fno=00071 name=+TEST_GRP/TEST/datafile/TEST_ods_sbscrbr_hist_jan07.330.680708683
    input datafile fno=00072 name=+TEST_GRP/TEST/datafile/TEST_ods_sbscrbr_hist_jan07.331.680708755
    input datafile fno=00008 name=+TEST_GRP/TEST/datafile/TEST_rpstry.268.654113363
    input datafile fno=00051 name=+TEST_GRP/TEST/datafile/TEST_dds.310.662492431
    input datafile fno=00067 name=+TEST_GRP/TEST/datafile/TEST_rds_tapin.326.667722723
    channel d8: starting compressed full datafile backupset
    channel d8: specifying datafile(s) in backupset
    input datafile fno=00004 name=+TEST_GRP/TEST/datafile/users.264.654101503
    input datafile fno=00146 name=+TEST_GRP/TEST/datafile/TEST_tds.406.707084307
    input datafile fno=00084 name=+TEST_GRP/TEST/datafile/TEST_tds.343.695237005
    input datafile fno=00075 name=+TEST_GRP/TEST/datafile/TEST_tds.334.695040959
    input datafile fno=00080 name=+TEST_GRP/TEST/datafile/TEST_tds.339.695129765
    input datafile fno=00153 name=+TEST_GRP/TEST/datafile/users.413.708271033
    input datafile fno=00014 name=+TEST_GRP/TEST/datafile/TEST_ads.274.654113499
    input datafile fno=00130 name=+TEST_GRP/TEST/datafile/TEST_ads.390.704194583
    input datafile fno=00145 name=+TEST_GRP/TEST/datafile/TEST_tds.405.707084139
    input datafile fno=00096 name=+TEST_GRP/TEST/datafile/TEST_ods1.355.696598533
    input datafile fno=00149 name=+TEST_GRP/TEST/datafile/TEST_tds.409.707569511
    input datafile fno=00106 name=+TEST_GRP/TEST/datafile/undotbs1.366.696693453
    input datafile fno=00117 name=+TEST_GRP/TEST/datafile/TESTtdscdrpart.377.697290949
    input datafile fno=00016 name=+TEST_GRP/TEST/datafile/TEST_olap.276.654113543
    input datafile fno=00013 name=+TEST_GRP/TEST/datafile/TEST_dds.273.654113489
    input datafile fno=00035 name=+TEST_GRP/TEST/datafile/TEST_ads_indexes.295.654113845
    input datafile fno=00064 name=+TEST_GRP/TEST/datafile/TEST_ads_tapout.323.667722723
    input datafile fno=00126 name=+TEST_GRP/TEST/datafile/TEST_ads_tapout.386.701419275
    input datafile fno=00134 name=+TEST_GRP/TEST/datafile/TEST_ads_tapout.394.704728861
    input datafile fno=00055 name=+TEST_GRP/TEST/datafile/TEST_dds.314.662492689
    channel d1: backup set complete, elapsed time: 00:54:41
    channel d3: backup set complete, elapsed time: 01:10:07
    channel d2: backup set complete, elapsed time: 01:11:12
    channel d4: backup set complete, elapsed time: 01:12:18
    channel d6: backup set complete, elapsed time: 01:12:42
    channel d7: backup set complete, elapsed time: 01:12:57
    channel d8: backup set complete, elapsed time: 01:14:31
    channel d5: backup set complete, elapsed time: 01:30:28
    Finished backup at 10-APR-10
    
    released channel: d1
    
    released channel: d2
    
    released channel: d3
    
    released channel: d4
    
    released channel: d5
    
    released channel: d6
    
    released channel: d7
    
    released channel: d8
    
    RMAN&gt;
    
    Recovery Manager complete.
    Edited by: Fahd Mirza on Apr 10, 2010 8:37 PM
This discussion has been closed.