Oracle下如何用rman备份到特定的sequence

简介:

本文为摘抄,目的为方便日后阅读:

http://docs.oracle.com/cd/B12037_01/server.101/b10734/rcmbackp.htm

To determine the archived logs needed for recovery of an online backup:

Start SQL*Plus and archive all unarchived logs, including the current log:
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

Query V$LOG to determine the log sequence number of the current redo log, as in the following example (which includes output):
SQL> SELECT SEQUENCE# FROM V$LOG WHERE STATUS = 'CURRENT';

SEQUENCE#
----------
9100

Start RMAN and make an online backup of the database. For example, enter:
RMAN> BACKUP DATABASE;

Archive all unarchived logs, including the current log:
RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

In SQL*Plus, query V$LOG to determine the log sequence number of the current redo log:
SQL> SELECT SEQUENCE# FROM V$LOG WHERE STATUS = 'CURRENT';

SEQUENCE#
----------
9112

Back up the logs beginning with the first sequence number that you queried, and ending with the last sequence number minus 1. The log before the current log is the most recent archived log. For example, if the first query returned 9100, then start at 9100. If the second query returned 9112, then end at 9111.

For example, issue the following to back up the necessary archived logs:

RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 9100 UNTIL SEQUENCE 9111;






本文转自健哥的数据花园博客园博客,原文链接:http://www.cnblogs.com/gaojian/p/3380849.html,如需转载请自行联系原作者

目录
相关文章
|
5月前
|
Oracle 安全 关系型数据库
|
5月前
|
存储 Oracle 关系型数据库
|
5月前
|
Oracle 关系型数据库 数据库
|
5月前
|
存储 监控 Oracle
关系型数据库Oracle备份策略建议
【7月更文挑战第21天】
79 6
|
5月前
|
存储 Oracle 关系型数据库
|
5月前
|
存储 Oracle 关系型数据库
关系型数据库Oracle运行RMAN脚本
【7月更文挑战第23天】
54 4
|
5月前
|
SQL Oracle 关系型数据库
关系型数据库Oracle设置 RMAN 环境:
【7月更文挑战第25天】
76 2
|
5月前
|
监控 Oracle 算法
|
5月前
|
SQL Oracle 关系型数据库
关系型数据库Oracle结束 RMAN 会话:
【7月更文挑战第25天】
108 1
|
5月前
|
Oracle 关系型数据库 数据库
关系型数据库Oracle编写RMAN脚本
【7月更文挑战第23天】
45 2