Home » Server Options » RAC & Failsafe » How to convert RAC database to single Instance Database?
How to convert RAC database to single Instance Database? [message #240867] Sat, 26 May 2007 16:09 Go to next message
wangxiaoyun@huayi2000.com
Messages: 2
Registered: May 2007
Junior Member
I want restore RAC database to single Instance Database environment.but wrong,who can help me ? Tanks.

oracle:ZHYZ_CS@/oracle/app/oracle10g/dbs>#rman cmdfile /nsr/script/recovedb

Recovery Manager: Release 10.2.0.2.0 - Production on Fri May 25 20:43:25 2007

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

RMAN> connect rcvcat *
2> set DBID=1853913856
3> connect target *
4> run
5> {
6> allocate channel t1 type 'sbt_tape';
7> allocate channel t2 type 'sbt_tape';
8> send 'NSR_ENV=(NSR_SERVER=zhyz-backup,NSR_CLIENT=ZHYZ_DB1,NSR_DATA_VOLUME_POOL=D
9> efault)';
10> set until time "to_date('2007-05-25 11:30:00','YYYY-MM-DD HH24:MI:SS')";
11> set newname for datafile 1 to '/oracle/oradata/zhyz1/1.dbf';
12> set newname for datafile 2 to '/oracle/oradata/zhyz1/2.dbf';
13> set newname for datafile 3 to '/oracle/oradata/zhyz1/3.dbf';
14> set newname for datafile 4 to '/oracle/oradata/zhyz1/4.dbf';
15> set newname for datafile 5 to '/oracle/oradata/zhyz1/5.dbf';
16> set newname for datafile 6 to '/oracle/oradata/zhyz1/6.dbf';
17> set newname for datafile 7 to '/oracle/oradata/zhyz1/7.dbf';
18> set newname for datafile 8 to '/oracle/oradata/zhyz1/8.dbf';
19> restore database;
20> recover database;
21> sql 'alter database open resetlogs';
22> release channel t1;
23> release channel t2;
24> }
25>
26>
connected to recovery catalog database

executing command: SET DBID
database name is "ZHYZ" and DBID is 1853913856

connected to target database: ZHYZ (DBID=1853913856, not open)

allocated channel: t1
channel t1: sid=485 devtype=SBT_TAPE
channel t1: NMO v4.2.0.0

allocated channel: t2
channel t2: sid=488 devtype=SBT_TAPE
channel t2: NMO v4.2.0.0

sent command to channel: t1
sent command to channel: t2

executing command: SET until clause

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

Starting restore at 25-MAY-07

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/zhyz1/1.dbf
restoring datafile 00003 to /oracle/oradata/zhyz1/3.dbf
restoring datafile 00006 to /oracle/oradata/zhyz1/6.dbf
restoring datafile 00008 to /oracle/oradata/zhyz1/8.dbf
channel t1: reading from backup piece oracle_zhyz_full_1_0hiijlic_17_623498828
channel t1: restored backup piece 1
piece handle=oracle_zhyz_full_1_0hiijlic_17_623498828 tag=TAG20070525T100704
channel t1: restore complete, elapsed time: 00:05:15
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /oracle/oradata/zhyz1/2.dbf
restoring datafile 00004 to /oracle/oradata/zhyz1/4.dbf
restoring datafile 00005 to /oracle/oradata/zhyz1/5.dbf
restoring datafile 00007 to /oracle/oradata/zhyz1/7.dbf
channel t1: reading from backup piece oracle_zhyz_full_1_0giijli9_16_623498825
channel t1: restored backup piece 1
piece handle=oracle_zhyz_full_1_0giijli9_16_623498825 tag=TAG20070525T100704
channel t1: restore complete, elapsed time: 00:06:45
Finished restore at 25-MAY-07

Starting recover at 25-MAY-07
added temporary file /dev/rrac_temp01 to tablespace TEMP in control file

starting media recovery

archive log thread 1 sequence 3151 is already on disk as file /oracle/app/oracle10g/dbs/arch1_3151_609052928.dbf
archive log thread 1 sequence 3152 is already on disk as file /oracle/app/oracle10g/dbs/arch1_3152_609052928.dbf
archive log thread 2 sequence 1474 is already on disk as file /oracle/app/oracle10g/dbs/arch2_1474_609052928.dbf
archive log thread 2 sequence 1475 is already on disk as file /oracle/app/oracle10g/dbs/arch2_1475_609052928.dbf
archive log filename=/oracle/app/oracle10g/dbs/arch2_1474_609052928.dbf thread=2 sequence=1474
archive log filename=/oracle/app/oracle10g/dbs/arch1_3151_609052928.dbf thread=1 sequence=0
archive log filename=/oracle/app/oracle10g/dbs/arch1_3152_609052928.dbf thread=1 sequence=3152
archive log filename=/oracle/app/oracle10g/dbs/arch2_1475_609052928.dbf thread=2 sequence=1475
media recovery complete, elapsed time: 00:01:15
Finished recover at 25-MAY-07

sql statement: alter database open resetlogs
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 05/25/2007 20:57:15
RMAN-11003: failure during parse/execution of SQL statement: alter database open resetlogs
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Recovery Manager complete.
oracle:ZHYZ_CS@/oracle/app/oracle10g/dbs>#
Re: How to convert RAC database to single Instance Database? [message #240868 is a reply to message #240867] Sat, 26 May 2007 16:34 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
CHECK THIS DOCUMENT FOR backup and recovery on RAC.

y not using easy simple recommened TEMPLATE method.

[Updated on: Sat, 26 May 2007 16:35]

Report message to a moderator

Re: How to convert RAC database to single Instance Database? [message #240869 is a reply to message #240868] Sat, 26 May 2007 17:03 Go to previous messageGo to next message
wangxiaoyun@huayi2000.com
Messages: 2
Registered: May 2007
Junior Member
Thanks,but i do not find a way to resolve my question form the document.
Re: How to convert RAC database to single Instance Database? [message #240870 is a reply to message #240869] Sat, 26 May 2007 17:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Y U NOT MAKING TEMPLATE OF YOUR EXISTING DATABASE AND THEN IMPORT THAT TEMPALTE TO RAC DATABASE??
Re: How to convert RAC database to single Instance Database? [message #440273 is a reply to message #240867] Thu, 21 January 2010 23:36 Go to previous messageGo to next message
entekeralam
Messages: 19
Registered: January 2010
Junior Member
check this..

dbaregistry.blogspot.com/2010/01/howto-restore-rac-database-to-single.html
Re: How to convert RAC database to single Instance Database? [message #440390 is a reply to message #440273] Sat, 23 January 2010 07:16 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
RMAN-11003: failure during parse/execution of SQL statement: alter database open resetlogs
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled


Check cluster_database parameter & do you have sufficient redo log files ?

- Babu
Previous Topic: RAC some queries
Next Topic: Separate table and index data in RAC
Goto Forum:
  


Current Time: Thu Mar 28 17:29:58 CDT 2024