How to restore one file from Ignite.

[Silver_1]

All,

Need to restore the cron file for oracle (user) to a file and need to send it to the DBA's.

I have last weeks ignite tape.

I was knowing the command but i forgot.

Any help is appeciated.

Tx

[Mel Burslan]

ignite image is a tar archive at the end, if you used the default option for the format. If this is the case,

cd /tmp
tar -xvf /dev/0m /var/spool/cron/crontabs/oracle

provided your tape drive's device path is /dev/0m and your crontabs are located at this location. If anything is different, adjust according to your specific situation.

[erics_1 · Accepted solution]

For future reference, the info is in the manpage for make_tape_recovery

mt -t /dev/rmt/0mn fsf 1
tar -xvf /dev/rmt/0m filename

Make sure to omit the leading / when specifying 'filename'.

Regards,
Eric

[Mel Burslan]

Beware, since there is a very high probabilty that this activity will write over oracle's existing crontab, better if you make a backup copy of the current crontab file.

[Tim Nelson]

Mel and Eric have nailed this on the head.
Have done individual file restores from Ignite tape many times.

mt -t tapen fsf 1 ( to forward past the LIF on tape, don't forget to use the no-rewind device)

tar xvf tape file to restore

Once past the LIF info you can do a "tar vtf tape" to list the contents just to be sure. Do not forget to rewind and fsf again to do the restore.

[Tom Danzig]

FYI, the files on the ignite tape are archive using relative pathnames. i.e.

var/spool/cron/crontabs/username

There is no leading slash so there is no fear of overwriting the existing file as long as you are not in the root (/) directory.

[Bill Hassell]

And a note for tar: it does an *EXACT* match on the filename as stored on the tape. So using /var/spool/cron/crontabs/username will fail. Your filename must match the entire name on the tape as in:

tar xvf /dev/rmt/0mnb var/spool/cron/crontabs/username

NOTE: ALWAYS use the Berkeley no-rewind device file. The default device file 0m will nullify any mt tape positioning commands. See man mt

[Silver_1]

All,

Given the following commands.
cd /tmp
mt -f /dev/rmt/0mn rew
mt -f /dev/rmt/0mn fsf 1
tar xvf /dev/rmt/0mn var/spool/cron/crontabs/oracle

the file was restored to /tmp.

Tx for all your help.