| Rman backup performance issue [message #649631] |
Fri, 01 April 2016 08:37  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
I am having performance issue in RMAN Backup.
I have ran the Rman Backup at 12.30 PM and the logfile register the exact time
But when I query the RMAN JOB output, It shows the RMAN BACKUP Started at 2.56 PM.
RMANBACKUP.CMD file has the below mentioned contents.
-----------------------------------------------------
set oracle_sid=<LIVESERVER>
del /f/s/q Z:\RBACKUP\DMP > nul
set dd=%DATE:~0,2%
Set mm=%DATE:~3,2%
Set yyyy=%DATE:~6,4%
rman cmdfile='<Path>\logbkp.txt' log='<path>\RMAN_LOG_%dd%-%mm%-%yyyy%.log'
LOGBKP.txt file has the below content:
--------------------------------------
connect target sys/<password>
connect catalog <username/password>@<connect string>
run
{
allocate channel dev1 type disk format '<path>\db_t%t_s%s_p%p';
allocate channel dev2 type disk format '<path>\db_t%t_s%s_p%p';
BACKUP archivelog all ;
delete noprompt archivelog all completed before 'sysdate-1';
release channel dev1 ;
release channel dev2 ;
}
Here is the LOGFILE:- Which shows that Activity started at exactly 12:30
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Apr 1 2:30:08 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target *
2> connect catalog *
3> run
4> {
5> allocate channel dev1 type disk format '<path>\db_t%t_s%s_p%p';
6> allocate channel dev2 type disk format '<path>\db_t%t_s%s_p%p';
7> BACKUP archivelog all ;
8> delete noprompt archivelog all completed before 'sysdate-1';
9> release channel dev1 ;
10> release channel dev2 ;
11>
12> }
13>
Here is the query and the output:
---------------------------------
1 select * from (select SID ,STATUS,operation,MBYTES_PROCESSED/1024 "GB",START_TIME,END_TIME
2 from v$rman_status order by start_time desc) where rownum <11
3* order by start_time asc
SQL> /
Fri Apr 01
RMAN Backups for last 24-hours
SID STATUS OPERATION GB START_TIME END_TIME
---------- ---------- --------------------------------- ---------- -------------------- --------------------
0 COMPLETED BACKUP 83.703125 01-apr-2016 14:40:31 01-apr-2016 15:04:25
0 COMPLETED DELETE 0 01-apr-2016 15:04:26 01-apr-2016 15:19:58
Kindly help me to understand the issue.
Regards
Muktha
|
|
|
|
| Re: Rman backup performance issue [message #649632 is a reply to message #649631] |
Fri, 01 April 2016 08:56  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Here is the LOGFILE:- Which shows that Activity started at exactly 12:30
Where?
All I see is that job started at APR 1 2:30 (April first) not at 12:30.
>>But when I query the RMAN JOB output, It shows the RMAN BACKUP Started at 2.56 PM.
Again,
where? I don't see it.
I don't understand what the problem is. Performance issue?
You are comparing the invoke time against actual start time.
[Updated on: Fri, 01 April 2016 08:58] Report message to a moderator |
|
|
|
| Re: Rman backup performance issue [message #649646 is a reply to message #649632] |
Fri, 01 April 2016 12:14 |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hai Mahesh,
Yes, you are right, the invoke time is 12.30 and the backup time started is 2.40.
Which means, I think querying the repository database was the problem, am I right?
If so, guide me to confirm it over the guess work.
Regards
Muktha
|
|
|
|
|
|
| Re: Rman backup performance issue [message #649743 is a reply to message #649652] |
Tue, 05 April 2016 02:29 |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
HI Mahesh,
I have done it in the below method
In the OS Level:
set NLS_DATE_FORMAT=dd-mon-rrrr hh24:mi:ss
In the RMAN Script:
alter session set nls_date_format='dd-mon-yyyy hh24:mi';
set echo on;
Now I am able to get the timestamp in the RMAN LOG file.
Which shows the startup and end time.
Thanks all
Muktha
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
