Skip to Main Content

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!

Rman Backup Script is not went to proper directory with error

Dr.AntyOct 18 2015 — edited Oct 26 2015

Hello Experts,

I have below rman backup script to take full backup, the backup went to fast recovery area, although I mentioned the Backup directory in scrip /backup/ RMANBACKUP...

 

/oracle/app/fast_recovery_area/GNDB/backupset ..2015_10_18

o1_mf_nnndf_TAG20151018T122709_c26shgq2_.bkp       

o1_mf_nnndf_TAG20151018T123757_c26t3owg_.bkp



kindly advice how to genriate the datafiles in /backup/RMANBACK


If you a comment for the below script.kindly advice.


#!/bin/sh

a='RMAN BACKUP START AT : '`date`

NLS_DATE_FORMAT='DD-mon-YYYY HH24:MI:SS'

export NLS_DATE_FORMAT

cd /backup/RMANBACKUP/

rm *

rman <<EOF

connect target

run

        crosscheck backupset ;

        crosscheck archivelog all ;

        allocate channel t1 device type disk format '/backup/RMANBACKUP/y.db_%d_t%t_s%s_p%p';

        configure controlfile autobackup on;

        delete noprompt obsolete device type disk;

        sql "alter system archive log current";

        backup database;

backup archivelog all delete input format '/backup/RMANBACKUP/arch_%d_%u_%s';

backup current controlfile format '/backup/RMANBACKUP/y.CNTRL_%d_t%t_s%s_p%p';

release channel t1;

        sql "alter system archive log current";

}

EOF

b='RMAN BACKUP END AT : '`date`

echo $a

echo $b

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2015
Added on Oct 18 2015
33 comments
3,839 views