syed_shabbir
asked on
For backups using RMAN, setting NLS_LANG, NLS_DATE and parameter BACKUP_TAPE_IO_SLAVES
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
Pls guide me in the above issues.
Thank you.
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
Pls guide me in the above issues.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.