Backup&Restore
文章平均质量分 56
tech2011
这个作者很懒,什么都没留下…
展开
-
11G Online Duplicate
<br />从11g数据库开始,可以在线克隆一个数据库了,标记下~<br />RMAN > DUPLICATE TARGET DATABASE<br />TO db_duplicate<br />FROM ACTIVE DATABASE<br />SPFILE PARAMETER_VALUE_CONVERT '/u02', 'u03'<br />SET SGA_MAX_SIXE = '500m'<br />SET SGA_TARGET = '250M'<br />SET LOG FILE_NAME_CONV翻译 2010-10-25 22:24:00 · 322 阅读 · 0 评论 -
Rman switch to copy
With RMAN you can create copy of live Database and perform the switch to copy when main database is not available due to any problem.First of all make the proper configuration with RMAN and then proceed,RMAN>CONFIGURE BACKUP OPTIMIZATION ON;ARMAN >CONFIGUR转载 2010-10-25 23:06:00 · 2501 阅读 · 0 评论 -
Disaster Recovery Planning For Oracle DB
<br />Planning DR is essential for any DBA because DBA will be first one to get under the gun if something goes wrong with database.<br />You have two options available ,Plan the DR Look for new job. <br />I will focus on first one only as i love to get pa转载 2010-10-26 17:59:00 · 404 阅读 · 0 评论 -
Restore n Recover Production DB to Point In Time on new machine
<br />1.Install Oracle RDBMS Server Software on destination host.<br />2.Patch it to same release which is installed on source host.<br />3.Copy Datafile Backups , Archivelog Backups , Controlfile backup and spfile backup on to destination host ( test2 ) t转载 2010-10-27 16:19:00 · 452 阅读 · 0 评论 -
RMAN Backup and Recovery Scenarios
Complete Closed Database Recovery. System tablespace is missingIf the system tablespace is missing or corrupted the database cannot be started up so a complete closed database recovery must be performed.Pre requisites: A closed or open database backup and转载 2010-10-25 22:53:00 · 514 阅读 · 0 评论 -
corrupt block
<br />/* <br /> This script prompts for an owner and a tbale name. It then created two new tables <br /> - orignal_table_name_BAD and orignal_table_name_SAVED. If either if these tables exist, <br /> they are dropped and then recreated. The script th原创 2011-03-17 17:29:00 · 507 阅读 · 0 评论