restore from tape help

[Joe Johnson]

Have a large database, all under one directory. Don't want to restore all files from tape due to time needed. Need to only restore files that have been modified since backup was made. Do you know how? Not familiar with any other way to restore files other than through SAM. I know there is the tar command, but not familiar with syntax.
Thanks in advance...

[S.K. Chan]

How were the files backed up at the first place, the command you used, etc ? If you use SAM to back it up, how was it defined ?

[Darrell Allen]

Hi Joe,

Question number 1: How was the backup made? That is, what utility was used to create your backup?

Darrell

[Craig Rants · Accepted solution]

If your tape was done with tar, here is how I would do this.
Run this script
#!/bin/sh
find /dbdir -mtime +"days since backup" -exec ls {} \; > /tmp/newfiles.out

for i in `cat /tmp/newfiles.out`
do
echo "$i \" >> /tmp/newfiles1.out
done


Then vi /tmp/newfiles1.out and add this on the first line making sure it not to remove the line currently present, but before the entry already present.
tar xvf /dev/rmt/tapedevice
Example

tar xvf /dev/rmt/tapedevice /ora01/file1 /ora01/file2 etc...

Hope this helps,
C

[Joe Johnson]

Used SAM interactive backup and selected an entire directory to make the backup...

[Patrick Wallek]

Via SAM, your backup would have been done with fbackup.

You'll have to do the restore either thru SAM, or use the frecover command.

Do you know, or can you tell via an ll of the directory, which files have changed since you ran the backup? If so, the recovery interface through SAM lets you specify specific files to restore. I am not sure what the other options within SAM are for recovering, as I'm not able to login right now.