Re: recovery without control file and online redo log

"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:aen1e9$psd$1_at_coco.singnet.com.sg...
> Thanks, it's working! resetlogs is the point.

And hooray! You finally got it. (I only mentioned it twice in my original reply)
HJR
> <Kenneth Koenraadt> wrote in message
> news:3d0ef443.8114948_at_news.capgemini.se...
> > On Tue, 18 Jun 2002 11:32:28 +0800, "xueyang"
> > <xueyangy_at_singnet.com.sg> wrote:
> >
> > >Hi,
> > >
> > >I backuped our production db( all the dbf files), but i didn't backup
the
> > >control file and online redo log. this db is running under noarchivelog
> > >mode.
> > >Now i try to restore this db on another server with this version of
> > >backup(all the dbf files , no control file and redo log file), and i
met
> > >some problem.
> > >I can't startup the db due to no control file. when i tried to create
> > >control file, it told me no redo log file.
> > >Anyone has any idea about this? thanks in advance.
> > >
> > >Regards,
> > >
> > >
> > >
> >
> > Hi,
> >
> > You need to use the "resetlogs" option in the "create controlfile"
> > command, like this :
> >
> > STARTUP NOMOUNT
> > CREATE CONTROLFILE REUSE DATABASE "K" RESETLOGS NOARCHIVELOG
> > MAXLOGFILES 5
> > MAXLOGMEMBERS 5
> > MAXDATAFILES 100
> > MAXINSTANCES 1
> > MAXLOGHISTORY 113
> > LOGFILE
> > GROUP 1 'C:\ORACLE\ORADATA\K\REDO01.LOG' SIZE 10M,
> > GROUP 2 'C:\ORACLE\ORADATA\K\REDO02.LOG' SIZE 10M,
> > GROUP 3 'C:\ORACLE\ORADATA\K\REDO03.LOG' SIZE 10M
> > DATAFILE
> > 'C:\ORACLE\ORADATA\K\SYSTEM01.DBF',
> > 'C:\ORACLE\ORADATA\K\RBS01.DBF',
> > 'C:\ORACLE\ORADATA\K\TOOLS01.DBF',
> > 'C:\ORACLE\ORADATA\K\USERS01.DBF'
> > CHARACTER SET WE8ISO8859P1;
> > ALTER DATABASE OPEN RESETLOGS;
> >
> > - Kenneth Koenraadt
> >

>
> Received on Tue Jun 18 2002 - 06:28:26 CDT