- 3,724,396 Users
- 2,244,747 Discussions
- 7,850,993 Comments
Forum Stats
Discussions
Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2.1K Databases
- 623 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 497 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 422 SQLcl
- 62 SQL Developer Data Modeler
- 185.1K SQL & PL/SQL
- 21.1K SQL Developer
- 2.5K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.7K Development Tools
- 14 DevOps
- 3K QA/Testing
- 338 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 72 Java Community Process
- 2 Java 25
- 12 Java APIs
- 141.2K Java Development Tools
- 8 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 16 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 147 LiveLabs
- 34 Workshops
- 10 Software
- 4 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 16 Español
- 1.9K Japanese
- 3 Portuguese
RMAN Script in Solaris
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
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
-
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 -
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 / <<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; } EOFEdited by: Fahd Mirza on Apr 10, 2010 1:24 PM
Edited by: Fahd Mirza on Apr 10, 2010 1:25 PM -
-
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 -
Will this script be run in parrallel by 8 channels, which I specified?When you run the script, what do you observe?
-
Can you please tell me how to monitor this thing?
regards -
ps -ef
-
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> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 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> Recovery Manager complete.
Edited by: Fahd Mirza on Apr 10, 2010 8:37 PM
This discussion has been closed.