Backup

[YOGI_3]

Hi All,
I compress 800Gb of data and come to 240GB on one LV.
I compress 80GB of data and come to 43GB on other LV.
I am using Ultrium 460 Drive. I am using ultrium 400GB tape for backup.
240+43=283GB. It should come on a single tape but its asking for other tape for continiung backup.
Also suggest me the trusted and fast backup utility for backup of oracle database.


Waiting for replis,,,
thanks,
Yogesh

[Rajeev Shukla]

Hi Yogesh,

the 400GB ultrium tape is actually 200GB uncompressed and 400GB compressed. Which means when you use a backup utility with compression enabled you can utilize 400GB of tape space and without compression only 200GB. Thats why its asking for another tape.

Cheers
Rajeev

[Wim Rombauts]

The current most supported way to backup oracle is RMAN. That is an Oracle tool that can be used from the commandline (and thus scripted). It can backup to disk files, or directly to tape.
To get to know the usage of RMAN, you best read the Oracle documentation.
As for your tape capacity question : the answer above is correct. A 400GB LTO-2 tape has only a 200GB capacity. The 400GB capacity is assumed when an average compression op 2:1 is possible. When you write already compressed data to that tape, it cannot be compressed a second time.
My tip : Don't compress your data, let your tape handle compression.

[renarios]

Hi Yogesh,

I use the Oracle RMAN utility. It is fast, can do SUPPORTED online backups and does not backup the complete datafiles, but only till the high-water mark.

Cheerio,

Renarios

[YOGI_3]

thanks for reply to all..
when iam tring to verify backup on tape which has taken by fbackup is giving follwing error---
---------------------------------------------
# frecover -N -I -f /dev/rmt/0mn
frecover(3207): additional argument: /dev/rmt/0mn specified
frecover -r [-hosvymFNOX] [-c config] [-f device] [-S skip] [-E extarg]
frecover -R path [-f device]
frecover -x [-hosvymFNOX] [-c config] [-e path] [-f device]
[-g graph] [-i path] [-S skip] [-E extarg]
frecover [-I | -V] path [-vy] [-f device] [-c config]
-{r,x} - full/partial recovery
-{I,V} - write index/volume-header to path
-{F,X} - flat/relative recovery
-{i,e} - specify a path to include/exclude
-{g,c} - specify a graph/configuration file
-{N,h} - No files recovered-Only verify/graph information
-R - continue an interrupted session
-f - specify an input device
-o - overwrite existing files
-v - verbose mode
-y - answer yes to all questions
-S - specify a file for skipped blocks
-s - sparse file recovery
-O - set ownership of files to the user running the recovery
-m - Print marker information (checksums, filemarks, setmarks)
-E - specify extent attributes handling: warn, force, or ignore
#
------------------------------------------
pl give me a coomand which will verify backup data in tape drive, i am using fbackup utility.

Thanks,
Yogesh

[Leif Halvarsson_2]

Hi
Do you backup COMPRESSED data to the Ultrium drive ? In that case, no more then 200GB (native capacity) will fit on one media. The 400GB is an average for uncompressed data (there may be big differences depending on the actual data type).

RMAN is the standard utility for Oracle backups. It can be used standalone but, better together with an 3-party backup software (e.g. Data Protector). DP acts as a Media Management system, scheduler and grapical interface for RMAN.

[Suraj_2 · Accepted solution]

Hi

try as follows to verify the backup

# frecover -x -N -f /dev/rmt/0mn



Rgds
Suraj

[Darren Prior]

Please note that fbackup/frecover do not support use of the no rewind device files. (ie /dev/rmt/0mn)

regards,

Darren.

[Devesh Pant_1]

My suggestion to you would be to use RMAN for Oracle backups.

However for the time being you might want to try out ignite for backing using an ignite server.

thanks
Devesh