RMAN cannot do the recovery !!

[nngk]

Hi,

Don't know how come. It's definitely a simple restore command but the fact is recovery cannot be done.

I've done a cold full database backup using Recovery Manager. The backup script used are shown in the following.

I try to do the recovery with the following script. But there is only error returned.

I'm totally lost. Any advise please?

Thanks,
nngk


Recovery Error
-----------------
:
:
RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06003: ORACLE error from target database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 923
ORA-06512: at line 1
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upper ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ;

Recovery Manager complete.


Recovery Script
-------------------
startup dba nomount
run
{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
setlimit channel ch1 kbytes 2097150 maxopenfiles 32 readrate 200;
setlimit channel ch2 kbytes 2097150 maxopenfiles 32 readrate 200;
restore controlfile;
alter database mount;
restore database;
recover database;
release channel ch1;
release channel ch2;
}


Backup Script
----------------
shutdown immediate;
startup force dba pfile=c:\oracle\ora81\database\initsieb.ora;
shutdown immediate;
startup mount;
run
{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
setlimit channel ch1 kbytes 2097150 maxopenfiles 32 readrate 200;
setlimit channel ch2 kbytes 2097150 maxopenfiles 32 readrate 200;
backup
full
skip inaccessible
filesperset 5
database;
alter database open;
release channel ch1;
release channel ch2;
}

[sambavan]

Originally posted by nngk


Recovery Script
-------------------
startup dba nomount
run
{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
setlimit channel ch1 kbytes 2097150 maxopenfiles 32 readrate 200;
setlimit channel ch2 kbytes 2097150 maxopenfiles 32 readrate 200;
restore controlfile;
alter database mount;
restore database;
recover database;
release channel ch1;
release channel ch2;
}

change the startup dba nomount to

startup nomount Since you have already connected to the target database, you don't have to specify the dba there.

Hope this would fix the problem for you.

Sam

[nngk]

hi sam,

I found where's the problem.

When I do the backup using Recovery Manager, I used the control file as RMAN's repository of metadata. And when I tried to do the recovery, I pretend that the control file is crashed and do the whole database recovery including the control file. That's where the problem comes!!

Although Oracle provide a choice to do the backup and use the control file as RMAN's repository of metadata instead of the Recovery Catalog, in the case that the control file is lost or damaged, Oracle DOES NOT support restore nor recovery without the Recovery Catalog.

Thanks anyway.
nngk