New answers tagged oracle-11g
startup nomount You have lost the UNDO tablespace, so switch to manual undo management: alter system set undo_management=manual scope=spfile sid='*'; You have lost the redo logs and your remaining datafiles are in an inconsistent state, so you will not be able to open the instance, unless you allow resetlogs corruption: alter system set ...
The problem was that all oracle linked tables in msaccess database, have the link description of an odbc of the previous database version (DBA=W;APA=T;EXC=F;FEN=T;QTO=F;). One of this parameters (Enable LOBs) was diferent and causes the error. To solve the problem have to relink all the tables of de msaccess database. It's important to relink all, because ...
As sporri said Rman is really not that hard once you get your head around it but try with this Link
Shut down the database instance. Copy all files to backup location. Start up the database instance.
Top 50 recent answers are included