Oracle Rman Backup Brief

Backup-related dynamic performance view and monitoring

1. Related view

V$backup_files

V$backup_set

V$backup_piece

V$backup_redolog

V$backup_spfile

V$backup_device

V$rman_configuration

V$archived_log

V$backup_corruption

V$copy_corruption

V$database_block_corruption

V$backup_datafile

2. View the channel corresponding server sessions

Using the SET command ID command

Query v$process and v$session determine which session corresponds to the Rman channel

Sql> Select Sid,username,client_info from V$session

2 where client_info is not null;

SID USERNAME Client_info

---------- ------------------------------ ------------------------------

146 SYS Rman Channel=ora_disk_1

148 SYS Rman Channel=ora_disk_2

$ SYS Rman Channel=ora_disk_3

--The SET command ID command is used below

Rman> run{

2> Allocate channel CH1 type disk;

3> set command ID to ' Rman ';

4> Backup as Copy datafile 4

5> format '/u01/app/oracle/rmanbak/dd_%u ';

6>}

Sql> Select Sid,username,client_info from V$session

2 where client_info is not null;

More Wonderful content: http://www.bianceng.cn/database/Oracle/

SID USERNAME Client_info

---------- ------------------------------ ------------------------------

140 SYS Id=rman

Sql> Select Sid,spid,client_info

2 from V$process p, v$session s

3 Where p.addr = S.paddr

4 and Client_info like '%id=% ';

SID SPID Client_info

---------- ------------ ------------------------------

140 5002 Id=rman

--View the full progress of Rman

Sql> Select Sid,serial#,context,sofar,totalwork,

2 round (sofar/totalwork*100,2) "% Complete"

3 from V$session_longops

4 where opname like ' rman:% '

5 and Opname not like ' rman:aggregate% '

6 and Totalwork!=0;

--Obtain the SID and SPID information for the service process that Rman uses to complete the backup operation through the following SQL:

Select Sid, SPID, client_info

From V$process p, v$session s

where p.addr = S.paddr

and client_info like '%id=rman% '

Automatic Rman Backup Under 3.Linux

Backup Scripts +crontab

Bak_inc0:0-level incremental backup, every Sunday with a level incremental backup

Bak_inc1:1-level incremental backups, incremental backups per Wednesday, and backup data changes from Sunday to Wednesday

Bak_inc2:2-level incremental backup that backs up the differential increments that occur on a daily basis. Differences from Sunday to Monday, from Monday to Tuesday

--Below is the level increment script, the rest level and the level Efaro, the difference is the backup level and the tag tag

[Oracle@oradb scripts]$ Cat Bak_inc0

Run {

Allocate channel CH1 type disk;

Backup as compressed Backupset incremental level 0

Format '/u01/oracle/bk/rmbk/incr0_%d_%u '