oh ok - I thought you had a full cold backup of your db - if you want I can
still get data out of those datafiles (if they're not too big and you only
want a couple of tables)
"Kev" <java2e_at_yahoo.com> wrote in message
news:ikj03usqh1acfhdaqj2dfjr94up4ihgvgc_at_4ax.com...
> Ah, well that is the problem I only had those files not all. The
> system became corrupted when the HD failed as did the rest those
> where the only 2 file I copied previously.
>
> I htink I got yeah. Next time I will be more careful and make darn
> sure I have a automated backup system.
>
> First time is ok the second time Im an idiot.
>
> Thank you again!
>
> Kev
>
>
> On Mon, 31 Dec 2001 09:22:36 GMT, "koert54" <koert54_at_nospam.com>
> wrote:
>
> >one moment here :
> >
> >These files are from the same database
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\SYSTEM01.DBF',
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\RBS01.DBF',
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\USERS01.DBF',
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\TEMP01.DBF',
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\TOOLS01.DBF',
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\INDX01.DBF',
> > 'E:\ORACLE8I\ORA81\ORADATA\K2\DR01.DBF',
> >AS
> >these files :
> >'F:\oracle\oradata\k2\MAIN01.ORA',
> >'F:\oracle\oradata\k2\MAIN02.ORA',
> >????????????????????
> >
> >You'll have to copy ALL database files from your backup to your second
> >machine and insert them in the controlfile....
> >If you create the dummy database - remove all the database files
belonging
> >to the dummy DB first (the dummy DB was just there
> >to create an easy dump of the controlfile to start with - nothing more !)
> >
> >
> >"Kev" <java2e_at_yahoo.com> wrote in message
> >news:15503ucr4ebj01i4uo2fk656etds8b4j4v_at_4ax.com...
> >> Here is the error that come back. I guess I just lost it and will
> >> ahve to resort to the last 12 days. BUMMER.
> >>
> >> I you think I can still get it out let me know.
> >>
> >>
> >>
> >> ORA-01503: CREATE CONTROLFILE failed
> >> ORA-01159: file is not from same database as previous files - wrong
> >> database id
> >>
> >> Sun Dec 30 23:37:06 2001
> >> CREATE CONTROLFILE REUSE DATABASE "K2" RESETLOGS NOARCHIVELOG
> >> MAXLOGFILES 32
> >> MAXLOGMEMBERS 2
> >> MAXDATAFILES 32
> >> MAXINSTANCES 16
> >> MAXLOGHISTORY 1815
> >> LOGFILE
> >> GROUP 1 'E:\ORACLE8I\ORA81\ORADATA\K2\REDO03a.LOG' SIZE 1M,
> >> GROUP 2 'E:\ORACLE8I\ORA81\ORADATA\K2\REDO02a.LOG' SIZE 1M,
> >> GROUP 3 'E:\ORACLE8I\ORA81\ORADATA\K2\REDO01a.LOG' SIZE 1M
> >> DATAFILE
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\SYSTEM01.DBF',
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\RBS01.DBF',
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\USERS01.DBF',
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\TEMP01.DBF',
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\TOOLS01.DBF',
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\INDX01.DBF',
> >> 'E:\ORACLE8I\ORA81\ORADATA\K2\DR01.DBF',
> >> 'F:\oracle\oradata\k2\MAIN01.ORA',
> >> 'F:\oracle\oradata\k2\MAIN02.ORA',
> >> CHARACTER SET WE8ISO8859P1
> >>
> >> Sun Dec 30 23:37:09 2001
> >> ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "K2"
> >> RESETLOGS N...
> >>
> >> The main01 and 02 are the ones I want to get the data out of.
> >>
> >>
> >> Thanks,
> >>
> >> Kev
> >>
> >> On Sun, 30 Dec 2001 22:10:46 GMT, "koert54" <koert54_at_nospam.com>
> >> wrote:
> >>
> >> >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
> >> >> >> >>
> >> >> >> >
> >> >> >>
> >> >> >
> >> >>
> >> >
> >>
> >
>
Received on Mon Dec 31 2001 - 09:51:26 CST
