Hi,
First of all FRA stands for Flash Recovery Area, just to correct you there.
Coming to your question,
MML or Secure backup is a must for you to perform database backup operation from RMAN.MML is the intemediary who speaks between RMAN and the tape
But if you wish to take a backup of the FRA, or the directory as a whole then you can simple perform a tar or an OS backup to the tape, and later onwards catalog the backup pieces in cases you need to restore/recover from tape.
Hope this answers your question.
Best Regards,
Hi ARM.Asif,
Thank you for your response to my question and also I appreciate correcting me the FRA Definition as Flash Recovery Area.
Back to your suggestion:
"But if you wish to take a backup of the FRA, or the directory as a whole then you can simple perform a tar or an OS backup to the tape, and later onwards catalog the backup pieces in cases you need to restore/recover from tape."
How can I obtain this and how it works?
Appreciate if you could give me a sample script on how to do this since this will be use as my daily backup routine using rman?
I was reading oracle books and forums but all of the samples are using MML. I really cannot find solutions and answers to my question.
Thank you so much
Hi,
Since you have not posted your OS details, I am unable to help you or direct you to a sample script
Please post the details here so that I can try to provide you with assistance.
Thank you so much
Welcome brother
Hi
Here are the details:
I am using OEL 6 with Oracle Database 11gR2 Single Instance with ASM.
Thank you
Hi,
There are so many hits you can get for achieving your objective in google: Let me google that for you
Syntax: tar -cvf <tape drive> <directory to backup>
Simply, assuming your linux OS has detected your tape drive to be /dev/st0. In that case:
cd $ORACLE_BASE
tar -cvf /dev/st0 FRA ## This command will backup the FRA directory to your tape
Hope this helps!
Regards,
I am sorry for my ignorance. Appreciate your fast response to my question,
Just to share with you my current routine
What I do is manually transfer FRA Backup Piece into File system using this script
for i in $(asmcmd ls +FRA/ILIFE/BACKUPSET/2013_05_21); do
asmcmd cp +FRA/ILIFE/BACKUPSET/2013_05_21/$i /u02/backup
done
then from file system I use tar cvf /dev/st0 <u02....> to backup this into tape.
but you gave me a simple solution on this and it was very helpful bro.
just an additional to question
How about restoring the tape into FRA and how to use ta CATALOG Command?
Thank you
Hi,
No need to be sorry.
You may restore from tape, using command:
tar -xvf /dev/st0
Doing some googling would help you on this. For example refer link:
Create/Add/Extract Tape ARchives files.
how to use ta CATALOG Command
You may simply issue the following command:
CATALOG {ARCHIVELOG | BACKUPPIECE | CONTROLFILECOPY | DATAFILECOPY}
Please refer documentation:
Hope this answers your question!
Best Regards
Correct me if Im wrong bro. I think this type of command works only if your FRA resides into a File System. Am I right?
to be able to access your FRA through ASM, you need to use the CL asmcmd
cd $ORACLE_BASE
tar -cvf /dev/st0 FRA ## This command will backup the FRA directory to your tape
Hi,
Your point of accessing FRA via ASM is correct.
But my illustration of command was just a mere example of how you can use the tar syntax to copy a directory/file into tape.
Once you extract the directories/files, you may start using the landed directories/files as required.
Hope this clarifies.
Best Regards,
I got your point ARM.Asif but the sample command you shared is applicable if you are in a non-asm environment.
cd $ORACLE_BASE
tar -cvf /dev/st0 FRA ## This command will backup the FRA directory to your tape
This doesn't solved my question
What I am expecting answer is,the possibility to take a backup from FRA-ASM directly to tape without using MML.
Hi,
What is the size of your database?
Please have a look at link:
Copying files from ASM to file system &laquo; Oracle Technologies Blog
I dont see of a easy method of transferrring backup to tape (except for getting licensed MML software), if not you will have to transfer the backups from ASM to filesystem, and from there transfer to TAPE.
Best Regards,
