Solved

RMAN Formatting

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

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 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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 …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now