Re: Full Ex/Im-port to New Instance, NT

From: Yassir Khogaly <yassir_at_khogaly.freeserve.co.uk>
Date: Fri, 9 Oct 1998 09:53:40 +0100
Message-ID: <6vkj9i$dl7$1@newsreader1.core.theplanet.net>

I will tell you an existing Open TAR with ORACLE UK Its a Bug On NT4.0 and Corrupt Rollback Segment Header when the following scenario occurs :

1-If you enable the UNLIMITED MAX EXTENTS while DB_BLOCK_SIZE=2K(DEFAULT)
2-ENABLE THE DYNAMIC SPACE MANAGEMENT ON DATAFILES LEVEL.
3-CREATE ANY PRIVATE ROLLBACK SEGMENTS "2 will be perfect".
4-Start some Procedure, Program, Application ...that accesses the Database

and requires to acquire the private rollback segments"AS OWNER".

5-Now Crash your database by Switching OFF POWER.
6-Restart the Machine & NT. Your Database will Start.
7- Check your alert file you will find that Smon tries to Recover some

Transactions..Then Ora600.. .
8-Your Private Rollback Segments Will become "Needs Recovery", But Will never ever recover Again".

9-ORACLE Corporation Support PROVIDES TWO SOLUTIONS, The First is Using "_corrupt_rollback_segments" which is Not Recommended because it leaves Corruption in the Dictionary and the Control File(s). The RECOMMENDED Solution IS TO RECREATE YOUR DATABASE....!

10-DO FULL EXPORT,RE-CREATE THE DATABASE & THE TABLESPACES WITH EXACT NAMES OF DATAFILES and LOCATIONS.
11-RE-CREATE YOUR PRIVATE ROLLBACK SEGMENTS WITH THE EXACT NAMES, to do that you need to Recreate your Application User then Create the Private Rollback Segments.
12-IMPORT FULL WITH "IGNORE=y".

13-After the Import is Done connect to your database and Drop the Private Rollback Segments if you want ..But only at this stage your database will be corruption Free...

Regards

about
Yassir Khogaly wrote in message
<6vkai7$bkl$1_at_newsreader2.core.theplanet.net>...
>Hi,
>
>Yes.. I Said that and it is correct.
>Read the original emai you will find that the question was about Full
import
>into an new Instance...! Talking about new instances..., Please try out
this
>yourself :
>
>1)-FULLY EXPORT YOUR CURRENT DATABASE.
>2)-DROP YOUR DATABASE COMPLETELY & REMOVE THE DATAFILES physically and also
>remove Oracleservice & OracleStart services
>3)-RECREATE YOUR DATABASE WITH ALL EXACT PARAMETERS, Tablespaces, Datafiles
>Names & locations, BUT CHANGED DB_BLOCK_SIZE TO 8K from 2K which is the
>default for NT4.0.
>4)-TRY TO IMPORT YOUR PREVIOUS EXPORT now...?.
>
>Please Let me know if you still NOT happy...!
>
>
>Good Luck
>
>
>
>
>
Received on Fri Oct 09 1998 - 03:53:40 CDT