Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Rman hot backup script gives error in R12.

pritesh ranjanJan 11 2014 — edited Jan 13 2014

hi experts

i m facing following prob when run the backup script. 1 day before the same script runs correctily but now  it gives me error at the allocatioion of channel rest of command run correctly.

[root@testerp rman_log]# cat UAT_daily_rman_hot_bkp_01-11-14_140301.log

-bash: /root/.bash_profile: Permission denied

Recovery Manager: Release 11.1.0.7.0 - Production on Sat Jan 11 14:03:01 2014

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

connected to target database: UAT (DBID=2855851979)

connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found "end-of-file": expecting one of: "allocate, alter, advise, backup, beginline, blockrecover, catalog, change, copy, convert, crosscheck, configure, duplicate, debug, delete, execute, endinline, flashback, host, mount, open, plsql, recover, release, replicate, report, restore, resync, repair, }, set, setlimit, sql, switch, startup, shutdown, send, show, transport, validate"

RMAN-01007: at line 12 column 1 file: standard input

RMAN>

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: "for"

RMAN-01008: the bad identifier was: c2

RMAN-01007: at line 1 column 18 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: "for"

RMAN-01008: the bad identifier was: c3

RMAN-01007: at line 1 column 18 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: "for"

RMAN-01008: the bad identifier was: c4

RMAN-01007: at line 1 column 18 file: standard input

RMAN>

Starting backup at 11-JAN-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=362 device type=DISK

channel ORA_DISK_1: starting incremental level 1 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00021 name=/d06/UAT/proddata/a_txn_data06.dbf

input datafile file number=00392 name=/d06/UAT/db/apps_st/data/a_txn_data01.dbf

input datafile file number=00401 name=/d06/UAT/db/apps_st/data/a_txn_data02.dbf

input datafile file number=00402 name=/d06/UAT/db/apps_st/data/a_txn_data03.dbf

input datafile file number=00022 name=/d06/UAT/proddata/a_txn_data07.dbf

input datafile file number=00014 name=/d06/UAT/db/apps_st/data/a_txn_data04.dbf

input datafile file number=00020 name=/d06/UAT/proddata/a_txn_data05.dbf

input datafile file number=00011 name=/d06/UAT/db/apps_st/data/sysaux01.dbf

input datafile file number=00018 name=/d06/UAT/db/apps_st/data/sysaux02.dbf

input datafile file number=00023 name=/d06/UAT/proddata/a_txn_data08.dbf

input datafile file number=00379 name=/d06/UAT/db/apps_st/data/undo01.dbf

input datafile file number=00024 name=/d06/UAT/proddata/sysaux03.dbf

input datafile file number=00025 name=/d06/UAT/proddata/sysaux04.dbf

input datafile file number=00033 name=/d06/UAT/proddata/a_txn_ind11.dbf

input datafile file number=00029 name=/d06/UAT/proddata/a_txn_ind09.dbf

input datafile file number=00030 name=/d06/UAT/proddata/a_txn_ind10.dbf

input datafile file number=00015 name=/d06/UAT/db/apps_st/data/a_txn_ind06.dbf

input datafile file number=00026 name=/d06/UAT/db/apps_st/data/a_txn_ind07.dbf

input datafile file number=00028 name=/d06/UAT/db/apps_st/data/a_txn_ind08.dbf

input datafile file number=00393 name=/d06/UAT/db/apps_st/data/a_txn_ind01.dbf

input datafile file number=00403 name=/d06/UAT/db/apps_st/data/a_txn_ind02.dbf

input datafile file number=00404 name=/d06/UAT/db/apps_st/data/a_txn_ind03.dbf

input datafile file number=00405 name=/d06/UAT/db/apps_st/data/a_txn_ind04.dbf

input datafile file number=00406 name=/d06/UAT/db/apps_st/data/a_txn_ind05.dbf

input datafile file number=00400 name=/d06/UAT/db/apps_st/data/a_media01.dbf

input datafile file number=00353 name=/d06/UAT/db/apps_st/data/system08.dbf

input datafile file number=00013 name=/d06/UAT/db/apps_st/data/system12.dbf

input datafile file number=00352 name=/d06/UAT/db/apps_st/data/system09.dbf

input datafile file number=00394 name=/d06/UAT/db/apps_st/data/a_ref01.dbf

input datafile file number=00407 name=/d06/UAT/db/apps_st/data/a_ref02.dbf

input datafile file number=00396 name=/d06/UAT/db/apps_st/data/a_summ01.dbf

