restore database

[theresatan]

Hi,

I am testing backup and restore with following step:
1. rman nocatalog
2. run {
allocate channel disk1
type disk
format 'c:\backup\%U';
backup database
tag open_db_full_1;
}
3.in SQLPlus
a.shutdown
b.startup mount
4. in rman
run {
allocate channel disk1 type disk;
restore database;
recover database;
alter database open;
}

I got following error:
.....
released channel: disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/25/2006 11:15:50
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database reco
ver if needed
start
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'

Any idea?

Thanks!

Theresa

 

[hoinz]

Theresa,

I am not an expert for RMAN.
But there wasn't a helpful reply so far, and so let me try:

Let's begin with this:

In Oracle9i, unlike in previous RMAN releases, RMAN by default does not restore a datafile if the file is in the correct place and its header contains the expected data (RMAN does not scan the datafile body for corrupt blocks). The FORCE option overrides this behavior and restores the requested files unconditionally.

From what you wrote it seems that your old datafiles were still there when you started restore.
My guess is that RMAN did not restore anything, and all files were good, and so could not be recovered either.

To check this:
How long did your restore command run? Just a few seconds, or rather minutes or hours?
And are you able to open your database after you got that recover error?

hope this helps