...run { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; backup full tag 'dbfull' format 'F:\rman_bak\fullbak\full%d_%t_%s' database include current controlfile; sql 'alter system archive log current'; backup filesperset 3 format 'F:\rman_bak\fullbak\arch%d_%t_%s' archivelog all delete input; delete obsolete; release channel c1; release channel c2; release channel c3; }就这了..
在rman中执行 startup nomount; restore controlfile from 备份的控制文件名; alter database open resetlogs; 也许...
startup nomount; restore controlfile from tag 'dbfull' ; 这样应该可以了, 建议开CONFIGURE CONTROLFILE AUTOBACKUP ON;或者每次备份数据库后再备份一边控制文件,这样备份的控制文件中就包含了最新的备份信息.
startup nomount; restore controlfile from 备份的控制文件名; alter database open resetlogs;
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup full tag 'dbfull' format 'F:\rman_bak\fullbak\full%d_%t_%s' database include current controlfile;
sql 'alter system archive log current';
backup filesperset 3 format 'F:\rman_bak\fullbak\arch%d_%t_%s' archivelog all delete input;
delete obsolete;
release channel c1;
release channel c2;
release channel c3;
}就这了..
startup nomount;
restore controlfile from 备份的控制文件名;
alter database open resetlogs; 也许...
restore controlfile from tag 'dbfull' ;
这样应该可以了,
建议开CONFIGURE CONTROLFILE AUTOBACKUP ON;或者每次备份数据库后再备份一边控制文件,这样备份的控制文件中就包含了最新的备份信息.
restore controlfile from 备份的控制文件名;
alter database open resetlogs;
--在sqlplus中执行
ALTER TABLESPACE TEMP ADD TEMPFILE tempfilename
SIZE size REUSE AUTOEXTEND OFF; 具体参考:
http://topic.csdn.net/t/20060406/09/4666548.html
RMAN> restore controlfile from 备份的控制文件名;