Solved

RMAN Formatting

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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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 configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

627 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