Printable View
Hi all
I've got copies of all necessary files, including control files, redo logfiles, datafiles. I don't have one for spfile. Is there any way I could create a database out of it and use the data there? I am doing this just for test purpose.
I appreciate any advice/suggestion.
Thanks
gtcol
yes, as long as you know the original location of all the files - if you dont, create a control file and use that
Thanks Davey.
Yes I have the location for all files, I need to know how we attach them to new database. I ran 'relink all' as it gives me:
ERROR:
ORA-12547: TNS:lost contact
while trying to connect as sys. But it doesn't seem to help.
Please suggest.
Thanks
gtcol
Incase I confused you all,
login as: oracle
[email protected]'s password:
Last login: Thu Feb 12 21:48:46 2009 from 192.168.74.97
[oracle@oradb1 ~]$ sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 12 23:30:21 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:sys as sysdba
Enter password:
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
Thanks
You do not attach datafiles to a database.
You are cloning -cloning as in creating- a database based on "all necessary files, including control files, redo logfiles, datafiles" you have gotten from other one.
well in case of emergency i wud have tried as follows:
Since i dont have an spfile.So first create one and give the path of controlfiles as controlfiles will be opend in the mount stage. Then wud have checked whether the datafiles have been restored to the correct location. iF i m going to restore them to a diff location, then wud have registered this change in the controlfile using rename command.
if clean shutdown is made, then no recovery is reqd.
but i wont be able to open the database as i dont have redologs that r registered in the controfile i.e log sequence number.
so, recover database until cancel n open using resetlogs.
do check tnsnames.ora and set oracle_sid.
may be there r other things to consider as well.
Thanks PAVB.Quote:
You do not attach datafiles to a database.
You are cloning -cloning as in creating- a database based on "all necessary files, including control files, redo logfiles, datafiles" you have gotten from other one.
I have just got the files of a database for which instance files were 'deleted', with rm command. From what I read about cloning is ,database needs to be cleanly shut down to perform a cold cloning. I have installed Oracle software with the same sid, port and home directories, but when I try to connect as sys, it gives the error that I've already posted.
Any help/suggestion is appreciated.
Thanks
gtcol
Make sure datafiles, archivelogs, etc. are available and in the right location as described in controlfile -from now on your_control_file.sql
Edit your controlfile:
Make sure the first line of your control file reads like...
CREATE CONTROLFILE REUSE SET DATABASE "your_db_name" RESETLOGS ARCHIVELOG
Make sure to comment out anything you may have after DATAFILES description like startup, alter database, etc.
Startup/recover your database:
sqlplus /nolog
conn sys as sysdba
--hit enter--
STARTUP NOMOUNT
@/your_path/your_control_file.sql
RECOVER DATABASE USING BACKUP CONTROLFILE until cancel
--apply your logs--
alter database open resetlogs;
Once your database is up, bounce it and be sure your alertlog is clean.
Hi PAVB
I understand what you're saying. But Oracle won't let me connect even as sysdba, in the first place. I tried relink all; attached is its output. (I had to break them down to 2, as they exceeded 100K size limit.) And after relinking, 'env | grep ORA' gives me correct paths. But still I am getting following error.
[oracle@oradb1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 13 14:50:15 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-12547: TNS:lost contact
SQL>
Thanks
gtcol
Have you ever had an Oracle database of the same version running in that particular machine?
Yes I had a database earlier. I deleted all software files and reinstalled Oracle 10.2.0.1 and patched with 10.2.0.4. Now I'm trying to build the database using the same datafiles, control files, redo log files. My database is in noarchivelog mode, on RHEL 4.
Understood. Your answer means "No", I understand you have a fresh Oracle installation then you never had an Oracle database of the same version running on that particular environment.
It looks to me your problem is not database related, the issue you are experiencing is Oracle installation related. Either something went wrong during Oracle installation or your kernel parameters are not properly set.
Hi PAVB
I am doing a fresh installation again, I won't be applying patches for 10.2.0.4 this time. I am going through kernel parameters as well. Lets see if something new shows up. I will let you know
Thanks