SELECT TRIM(START_TIME || '#'),
       TRIM(END_TIME || '#'),
       TRIM(CASE OUTPUT_DEVICE_TYPE
              WHEN 'DISK' THEN
               'DISK'
              WHEN 'SBT_TAPE' THEN
               'SBT_TAPE'
              ELSE
               'Others'
            END || '#') AS BACKUP_DEVICE,
       TRIM(STATUS || '#'),
       TRIM(CASE INPUT_TYPE
              WHEN 'DB FULL' THEN
               'DB_FULL'
              WHEN 'DB INCR' THEN
               'DB_INCR'
              WHEN 'ARCHIVELOG' THEN
               'DB_ARCH'
              ELSE
               'Others'
            END || '#') AS BACKUP_TYPE,
       TRIM(ROUND(ELAPSED_SECONDS / 60 / 60, 2) || '#') AS T,
       TRIM(OUTPUT_BYTES_DISPLAY || '#') AS DB_SIZE
  FROM V$RMAN_BACKUP_JOB_DETAILS
 WHERE START_TIME = (SELECT MAX(START_TIME) FROM V$RMAN_BACKUP_JOB_DETAILS);

oracle Backup information query more related articles

  1. oracle Database information query

    /* Query the current user table information / select A.column_name    Field name , A.data_type      data type , A.data_length    length , A.data_precisi ...

  2. Oracle User information query

    1. View all users : select * from dba_users;    select * from all_users;    select * from user_users; 2. View users or corners ...

  3. Oracle Database information query

    View the current database select name from V$DATABASE; select SYS_CONTEXT('USERENV','INSTANCE_NAME') from dual; user sel ...

  4. ORACLE see RMAN Summary of backup information for

    About Oracle Database RMAN Backup , Except for the mail , Whether it can be checked by other means RMAN The success and failure of backup ? In fact, we can go through the following SQL Script to check the record of backup failure in a certain period of time : SELECT * FROM V$RM ...

  5. Inquire about rman Backup information often uses instructions

    Inquire about rman Backup information often uses instructions ---- Log in to rman $rman target / ---- View backup information in a streamlined format RMAN> list backup of database summar ...

  6. turn ORACLE see RMAN Summary of backup information for

    http://www.cnblogs.com/kerrycode/p/5684768.html About Oracle Database RMAN Backup , Except for the mail , Whether it can be checked by other means RMAN The success and failure of backup ? Actually ...

  7. Data files 、 Log files 、 The archive 、 Control documents 、 Parameter file and RMAN Backup database information query

    One . View database information :=====================1. Data files SQL> SELECT FILE#,STATUS,ENABLED,NAME FROM V$DATAFILE; FILE ...

  8. adopt sql Inquire about rman Backup information

    adopt sql Inquire about rman Backup information View all backup sets SELECT A.RECID "BACKUP SET", A.SET_STAMP, DECODE (B.INCREMENTAL_LE ...

  9. SQL Server Query database space allocation 、 Database backup information

    Query database space allocation : use master go create procedure dbo.proc_getdbspaceused as begin set nocount on create t ...

Random recommendation

  1. struts1 Two : Basic environment construction

    So let's set up a web project Lead-in required jar package Build package com.bjpowernode.struts establish LoginAction package com.bjpowernode.struts; import ...

  2. 51nod1130( Stirling approximation )

    Topic link : https://www.51nod.com/onlineJudge/questionCode.html#!problemId=1130 The question : Chinese question ~ Ideas : Just go straight to the Stirling formula ~ ...

  3. Linux Under the server nginx Security configuration

    1. Some common sense linux Next , To read a file , First, you need to have execute permission on the folder where the file is located , Then you need access to the file . php The execution of the file does not require the execution permission of the file , It only needs nginx and php-fpm Read access to the running account ...

  4. Windows Get this machine under IP Address method introduction

    Windows Get this machine under IP Address method introduction if((hostinfo = gethostbyname(name)) != NULL) { #if 1 ; printf("IP COUNT: % ...

  5. mvc Simple execl export

    Go straight to the code : public static byte[] GetExecl(DataTable dt, List<string> list) { var sbHtml = new Strin ...

  6. sed Here's an example : Insert... At a specific location

    Be familiar with through an example sed The use of The following command is modifying  ~/fs/install/nzos.conf file , And in env Add another line where it first appears  env LXC_EXTRA_PORT=5556 sed ...

  7. take eclipse dynamic web project Deploy to specified tomcat Under the software webapps In the folder

  8. requestium

    chrome Browser installation version or green portable version to add .exe,chromedriver Drive none .exe. No display …… Control of test software . With no head [] Inside , Plug ins and other new versions , It's useless {}:CentBrowser Of Chrome kernel ...

  9. Javascript - ExtJs - Ext.form.Panel Components

    FormPanel Components (Ext.form.FormPanel) logogram:Ext.form.Panel | xtype:form Ext.form.Panel. To configure frame }// All of them ...

  10. window Form Use in Font Awesome z

    Icon fonts are vector , Vector graphics means that every icon is perfectly rendered on a screen of all sizes , You can change the size and color at any time , And no distortion , It really gives people a kind of “ On the tall ” The feeling of . because Font Awesome It's completely free , For personal and commercial use , ...