Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. RMAN Backups > Monitoring RMAN Backup Status

9.3. Monitoring RMAN Backup Status

RMAN produces output during the backup process. If you enable logging when you start RMAN, that output is suppressed. You can monitor RMAN operations by keeping an eye on the log file being generated, or you can use the V$ view V$RMAN_OUTPUT, as shown in this example:

SQL> select output from v$rman_output order by stamp;
OUTPUT
------------------------------------------------------------------Starting
backup at 12-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=154 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001
name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\SYSTEM01.DBF
input datafile fno=00004
name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 12-NOV-05
input datafile fno=00003
name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\SYSAUX01.DBF
channel ORA_DISK_2: specifying datafile(s) in backupset
channel ORA_DISK_2: starting compressed full datafile backupset
input datafile fno=00005name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\EXAMPLE01.DBF
input datafile fno=00002name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\UNDOTBS01.DBF
channel ORA_DISK_2: starting piece 1 at 12-NOV-05

					  


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint