Re: After Control File backup

Mark D Powell wrote:
> What version of Oracle?

Oracle 9.2

>
> Oracle includes one or more Backup and Recovery manuals depending on
> your version. In your example you do not need to perform database
> recovery. You can recover the lost control file using the second
> control file since you should have at least two. But yes. you can
> recover your database using a backup control file if all current
> control files are lost as part of the media failure. Lookup recovery
> using a backup control file.

Agreed that i can recover the database from backup Control ile, but my question is that my backup control file will not have the definition of the tablespace, Which i added after taking the backup. (Assume i have lost all control files) So will the backup control file be able to recover the new tablespace ? If Yes how? and if NO then Why?

I hope i am more clear now.

>
> HTH -- Mark D Powell --
Received on Tue Aug 02 2005 - 09:42:17 CDT