Re: standby database - missing datafiles

Thanks Ric,

Well, I have already done with it.

Since my standby_file_management was set auto, I made it back to
manual and I renamed the 194 file to the real one and then stop and
start the database. Now,  everything is back to normal. Of course, I
change standby_file_management=auto back in my init file.

Thanks once again.

On 8/31/05, Ric Van Dyke <Ric.Van.Dyke@xxxxxxxxxx> wrote:
> All you should need to do is add the datafile to the standby manually, then 
> restart the apply (MRP) on the standby.  The apply will not work until that 
> datafile is there.
> 
> 
> Ric Van Dyke
> Ric.van.Dyke@xxxxxxxxxx
> 
> 
> ----- Original Message -----
> From: The Human Fly
> Sent: Wed Aug 31 04:56:20 EDT 2005
> To: Oracle-L Freelists
> Subject: standby database - missing datafiles
> 
> 
> Hello list,
> 
> We have a standby database for one of bank critical database. Unfortunately,
> when we added a datafile to the production database, there was no space left 
> on
> standby database server and oracle couldn't create the file on standby
> server and alter log says the following:
> ==
> File #194 added to control file as 'UNNAMED00194'. Originally created as:
> '/u2camm1/oradata/SYMP/SYMPperfstat03.dbf'
> Recovery was unable to create the file as:
> '/u2camm1/oradata/SYMP/SYMPperfstat03.dbf'
> Sun Aug 28 09:42:21 2005
> MRP0: Background Media Recovery terminated with error 1274
> Sun Aug 28 09:42:22 2005
> Errors in file /u2camm1/oradba/admin/SYMP/bdump/symp_mrp0_598062.trc:
> ORA-01274: cannot add datafile '/u2camm1/oradata/SYMP/SYMPperfstat03.dbf' -
> file could not be created
> ORA-19502: write error on file "/u2camm1/oradata/SYMP/SYMPperfstat03.dbf",
> blockno 19969 (blocksize=8192)
> ORA-27063: skgfospo: number of bytes read/written is incorrect
> IBM AIX RISC System/6000 Error: 28: No space left on device
> Additional information: -1
> Additional information: 1048576
> ORA-19502: write error on file "/u2camm1/oradata/SYMP/SYMPperfstat03.dbf",
> blockno 19713 (blocksize=8192)
> ORA-27063: skgfospo: number of bytes read/written is incorrect
> IBM AIX RISC System/6000 Error: 28: No space left on device
> Additional information: -1
> Additional information: 1048576
> Some recovered datafiles maybe left media fuzzy
> Media recovery may continue but open resetlogs may fail
> MRP0: Background Media Recovery process shutdown
> Sun Aug 28 10:07:11 2005
> ===
> I try to stop and start the standby database, the MRP background process dies
> and not able to apply archived to the stand database.
> 
> 
> 
> --
> Best Regards,
> Syed Jaffar Hussain
> OCP 8i & 9i DBA,
> ----------------------------------------------------------------------------------------
> "It is your atittude, not your aptitude that determins your altitude."
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
Best Regards,
Syed Jaffar Hussain
OCP 8i & 9i DBA,
Banque Saudi Fransi,
Saudi Arabia
----------------------------------------------------------------------------------------
"It is your atittude, not your aptitude that determins your altitude."
--
http://www.freelists.org/webpage/oracle-l

Other related posts: