• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 781
  • Last Modified:

Virtualized Oracle database without .dbf files, cannot connector or open

I have an oracle 10.0.2.0.4 instance on a 2003 x64 box that is the back end to an Arcsight ESM installation. In order to test some ugprades, I ran VMwares P2V and virtualized everything, including the drives, except for my physical database files. My plan was to use 'arcsight database init' to recreate a new database. I did this because I didn't have the luxury of bringing the database down and doing a cold copy of my production database. I also simply do not have the space on my SAN to have a production copy of the database. Since this is just a test instance for an upgrade, I don't care about the data, but I do want to have a similar database structure to upgrade.

I can't seem to get the database to open. It mounts, but doesn't open because it's looking for a file that doesn't exit. I'm getting the ORA-01157 and ORA-01110 errors when trying to manually start it up, and it refers to a .dbf file that doesn't exist.

Is there anyway to blow away what it thinks is active, and just rebuild the database structure from scratch? Arcsight's utilities cannot connect to the instance, because their credentials are being rejected. I'm guessing this is because those credentials were stored somewhere in one of the .dbf files?
0
Bigchingan
Asked:
Bigchingan
  • 2
1 Solution
 
BigchinganAuthor Commented:
Update: I used the alter database datafile 'path.dbf' to delete all of the missing database files from the database. Now I'm pulling over some redo_logs, which it failed on to try and get the database to open
0
 
mrjoltcolaCommented:
>>I can't seem to get the database to open. It mounts, but doesn't open because it's looking for a file that doesn't exit. I'm getting the ORA-01157 and ORA-01110 errors when trying to manually start it up, and it refers to a .dbf file that doesn't exist.

Post the actual log here. The ORA numbers are helpful, but we need to see more details.

It is possible that the dbf files it is looking for is the online logs. You can't really take a live snapshot of Oracle like this, unless you put the database into backup mode, as if you were doing a live mirror / bcv split.

I would suggest an export, without data, or with limited data. You can specify to export rows=n, or use datapump to specify filter options for certain tables to only grab a small subset of data, either approach can result in a small structure only export.
0
 
BigchinganAuthor Commented:
Your answer is probably correct, however I ended up just rebuilding anyways. Thanks.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now