1.list backup;列出数据库中所有的备份信息。 2.list backup of controlfile;列出所有备份的控制文件。 3.list backup of datafile ' 或者 list backup of datafile 对应数据文件的ID号。数据文件全路径.dbf';列出指定的备份的数据文件。 4.list backup of archivelog all;列出所有备份的归档文件。 5.list copy...
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 ...
list backup of archivelog time between "to_date('2016-03-01 20:00:00','yyyy-mm-dd hh24:mi:ss')" and "to_date('2016-03-02 00:00:00','yyyy-mm-dd hh24:mi:ss')"; (二)、从指定的磁带中恢复归档日志的方法:(异机恢复时,从指定的月度备份的磁带中恢复归档日志) 方法一: 指定参数(time...
list backup of archivelog from scn ...; list backup of archivelog until scn ...; list backup of archivelog from sequence ..; list backup of archivelog until time 'sysdate-10'; list backup of archivelog {all, from, high, like, logseq, low, scn, sequence, time, until}; 1.List当前RMAN...
list backup of archivelog all; 这里我们可以用另外一个命令:LIST BACKUP OF ARCHIVELOG FROM SEQUENCE seq_no [THREAD thread_no]; 选择一个合适的SEQuence号,接下来这个命令会将备份过的日志按照序号展现出来,非常便于观察。 对于RAC环境不同的Thread可以加上不同的Thread号。对于单节点数据库是这样的...
to audit my logic to verify that the files I have remotely are managed correctly by my homegrown scripts. "list backup of archivelog all" does tell me what I want to know, but it's messy because of the different tags. Really it's the cleanup of the remote site I'm trying to verify...
rman>list backup of tablespace users; 3、列出控制文件备份集 rman>list backup of controlfile; 4、列出归档日志备份集 rman>list backup of archivelog all; 5、其他备份集信息 spfile文件的备份集信息:list backup of spfile; 列出数据文件镜像副本信息:list copy of database\ list copy of tablespace\ list...
RMAN> list backup of tablespace userdata; using target database control file instead of recovery catalog 使用RMAN命令修复表空间,注意红色部分,由于没有备份,所以Oracle并没有执行restore动作,而是创建了一个新的数据文件,当然这个文件是空的, 没有内容的,所以后面Oracle会开始recover的动作,应用日志,把文件修复到...
channel c2: specifying datafile(s) in backup set ##通道c2执行第二次备份,备份集包括以下三个文件 input datafile file number=00010name=/u01/app/data/ORCL/pdb01/sysaux01.dbf input datafile file number=00012name=/u01/app/data/ORCL/pdb01/users01.dbf ...
restore standby controlfileto'/oradata/hisnewdb/control01.ctl'from'/home/oracle/backup/某个文件'; 1. 如果文件太多,可以先rman注册文件后,再恢复控制文件。 要找开备库mount状态才能注册 复制 rmant target / <<eofstartup mount;catalog startwith'/home/oracle/backup/';list backupofcontrolfile;restore...