RMAN> list expired backup of archivelog until time "to_date('2010-7-6','yyyy-mm-dd')"; 1.2.8 列出控制文件和服务器参数文件备份 List backup of controlfile命令可以向用户提供控制文件备份的列表,list backup of spfile 可以提供服务器参数文件备份的列表。 RMAN> list backup of controlfile; RMAN> ...
list backup of controlfile; list backup datafile n,n,n; list backup tablespace tablespace_name; list backup of archivelog all; list backup of archivelog from scn ...; list backup of archivelog until scn ...; list backup of archivelog from sequence ..; list backup of archivelog until time ...
BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/home/oracle/ctl.bak'; 4.执行BACKUP时指定INCLUDE CURRENT CONTROLFILE参数,例如: RMAN> BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; 5.SQLPLUS下: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE as '/home/bk/a.ctl';--得到建立控制文件的脚本 SQL>alter ...
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE [RESETLOGS|NORESETLOGS]; ② RMAN手动备份控制文件: BACKUP CURRENT CONTROLFILE; BACKUP CURRENT CONTROLFILE FORMAT '/home/oracle/oracle_bk/orclasm/ctl_%d_%T_%s_%p.bak'; BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/home/oracle/ctl.bak'; BACKUP DAT...
1.3.list backup; 这个命令列出已备份集的详细信息。 1.4.list expired backup; 列出过期的备份文件 1.5.list copy; 列出copy文件 list copy of database; list copy of controlfile; list copy of tablespace users; list copy of datafile n,n,n; ...
list backup by file; 按照文件类型分别列出 list backup; 列出已有备份集的详细信息 list expired backup; 列出过期的备份文件 list backup of {archivelog,controlfile,database,datafile,spfile,tablespace}; list backup of archivelog {all,from,high,like,logseq,low,scn,sequence,time,until}; ...
3.6、RMAN> list copy of controlfile 列出控制文件映像副本;3.7、RMAN> list copy of archivelog all 列出归档日志映像副本;3.8、RMAN> list incarnation of database 列出对应物/列出数据库副本;3.9、RMAN> list backup summary; 概述可用的备份； B表示backup ...
RMAN> list backup of datafile n; n=指定的数据文件序号,如果需要备份的数据文件有多个,n=多个序号,中间以逗号分隔即可。 1.6.备份控制文件 手动执行备份命令,例如: RMAN>backup current controlfile; 或者指定include current controlfile子句 不仅限于database,执行backup命令备份任何文件时都可以指定include current...
list backupoftablespace users;--以文件序号,列出备份集,文件序号就是v$datafile的file# list backupset by file;--可用备份情况概述(常用) list backupset summary; 2.report命令 代码语言:javascript 复制 --查看构成数据库组成的文件(数据文件、临时文件)report schema;--报告需要备份的文件 ...
RMANlistexpiredbackup列出过期备份; RMANlistbackupofdatabase;列出所有数据文件的备份集; RMANlistbackupoftablespaceuser01;列出特定表空间的所有数据文件备 份集; 2、RMANlistbackupofcontrolfile列出控制文件备份集; 3、RMANlistbackupofarchivelogall列出归档日志备份集详细信息; ...