Home » RDBMS Server » Backup & Recovery » error while copying database to new server. (Oracle 10g R2 (10.2.0.1.0))
error while copying database to new server. [message #492416] Mon, 31 January 2011 01:25 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

I am restoring Oracle rman backup from nodeA to nodeB through RMAN and I was in the middle of the process of rename the redo log files to new location where I suddenly got the below mentioned error:

RMAN> SQL "alter database rename file 'E:\oracle\product\10.2.0\oradata\dbadeepak\REDO01.LOG' to 'E:\test_rman\testrman\REDO01.LOG'";

sql statement: alter database rename file 'E:\oracle\product\10.2.0\oradata\dbadeepak\REDO01.LOG' to 'E:\test_rman\testrman\REDO01.LOG'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 01/31/2011 12:53:04
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 103 on line 4 column 36: Encountered the symbol "E" when expecting one of the following:

   ) , * & = - + < / > at in is mod remainder not rem
   <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
   LIKE4_ LIKEC_ between || multiset member SUBMULTISET_


If anyone can help me out I'll be really thankful.

Regards
Deepak
Re: error while copying database to new server. [message #492422 is a reply to message #492416] Mon, 31 January 2011 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try replacing all \ by /

Regards
Michel
Re: error while copying database to new server. [message #492431 is a reply to message #492422] Mon, 31 January 2011 03:40 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

I'll try this wayout as well, but for the time being I have done the changes from the SQL Prompt and it worked well.

Thanks
Deepak
Re: error while copying database to new server. [message #492432 is a reply to message #492422] Mon, 31 January 2011 03:47 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Now I have stuck to the last point of the Recovery Sir,

Alter making the changes to the location of the file I issue catalog command for the each backup piece.

Thse are the step which I followed before renaming the redolog files..
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> catalog backuppiece 'E:\test_rman\2011_01_31\O1_MF_NNNDF_TAG20110131T105709_6NDL1VG6_.BKP';

Starting implicit crosscheck backup at 31-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 31-JAN-11

Starting implicit crosscheck copy at 31-JAN-11
using channel ORA_DISK_1
Crosschecked 8 objects
Finished implicit crosscheck copy at 31-JAN-11

searching for all files in the recovery area
cataloging files...
no files cataloged

cataloged backuppiece
backup piece handle=E:\TEST_RMAN\2011_01_31\O1_MF_NNNDF_TAG20110131T105709_6NDL1VG6_.BKP recid=86 stamp=741875609


RMAN> catalog backuppiece 'E:\test_rman\2011_01_31\O1_MF_ANNNN_TAG20110131T105520_6NDKY53S_.BKP';

cataloged backuppiece
backup piece handle=E:\TEST_RMAN\2011_01_31\O1_MF_ANNNN_TAG20110131T105520_6NDKY53S_.BKP recid=87 stamp=741876015

RMAN> catalog backuppiece 'E:\test_rman\2011_01_31\O1_MF_ANNNN_TAG20110131T105930_6NDL5WP1_.BKP'
2> ;

cataloged backuppiece
backup piece handle=E:\TEST_RMAN\2011_01_31\O1_MF_ANNNN_TAG20110131T105930_6NDL5WP1_.BKP recid=88 stamp=741876060


RMAN> list backup of archivelog all;


List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
81      865.15M    DISK        00:01:28     31-JAN-11
        BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20110131T105520
        Piece Name: E:\TEST_RMAN\2011_01_31\O1_MF_ANNNN_TAG20110131T105520_6NDKY53S_.BKP

  List of Archived Logs in backup set 81
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    79      1365568    19-JAN-11 1386283    19-JAN-11
  1    80      1386283    19-JAN-11 1414516    20-JAN-11
  1    81      1414516    20-JAN-11 1419895    20-JAN-11
  1    82      1419895    20-JAN-11 1419909    20-JAN-11
  1    83      1419909    20-JAN-11 1459046    20-JAN-11
  1    84      1459046    20-JAN-11 1478648    21-JAN-11
  1    85      1478648    21-JAN-11 1524731    21-JAN-11
  1    86      1524731    21-JAN-11 1551766    21-JAN-11
  1    87      1551766    21-JAN-11 1581611    22-JAN-11
  1    88      1581611    22-JAN-11 1617940    22-JAN-11
  1    89      1617940    22-JAN-11 1658401    23-JAN-11
  1    90      1658401    23-JAN-11 1702859    23-JAN-11
  1    91      1702859    23-JAN-11 1745741    24-JAN-11
  1    92      1745741    24-JAN-11 1789479    24-JAN-11
  1    93      1789479    24-JAN-11 1815183    25-JAN-11
  1    94      1815183    25-JAN-11 1853718    25-JAN-11
  1    95      1853718    25-JAN-11 1889000    25-JAN-11
  1    96      1889000    25-JAN-11 1918175    26-JAN-11
  1    97      1918175    26-JAN-11 1961084    26-JAN-11
  1    98      1961084    26-JAN-11 1986332    27-JAN-11
  1    99      1986332    27-JAN-11 2026385    27-JAN-11
  1    100     2026385    27-JAN-11 2060670    31-JAN-11
  1    101     2060670    31-JAN-11 2068125    31-JAN-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
83      108.50K    DISK        00:00:00     31-JAN-11
        BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20110131T105930
        Piece Name: E:\TEST_RMAN\2011_01_31\O1_MF_ANNNN_TAG20110131T105930_6NDL5WP1_.BKP

  List of Archived Logs in backup set 83
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    102     2068125    31-JAN-11 2068308    31-JAN-11


RMAN> run
2> {
3> set until sequence 102;
4> set newname for datafile 1 to 'E:\test_rman\testrman\SYSTEM01.DBF';
5> set newname for datafile 2 to 'E:\test_rman\testrman\UNDOTBS01.DBF';
6> set newname for datafile 3 to 'E:\test_rman\testrman\SYSAUX01.DBF';
7> set newname for datafile 4 to 'E:\test_rman\testrman\USERS01.DBF';
8> restore database; switch datafile all; recover database; alter database open resetlogs;
9> }

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 31-JAN-11
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/31/2011 13:24:31
RMAN-06026: some targets not found - aborting 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


Why this happend Sir. Help me out.

Regards
Deepak
Re: error while copying database to new server. [message #492475 is a reply to message #492432] Mon, 31 January 2011 06:43 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

have you registeed all backuppiece in recovery catalog? looks like datafile not available from your backuppiece

- Babu
Re: error while copying database to new server. [message #492477 is a reply to message #492475] Mon, 31 January 2011 06:59 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

Thanks for all your help, Issue has been resolved. I forgot to delete the previouse datafiles,redolog files and the control files. Now I have followed the procedure once again with proper step and I have successfully restored the RMAN backup to a new server.

This what I did was for the Full Backup, If anyone can tell me whats the procedure is goin to be for the Incremental backup.
Regards
Deepak
Re: error while copying database to new server. [message #492479 is a reply to message #492477] Mon, 31 January 2011 07:22 Go to previous message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

Thanks for the feedback.

You have been opened this thread two different topic. Please open new thread to discuss about incremental bakcup/restore

- Babu
Previous Topic: restore/recover level 1 backup on new server
Next Topic: RAC Database duplication using RMAN
Goto Forum:
  


Current Time: Wed Apr 16 21:17:17 CDT 2014

Total time taken to generate the page: 0.10745 seconds