standby database - missing datafiles
- From: The Human Fly <sjaffarhussain@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 11:59:34 +0300
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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
