Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the method of backup with Oracle RMAN". In the daily operation, I believe that many people have doubts about what the method of backup with Oracle RMAN is. The editor consulted all kinds of data and sorted out a simple and easy-to-use method of operation. I hope it will be helpful to answer the doubt of "what is the method of backup with Oracle RMAN?" Next, please follow the editor to study!

Database cycle:

Level 0 backup on Monday, level 2 backup on Tuesday and Wednesday, level 1 backup on Thursday, level 2 backup on Friday, Saturday and Sunday.

Archive backup cycle:

Back up once an hour

The script is as follows:

# start archiving #

[root@cjcos01 ~] # mkdir / rman/ {db,arch}-p [root@cjcos01 ~] # chown oracle.oinstall / rman-R [root@cjcos01 ~] # su-oracle [oracle@cjcos01 ~] $sqlplus / as sysdbaSQL > alter system set log_archive_dest_1='location=/rman/arch';SQL > alter system set log_archive_format = "cjcpdb_%t_%s_%r.arc" scope=spfile;SQL > shutdown immediate;SQL > startup mount;SQL > alter database archivelog;SQL > alter database open;SQL > archivelog list

# create test data #

SQL > conn cjc/***SQL > CREATE OR REPLACE PROCEDURE test_pro isbegin for i in 1. 10 loop insert into T1 values (I, to_char (sysdate, 'yyyy/mm/dd hh34:mi:ss')); commit; end loop;end;/

Monday: level 0 backup

# 0_rmanbak.sh begin### export NLS_DATE_FORMAT='yyyy-mm-dd hh34:mi:ss'export ORACLE_SID=cjcdb01 rman target / log=/rman/db/0_rmanbak.log

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.