backup database plus archivelog; 此命令將觸發(fā)以下操作: 1、首先,進程使用alter system arc" />

国产99久久精品_欧美日本韩国一区二区_激情小说综合网_欧美一级二级视频_午夜av电影_日本久久精品视频

最新文章專題視頻專題問答1問答10問答100問答1000問答2000關鍵字專題1關鍵字專題50關鍵字專題500關鍵字專題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關鍵字專題關鍵字專題tag2tag3文章專題文章專題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專題3
問答文章1 問答文章501 問答文章1001 問答文章1501 問答文章2001 問答文章2501 問答文章3001 問答文章3501 問答文章4001 問答文章4501 問答文章5001 問答文章5501 問答文章6001 問答文章6501 問答文章7001 問答文章7501 問答文章8001 問答文章8501 問答文章9001 問答文章9501
當前位置: 首頁 - 科技 - 知識百科 - 正文

OracleRMAN備份深入解析--聯機備份

來源:懂視網 責編:小采 時間:2020-11-09 12:34:28
文檔

OracleRMAN備份深入解析--聯機備份

OracleRMAN備份深入解析--聯機備份:Oracle RMAN備份深入解析--聯機備份,開始執(zhí)行實際的數據庫備份操作,此時會發(fā)生一次日志切換(alter system archivelog current RMAN> backup database plus archivelog; 此命令將觸發(fā)以下操作: 1、首先,進程使用alter system arc
推薦度:
導讀OracleRMAN備份深入解析--聯機備份:Oracle RMAN備份深入解析--聯機備份,開始執(zhí)行實際的數據庫備份操作,此時會發(fā)生一次日志切換(alter system archivelog current RMAN> backup database plus archivelog; 此命令將觸發(fā)以下操作: 1、首先,進程使用alter system arc

Oracle RMAN備份深入解析--聯機備份,開始執(zhí)行實際的數據庫備份操作,此時會發(fā)生一次日志切換(alter system archivelog current

RMAN> backup database plus archivelog;

此命令將觸發(fā)以下操作:

1、首先,進程使用alter system archivelog current命令完成了日志切換操作。

2、進程將現存所有歸檔重做日志備份

3、開始執(zhí)行實際的數據庫備份操作,此時會發(fā)生一次日志切換(alter system archivelog current),同時RMAN備份剩余的歸檔重做日志(使用backup archivelog all命令)。

4、執(zhí)行控制文件和服務器參數文件的自動備份操作。

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

RMAN 配置歸檔日志刪除策略

Oracle基礎教程之通過RMAN復制數據庫

RMAN備份策略制定參考內容

RMAN備份學習筆記

Oracle數據庫備份加密 RMAN加密

Linux-6-64下安裝Oracle 12C筆記

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

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

案例:

1、查看備份前的日志信息

17:13:50 SYS@ prod>select group#,sequence#,thread#,status from v$log;

GROUP# SEQUENCE# THREAD# STATUS

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

1 16 1 CURRENT

2 14 1 INACTIVE

3 15 1 INACTIVE

Elapsed: 00:00:00.05

2、執(zhí)行備份

RMAN> backup database plus archivelog;

Starting backup at 03-JUL-14

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=13 RECID=41 STAMP=851966028

input archived log thread=1 sequence=14 RECID=42 STAMP=851966028

input archived log thread=1 sequence=15 RECID=43 STAMP=851966030

input archived log thread=1 sequence=16 RECID=44 STAMP=851966141

channel ORA_DISK_1: starting piece 1 at 03-JUL-14

channel ORA_DISK_1: finished piece 1 at 03-JUL-14

piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1 tag=TAG20140703T171541 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

Finished backup at 03-JUL-14

Starting backup at 03-JUL-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/prod/system01.dbf

input datafile file number=00002 name=/u01/app/oracle/oradata/prod/sysaux01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/prod/perftbs01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/prod/users01.dbf

input datafile file number=00005 name=/u01/app/oracle/oradata/prod/example01.dbf

input datafile file number=00007 name=/u01/app/oracle/oradata/prod/undotbs2.dbf

input datafile file number=00006 name=/u01/app/oracle/oradata/prod/tbs1.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/prod/undotbs1.dbf

channel ORA_DISK_1: starting piece 1 at 03-JUL-14

channel ORA_DISK_1: finished piece 1 at 03-JUL-14

piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1 tag=TAG20140703T171545 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:26

Finished backup at 03-JUL-14

Starting backup at 03-JUL-14

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=17 RECID=45 STAMP=851966231

channel ORA_DISK_1: starting piece 1 at 03-JUL-14

channel ORA_DISK_1: finished piece 1 at 03-JUL-14

piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1 tag=TAG20140703T171712 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 03-JUL-14

Starting Control File and SPFILE Autobackup at 03-JUL-14

piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/c-239333010-20140703-00 comment=NONE

Finished Control File and SPFILE Autobackup at 03-JUL-14


3、查看告警日志

[oracle@rh6 ~]$ tail -f /u01/app/oracle/diag/rdbms/prod/prod/trace/alert_prod.log

Current log# 1 seq# 16 mem# 1: /dsk2/oradata/prod/redo01b.log

Thu Jul 03 17:13:50 2014

Archived Log entry 43 added for thread 1 sequence 15 ID 0xfaf1e60 dest 2:

Thu Jul 03 17:15:41 2014

ALTER SYSTEM ARCHIVE LOG

Thu Jul 03 17:15:41 2014

Thread 1 advanced to log sequence 17 (LGWR switch)

Current log# 2 seq# 17 mem# 0: /dsk1/oradata/prod/redo02a.log

Current log# 2 seq# 17 mem# 1: /dsk2/oradata/prod/redo02b.log

Archived Log entry 44 added for thread 1 sequence 16 ID 0xfaf1e60 dest 2:

Thu Jul 03 17:17:11 2014

ALTER SYSTEM ARCHIVE LOG

Thu Jul 03 17:17:11 2014

Thread 1 advanced to log sequence 18 (LGWR switch)

Current log# 3 seq# 18 mem# 0: /dsk1/oradata/prod/redo03a.log

Current log# 3 seq# 18 mem# 1: /dsk2/oradata/prod/redo03b.log

Archived Log entry 45 added for thread 1 sequence 17 ID 0xfaf1e60 dest 2:

4、備份后的日志切換信息

17:13:56 SYS@ prod>select group#,sequence#,thread#,status from v$log;

GROUP# SEQUENCE# THREAD# STATUS

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

1 16 1 INACTIVE

2 17 1 ACTIVE

3 18 1 CURRENT

Elapsed: 00:00:00.01

5、查看備份信息

RMAN> list backup of database;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

17 Full 1.13G DISK 00:01:21 03-JUL-14

BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171545

Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1

List of Datafiles in backup set 17

File LV Type Ckp SCN Ckp Time Name

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

1 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/system01.dbf

2 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/sysaux01.dbf

3 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs1.dbf

4 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/users01.dbf

5 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/example01.dbf

6 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/tbs1.dbf

7 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs2.dbf

8 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/perftbs01.dbf

RMAN> list backup of archivelog all;

List of Backup Sets

===================

BS Key Size Device Type Elapsed Time Completion Time

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

16 31.11M DISK 00:00:01 03-JUL-14

BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171541

Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1

List of Archived Logs in backup set 16

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 13 2051289 03-JUL-14 2066660 03-JUL-14

1 14 2066660 03-JUL-14 2066663 03-JUL-14

1 15 2066663 03-JUL-14 2066666 03-JUL-14

1 16 2066666 03-JUL-14 2066878 03-JUL-14

BS Key Size Device Type Elapsed Time Completion Time

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

18 104.00K DISK 00:00:00 03-JUL-14

BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171712

Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1

List of Archived Logs in backup set 18

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 17 2066878 03-JUL-14 2066956 03-JUL-14

本文永久更新鏈接地址:

linux

聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

文檔

OracleRMAN備份深入解析--聯機備份

OracleRMAN備份深入解析--聯機備份:Oracle RMAN備份深入解析--聯機備份,開始執(zhí)行實際的數據庫備份操作,此時會發(fā)生一次日志切換(alter system archivelog current RMAN> backup database plus archivelog; 此命令將觸發(fā)以下操作: 1、首先,進程使用alter system arc
推薦度:
標簽: 備份 聯機 oracle
  • 熱門焦點

最新推薦

猜你喜歡

熱門推薦

專題
Top
主站蜘蛛池模板: 九九久久99综合一区二区 | 亚洲欧美日韩另类 | 日韩高清dvd | 国产免费网 | 成人免费一区二区三区 | 国产热久久精 | 91亚洲欧美综合高清在线 | 久久精品综合国产二区 | 91第一页| 日韩成人在线免费视频 | 欧美日韩高清完整版在线观看免费 | 日韩 欧美 综合 在线 制服 | 精品日韩欧美国产一区二区 | 黑人操穴| 午夜精品久久久久久毛片 | 在线一区二区三区 | 一区二区网站 | 最近中文字幕高清电影在线 | 一级毛片不收费 | 91精品成人免费国产 | 日韩综合图区 | 亚洲欧美日韩在线观看播放 | 一区二区三区高清不卡 | 久久91精品久久91综合 | 欧美视频免费看 | 精品一区二区三区高清免费不卡 | 国产亚洲欧美在线人成aaaa | 欧美日韩综合视频 | 欧美日韩亚洲v在线观看 | 免费一看一级毛片全播放 | 精品一区二区三区免费视频 | 国产精品久久久久久久久 | 韩国精品欧美一区二区三区 | 欧美成人性色生活18黑人 | 欧美日韩电影在线观看 | 国产精品视频a | 国语清晰对白声音刺激 | 国产欧美日韩综合精品二区 | 中文国产成人精品久久一区 | 欧美一级色图 | 日本伊人网 |