Home » RDBMS Server » Backup & Recovery » Error Restore New Host
Error Restore New Host [message #336267] Fri, 25 July 2008 08:24 Go to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

I am try restore my database to new host. Im my new host, I created new database with name "oradds", same name from old host. I setting up the same sid from old host. And I restore spfile, controlfile, and start up my database. After this, I execute:

RMAN> run{
2> set newname for datafile 1 to '/dados/u01/oradata/oradds/system01.dbf';
3> set newname for datafile 2 to '/dados/u01/oradata/oradds/undotbs01.dbf';
4> set newname for datafile 3 to '/dados/u01/oradata/oradds/sysaux01.dbf';
5> set newname for datafile 4 to '/dados/u01/oradata/oradds/users01.dbf';
6> set newname for datafile 5 to '/dados/u01/oradata/oradds/sentineladata';
7> set newname for datafile 6 to '/dados/u01/oradata/oradds/sentinelaindx';
8> set newname for datafile 7 to '/dados/u01/oradata/oradds/afi_ts';
9> set newname for datafile 8 to '/dados/u01/oradata/oradds/afi_ts_idx';
10> set newname for datafile 9 to '/dados/u01/oradata/oradds/GAFDATA';
11> set newname for datafile 10 to '/dados/u01/oradata/oradds/get_ts';
12> set newname for datafile 11 to '/dados/u01/oradata/oradds/gcc_ts';
13> set newname for datafile 12 to '/dados/u01/oradata/oradds/icap_ts';
14> set newname for datafile 13 to '/dados/u01/oradata/oradds/spo_ts';
15> set newname for datafile 14 to '/dados/u01/oradata/oradds/srt_ts';
16> set newname for datafile 15 to '/dados/u01/oradata/oradds/sca_ts';
17> set newname for datafile 16 to '/dados/u01/oradata/oradds/PRODIP_TS';
18> set newname for datafile 17 to '/dados/u01/oradata/oradds/GAFINDX';
19> set newname for datafile 18 to '/dados/u01/oradata/oradds/obras_ts';
20> set newname for datafile 19 to '/dados/u01/oradata/oradds/rman_ts';
21> set newname for datafile 20 to '/dados/u01/oradata/oradds/SIGRHAM_DATA';
22> set newname for datafile 21 to '/dados/u01/oradata/oradds/SIGRHAM_CTX';
23> set newname for datafile 22 to '/dados/u01/oradata/oradds/sigrham_index';
24> set until scn 10594914;
25> restore database;
26> switch datafile all;
27> recover database;
28> }
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET until clause

Starting restore at 25-JUL-08
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /dados/u01/oradata/oradds/system01.dbf
restoring datafile 00002 to /dados/u01/oradata/oradds/undotbs01.dbf
restoring datafile 00003 to /dados/u01/oradata/oradds/sysaux01.dbf
restoring datafile 00004 to /dados/u01/oradata/oradds/users01.dbf
restoring datafile 00005 to /dados/u01/oradata/oradds/sentineladata
restoring datafile 00006 to /dados/u01/oradata/oradds/sentinelaindx
restoring datafile 00007 to /dados/u01/oradata/oradds/afi_ts
restoring datafile 00008 to /dados/u01/oradata/oradds/afi_ts_idx
restoring datafile 00009 to /dados/u01/oradata/oradds/GAFDATA
restoring datafile 00010 to /dados/u01/oradata/oradds/get_ts
restoring datafile 00011 to /dados/u01/oradata/oradds/gcc_ts
restoring datafile 00012 to /dados/u01/oradata/oradds/icap_ts
restoring datafile 00013 to /dados/u01/oradata/oradds/spo_ts
restoring datafile 00014 to /dados/u01/oradata/oradds/srt_ts
restoring datafile 00015 to /dados/u01/oradata/oradds/sca_ts
restoring datafile 00016 to /dados/u01/oradata/oradds/PRODIP_TS
restoring datafile 00017 to /dados/u01/oradata/oradds/GAFINDX
restoring datafile 00018 to /dados/u01/oradata/oradds/obras_ts
restoring datafile 00019 to /dados/u01/oradata/oradds/rman_ts
restoring datafile 00020 to /dados/u01/oradata/oradds/SIGRHAM_DATA
restoring datafile 00021 to /dados/u01/oradata/oradds/SIGRHAM_CTX
restoring datafile 00022 to /dados/u01/oradata/oradds/sigrham_index
channel ORA_DISK_1: reading from backup piece /dados/u01/app/oracle/flash_recovery_area/ORADDS/backupset/2008_07_25/o1_mf_nnndf_TAG20080722T060030_48ccxzf9_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/dados/u01/app/oracle/flash_recovery_area/ORADDS/backupset/2008_07_25/o1_mf_nnndf_TAG20080722T060030_48ccxzf9_.bkp tag=TAG20080722T060030
channel ORA_DISK_1: restore complete, elapsed time: 00:00:56
Finished restore at 25-JUL-08


Starting recover at 25-JUL-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/25/2008 09:18:30
ORA-19698: /dados/u01/oradata/oradds/redo01.log is from different database: id=2008663855, db_name=ORADDS


Can anybody help me?


Marcos Santos

Re: Error Restore New Host [message #336270 is a reply to message #336267] Fri, 25 July 2008 08:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you verify that the case name of the database is the same? How did you do the backup/restore?
Re: Error Restore New Host [message #336274 is a reply to message #336267] Fri, 25 July 2008 08:37 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
I user this steps:

-bash-3.00$ rman target /

RMAN> set dbid 00000olddbid

RMAN> startup nomount

RMAN> restore spfile to pfile '/oracle/app/oracle/product/10.2.0/db_1/dbs/initoradds.ora' from '/oradata2/o1_mf_s_654016132_421c64vl_.bkp';

RMAN> STARTUP FORCE NOMOUNT PFILE='/oracle/app/oracle/product/10.2.0/db_1/dbs/initoradds.ora';

RMAN> RESTORE CONTROLFILE FROM '/oradata2/o1_mf_s_654016132_421c64vl_.bkp';

RMAN> ALTER DATABASE MOUNT;

RMAN> catalog backuppiece '/oradata2/o1_mf_nnndf_TAG20080506T150716_421c355f_.bkp';

RMAN> run{
2> set newname for datafile 1 to '/dados/u01/oradata/oradds/system01.dbf';
3> set newname for datafile 2 to '/dados/u01/oradata/oradds/undotbs01.dbf';
4> set newname for datafile 3 to '/dados/u01/oradata/oradds/sysaux01.dbf';
5> set newname for datafile 4 to '/dados/u01/oradata/oradds/users01.dbf';
6> set newname for datafile 5 to '/dados/u01/oradata/oradds/sentineladata';
7> set newname for datafile 6 to '/dados/u01/oradata/oradds/sentinelaindx';
8> set newname for datafile 7 to '/dados/u01/oradata/oradds/afi_ts';
9> set newname for datafile 8 to '/dados/u01/oradata/oradds/afi_ts_idx';
10> set newname for datafile 9 to '/dados/u01/oradata/oradds/GAFDATA';
11> set newname for datafile 10 to '/dados/u01/oradata/oradds/get_ts';
12> set newname for datafile 11 to '/dados/u01/oradata/oradds/gcc_ts';
13> set newname for datafile 12 to '/dados/u01/oradata/oradds/icap_ts';
14> set newname for datafile 13 to '/dados/u01/oradata/oradds/spo_ts';
15> set newname for datafile 14 to '/dados/u01/oradata/oradds/srt_ts';
16> set newname for datafile 15 to '/dados/u01/oradata/oradds/sca_ts';
17> set newname for datafile 16 to '/dados/u01/oradata/oradds/PRODIP_TS';
18> set newname for datafile 17 to '/dados/u01/oradata/oradds/GAFINDX';
19> set newname for datafile 18 to '/dados/u01/oradata/oradds/obras_ts';
20> set newname for datafile 19 to '/dados/u01/oradata/oradds/rman_ts';
21> set newname for datafile 20 to '/dados/u01/oradata/oradds/SIGRHAM_DATA';
22> set newname for datafile 21 to '/dados/u01/oradata/oradds/SIGRHAM_CTX';
23> set newname for datafile 22 to '/dados/u01/oradata/oradds/sigrham_index';
24> set until scn 10594914;
25> restore database;
26> switch datafile all;
27> recover database;
28> }


Marcos
Re: Error Restore New Host [message #336278 is a reply to message #336274] Fri, 25 July 2008 08:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Remove any redo logs you may have copied.
Re: Error Restore New Host [message #336293 is a reply to message #336267] Fri, 25 July 2008 09:40 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,
I dont copy redolog. Only I create a database with dbca, so it create relogs. The backup no copy redolog with RMAN. Only datafiles. I cannot startup instance.

Do you want that I remove the redologs?

Why?

Explain me, please!

Marcos Santos

Re: Error Restore New Host [message #336309 is a reply to message #336293] Fri, 25 July 2008 10:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I'm not following what you are describing. What did you copy to the new host? Did you create a database on the new host with dbca?

You should only need the backupsets to do the restore/recovery. That being said, I can't give specifics without knowing specifics (ie. what backup script did you use, how did you set the ORACLE_SID on the new host, what files did you copy to the new host, etc.).
Re: Error Restore New Host [message #336311 is a reply to message #336267] Fri, 25 July 2008 11:01 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

info:

old_host = oradds new_hot=oradds

backup old_host = RMAN>backup database plus archivelog;

autobackup controlfiles = on

I has copied the backupset from old_host to newhost.

I created new database on new host with dbca, same name of old_host: oradds.

And restore/recovery with RMAN.

Marcos
Re: Error Restore New Host [message #336327 is a reply to message #336311] Fri, 25 July 2008 12:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You don't need to create a new database prior to restore/recovering with RMAN.

Follow Restore and Recovery of the Database on a New Host for the complete process.
Re: Error Restore New Host [message #336341 is a reply to message #336267] Fri, 25 July 2008 14:45 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

Really! Not is necessary to create a new database on new_host. Its work. But, after recover I have create a dbconsole?


Marcos
Re: Error Restore New Host [message #336346 is a reply to message #336341] Fri, 25 July 2008 15:02 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
marcossantos wrote on Fri, 25 July 2008 15:45

Really! Not is necessary to create a new database on new_host. Its work. But, after recover I have create a dbconsole?

Well if it works, then why did you post the problem ?? If you got it to work, then please show me !!

Sure you can create "A" database with dbca, but the database you create from dbca is different than your original database.
Re: Error Restore New Host [message #336351 is a reply to message #336267] Fri, 25 July 2008 15:18 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

My database of developing crash during apply patch set 10.2.0.3. So, I had other host in my network. I was trying to restore the backup RMAN from developing in this new host. But, not worked, because I always create a new database after restore. I got error.

RMAN-03002: failure of recover command at 07/25/2008 09:18:30
ORA-19698: /dados/u01/oradata/oradds/redo01.log is from different database: id=2008663855, db_name=ORADDS

I used to create a new database with dbca before to restore with rman in my new host.

When you said that not is necessary I trying and work.

The same steps, but without create a new instance before.

thanks,

Marcos
Re: Error Restore New Host [message #336353 is a reply to message #336351] Fri, 25 July 2008 15:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Sorry, I must have misunderstood your previous post.

Glad it worked out for you.
Re: Error Restore New Host [message #336358 is a reply to message #336267] Fri, 25 July 2008 15:46 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Thanks.
Re: Error Restore New Host [message #336689 is a reply to message #336353] Mon, 28 July 2008 12:58 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
hi,

I have other problem.

My restore and recovery is Ok, I dont create a database before restore with dbca. For this, a dbconsole not is create together. It is necessary create it separately.

$<ORACLE_HOME>bin/emca -config dbcontrol db -repos create

But, I cannot access through entreprise manager. I get error in logon: user/password invalid.

I use:
http://host_server:1158/em

I try drop and create the repository, drop user SYSMAN and recreate, but no work out.


Any reference at other host exist in dbconsole.

Through sql*plus I connect with User SYS and Pass but over enterpeise manager I cannot, with same user.


Marcos

[Updated on: Mon, 28 July 2008 13:01]

Report message to a moderator

Re: Error Restore New Host [message #336691 is a reply to message #336267] Mon, 28 July 2008 13:05 Go to previous message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/336664/74940/#msg_336664

Do NOT cross/multi-post
Previous Topic: sql query
Next Topic: difference between cloning database and standby database
Goto Forum:
  


Current Time: Sat Dec 03 16:03:00 CST 2016

Total time taken to generate the page: 0.13201 seconds