执行BACKUP命令时指定PLUS ARCHIVELOG子句

最新推荐文章于 2021-04-06 04:44:16 发布

congtudi4111

最新推荐文章于 2021-04-06 04:44:16 发布

阅读量213

点赞数

文章标签：数据库

RMAN> BACKUP CURRENT CONTROLFILE PLUS ARCHIVELOG;

在备份控制文件之前首先对所有归档文件进行备份。

　　PLUS ARCHIVELOG 的方式与上种有什么区别呢？区别太明显了，BACKUP...PLUS ARCHIVELOG命令在备份过程中会依次执行下列步骤：

　　1 ）运行ALTER SYSTEM ARCHIVE LOG CURRENT语句对当前 R edolog 进行归档。

　　2 ）执行BACKUP ARCHIVELOG ALL命令备份所有已归档日志。

　　3 ）执行BACKUP命令对指定项进行备份。

　　4 ）再次运行ALTER SYSTEM ARCHIVE LOG CURRENT对当前 R edolog 归档。

　　5 ）对新生成的尚未备份的归档文件进行备份。

在完成归档日志文件备份后，我们需要删除已备份过的归档文件（归档文件记录下了数据库进行的所有操作，如果您的数据库操作频繁而且量大，那归档文件的大小也是相当恐怖，备份后删除释放存储空间是相当有必要的）。RMAN提供了DELETE ALL INPUT参数，加在BACKUP命令后，则会在完成备份后自动删除归档目录中已备份的归档日志。

　　完成备份之后，可以通过下列命令查看已备份的归档日志片段：

RMAN> LIST BACKUP OF ARCHIVELOG ALL;

RMAN> list backup of archivelog all;

List of Backup Sets
===================

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
40      4G         DISK        00:02:45     2010-01-29 13:37:34
        BP Key: 40   Status: AVAILABLE   Tag: TAG20100129T133448
        Piece Name: F:\ARCH\DEMOARCHIVE\BK\FULLBACKUP\DEMO_20100129_43

