Home » RDBMS Server » Backup & Recovery » taging the backup set
taging the backup set [message #152909] Tue, 27 December 2005 15:12 Go to next message
skodman
Messages: 10
Registered: March 2005
Location: Auckland
Junior Member
here is the question

I have to implement incremental backups during the week and full backup on Sundays. Now i have to tag level 1 backups like mon_set, tue_set etc.

How i understand this is that i have to run different script every day with different tag. Basically it would be same script with different tag part. Thing i don't know is if it is possible to make this script more generic so i always call same script and tag is changing automatically. Something like formating options (%d, %F and all the others).,

any idea?
Re: taging the backup set [message #152925 is a reply to message #152909] Tue, 27 December 2005 23:03 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
can something like this help you.

 # incr_lev.sh
 # $1 -- tag value
 tag_txt="$1"
 rman <<EOF
 connect target sys/your_passwd
 connect catalog rman/rman@srvc_rman
 run 
 {
 allocate channel chan1 device type disk;
 backup 
 incremental level 1
 fileperset 2
 tag $tag_txt
 format 'YOUR_PATH/incr_%d_%t_%p_%c.dbf' 
 database;
 release channel chan1;
 }
 EOF


I didnt try it but i hope it should work for you. Post back the results.

[Updated on: Tue, 27 December 2005 23:12]

Report message to a moderator

Previous Topic: db_flashback_retention _target in Flashback recovery
Next Topic: how to restore the database after re-install windows system??
Goto Forum:
  


Current Time: Fri Apr 19 22:23:58 CDT 2024