Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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,074 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
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

580 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