List of Archived Logs in backup set 40
Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
---- ------- ---------- ------------------- ---------- ---------
1    61      5589422    2009-12-15 03:07:06 1171671565945 2009-12-16 03:13:07
1    62      1171671565945 2009-12-16 03:13:07 1171671871584 2009-12-17 03:13:
38
1    63      1171671871584 2009-12-17 03:13:38 1171672177491 2009-12-18 03:19:
09
1    64      1171672177491 2009-12-18 03:19:09 1171672270353 2009-12-18 09:02:
55
1    65      1171672270353 2009-12-18 09:02:55 1171672575926 2009-12-19 09:03:
50
1    66      1171672575926 2009-12-19 09:03:50 1171672881859 2009-12-20 08:58:
51
1    67      1171672881859 2009-12-20 08:58:51 1171673188252 2009-12-21 09:01:
23
1    68      1171673188252 2009-12-21 09:01:23 1171673493092 2009-12-22 08:51:
54
1    69      1171673493092 2009-12-22 08:51:54 1171673798487 2009-12-23 08:53:
25
1    70      1171673798487 2009-12-23 08:53:25 1171674104795 2009-12-24 08:55:
55
1    71      1171674104795 2009-12-24 08:55:55 1171674410580 2009-12-25 08:46:
26
1    72      1171674410580 2009-12-25 08:46:26 1171674716097 2009-12-26 08:41:
57
1    73      1171674716097 2009-12-26 08:41:57 1171675021392 2009-12-27 08:39:
58
1    74      1171675021392 2009-12-27 08:39:58 1171675326994 2009-12-28 08:26:
29
1    75      1171675326994 2009-12-28 08:26:29 1171675632224 2009-12-29 08:19:
30
1    76      1171675632224 2009-12-29 08:19:30 1171675938419 2009-12-30 08:22:
01
1    77      1171675938419 2009-12-30 08:22:01 1171676244329 2009-12-31 08:13:
32
1    78      1171676244329 2009-12-31 08:13:32 1171676550054 2010-01-01 08:13:
02
1    79      1171676550054 2010-01-01 08:13:02 1171676856995 2010-01-02 08:13:
04
1    80      1171676856995 2010-01-02 08:13:04 1171677162671 2010-01-03 08:16:
32
1    81      1171677162671 2010-01-03 08:16:32 1171677470146 2010-01-04 08:24:
03
1    82      1171677470146 2010-01-04 08:24:03 1171677776464 2010-01-05 08:21:
34
1    83      1171677776464 2010-01-05 08:21:34 1171678081438 2010-01-06 08:23:
35
1    84      1171678081438 2010-01-06 08:23:35 1171678387879 2010-01-07 08:21:
06
1    85      1171678387879 2010-01-07 08:21:06 1171678694586 2010-01-08 08:18:
37
1    86      1171678694586 2010-01-08 08:18:37 1171678999148 2010-01-09 08:18:
08
1    87      1171678999148 2010-01-09 08:18:08 1171679306527 2010-01-10 08:19:
09
1    88      1171679306527 2010-01-10 08:19:09 1171679613144 2010-01-11 08:17:
11
1    89      1171679613144 2010-01-11 08:17:11 1171679919640 2010-01-12 08:10:
12
1    90      1171679919640 2010-01-12 08:10:12 1171680226078 2010-01-13 08:05:
43
1    91      1171680226078 2010-01-13 08:05:43 1171680531546 2010-01-14 08:03:
38
1    92      1171680531546 2010-01-14 08:03:38 1171680838233 2010-01-15 08:01:
10
1    93      1171680838233 2010-01-15 08:01:10 1171681144337 2010-01-16 08:04:
41
1    94      1171681144337 2010-01-16 08:04:41 1171681449427 2010-01-17 08:01:
13
1    95      1171681449427 2010-01-17 08:01:13 1171681755004 2010-01-18 07:52:
44
1    96      1171681755004 2010-01-18 07:52:44 1171682061075 2010-01-19 07:54:
53
1    97      1171682061075 2010-01-19 07:54:53 1171682366145 2010-01-20 07:59:
49
1    98      1171682366145 2010-01-20 07:59:49 1171682671198 2010-01-21 08:01:
51
1    99      1171682671198 2010-01-21 08:01:51 1171682976669 2010-01-22 08:05:
52
1    100     1171682976669 2010-01-22 08:05:52 1171683281616 2010-01-23 08:07:
25
1    101     1171683281616 2010-01-23 08:07:25 1171683587198 2010-01-24 08:01:
56
1    102     1171683587198 2010-01-24 08:01:56 1171683893516 2010-01-25 08:08:
27
1    103     1171683893516 2010-01-25 08:08:27 1171684198853 2010-01-26 08:13:
58
1    104     1171684198853 2010-01-26 08:13:58 1171684311370 2010-01-26 17:07:
21
1    105     1171684311370 2010-01-26 17:07:21 1171684617387 2010-01-27 17:12:
49
1    106     1171684617387 2010-01-27 17:12:49 1171684922913 2010-01-28 17:33:
21
1    107     1171684922913 2010-01-28 17:33:21 1171685171832 2010-01-29 13:34:
45

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
42      99M        DISK        00:00:03     2010-01-29 13:42:18
        BP Key: 42   Status: AVAILABLE   Tag: TAG20100129T134215
        Piece Name: F:\ARCH\DEMOARCHIVE\BK\FULLBACKUP\DEMO_20100129_45

List of Archived Logs in backup set 42
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 61 5589422 2009-12-15 03:07:06 1171671565945 2009-12-16 03:13:07

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
44      423M       DISK        00:00:16     2010-01-29 13:46:40
        BP Key: 44   Status: AVAILABLE   Tag: TAG20100129T134624
        Piece Name: F:\ARCH\DEMOARCHIVE\BK\FULLBACKUP\DEMO_20100129_47

List of Archived Logs in backup set 44
Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
---- ------- ---------- ------------------- ---------- ---------
1    61      5589422    2009-12-15 03:07:06 1171671565945 2009-12-16 03:13:07
1    62      1171671565945 2009-12-16 03:13:07 1171671871584 2009-12-17 03:13:
38
1    63      1171671871584 2009-12-17 03:13:38 1171672177491 2009-12-18 03:19:
09
1    64      1171672177491 2009-12-18 03:19:09 1171672270353 2009-12-18 09:02:
55
1    65      1171672270353 2009-12-18 09:02:55 1171672575926 2009-12-19 09:03:
50

RMAN> list backup of archivelog sequence 61;

List of Backup Sets
===================

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
40      99M        DISK        00:02:45     2010-01-29 13:37:34
        BP Key: 40   Status: AVAILABLE   Tag: TAG20100129T133448
        Piece Name: F:\ARCH\DEMOARCHIVE\BK\FULLBACKUP\DEMO_20100129_43

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
44      99M        DISK        00:00:16     2010-01-29 13:46:40
        BP Key: 44   Status: AVAILABLE   Tag: TAG20100129T134624
        Piece Name: F:\ARCH\DEMOARCHIVE\BK\FULLBACKUP\DEMO_20100129_47

RMAN>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-626350/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8102208/viewspace-626350/