Oracle Rman Backup Brief

Source: Internet
Author: User
Tags backup

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 '

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.