input datafile file number=00395 name=/d06/UAT/db/apps_st/data/a_int01.dbf

input datafile file number=00008 name=/d06/UAT/db/apps_st/data/a_queue02.dbf

input datafile file number=00027 name=/d06/UAT/db/apps_st/data/a_queue03.dbf

input datafile file number=00031 name=/d06/UAT/db/apps_st/data/a_queue04.dbf

input datafile file number=00399 name=/d06/UAT/db/apps_st/data/a_queue01.dbf

input datafile file number=00001 name=/d06/UAT/db/apps_st/data/system01.dbf

input datafile file number=00002 name=/d06/UAT/db/apps_st/data/system02.dbf

input datafile file number=00003 name=/d06/UAT/db/apps_st/data/system03.dbf

input datafile file number=00004 name=/d06/UAT/db/apps_st/data/system04.dbf

input datafile file number=00005 name=/d06/UAT/db/apps_st/data/system05.dbf

input datafile file number=00398 name=/d06/UAT/db/apps_st/data/a_archive01.dbf

input datafile file number=00295 name=/d06/UAT/db/apps_st/data/system06.dbf

input datafile file number=00351 name=/d06/UAT/db/apps_st/data/system07.dbf

input datafile file number=00354 name=/d06/UAT/db/apps_st/data/system11.dbf

input datafile file number=00288 name=/d06/UAT/db/apps_st/data/system10.dbf

input datafile file number=00012 name=/d06/UAT/db/apps_st/data/apps_ts_tools01.dbf

input datafile file number=00016 name=/d06/UAT/db/apps_st/data/a_ref03.dbf

input datafile file number=00019 name=/d06/UAT/db/apps_st/data/MLSEIGL01.dbf

input datafile file number=00032 name=/d06/UAT/db/apps_st/data/RMAN01.dbf

input datafile file number=00397 name=/d06/UAT/db/apps_st/data/a_nolog01.dbf

input datafile file number=00314 name=/d06/UAT/db/apps_st/data/portal01.dbf

input datafile file number=00017 name=/d06/UAT/db/apps_st/data/a_int02.dbf

input datafile file number=00006 name=/d06/UAT/db/apps_st/data/ctxd01.dbf

input datafile file number=00010 name=/d06/UAT/db/apps_st/data/olap.dbf

input datafile file number=00009 name=/d06/UAT/db/apps_st/data/odm.dbf

input datafile file number=00007 name=/d06/UAT/db/apps_st/data/owad01.dbf

channel ORA_DISK_1: starting piece 1 at 11-JAN-14

[root@testerp rman_log]#

###########################################################################################################################


backup script is below:

in this script it returns error only at the channel allocaition rest of all backup command i run manually or with scirpt it runs correctly.4

i m not able to know why it returns error only at challnel allocation 1 day before it runs correctly.


[orauat@testerp rman_script]$ cat rman_backup.sh

#!/bin/sh

#############################################################################

#ORACLE_SID=UAT

#BACKUP_START_TIME='date +"%y""%m""%d"_"%H""%M""%S"'

#ORACLE_HOME=/d06/UAT/db/tech_st/11.1.0

#PATH=$PATH:${ORACLE_HOME}:${ORACLE_HOME}/bin

#export ORACLE_SID

#export ORACLE_HOME

#export PATH

/d06/UAT/db/tech_st/11.1.0/bin/rman catalog rman/rman007 target sys/sysuat <<EOF

run

{

allocate channel c1 device type disk format '/d06/UAT/rman_hot_backup/Daily_backup%d_Arch_%c_%U';

sql 'alter system switch logfile';

sql 'alter system switch logfile';

sql 'alter system archive log current';

delete expired archivelog all;

crosscheck archivelog all;

backup archivelog all;

delete noprompt archivelog all completed before 'sysdate-4' backed up 1 times to disk;

allocate channel c2 device type disk format '/d06/UAT/rman_hot_backup/Daily_backup%d_DB_%c_%U';

allocate channel c3 device type disk format '/d06/UAT/rman_hot_backup/Daily_backup%d_DB_%c_%U';

allocate channel c4 device type disk format '/d06/UAT/rman_hot_backup/Daily_backup%d_DB_%c_%U';

backup incremental level 1 database;

delete expired backup device type disk;

delete obsolete device type disk;

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}

exit

EOF


regards

pritesh ranjan
This post has been answered by Hemant K Chitale on Jan 13 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 10 2014
Added on Jan 11 2014
#performance-availability, #recovery-manager-rman
4 comments
3,153 views