In fact, we are keeping 6 copies of our last backups on high-speed tape (HP-Ultrium).Įveryday except Early Monday morning where you should append to the tape. The backup files being deleted are already on tape beforehand. In fact, i can't forget your words "I've seen it happen more than once and it will happen to you" which you have repeated on most of your replies to backup related questions ) My goal is to get that backup off to tape actually - onto some other storage. O that is up to you - I would just stripe them all together into one big one and deal with it that way. Why? Because my database could be that big and it'll grow and I want to have space to stuff it. O I would use the size of my database as a starting point, and make sure I have 1.5 to 2x that much storage available for my current backup set. You need to buy a tape drive or some other storage device if you are somewhat serious about backup and recovery. ELSE YOU WILL LOSE ALL OF YOUR DATA SOMEDAY.ĭon't laugh - I've not only seen it happen, I've seen it happen more then once and it will happen to you. You need to keep at least two and preferably 3 or more of your last backups. Thank you for your patience and precious guidance. Based on the size of the file systems, how do i allocate my channels so that we make the best use of the file systems?
AUTOMIZE AS2 FULL
How do i determine how much space will be required by my FULL rman backup? Subject="RMAN-Backup Log (full) on -s "$subject" $emailadd1 /devĮcho "allocate channel for delete type disk "įor i in `ls -1 /backup*/rman/full/fs*/* ` Messagelog="/backup/rman/logfiles/rman_full-`date +%d%m%y-%H%M`"Īllocate channel fs1b type disk format='/backup/rman/full/fs1/full_%u.%p' Īllocate channel fs2b type disk format='/backup/rman/full/fs2/full_%u.%p' Īllocate channel fs3b type disk format='/backup/rman/full/fs3/full_%u.%p' Īllocate channel fs4b type disk format='/backup/rman/full/fs4/full_%u.%p' Īllocate channel fs5b type disk format='/backup/rman/full/fs5/full_%u.%p' Īllocate channel fs6b type disk format='/backup/rman/full/fs6/full_%u.%p' Īllocate channel fs7b type disk format='/backup/rman/full/fs7/full_%u.%p' īackup database include current controlfile } prod/global/admin/bckup/rman_deletefull.sh prod/global/admin/bckup/generate_deletefull_script.sh > /prod/global/admin/bckup/rman_deletefull.shĬhmod +x /prod/global/admin/bckup/rman_deletefull.sh the disk backup is then to sent to tape by another scheduled process) My last successful FUll RMAN backup took 14GB (fitted in /backup => ). Hence, i have 2 file systems of different sizes available.įilesystem kbytes used avail %used Mounted on
AUTOMIZE AS2 FREE
Which i believe is related to insufficient disk space being available in file system /backup.įortunately, i have another file system /backup01 (which is reserved for RMAN Archived Redolog backup) with lots of free space. RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE HP-UX Error: 2: No such file or directory RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/backup/rman/full/fs2/full_idecnd2s.2", blockno 67585 (blocksize=1024) RMAN-07004: unhandled exception during command execution on channel fs2b RMAN-03007: retryable error occurred during execution of command: backup
RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = With this my RMAN backup is starting to Fail! I was doing my Database backup using RMAN (Full backup everyday) to disk until recently when we got a new application which required about 2 GB of additional disk space.
I have a question concerning RMAN backup to disk.
0 kommentar(er)
