not allowing to backup my spfile

what might be the reason for this boss?

please help me asap?

Was the database started with a different SP File from the one that u are trying to back up now???
If that is the case, then shutdown the database instance and startup the DB instance with the appropriate SP file..

Good luck!

I TRIED BUT THE SAME ERROR...
I DON'T KNOW WHY?

This is what the error translates to..

Oracle Error :: RMAN-06062
can not backup SPFILE because the instance was not started with SPFILE
Cause
A backup command requested a backup of the SPFILE, but no SPFILE was used to startup the instance.
Action
Create an SPFILE and re-start the instance using the SPFILE or modify the command

Can u post the exact command that was used to start ur oracle DB?

In sqlplus run this command:

sqlplus> show parameter pfile

Out put of this command will look something like this:
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA

This means that Database was starting using spfile.

If spfile does not exist then you can create one as SYS user.

sqlplus> create spfile from pfile='C:\xxx\pfile\init.ora'

Hope this helps

You need to start the database from an spfile in order to back up an spfile with RMAN.  It looks like you started your database with the older style init*.ora file.

First check if you have an spfile.  Look in your Oracle_home\database directory for a file like: spfile....ora.  If you have one, then use SQL*Plus to shutdown your database, then do "startup".  That should start it from the spfile.

If you don't have an spfile, you can create one like mohammadzahid suggested.

THIS WAS WHAT I DID..
STILL I CAN'T BACKUP?


SQL> conn / as sysdba
Connected.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      C:\ORACLE\PRODUCT\10.2.0\DB_1\
                                                 DATABASE\SPFILEINDIA.ORA
SQL> SELECT NAME FROM V$DATABASE;

NAME
---------
INDIA

SQL> SELECT LOG_MODE FROM V$DATABASE;

LOG_MODE
------------
ARCHIVELOG


SQL> EXIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

C:\Documents and Settings\Administrator>rman target="system/india@india" catalog
="rman/rman@rman"

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Nov 18 14:26:34 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: INDIA (DBID=2782793055)
connected to recovery catalog database

RMAN> REGISTER DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 11/18/2006 14:26:5
5
RMAN-20002: target database already registered in recovery catalog

RMAN> BACKUP SPFILE;

Starting backup at 18-NOV-06
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/18/2006 14:27:10
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20020: database in
carnation not set

PLEASE HELP ME??

I'm not an expert with RMAN, I just use this command:
backup database;
and I let RMAN then figure out what to back up.  I think that it gets the spfile along with the tablespaces, but the spfile is easy to back up with either a simple file copy, or a normal O/S backup, so I don't worry about trying to use RMAN to back it up by itself.

any body who can help with RMAN  will be appreciated...

As markgeer stated in his last post that it is easy to take backup using OS commands.

Why are you using catalog to take backup of a spfile? Is spfile on your machine or on target host?
What are you trying to accomplish?

RMAN WELCOMED

What do you think the advantage is of using RMAN to back up the spfile by itself?  It is very easy to simply copy or backup with standard O/S commands.

PLEASE SUGGEST ME THAT STEP
1)COMMAND LINE

2)USING DBCONSOLE

THANKS MAN...........MY DOUBT WAS CLEARED...

No problem. Enjoy Oracle. :-)