http://www.forum.askdba.org/ Forum for Oracle DBA's en Sun, 12 Feb 2012 09:59:30 +0000 http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-155 Wed, 02 Jun 2010 08:10:15 +0000 Anonymous 155@http://www.forum.askdba.org/ <p>Download demo ost recovery software to convert .OST files to .PST file. Saved .PST file can be accessed with MS Outlook with other save options including .EML and .MSG which can be accessed with Outlook Express and MS Outlook. </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-140 Sun, 14 Mar 2010 06:15:39 +0000 Saurabh Sood 140@http://www.forum.askdba.org/ <p>Please update the complete backup script that you are using to take backup </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-139 Sun, 14 Mar 2010 05:12:56 +0000 Omar 139@http://www.forum.askdba.org/ <p>Check if you are using same Rman executable version for backup and restore. If not try using same version. </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-138 Fri, 12 Mar 2010 12:24:10 +0000 Mahesh.G 138@http://www.forum.askdba.org/ <p>Hi,</p> <p>I still see the same errors even after taking control file and datafiles backup at a time. In alert log i found below error which is causing this issue.<br /> Please help me in understanding the issue and best solution for the problem. alert log shows the below errors..</p> <p>Fri Mar 12 06:25:56 2010<br /> The input backup piece /backup/ora_backup/gll88kta_9_1 is in compressed format.<br /> Error validating file dummy (5) in piece /backup/ora_backup/gll88kta_9_1: missing header<br /> Error validating file dummy (15) in piece /backup/ora_backup/gll88kta_9_1: missing header<br /> Error validating file dummy (14) in piece /backup/ora_backup/gll88kta_9_1: missing header<br /> Error validating file dummy (27) in piece /backup/ora_backup/gll88kta_9_1: missing header<br /> Error validating file dummy (10) in piece /backup/ora_backup/gll88kta_9_1: missing header<br /> Error validating file dummy (12) in piece /backup/ora_backup/gll88kta_9_1: missing header</p> <p>Mahesh.G </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-137 Thu, 11 Mar 2010 12:44:40 +0000 Mahesh.G 137@http://www.forum.askdba.org/ <p>Sorry for the delay in replying..</p> <p>Yes. Yesterday we identified by using list backup command that backuppieces are expiered status. Then i realized that control file (standby) has been backed after backup is taken.<br /> So i believe there is mismatch there. I already taken standby control file backup and database backup at once and copying in DR location. I will keep you posted once i am done.</p> <p>Thanks, </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-136 Thu, 11 Mar 2010 06:47:31 +0000 Saurabh Sood 136@http://www.forum.askdba.org/ <p>Have you taken the backup of archivelogs when you issued the rman backup?</p> <p>If not, then switch the logfile and make backup of archivelogs with your datafile backups, and try the restore again.</p> <p>The backup script should look like:</p> <p>backup format '/u01/PROD/df_t%t_s%s_p%p' database;<br /> sql 'alter system archive log current';<br /> backup format '/u01/PROD/al_t%t_s%s_p%p' archivelog all; </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-135 Thu, 11 Mar 2010 06:44:53 +0000 sunkkuma 135@http://www.forum.askdba.org/ <p>you can also use " list backup by datafile &lt;datafile_no&gt; " to check if there are any backups available for a datafile </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-133 Thu, 11 Mar 2010 06:02:52 +0000 animesh 133@http://www.forum.askdba.org/ <p>Can you please provide step by step process you have followed.<br /> The error suggest that the datafile 27 and 28 is not there in the backup piece.</p> <p>++ crosscheck backup</p> <p>Check the below link for complete steps for standby setup.<br /> <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i67520" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i67520</a></p> <p>Animesh </p> http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-131 Wed, 10 Mar 2010 11:27:43 +0000 Mahesh.G 131@http://www.forum.askdba.org/ <p>Hi Experts,</p> <p>While doing DR rebuild ( physical standby ), after restoring standby controlfile in DR location, i am getting below error while restoring<br /> database. I took backup through RMAN ( hotbackup ) from primary database.</p> <p>RMAN-00571: ===========================================================<br /> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br /> RMAN-00571: ===========================================================<br /> RMAN-03002: failure of restore command at 03/10/2010 11:58:32<br /> RMAN-06026: some targets not found - aborting restore<br /> RMAN-06023: no backup or copy of datafile 28 found to restore<br /> RMAN-06023: no backup or copy of datafile 27 found to restore</p> <p>I tried the below options :-</p> <p>1. Duplicate command :- while using duplicate command also i got the same error<br /> 2. " catalog backuppiece " of all backup pieces copied from primary database.<br /> 3. I used restore with set until time option also but no luck.</p> <p>In all cases i got same error. How can i restore primary database backup in DR ? Pls help. </p> <p>Mahesh </p>