If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

data file need media recovery

Hello All,
I am new to this field so please be patient. I have taken the backup of all datafiles, redologs, control file, spfile for my database.
After taking the backup i shutdown the database and change the location of all original datafiles, redolog files , control files which is asked by my team lead.
Now when i try to bring the database up its giving me this error:

I took hot backup of all datafiles and control files and redolog files i used simple OS cp command.
Then i asked for downtime and shutdown the database.
After that my lead asked me to change the location of original datafiles,control files and redo log files so i did that.
But i did not swich log for taking backup of datafiles, may be thats the problem.
now when i try to recover the database its giving me this error.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

I took the hot backup by traditional way means by putting tablespaces in hot backup mode by
alter tablespace begin backup;
then i copy all the datafiles associated with this tablespace to desired location.i repeated same procedures for all tablespaces.
i believe this is the only way to take hot backup...
For redologs, control files i simply took copy of these files.
after that i shutdown the database
then i moved the original datafiles, control files and redolog files to a location which is asked by my lead coz they wanted to change the location for all these files.
and that is the reason i took backup of those datafiles, control files and redolog. so that if i wont be able to startup the database i can restore it in old condition.
now after changing the location i am not able to startup the database and i want to restore it.
when i am trying to restore database by using my backup i am getting this error..
i hope this time i explain my problem clearly

You should not need to go to the backup since you shutdown the DB prior to moving your datafiles and redo logs.

You do however need to re-create your control files. And point the pfile/spfile to the new control files.

A suggestion for next time to assist you in re-creating control files.
"alter database backup control file to trace"

You have 2 choices:
1. a. copy everything to its original location. (if you have capacity)
b. Run alter database backup controlfile to trace...
c. Edit the .trc file created, with the location of the the new files.
d. edit the pfile/spfile setting up the control file location.
e. Run the create control file command.
or
2. a. Build a create controlfile command by hand.
b. edit the pfile/spfile setting up the new control file locatoin
c. run the create control file script.

-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;