Solved

RMAN Formatting

Posted on 2014-04-01
4
333 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 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

Industry Leaders: 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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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.

680 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