Home » RDBMS Server » Backup & Recovery » RMAN ERROR: ORA-00209
icon7.gif  RMAN ERROR: ORA-00209 [message #188974] Tue, 22 August 2006 11:11 Go to next message
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 !

Re: RMAN ERROR: ORA-00209 [message #189032 is a reply to message #188974] Tue, 22 August 2006 18:27 Go to previous messageGo to next message
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.
Re: RMAN ERROR: ORA-00209 [message #189179 is a reply to message #189032] Wed, 23 August 2006 09:13 Go to previous messageGo to next message
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 !


Re: RMAN ERROR: ORA-00209 [message #189184 is a reply to message #189179] Wed, 23 August 2006 09:40 Go to previous messageGo to next message
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.
Re: RMAN ERROR: ORA-00209 [message #189644 is a reply to message #189184] Fri, 25 August 2006 07:14 Go to previous messageGo to next message
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 ! =)


Re: RMAN ERROR: ORA-00209 [message #189916 is a reply to message #189644] Mon, 28 August 2006 09:12 Go to previous messageGo to next message
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 !


Re: RMAN ERROR: ORA-00209 [message #189977 is a reply to message #189916] Mon, 28 August 2006 16:41 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
Nope. Controlfile is not acceptable after manual editing.
Previous Topic: RMAN execution fails with TNS:Lost contact
Next Topic: restore database
Goto Forum:
  


Current Time: Wed Dec 07 08:30:02 CST 2016

Total time taken to generate the page: 0.35068 seconds