Home » RDBMS Server » Backup & Recovery » Rman backup performance issue (Oracle 12c, windows 2012)
Rman backup performance issue [message #649631] Fri, 01 April 2016 08:37 Go to next message
muktha_22
Messages: 526
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10681
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.
Fri Apr 1 2:30:08 2016


>>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 Go to previous messageGo to next message
muktha_22
Messages: 526
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 #649652 is a reply to message #649646] Fri, 01 April 2016 14:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10681
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Which means, I think querying the repository database was the problem, am I right?
How can I confirm it? You should do it.

[Updated on: Fri, 01 April 2016 14:53]

Report message to a moderator

Re: Rman backup performance issue [message #649743 is a reply to message #649652] Tue, 05 April 2016 02:29 Go to previous messageGo to next message
muktha_22
Messages: 526
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
Re: Rman backup performance issue [message #649756 is a reply to message #649743] Tue, 05 April 2016 06:42 Go to previous messageGo to next message
EdStevens
Messages: 901
Registered: September 2013
Senior Member
muktha_22 wrote on Tue, 05 April 2016 02:29
HI Mahesh,

I have done it in the below method

In the OS Level:
           set NLS_DATE_FORMAT=dd-mon-rrrr hh24:mi:ss          




PUHLEEZE!
The 'rrrr' (or 'rr') date format was a band-aid to buy some time in getting through Y2K. That was 16 years ago! It should be well past time to drop it and just use 'yyyy'.
Re: Rman backup performance issue [message #649831 is a reply to message #649756] Fri, 08 April 2016 06:02 Go to previous message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi EdStevens,

Fine,

Thanks
Muktha
Previous Topic: how to recover corrupted datafile
Next Topic: How long can we keep backed up files in RMAN NOCATALOG?
Goto Forum:
  


Current Time: Sat Feb 17 22:16:52 CST 2018

Total time taken to generate the page: 0.08776 seconds