Mobile Application Services

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Wednesday, 24 October 2012

How to monitor RMAN Backups ?

Posted on 02:33 by Unknown

RMAN Backups Monitoring

select count(*) from  v$backup_async_io where status='IN PROGRESS';

Session information on backups

SELECT s.sid, username AS "User", program, module, action, logon_time "Logon", l.*
FROM v$session s, v$enqueue_lock l
WHERE l.sid = s.sid and l.type = 'CF' AND l.id1 = 0 and l.id2 = 2;

RMAN backup overall progress status

SELECT decode(context,1,'This Task:',2,'Agregate:','?') Context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete"
FROM v$session_longops
WHERE opname LIKE 'RMAN%'
AND opname LIKE '%aggregate%'
AND totalwork != 0
AND sofar <> totalwork
UNION
SELECT decode(context,1,'This Task:',2,'Agregate:','?') Context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete"
FROM v$session_longops
WHERE opname LIKE 'RMAN%'
AND opname NOT LIKE '%aggregate%'
AND totalwork != 0
AND sofar <> totalwork;
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in RMAN Backup | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • The simplest query for checking what’s happening in a database
    When someone asks you to take a quick look into database performance and for whatever reason you can’t run your usual scripts or performance...
  • Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications
    A. Introduction When starting a Forms-based session in Applications it is possible to pass various useful parameters like formname=xyz, or l...
  • Resolving "JInitiator version too low" Errors in EBS Environments
    Oracle JInitiator 1.3 was  desupported for E-Business Suite environments  at the end of July 2009.  JInitiator 1.1.8 was desupported at the ...
  • How To Change Look And Feel and Colors Of Oracle Applications 11i and R12
    There are two system profile options that can be used to change look and feel.  Java Look and Feel . Java Look and Feel can have two values:...
  • Oracle 11g RAC Interview question and answers
    1. What is the major difference between 10g and 11g RAC? Well, there is not much difference between 10g and 11gR (1) RAC. But there is a sig...
  • Concurrent Manager : troubleshooting
    Concurrent Manager : troubleshooting Summary of Possible Reasons and Solutions for the Problem Where All Concurrent Requests Stuck in Pendin...
  • 11.2.0.3 to 12.1.0 (Oracle 12c) upgrade
    Upgrading Oracle Database 11.2.0.3 to 12.1.0 (Oracle 12c) There are different ways of upgrading to the latest release of Oracle database and...
  • Patching - Applications
    ADPatch   Applying a patch updates your existing system in various ways, from adding a new feature or product to improving system performanc...
  • Oracle Apps DBA Interview Questions
    1.         What is FNDSM? FNDSM is executable & core component in GSM (Generic Service Management Framework). You start FNDSM services v...
  • Oracle Core DBA Interview questions - Backup and Recovery
    1.         Which types of backups you can take in Oracle? 2.         A database is running in NOARCHIVELOG mode then which type of backups y...

Categories

  • 11.2.0.3 to 12.1.0 (Oracle 12c) upgrade
  • Backup and recovery
  • Basic RAC Commands
  • Blocking Sessions
  • CMAN [ Oracle Connection Manager ]
  • Data Guard Interview Questions
  • Deadlocks
  • Difference Between Oracle apps 11i & R12
  • File Locations -R12
  • Gather stats on table in oracle
  • How To Change Look And Feel and Colors Of Oracle Applications 11i and R12
  • How to compile invalid objects in an APPS Environment
  • How to recover Applications context file if it is corrupted or deleted accidentally?
  • How to Recreate the OraInventory?
  • Important DBA Views
  • JInitiator version too low and quot Errors in EBS Environments
  • Linux interview questions for DBA
  • Log file location in Oracle Apps 11i/R12
  • Long running concurrent requests
  • MWA Services
  • Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications
  • ORA-00845: MEMORY_TARGET not supported on this system
  • Oracle 11g RAC Interview question and answers
  • Oracle Applications Idle Session Timeout
  • Oracle Apps DBA Interview Questions
  • Oracle DBA Interview Questions
  • Oracle E-Business Suite 12.2 Architecture
  • Oracle Exadata Interview Questions
  • Personalizing The Login Page
  • RAC Cheat Sheet
  • RAC Interview Questions
  • Recovery catalog for RMAN backup
  • Refresh vs Clone
  • REP-3000 Oracle Toolkit Error
  • Replacing Jinitiator with JRE
  • RMAN Backup
  • RMAN Commands List (Oracle 11g)
  • Snapshot
  • TEMP Tablespace
  • Tracing Techniques
  • Undo Tablespace
  • Unix for DBA's
  • Workflow Mailer Troubleshooting
  • Workflow Trouble Shooting

Blog Archive

  • ►  2013 (30)
    • ►  November (3)
    • ►  October (3)
    • ►  August (3)
    • ►  July (1)
    • ►  May (1)
    • ►  March (10)
    • ►  February (8)
    • ►  January (1)
  • ▼  2012 (27)
    • ►  November (1)
    • ▼  October (8)
      • Tracking Oracle database growth
      • AWR Reports
      • Long running Concurrent Requests
      • How to monitor RMAN Backups ?
      • The simplest query for checking what’s happening i...
      • How to recover Applications context file if it is ...
      • How to compile invalid objects in an APPS Environment
      • Undo Related Queries
    • ►  September (5)
    • ►  August (5)
    • ►  July (7)
    • ►  June (1)
Powered by Blogger.

About Me

Unknown
View my complete profile