Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

RMAN Formatting

Posted on 2014-04-01
4
Medium Priority
?
337 Views
Last Modified: 2014-04-02
I have archived logs that come out in the following format
-bash-3.2$ ls /archlog1/BB60
1_253772_786457154.arc  1_253823_786457154.arc  1_253874_786457154.arc  1_253925_786457154.arc  1_253976_786457154.arc
1_253773_786457154.arc  1_253824_786457154.arc  1_253875_786457154.arc  1_253926_786457154.arc  1_253977_786457154.arc
I want to use RMAN to back these up and retain the same filenames for the backed up files.
I'm thinking something like:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/archlog2/BB60/archlogbackup/%...%...
How do I find out how to do that?
0
Comment
Question by:xoxomos
  • 2
  • 2
4 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1200 total points
ID: 39970981
Archived redo logs are backed up as a set.

As far as the format of the archive log backups, just add the format clause to the archivelog line.


 ... plus archivelog format ??? ...

Where ??? is whatever format clause you want.

I don't have access to my rman scripts right now but I remember having a backup for the database and another line for the archived redo logs.

If you can't find a solution, I'll try to get access to my script in the next few days.
0
 

Author Comment

by:xoxomos
ID: 39971213
Thanks.  Before going to that trouble, let me try testing.  Since RMAN backs them up as a set, i guess there is no need for me to recognize or have the same file names as the logs.
Correct?
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39973603
I can see no reason to change the name of the set to show what logs are in the set.  RMAN will report what is where if you ever need a specific archived redo log, then you know what set to grab.

If knowing exactly what is where at any given time without RMAN reporting, save your RMAN logs for every backup.
0
 

Author Comment

by:xoxomos
ID: 39973750
Agreed.  As long as RMAN knows, less concern for me.  I think setting up the separate retention policies for logs and data will work fine.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question