?
Solved

For backups using RMAN, setting NLS_LANG, NLS_DATE and parameter BACKUP_TAPE_IO_SLAVES

Posted on 2003-02-26
2
Medium Priority
?
3,032 Views
Last Modified: 2007-12-19
We are using SAP 4.6 C application, Oracle 8.1.7.3 database, and AIX 4.3 Operating System. I am taking the backups using RMAN (Recovery Manager, which is a Oracle tool) in cooperation with TSM (Tivoli Storage Manager).
In the RMAN messages log file after the completion of the Oracle database backups using RMAN, it is showing the backup set creation_time=26-FEB-03, it is showing only the date but not the time at which the backup has been taken place. Waht I have to do if I wants to get the backup time also to be recorded in the log file instead of only the backup date? I wants both the backup time and date to be recorded in the RMAN log file, for this what should I do? I have seen in Oracle manual to set the fololowing NLS environment variables before invoking RMAN.
The environment variables are : NLS_LANG=american,
NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'.
I don't know how to set these environment variable, pls guide me how to do these settings. And, it is saying that these variables has to be set before invoking RMAN, what does it means? Before taking the backups I have to set these variables or someother meaning? I have already invoked RMAN and daily taking the backups, now how should I set these variables so that I can get both the date and time in the backup log files.
And another issue is, when taking the backups to 3 different tapes at the same time, the init parameter BACKUP_TAPE_IO_SLAVES=TRUE has to be there in init<sid>.ora parameter file, this is what the Oracle manual is saying. Only this is the parameter I have to change to take the duplex backup sets or I have to add or change any other parameters or settings? I have to increase the number of backup channels also or not?
Pls guide me in the above issues.
Thank you.
0
Comment
Question by:syed_shabbir
[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 Comments
 

Accepted Solution

by:
giteshtrivedi earned 300 total points
ID: 8027298
Dear friend,

It is very simple to set this variable at when you start with RMAN.

ALTER SESSION SET NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'

or

ALTER SYSTEM SET NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'

I think after you set this parameter in your SQLplus you can work easily.

Thanks,
Gitesh Trivedi.

0
 

Author Comment

by:syed_shabbir
ID: 8046868
Mr.Trivedi,
As you said, I have used the command "Alter session set NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'" in SQLPLUS. After using this command still RMAN backup messages are not showing the time, only date is written. Pls could you tell me clearly how to set this variable and what to do after setting this variable to get the backup time written in the backup log files?

Thank you,
Shabbir.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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 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…
Suggested Courses

762 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