Rman backup restore problem

I have a RMAN backup of 10G Release 1; the backup is full backup mean it includes control file, datafiles and archivelogs. The database name is ORCL and OS is windows XP.
Now I want to restore this backup on new machine, the new machine is also windows XP and the directory structure is 100% same as on old machine.
What I do on new machine; I install the 10G R1 and create database with name of ORCL and copy the rman backup folder on new machine in same directory as it was on old machine. then I connect to RMAN and perform following steps.
Rman>Shutdown immediate;
Rman>restore controfile from E:\MyBkp\uua8asd
Control restored successfully then I mount the database
Rman>alter database mount
And database successfully mounted
By using list backup command I am able to view the backup list then I restore the backup
Rman>restore database; and all datafiles are restored succsefully.
Now the problem is that when I try to recover databases Rman>recover database then I got error that Redo is belong to other database mean the database which was created using DBCA but the control file is used from backup or if I try to open the database Rman>alter database open resetlogs; then I got the error the tablespace system01.dbf is resoted from sufficientry old backup.
The purpose of writing whole story here is that I am unable to open the database. Please tell me where I am wrong??
I spent 2 days and then I am putting the question here. I am learning the oracle database so I am not too much expert please guide me in detail.
----------Here is exact error
RMAN> recover database;

Starting recover at 24-JAN-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/24/2008 23:59:37
ORA-19698: C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG is from different database: id=1172716754, db_name=ORCL

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/24/2008 23:59:55
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF'
asifsomiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sonicefuCommented:
*)  Restart after recovering the controlfile, and instance should know where the restored control files

**) Try the following steps

0)
RMAN> restore controlfile from 'sourcePath';
or
RMAN> restore controlfile to 'destinationPath' from 'sourcePath';

1)
shutdown immediate;

2)
rman target /

3)
startup mount;

4)
restore database;

5)
recover database;
0
sonicefuCommented:
If the concern is to make new server, copy of another server, then follow the steps
source server = A
destination server = B

1) install orcle software at server B at 'C:\ORACLE', shutdown instance

2) shutdown database at A

3) copy oracle folder 'C:\ORACLE'

4) paste it to B, at C:\

5) start databases at server A and B or restart servers/machines A and B
0
asifsomiAuthor Commented:
Hi Sonicefu. here is complete sequence which i did by reading your first reply.
------------Start----------------
C:\Documents and Settings\asif.nadeem.WARIDTEL>rman target sys/oracle

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1172703461)

RMAN> shutdown immediate;

using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area     171966464 bytes

Fixed Size                      787988 bytes
Variable Size                145488364 bytes
Database Buffers              25165824 bytes
Redo Buffers                    524288 bytes

RMAN> restore controlfile from 'E:\MyMachineORABackups\7DJ6T0U9';

Starting restore at 25-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK

channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL01.CTL
output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL02.CTL
output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL03.CTL
Finished restore at 25-JAN-08

RMAN> shutdown immediate;

Oracle instance shut down

RMAN> exit


Recovery Manager complete.

C:\Documents and Settings\asif.nadeem.WARIDTEL>rman target sys/oracle

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup mount;

Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 01/25/2008 09:18:28
ORA-01991: invalid password file 'C:\oracle\product\10.1.0\db_1\DATABASE\PWDorcl.ORA'

RMAN> restore database;

Starting restore at 25-JAN-08
Starting implicit crosscheck backup at 25-JAN-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 25-JAN-08

Starting implicit crosscheck copy at 25-JAN-08
using channel ORA_DISK_1
Finished implicit crosscheck copy at 25-JAN-08

searching for all files in the recovery area
cataloging files...
cataloging done

no files cataloged

using channel ORA_DISK_1

skipping datafile 5; already restored to file E:\ORALCETABLESPACES\CRMANDOTHERS.DBF
skipping datafile 9; already restored to file E:\ORALCETABLESPACES\PORTAL.DBF
skipping datafile 10; already restored to file C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DATAFILE2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=E:\MYMACHINEORABACKUPS\7CJ6T0R0 tag=FULL22JAN08
channel ORA_DISK_1: restore complete
Finished restore at 25-JAN-08

