| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Lost oracle database but have the datafiles
could you post the alert.log concerning the message ...
"Kev" <java2e_at_yahoo.com> wrote in message
news:b52v2uglck8f6amnafrvsiri0dm4n2d00h_at_4ax.com...
> I just ran this and I keep getting an error that says this was created
> with a different redolog files?
>
> I dont have a copy of the redos.
>
> What did I miss?
>
> Thanks again!
>
> On Sun, 30 Dec 2001 20:06:50 GMT, "koert54" <koert54_at_nospam.com>
> wrote:
>
> >cool - so you just have the datafiles and no controlfiles, no redologs
and
> >no init.ora
> >
> >if you did a shutdown (other than abort) the database checkpointed and is
> >consistent - so no redologs are
> >needed for instance recovery.
> >
> >what I should do in this case is :
> >1. on the new machine create a dummy database (this should make it easier
to
> >create init.ora and a controlfile)
> >2. issue - 'alter database backup controlfile to trace ;'
> >This will generate a dump of the controlfile of the dummy database (in
> >$ORACLE_HOME/admin/<SID>/udump)- it looks like this :
> >*** 2001-12-30 20:53:53.150
> ># The following commands will create a new control file and use it
> ># to open the database.
> ># Data used by the recovery manager will be lost. Additional logs may
> ># be required for media recovery of offline data files. Use this
> ># only if the current version of all online logs are available.
> >STARTUP NOMOUNT
> >CREATE CONTROLFILE REUSE DATABASE "PO" NORESETLOGS NOARCHIVELOG
> > MAXLOGFILES 32
> > MAXLOGMEMBERS 2
> > MAXDATAFILES 254
> > MAXINSTANCES 1
> > MAXLOGHISTORY 899
> >LOGFILE
> > GROUP 1 'J:\ORA8I\ORADATA\PO\REDO01.LOG' SIZE 1M,
> > GROUP 2 'J:\ORA8I\ORADATA\PO\REDO02.LOG' SIZE 1M,
> > GROUP 3 'J:\ORA8I\ORADATA\PO\REDO03.LOG' SIZE 1M
> >DATAFILE
> > 'J:\ORA8I\ORADATA\PO\SYSTEM01.DBF',
> > 'J:\ORA8I\ORADATA\PO\RBS01.DBF',
> > 'J:\ORA8I\ORADATA\PO\DUL01.DBF'
> >CHARACTER SET WE8ISO8859P1
> >;
> ># Recovery is required if any of the datafiles are restored backups,
> ># or if the last shutdown was not normal or immediate.
> >RECOVER DATABASE
> ># Database can now be opened normally.
> >ALTER DATABASE OPEN;
> ># Commands to add tempfiles to temporary tablespaces.
> ># Online tempfiles have complete space information.
> ># Other tempfiles may require adjustment.
> >ALTER TABLESPACE TEMP ADD TEMPFILE 'J:\ORA8I\ORADATA\PO\TEMP01.DBF'
REUSE;
> ># End of tempfile additions.
> >#
> >3. shutdown the dummy database and remove all of it's files except
init.ora
> >
> >4. copy the backup of your datafiles to disk
> >
> >5. edit the dump of the controlfile (remove all crap)
> >a. NORESETLOGS should become RESETLOGS
> >b. set the DATABASE <SID> correctly
> >c. edit the DATAFILE clause to confirm with the copy of your datafiles
> >d. edit the LOGFILE clause to whatever you like (it's ok if you don't
have
> >the redologs)
> >e. rename the dump to control.sql
> >
> >STARTUP NOMOUNT
> >CREATE CONTROLFILE REUSE DATABASE "PO" NORESETLOGS NOARCHIVELOG
> > MAXLOGFILES 32
> > MAXLOGMEMBERS 2
> > MAXDATAFILES 254
> > MAXINSTANCES 1
> > MAXLOGHISTORY 899
> >LOGFILE
> > GROUP 1 'J:\ORA8I\ORADATA\PO\REDO01.LOG' SIZE 1M,
> > GROUP 2 'J:\ORA8I\ORADATA\PO\REDO02.LOG' SIZE 1M,
> > GROUP 3 'J:\ORA8I\ORADATA\PO\REDO03.LOG' SIZE 1M
> >DATAFILE
> > 'J:\ORA8I\ORADATA\PO\SYSTEM01.DBF',
> > 'J:\ORA8I\ORADATA\PO\RBS01.DBF',
> > 'J:\ORA8I\ORADATA\PO\DUL01.DBF'
> >CHARACTER SET WE8ISO8859P1
> >;
> >
> >5. edit init.ora of the dummy database - you should change DB_NAME,
> >INSTANCE_NAME, CONTROL_FILES, etc to comply with the backup
> >of your database
> >
> >6. svrmgrl
> >connect internal
> >->>>> run control.sql
> >->>>> controlfiles are now create according to CONTROL_FILES parameter in
> >init.ora
> >
> >7. alter database open resetlogs ;
> >-->>>> this will create the redologs (see LOGFILE clause control.sql)
> >
> >Howard - you as backup&recovery guru ... can you double check this ? -
I'm
> >pretty sure it'll work as no recovery is needed ....
> >
> >
> >"Kev" <java2e_at_yahoo.com> wrote in message
> >news:hmru2ug9vr69lcdp1h9j24itri42uk8cun_at_4ax.com...
> >> I copied the datafiles after I did a shutdown of the server. Then I
> >> rebooted the machine. Then today the harddrive crashed.
> >>
> >> So I have a clean copy of the datafile. I installed Oracle on another
> >> machine and I wanted to move those file to the new installation but I
> >> have no idea on how to do it.
> >>
> >> The other machine oracle was on is dead until I can replace the drive.
> >>
> >> but the new machine is good to go.
> >>
> >> Thanks.
> >>
> >>
> >> On Sun, 30 Dec 2001 19:46:59 GMT, "koert54" <koert54_at_nospam.com>
> >> wrote:
> >>
> >> >
> >> >how did you backup those datafiles ?????
> >> >even if you didn't backup controlfiles and redolog you'll be able to
open
> >> >the DB
> >> >if you first did a shutdown other than abort and then copied the
> >datafiles
> >> >....
> >> >
> >> >1. copy the datafiles back to your drive
> >> >2. recreate the controlfile (check the create controlfile command)
> >> >3. open the database using resetlogs
> >> >
> >> >"Kev" <java2e_at_yahoo.com> wrote in message
> >> >news:l1ru2uk66fa4ci1bb2gjl44rve2ajadqbl_at_4ax.com...
> >> >> Hello Howard,
> >> >>
> >> >> Here is the problem. I completely lost my harddrive but before I
did
> >> >> about a day ago I saved the datafiles, no idea of why I did it. And
> >> >> about 1 week ago I did a export of the schema I care about.
> >> >>
> >> >> What I need to do is jsut get one table out of the datafile and the
> >> >> rest I dont care about.
> >> >>
> >> >> I might be abot to get the control files but not the arcive or
redos.
> >> >>
> >> >> I can run the import to create the structure but I need to pull the
> >> >> data from the datafiles if this is at all possible.
> >> >>
> >> >> Thanks,
> >> >>
> >> >> Kev
> >> >>
> >> >> On Mon, 31 Dec 2001 06:29:12 +1100, "Howard J. Rogers"
> >> >> <dba_at_hjrdba.com> wrote:
> >> >>
> >> >> >Kev,
> >> >> >
> >> >> >Your post is not entirely clear... Do you have the datafiles as
your
> >post
> >> >> >title suggests, or do you merely have an export file as your post
> >> >contents
> >> >> >suggests?
> >> >> >
> >> >> >If you have the datafiles themselves, do you have a control file as
> >well?
> >> >> >And do you have archives? Because if that's all true, then you can
> >> >perform
> >> >> >a standard incomplete recovery and get all your data back, except
for
> >the
> >> >> >last little bit that was in the current online redo log.
> >> >> >
> >> >> >If all you've got is the export file, then you'll have to create a
> >brand
> >> >new
> >> >> >database from scratch, and run import to get the data back as it
was
> >at
> >> >the
> >> >> >time you took the export. The easiest way to proceed in that
> >eventuality
> >> >> >would be to manually create all the right tablespaces (and users),
and
> >> >then
> >> >> >leave import to create all the tables, indexes and so on, and
populate
> >> >them.
> >> >> >
> >> >> >Regards
> >> >> >HJR
> >> >>
> >> >
> >>
> >
>
This message was cancelled from within Mozilla...not Received on Sun Dec 30 2001 - 16:10:46 CST
 |
 |