restore database

[theresatan]

Hi,

I have a full database backup(hot) and I want to restore the database using this backup.

I shutdown the database then startup mount the database.

then in rman
run {
allocate channel disk1 type disk;
restore database;
recover database;
alter database open;
}
and I got
rman-03002 failure of recover command
ora-00283 recovery session canceled due to error cannot recover data file 1 -file is in use ...system01.dbf

Thanks!

Theresa

[skhanal]

Do you have the database running?. You have to start the instance in mount mode and run restore.

[theresatan]

Yes.

I did shutdown the database then startup mount the database.

Thanks!

Theresa

[skhanal]

The file lock may not be released on system01.dbf, do you have any tools (such as freeware process explorer www.sysinternals.com) to see what application has it open.