Home » RDBMS Server » Backup & Recovery » Disaster Recovery (Oracle 9.0.2.0.0 Windows Server 2003)
Disaster Recovery [message #286090] Thu, 06 December 2007 07:46 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,
I m testing disaster recvover plan by using the following link
http://www.orafusion.com/art_rman3.htm

it was an excellent document but it is required to have SERVER with same no. of drives and directory structure
but what if we have a server with different no. of drives and directory structure
e.g. we have all datafiles,controlfiles and Redolog files at d:\oracle\oradata previously but now i want to restore datafiles at e:\oracle\oradata in New Server
According to the document we should have d:\oracle\oradata to make disaster recovery possible

i managed to restore control file at different location by adding the following steps
1-SQL>create pfile from spfile;
modiby pfile created by the above command
control_files should be modified
2-SQL>startup force nomount pfile='D:\oracle\ora92\database\initTEST.ora';
3-SQL>create spfile from pfile;
4-SQL>startup force nomount;
5-RMAN>restore controlfile from 'd:\oracle\...'
6-RMAN>alter database mount;

But when i try to restore datafiles at different location by using the following
RMAN>run {
set newname for datafile 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' to 'D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\CWMLITE01.DBF' to 'D:\ORACLE\ORADATA\TEST1\CWMLITE01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\DRSYS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\DRSYS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\EXAMPLE01.DBF' to 'D:\ORACLE\ORADATA\TEST1\EXAMPLE01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\INDX01.DBF' to 'D:\ORACLE\ORADATA\TEST1\INDX01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\ODM01.DBF' to 'D:\ORACLE\ORADATA\TEST\ODM01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\TOOLS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\TOOLS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\USERS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\USERS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\XDB01.DBF' to 'D:\ORACLE\ORADATA\TEST1\XDB01.DBF';
restore database;
switch datafile all;
}
or
run {
set newname for datafile 1 to 'D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF';
set newname for datafile 2 to 'D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF';
set newname for datafile 3 to 'D:\ORACLE\ORADATA\TEST1\CWMLITE01.DBF';
set newname for datafile 4 to 'D:\ORACLE\ORADATA\TEST1\DRSYS01.DBF';
set newname for datafile 5 to 'D:\ORACLE\ORADATA\TEST1\EXAMPLE01.DBF';
set newname for datafile 6 to 'D:\ORACLE\ORADATA\TEST1\INDX01.DBF';
set newname for datafile 7 to 'D:\ORACLE\ORADATA\TEST\ODM01.DBF';
set newname for datafile 8 to 'D:\ORACLE\ORADATA\TEST1\TOOLS01.DBF';
set newname for datafile 9 to 'D:\ORACLE\ORADATA\TEST1\USERS01.DBF';
set newname for datafile 10 to 'D:\ORACLE\ORADATA\TEST1\XDB01.DBF';
restore database;
switch datafile all;
}
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

Starting restore at 06-DEC-07

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/06/2007 18:26:15
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Please suggest !
I'll thankful to you

Re: Disaster Recovery [message #286139 is a reply to message #286090] Thu, 06 December 2007 10:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
But when i try to restore datafiles at different location by using the following
RMAN>run {
set newname for datafile 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' to 'D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\CWMLITE01.DBF' to 'D:\ORACLE\ORADATA\TEST1\CWMLITE01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\DRSYS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\DRSYS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\EXAMPLE01.DBF' to 'D:\ORACLE\ORADATA\TEST1\EXAMPLE01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\INDX01.DBF' to 'D:\ORACLE\ORADATA\TEST1\INDX01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\ODM01.DBF' to 'D:\ORACLE\ORADATA\TEST\ODM01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\TOOLS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\TOOLS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\USERS01.DBF' to 'D:\ORACLE\ORADATA\TEST1\USERS01.DBF';
set newname for datafile 'D:\ORACLE\ORADATA\TEST\XDB01.DBF' to 'D:\ORACLE\ORADATA\TEST1\XDB01.DBF';



You mentioned the same path??

Re: Disaster Recovery [message #286241 is a reply to message #286139] Fri, 07 December 2007 00:22 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear Brother,

the path is different
set newname for datafile 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' to 'D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF';
Re: Disaster Recovery [message #286486 is a reply to message #286241] Fri, 07 December 2007 10:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Try to use tag in your restore database command.
Re: Disaster Recovery [message #286539 is a reply to message #286486] Fri, 07 December 2007 23:47 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i think we use tags when v r taking RMAN backups
can u please tell me how to use tags during restore and recovery?

please suggest!
Re: Disaster Recovery [message #286540 is a reply to message #286539] Fri, 07 December 2007 23:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

YOu can also use tag for restore purpose.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10735/bkup.htm#1028491
Re: Disaster Recovery [message #286543 is a reply to message #286090] Sat, 08 December 2007 01:01 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear Muhammad Taj,

I didn't find any Restore command with tags in the link u provided but please look at my problem which i am facing during restore to different location

run {
set newname for datafile 1 to 'D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF';
set newname for datafile 2 to 'D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF';
set newname for datafile 3 to 'D:\ORACLE\ORADATA\TEST1\CWMLITE01.DBF';
set newname for datafile 4 to 'D:\ORACLE\ORADATA\TEST1\DRSYS01.DBF';
set newname for datafile 5 to 'D:\ORACLE\ORADATA\TEST1\EXAMPLE01.DBF';
set newname for datafile 6 to 'D:\ORACLE\ORADATA\TEST1\INDX01.DBF';
set newname for datafile 7 to 'D:\ORACLE\ORADATA\TEST\ODM01.DBF';
set newname for datafile 8 to 'D:\ORACLE\ORADATA\TEST1\TOOLS01.DBF';
set newname for datafile 9 to 'D:\ORACLE\ORADATA\TEST1\USERS01.DBF';
set newname for datafile 10 to 'D:\ORACLE\ORADATA\TEST1\XDB01.DBF';
restore database;
switch datafile all;
}
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

Starting restore at 06-DEC-07

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/06/2007 18:26:15
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore


Please suggest!

ALLAH HAFIZ
Re: Disaster Recovery [message #286545 is a reply to message #286543] Sat, 08 December 2007 01:10 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

RESTORE DATABASE FROM TAG 'node name'
RECOVER DATABASE FROM TAG 'node name' ARCHIVELOG TAG 'node name'


http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14239/rman.htm

Babu
Re: Disaster Recovery [message #286608 is a reply to message #286090] Sat, 08 December 2007 22:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

M.Shakeel Azeem, I think I can help you.

Did you set the proper DBID?
Re: Disaster Recovery [message #286709 is a reply to message #286608] Sun, 09 December 2007 23:39 Go to previous message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear Arju

I m sure i set DBID properly and i am able to reecover my DB without set new name command in RMAN Recovery script but now i want to restore datafiles at different location other than default

Regards,
M.Shakeel Azeem
Previous Topic: Problem with Recovery
Next Topic: Problem with RMAN configuration, I need help!
Goto Forum:
  


Current Time: Thu Dec 08 01:59:33 CST 2016

Total time taken to generate the page: 0.15982 seconds