it was not opening i did this

SQL> startup force
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01122: database file 12 failed verification check
ORA-01110: data file 12: 'C:\ORACLE\ORADATA\OEMREP\INSALIM.DBF'
ORA-01207: file is more recent than controlfile - old controlfile

________________________________

From: Jay [mailto:Jay.[Email address protected]
Sent: Mon 1/30/2006 5:53 AM
To: Jumma, Salim
Subject: Re: Manual backup



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


If its a cold backup you wont require the recover step.

regards,
Jay Munshi
http://jaydba.tripod.com




"Jumma Salim " [Email address protected]
01/30/2006 04:06 PM


To
"LazyDBA Discussion" [Email address protected]
cc

Subject
Manual backup






platform window 2000 profession / oracle 9i .2

I was testing Manual backup directly from files
Backup
1) shutdown
2) copy data & control file (*.dbf & *.ctl)

As test deleted all .dbf files and .ctl files

RESTORATION

1) Shutdown if open
2) copy back the file (*.dbf & *.ctl in default location from backup)
3) On sql prompt
Recover database until cancel

I get this error
SQL> recover database until cancel;
ORA-01034: ORACLE not available

Next step to be done is ...
cancel
alter database open resetlogs


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html


ForwardSourceID:NT00005A1A





Oracle LazyDBA home page