Solved

RMAN Formatting

Posted on 2014-04-01
4
334 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 300 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 77

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.

752 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