RMAN> recover database;

Starting recover at 25-JAN-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/25/2008 09:20:13
ORA-19698: C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG is from different database: id=1172703461, db_name=ORCL

RMAN>
--------End------------

i can't implement your second solution bcuase i lost first machine and i have only backup of my first machine and i want to build new machine.
please hlep
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

sonicefuCommented:
<<RMAN> startup mount;>>
<<ORA-01991: invalid password file 'C:\oracle\product\10.1.0\db_1\DATABASE\PWDorcl.ORA'>>

* Have you movee the password file and the SPFILE from the old instance
     just for information http://www.cryer.co.uk/brian/oracle/ORA01991.htm

**  See the accepted solution in the followin link, it addresses all the issues you are facing
http://www.experts-exchange.com/Database/Oracle/Q_21460299.html?sfQueryTermInfo=1+ora-01991
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sonicefuCommented:
0)
RMAN> restore controlfile from 'sourcePath';
or
RMAN> restore controlfile to 'destinationPath' from 'sourcePath';

1)
shutdown immediate;

2)
rman target /

3) SET DBID 1172703461                                   --<------

4)
startup mount;

5)
restore database;

6)
recover database;
0
sonicefuCommented:
sorry i missed '=' in above comment, actual statement is as follows

3)    SET DBID = 1172703461
0
sonicefuCommented:
i hope you have replaced redolog files
0
asifsomiAuthor Commented:
i dont have redo logs in my rman backup
0
sonicefuCommented:
Have you executed the following steps?

0)
RMAN> restore controlfile from 'sourcePath';
or
RMAN> restore controlfile to 'destinationPath' from 'sourcePath';

1)
shutdown immediate;

2)
rman target /

3) SET DBID = 1172703461                                    --<------

4)
startup mount;

5)
restore database;

6)
recover database;
0
asifsomiAuthor Commented:
let me try it
0
asifsomiAuthor Commented:
after creating the new password file i run the commands according to your sequece and i got error at mount stage.
here is whole rman windows log
C:\Documents and Settings\asif.nadeem.WARIDTEL>rman target sys/a

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1164248715)

RMAN>

RMAN> shutdown immediate;

using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     171966464 bytes

Fixed Size                      787988 bytes
Variable Size                145488364 bytes
Database Buffers              25165824 bytes
Redo Buffers                    524288 bytes

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> exit


Recovery Manager complete.

C:\Documents and Settings\asif.nadeem.WARIDTEL>rman target sys/a

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1172711758)

RMAN> startup force nomount;

Oracle instance started

Total System Global Area     171966464 bytes

Fixed Size                      787988 bytes
Variable Size                145488364 bytes
Database Buffers              25165824 bytes
Redo Buffers                    524288 bytes

RMAN> restore controlfile from 'E:\MyMachineORABackups\7DJ6T0U9';

Starting restore at 25-JAN-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK

channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL01.CTL
output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL02.CTL
output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL03.CTL
Finished restore at 25-JAN-08

RMAN> shutdown immediate;

Oracle instance shut down

RMAN> set dbid=1172711758

executing command: SET DBID

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 01/25/2008 11:36:53
ORA-01991: invalid password file 'C:\oracle\product\10.1.0\db_1\DATABASE\PWDorcl.ORA'

RMAN> restore database;

Starting restore at 25-JAN-08
Starting implicit crosscheck backup at 25-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2008 11:37:07
RMAN-06189: current DBID 1172711758 does not match target mounted database (1164248715)

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     171966464 bytes

Fixed Size                      787988 bytes
Variable Size                145488364 bytes
Database Buffers              25165824 bytes
Redo Buffers                    524288 bytes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 01/25/2008 11:39:21
RMAN-06189: current DBID 1172711758 does not match target mounted database (1164248715)

RMAN>
0
asifsomiAuthor Commented:
orapwd file=C:\oracle\product\10.1.0\db_1\DATABASE\PWDorcl.ORA password=oracle
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.