Mediarecoverycansometimesbestoppedbytheinabilitytoreadpastacertainpointintheredostream.Thisisoftenreferredtoasstuckrecovery”.BeforeOracle9i,the
DatabaseAdministratorhadfewoptionstodealwithstuckrecovery.Ifthecorruptredocouldnotberecoveredfromsomeothersource,thenalltransactionsthatcommittedafterthecorruptpointintheredosteamwouldbelost.
Oracle9ichangesthatwiththeTrialRecoveryfeature.TrialRecoverisusedtotesttheapplicationoftheredologstothedatabase.
WhatarethreeothercharacteristicsofTrialRecovery()