1
vote
1answer
35 views

What are the contents of the Headers in Control,Redo log and data file in a typical Oracle DB?

Where can i find the contents contents of the Headers in Control,Redo log and data file in a typical Oracle DB.
2
votes
1answer
320 views

Opening an oracle database crashes the service [SOLVED]

I am experiencing a weird issue with Oracle where the service started fine after a crash. The database mount went fine as well. However, when I issue alter database open; command, the database does ...
1
vote
3answers
3k views

How do you clone an oracle instance?

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname. I'm working with Oracle 10.2.