OraFAQ Forum: Backup & Recovery » RMAN ERROR: ORA-00209

Home » RDBMS Server » Backup & Recovery » RMAN ERROR: ORA-00209

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN ERROR: ORA-00209 [message #188974]

Tue, 22 August 2006 11:11

mariliaaguiar
Messages: 6
Registered: July 2006

Junior Member

Hi Everybody!

I´m trying to make a recovery with RMAN and this way testing my RMAN backup if it´s working.
I´ve got this error ORA-00209.

I read about an Oracle´s documentation about RMAN without catalog (cause I don´t have it).
I have the backup of Controlfiles, datafiles and archivelogfiles.
My old and new machines are SUNOS 5.8 - SPARC.

Here there are the steps I followed:

1- Create a new service by editing the listener.ora.
2- STOP and START the listener
3- Start RMAN
4- Set a DBID to identify the Database
5- connect to DB ( connect target / )
6- run this script:

run {
startup nomount;
set controlfile autobackup format for device type disk to '/oracle/%F';
restore controlfile from /oracle/backup/C-XXXXXXXX-20060822-00';
mount database;
restore database}

When I run this script, RMAN looks for a parameter file (without success). Then it creates a dummy parameter file and starts the recovery with the controlfile´s settings, MOUNT the database and give me a message as follows:

ORA-00209: control file blocksize mismatch, check alert log for more info

When I try to start the instance setting the DB_BLOCK_SIZE = 8192 (as the same as the old database), I got another this error:
"ORA-00439: feature not enabled: Managed Standby"

Does anybody can help me, Please ???

Thanks in advance !

Report message to a moderator

Re: RMAN ERROR: ORA-00209 [message #189032 is a reply to message #188974]

Tue, 22 August 2006 18:27

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you didn't backup the SPFILE and you don't have a extra copy of the SPFILE or PFILE, then you should recreate a PFILE by hand and after you run STARTUP NOMOUNT, then run:

STARTUP FORCE PFILE=/oracle/pfileTEMP.ora;

at this point, you can try to restore control file again.

You don't mention what version of Oracle you are using, but if you are on 9i or above, you should set AUTOBACKUP ON, then the SPFILE will get backed up with the control file.

Report message to a moderator

Re: RMAN ERROR: ORA-00209 [message #189179 is a reply to message #189032]

Wed, 23 August 2006 09:13

mariliaaguiar
Messages: 6
Registered: July 2006

Junior Member

Hi There !!

I tried to follow the instructions as you said and I´ve got this message error:

$ rman

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> set dbid=XXXXXXXXXXX

executing command: SET DBID

RMAN> connect target /

connected to target database (not started)

RMAN> run {
startup nomount;
startup force pfile=/oracle/product/dbs/initXXXX.ora;
}
2> 3> 4>
RMAN-00571: =======================================================
RMAN-00569: =========== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: =======================================================
RMAN-03002: failure of startup command at 08/23/2006 11:14:56
RMAN-04014: startup failed: ORA-00439: feature not enabled: Managed Standby

RMAN>

The parameter file is from the original machine.

thanks for your help !

Report message to a moderator

Re: RMAN ERROR: ORA-00209 [message #189184 is a reply to message #189179]

Wed, 23 August 2006 09:40

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Do you have LOG_ARCHIVE_DEST_n set in the pfile? If so, you may want to modify this parameter to LOG_ARCHIVE_DEST to try and start the database and then change it back once you've completed the recovery.

Report message to a moderator

Re: RMAN ERROR: ORA-00209 [message #189644 is a reply to message #189184]

Fri, 25 August 2006 07:14

mariliaaguiar
Messages: 6
Registered: July 2006

Junior Member

Hi Again !!
Thanks a lot for your help ! It works fine.

Now I have another problem: FREE DISK SPACE

The machine that I´ve recovered my database doesn´t have enough space, if I consider the size of files of original database. But these files haven´t full using (do you know what I mean) ?

My question is:

Can RMAN make a recovery by blocks that contains data ONLY or RMAN needs the space that used to have in the old machine?

Is that possible ?

Thanks a LOT ! =)

Report message to a moderator

Re: RMAN ERROR: ORA-00209 [message #189916 is a reply to message #189644]

Mon, 28 August 2006 09:12

mariliaaguiar
Messages: 6
Registered: July 2006

Junior Member

Hello !

Is it possible to recover controlfile and edit it to delete some entries(tablespaces) before database´s recovery and then create a new controlfile?

I would like to recover some tablespaces only, not all. This way I have enough Free Space to recover my database cause I don´t need all of them.

Thanks !

Report message to a moderator

Re: RMAN ERROR: ORA-00209 [message #189977 is a reply to message #189916]

Mon, 28 August 2006 16:41

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

Nope. Controlfile is not acceptable after manual editing.

Report message to a moderator

Previous Topic:	RMAN execution fails with TNS:Lost contact
Next Topic:	restore database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 13:56:50 CDT 2024