9月份新公司以来的第一篇文章,有关数据恢复需求的记录:
用户需求查询2012年9月份的2笔数据,DBA需要从1.7TB的RMAN备份集中还原出2012-09年的数据。
1,目前所有的可利用的设备存储空间为700GB,需还原的DB_SIZE=1.8TB;
看起来当前的设备无法满足用户需求
2,分析用户需求的数据表段存在与一个TABLESPACE中,20个datafile 越600GB的空间需求;
综上可采用RESTORE DATAFILE的方式还原出DB。
过程:
1,从磁带机还原2012 10 10月份全备份集,以及2012 10 09 --2012 10 11的archivelog ----- 1.6TB
2,利用NFS远程挂在备份集到Server
3,Install Oracle Software same as ProductDB
4,Using RMAN Fullbackup pipe restore database
1>create pfile
*.audit_file_dest='/u01/app/oracle/admin/saedba/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/saedba/control01.ctl','/u01/app/oracle/oradata/saedba/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='saedba'
*.diagnostic_dest='/u01/app/oracle'
*.open_cursors=300
*.pga_aggregate_target=25396510720
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1610612736
*.undo_tablespace='UNDOTBS1'
2> create orapwsaedba
3>rman target /
startup nomount;
RESTORE CONTROLFILE FROM '/data1/saedba/backup/rmanbackup/SAEDBA_20121010_1160_1_CONTROL';
alter database mount;
RUN {
SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/saedba01/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/u01/app/oracle/oradata/saedba01/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 3 TO '/u01/app/oracle/oradata/saedba01/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 4 TO '/u01/app/oracle/oradata/saedba01/users01.dbf';
SET NEWNAME FOR DATAFILE 50 TO '/u01/app/oracle/oradata/saedba01/ygzhou_dg01.dbf';
SET NEWNAME FOR DATAFILE 51 TO '/u01/app/oracle/oradata/saedba01/monitor01.dbf';
....
RESTORE datafile 1;
RESTORE datafile 2;
RESTORE datafile 3;
RESTORE datafile 4;
RESTORE datafile 50;
RESTORE datafile 51;
.....
}
4,Offline datafile----将不需要的datafile offline,此时还可以通过重建controlfile的方式实现
ALTER DATABASE OFFLINE DATAFILE 5;
ALTER DATABASE OFFLINE DATAFILE 6;
.....
5,RECOVER DATABASE
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
6,OPEN DATABASE
ALTER DATABASE RESETLOGS OPNE;
至此整个还原操作完成,整个还原操作历时70+小时。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24867586/viewspace-775717/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24867586/viewspace-775717/