Message
Goal: To restore the database
from RMAN backup on a different server by means of moving the backup pieces and
logs over to the new machine and use Rman to unpack the database
files.
Strategy: To restore the
database from the RMAN backup pieces into a new directory locations on the
machine and extract the control file and startup the
database.
Some
of the steps to setup the new machine.
1)
Install oracle 8i
2) install the patch 4.0
3) copy .profile
over
4)
duplicated the Admin directories for the database to be
restored
5)
created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6)
Created a backup mount point to store the RMAN backup pieces and
archivelogs
7)
moved the backup pieces and archivelogs to the new machine
8)
Setup and confirm connectivity to Rman catalog
9) No
mount the database to be on the new machine
10)
Launch the Rman command
rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it
gets to processing the command and gets to the "RMAN-03022:
compiling command: set " and just hangs...adding another line every 1/2
hour or so...
Anybody seen this or have ideas? I talked to one guy
who did have this but couldn't remember the solution. This is the first time
doing this so I might be missing something simple..
Here is the command in operation
==> rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 -
Production
RMAN>
RMAN> connect catalog
rman81740/depart@ltsprcat
2>
3> connect target /
4>
5>
6>
7> run
8>
9> {
10>
11> allocate channel disk_channel1 type disk
;
12>
13> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD
HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15>
16> set newname for datafile 1 to
17>
'/u02/vssppln/system01.dbf';
18>
19> set newname for datafile
2 to
20> '/u02/vssppln/rbs01.dbf';
21>
22> set newname
for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24>
25>
set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27>
28> set newname for datafile 5 to
29>
'/u02/vssppln/AIMFACT_INDEX01.dbf';
30>
31> set newname for
datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33>
34> set newname for datafile 7 to
35>
'/u02/vssppln/AIMFACT102.dbf';
36>
37> set newname for
datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39>
40> set newname for datafile 9 to
41>
'/u02/vssppln/aimfact1_index02.dbf';
42>
43> set newname for
datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45>
46> set newname for datafile 11 to
47>
'/u02/vssppln/aimfact1_index04.dbf';
48>
49> set newname for
datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51>
52> set newname for datafile 13 to
53>
'/u02/vssppln/aimfact202.dbf';
54>
55> set newname for
datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57>
58> set newname for datafile 15 to
59>
'/u02/vssppln/aimfact2_index02.dbf';
60>
61> set newname for
datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63>
64> set newname for datafile 17 to
65>
'/u02/vssppln/aimfact2_index04.dbf';
66>
67> set newname for
datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69>
70> set newname for datafile 19 to
71>
'/u02/vssppln/aimstruct_index01.dbf';
72>
73> set newname for
datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75>
76> set newname for datafile 21 to
77>
'/u02/vssppln/aimstruct1_index01.dbf';
78>
79> set newname
for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81>
82> set newname for datafile 23 to
83>
'/u02/vssppln/mipsdata01.dbf';
84>
85> set newname for
datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87>
88> set newname for datafile 25 to
89>
'/u02/vssppln/mipsdata101.dbf';
90>
91> set newname for
datafile 26 to
92> '/u02/vssppln/mipsdata1_index01.dbf';
93>
94> set newname for datafile 27 to
95>
'/u02/vssppln/mipsdata201.dbf';
96>
97> set newname for
datafile 28 to
98> '/u02/vssppln/nipsdata2_index01.dbf';
99>
100> set newname for datafile 29 to
101>
'/u02/vssppln/tools01.dbf';
102>
103> set newname for
datafile 30 to
104> '/u02/vssppln/users01.dbf';
105>
106> set newname for datafile 31 to
107>
'/u02/vssppln/AIMINDEX01.dbf';
108>
109> set newname for
datafile 32 to
110> '/u02/vssppln/aimfact1_index05.dbf';
111>
112> set newname for datafile 33 to
113>
'/u02/vssppln/aimfact2_index05.dbf';
114>
115>
116> restore
database;
117>
118> restore controlfile to
'/u02/vssppln/restored_cf.ctl';
119>
120> mount
database;
121>
122> switch datafile all;
123>
124>
release channel disk_channel1;
125> }
126>
127>
RMAN-06008: connected to recovery catalog database
RMAN-06006: connected to target
database: vssppln (not mounted)
RMAN-03022: compiling command:
allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated
channel: disk_channel1
RMAN-08500: channel disk_channel1: sid=10
devtype=DISK
RMAN-03022: compiling command:
sql
RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD
HH24:MI:SS"
RMAN-03023: executing command: sql
RMAN-03022: compiling command:
set
RMAN-03022: compiling command:
set
RMAN-03022: compiling command:
set
RMAN-03022: compiling command:
set
RMAN-03022: compiling
command: set
(and it slowly keeps spitting out
these "RMAN-03022: compiling command: set "
)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Spears, Brian
INET: BSpears_at_Limitedbrands.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Dec 05 2003 - 16:14:25 CST
