RE: missing datafile on STANDBY DATABASE.
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <sjaffarhussain@xxxxxxxxx>, "_oracle_L_list" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Aug 2006 09:33:41 -0500
Please read:
8.4.1 Adding a Datafile or Creating a Tablespace
In the Oracle Data Guard Concepts and Administration manual. This is
for a Physical standby, I don't know what you have but I'm guessing it's
a physical not a logical. And this is the section number in 9.2, again
I'm assuming you are on 9.2, might be slightly different in other
database versions.
Ric Van Dyke
Hotsos Enterprises
-----------------------
Hotsos Symposium March 4-8, 2007. Be there.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, August 08, 2006 9:52 AM
To: _oracle_L_list
Subject: missing datafile on STANDBY DATABASE.
Hello list,
We are maintaining the standby database to our one of important
database.
On 5th August, a datafile has been added to primary database,
unfortunately, there was no sufficient space on standby server.
MRP background process has died and no archive logs were applied until
now.
I try to rename the datafile, create datafile, but, couldn't succeeded.
Opened a TAR with oracle and they said that rebuild standby.
I couldn't find the 'UNNAMED00266' file at OS leve. But, the entry is
there in v$datafile.
I have even cheked all my backups from 5th August, finding a luck to
have the file in backup, if someone deleted the file. But, not luck.
Is there any way that we can resolve this issue?
I have all the archived log since that point.
Thanks,
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
Banque Saudi Fransi,
Saudi Arabia
I blog at :http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
------------------------------------------------------------------------
----------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
