Hi Salim,
Looks like your db was not shut while you took the backup.

Do this for cold back up.

Conn sys as sysdba
shutdown immediate

copy your files i.e. dbf,control and redo ( Its allright to copy redo logs
in a cold backup)

restore them when necessary.

conn to sys as sysdba

start your db.

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




"Jumma Salim " <oracledba-ezmlmshield-x57920874.[Email address protected]
01/30/2006 04:19 PM


To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Manual backup






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






--------
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:NT00005A2A

Oracle LazyDBA home page