Home » RDBMS Server » Backup & Recovery » How to recover from .DAT file (ORA 9i, WIN 2000)
How to recover from .DAT file [message #298642] Wed, 06 February 2008 23:09 Go to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
Im using ora 9i, with win 2000 server.
my OS was currupted so that I repaired the registry.
After the repair, my system able to logged in; but oracle was not loaded; and I searched in services.msc and find NO services associated with ORACLE.
I cannot able to take the backup by EXP option too.So i backup d:\oracle\oradata\*.dat files and
bdump and cdump files in admin folder; And i reinstalled the ORACLE; now its able to logged in to the new oracle database;
But my datas are in THE d:\oracle\oradata\*.dat files;
i need to use those datas in .DAT FILES; how to do that;
pls anyone help me; thanks in advance;

pls do the necessary;

Bala
Re: How to recover from .DAT file [message #298647 is a reply to message #298642] Thu, 07 February 2008 00:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you save or do you have the database control files?
Do you have the init.ora or spfile?
If so, just use oradim command to recreate the Oracle instance service.

Regards
Michel

Re: How to recover from .DAT file [message #298664 is a reply to message #298642] Thu, 07 February 2008 01:10 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
now its able to logged in to the new oracle database;


How did you log in?
Re: How to recover from .DAT file [message #298671 is a reply to message #298647] Thu, 07 February 2008 01:30 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
Thanks for your reply ,Michel Cadot,

Yes sir i have both files, init.ora and spfiles;

but i dont know how to use ORADIM command sir;

my previous instance name is ORASRV;
and my new instance name is HTGORA;(since ORASRV not loading i reinstall the ORA 9i server)

sir, i backed up the d:\oracle\ora\oradata\*.dat files
and d:\orasrv\ADMIN\orasrv files;

I cannot able to log on using , instance ORASRV ;
but at first i can able to log in new instance HTGORA;

Sorry sir, i tryed a bad logic, from my friend ,
i) I stopped the service HTGORA in SERVICE.MSC
ii) then I renamed a ams0708.dat;
iii) then i found "oracle shutdown or initialisation error"

now i restart the HTGORA service, but still i cant able to log in THE NEW INSTANCE TOO;


sir, my need is, to copy all the tables in the ORASRV instance
or restore the ORASRV instance;

pls help me how to do it sir,

I m very thankful to u

Thanks
Bala

Re: How to recover from .DAT file [message #298675 is a reply to message #298642] Thu, 07 February 2008 01:49 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
YOu installed a new oracle database of name HTGORA.
Then Automatically oracle must have created an instance of the name HTGORA.
YOu have all the controlfiles,datafiles of the previous database.
JUst shutdown the new database.Overwrite all the existing files to the previous datafiles.
Recreate password file.
startup
Re: How to recover from .DAT file [message #298679 is a reply to message #298675] Thu, 07 February 2008 02:10 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
sir, thanks for your instant reply,
dont mistaken me, i dont know how to shutdown the current instance and
pls tell me how to "Overwrite all the existing files to the previous datafiles."
how to "Recreate password file."


pls sir,
Thanks for your reply

BALA
Re: How to recover from .DAT file [message #298684 is a reply to message #298679] Thu, 07 February 2008 02:49 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
Sir,
kindly anybody pls help me to solve this problem;
pls sir;

Im awaiting for your valuable reply

thank
Bala
Re: How to recover from .DAT file [message #298695 is a reply to message #298642] Thu, 07 February 2008 03:35 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
SQL>conn /as sysdba
SQL>shutdown immediate
Now copy all the files including control files of the previous database to the location where new database files reside.

Next create password file
Use ORAPWD utility
Re: How to recover from .DAT file [message #298706 is a reply to message #298695] Thu, 07 February 2008 04:09 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
SIR, i have done what u said,
i copyied all the control files into the new database file

now im creating the password file using orapwd tool;

orapwd file=password_file_name password=the_secret_password

orapwd file=PWDhtgora.ora password=myownpassword

this line is enough?

or anything i need to do sir

is there any need to copy the .DAT FILES IN OLD INSTANCE FOLDER TO NEW INSTANCE FOLDER?

Sir pls instruct me

thank u sir

Bala
Re: How to recover from .DAT file [message #298724 is a reply to message #298642] Thu, 07 February 2008 06:05 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
just copy all the files.
startup the database
Re: How to recover from .DAT file [message #298737 is a reply to message #298724] Thu, 07 February 2008 06:41 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
Sir, i dismouted the database and i copied every file of old database into new database.

orasrv(old instance) & HTGORA (NEW INSTANCE)

copy d:\oracle\admin\ORASRV d:\oracle\admin\HTGORA

copy d:\oracle\oradata\orasrv\*.* d:\oracle\oradata\htgora\*.*

and i write the password too.

but after a restart, i found
first "TNS LISTER COULD NOT RESOLVE THE SERVICE NAME"
and after a two or 3 tries, i m getting this,

"ORA-01033 oracle initialization or shutdown in progress"

SIR, i need the data, pls guide me to solve this problem sir;
everybody is waiting for me to correct the problem sir;
pls give your valuable ideas to come out of this error.

Thanking u

Bala
Re: How to recover from .DAT file [message #298744 is a reply to message #298737] Thu, 07 February 2008 07:53 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
SIR, i did what u say, but still i have the same problem.
i try to start up using SQLPLUSW sys/change_on_install@HTGORA as sysdba;
and i typed startup
ORACLE instance started
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 38886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes

ORA-01103: database name 'ORASRV' in controlfile is not 'HTGORA'

sir, how to change the ORASRV NAME TO HTGORA

pls do the needed

thanks
Bala

Re: How to recover from .DAT file [message #298751 is a reply to message #298744] Thu, 07 February 2008 08:34 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Why are you trying to rename the database?? You should just be concerned with recovering the database.

Check ORADIM to learn how it is used.
Re: How to recover from .DAT file [message #298839 is a reply to message #298642] Fri, 08 February 2008 00:04 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
BRIAN SIR, thanks for your reply,
i tryed with oradim

ORADIM -startup -sid orasrv -usrpwd manager -starttype SRVC,INST -pfile D:\ORACLE\ADMIN\ORASRV\PFILE\INIT.ORA

DIM-00011: The service does not exists
O/S-Error: (OS 1060)The specified service does not exists as an installed service.


Sir,since the OS was corrupted, i repaired the OS and REGISTRY.
everything working fine except oracle.I went into services.msc to start the oracle services;
i found no services named in oracle.
i searched through registry for oracle.exe; i found no entries;

so i reinstalled the ORACLE,and i take backup of d:\oracle\oradata\*.* and
d:\oracle\admin\*.*

And i installed new instance HTGORA in the same OS.
THE old oracle instance, not working was, ORASRV.

pls instruct me, how to solve this problem;

I want the data from ORASRV instance;

i have all the control files and spfile

sir, dont mistake me, pls do the favour in time , Thank u sir,

Bala




Re: How to recover from .DAT file [message #298858 is a reply to message #298839] Fri, 08 February 2008 00:53 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\>oradim
ORADIM: <command> [options].  Refer to manual.
Enter one of the following command:
Create an instance by specifying the following options:
     -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
     -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
     -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
Startup services and instance by specifying the following options:
     -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
Shutdown service and instance by specifying the following options:
     -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
 [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]
 Query for help by specifying the following parameters: -? | -h | -help

Use -NEW to create a new service/instance.

Quote:
And i installed new instance HTGORA in the same OS.
THE old oracle instance, not working was, ORASRV.

The db_name parameter in ora.init must be the same the db name in files, that the old name.

Regards
Michel
Previous Topic: BAckup issue
Next Topic: Redo Logs Missing | Datafile Corrupted
Goto Forum:
  


Current Time: Tue Dec 06 14:05:24 CST 2016

Total time taken to generate the page: 0.08404 seconds