Home » RDBMS Server » Server Administration » Upgrade 9i to 10g using RMAN backup. Is it failed? (9.2.0.8.0 on linux to 10.2.0.4.0 on Linux)
Upgrade 9i to 10g using RMAN backup. Is it failed? [message #500583] |
Tue, 22 March 2011 05:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
OraKaran
Messages: 183 Registered: March 2008 Location: United Kingdom
|
Senior Member |
|
|
Hello
I have upgraded a 9i db to 10g on another server using rman backup
(9.2.0.8.0 on linux to 10.2.0.4.0 on Linux)
I copied the hot backup - rman from 9i db server to 10g db server
Then I restores the rman backup on the 10g db server
opened the database with
alter database open restlogs upgrade;
@?/rdbms/admin/catupgrd.sql
shutdown immediate;
startup restrict
@?/rdbms/admin/utlrp.sql
Now I have all components in VALID state but the db server itself in INVALID state as can be seen from results below
SQL> select comp_name, status, version from dba_registry;
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle Database Catalog Views
VALID 10.2.0.4.0
Oracle Database Packages and Types
VALID 10.2.0.4.0
SQL> @?/rdbms/admin/utlu102s.sql TEXT
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 10:35:20
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05
PL/SQL procedure successfully completed.
SQL>
Has the upgrade failed?
Note that
OS for 9i db server is
Linux 2.6.9-42.EL #1 x86_64 x86_64 x86_64 GNU/Linux
OS for 10g db server is
Linux 2.6.18-53.el5 #1 x86_64 x86_64 x86_64 GNU/Linux
Regards,
OraKaran
|
|
|
|
Re: Upgrade 9i to 10g using RMAN backup. Is it failed? [message #500603 is a reply to message #500583] |
Tue, 22 March 2011 06:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
OraKaran
Messages: 183 Registered: March 2008 Location: United Kingdom
|
Senior Member |
|
|
Hell Mahesh
I have nothing to hide from
At the most you can blame me for not keeping spool of catupgrd.sql
This is small test database I am trying before I do the same exercise on larger database
This is available on the screen till the point I can scroll up
33 ELSIF log.comp_id = 'UPGRD_END' THEN
34 end_time := log.optime;
35 END IF;
36
37 IF log.comp_id LIKE '%_BGN' OR log.comp_id LIKE '%_END' OR
38 log.comp_id = 'CATPROC' THEN
39 NULL;
40 ELSE
41 IF log.comp_id = 'RDBMS' THEN
42 component := 'Oracle Database Server';
43 ELSE
44 component := dbms_registry.comp_name(log.comp_id);
45 END IF;
46 elapsed_time := log.optime - prv_time;
47 time_result := to_char(elapsed_time);
48 IF display_xml THEN
49 DBMS_OUTPUT.PUT_LINE ('<Component id="' || component ||
50 '" cid="' || log.comp_id ||
51 '" status="' || LOWER(log.operation) ||
52 '" upgradeTime="' || substr(time_result,5,8) ||
53 '">');
54 ELSE
55 DBMS_OUTPUT.PUT_LINE(rpad(component,35) ||
56 LPAD(log.operation,12) || ' ' ||
57 LPAD(substr(log.message,1,15),15) ||
58 LPAD(substr(time_result,5,8),10));
59 END IF;
60 prv_time := log.optime;
61 END IF;
62 END LOOP;
63
64 IF end_time IS NOT NULL THEN
65 elapsed_time := end_time - start_time;
66 time_result := to_char(elapsed_time);
67 IF display_xml THEN
68 DBMS_OUTPUT.PUT_LINE('<totalUpgrade time="' ||
69 substr(time_result, 5,8) || '">');
70 ELSE
71 DBMS_OUTPUT.PUT_LINE('.');
72 DBMS_OUTPUT.PUT_LINE('Total Upgrade Time: ' ||
73 substr(time_result, 5,8));
74 END IF;
75 ELSE
76 IF display_xml THEN
77 DBMS_OUTPUT.PUT_LINE('<Upgrade incomplete/>');
78 ELSE
79 DBMS_OUTPUT.PUT_LINE('Upgrade Incomplete');
80 END IF;
81 END IF;
82 IF display_xml THEN
83 DBMS_OUTPUT.PUT_LINE('</Components>');
84 DBMS_OUTPUT.PUT_LINE('</RDBMSUP>');
85 END IF;
86 END;
87 /
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 09:36:34
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05
PL/SQL procedure successfully completed.
SQL>
SQL> SET SERVEROUTPUT OFF
SQL> SET VERIFY ON
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL>
SQL> Rem *********************************************************************
SQL> Rem END catupgrd.sql
SQL> Rem *********************************************************************
SQL>
SQL>
SQL> @?/rdbms/admin/utlu102s.sql TEXT
SQL> Rem
SQL> Rem $Header: utlu102s.sql 22-jun-2004.06:32:46 rburns Exp $
SQL> Rem
SQL> Rem utlu102s.sql
SQL> Rem
SQL> Rem Copyright (c) 2004, Oracle. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem utlu102s.sql - UTiLity Upgrade Status
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem This script provides information about databases that have
SQL> Rem been upgraded to 10.2.
SQL> Rem
SQL> Rem
SQL> Rem NOTES
SQL> Rem Connect AS SYSDBA
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem rburns 06/22/04 - rburns_pre_upgrade_util
SQL> Rem rburns 05/11/04 - Created
SQL> Rem
SQL>
SQL> @@utlusts TEXT
SQL> Rem
SQL> Rem $Header: utlusts.sql 26-jul-2004.09:57:38 rburns Exp $
SQL> Rem
SQL> Rem utlusts.sql
SQL> Rem
SQL> Rem Copyright (c) 2004, Oracle. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem utlusts.sql - UTiLity Upgrade STatuS
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem Presents Post-upgrade Status in either TEXT or XML
SQL> Rem
SQL> Rem NOTES
SQL> Rem Invoked by utlu102s.sql with TEXT parameter
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem rburns 07/21/04 - add elapsed time
SQL> Rem rburns 06/22/04 - rburns_pre_upgrade_util
SQL> Rem rburns 06/16/04 - Created
SQL> Rem
SQL>
SQL> SET SERVEROUTPUT ON
SQL> SET VERIFY OFF
SQL>
SQL> DECLARE
2
3 display_mode VARCHAR2(4) := '&1';
4 display_xml BOOLEAN := FALSE;
5 component registry$.cname%type;
6 prv_time TIMESTAMP;
7 start_time TIMESTAMP;
8 end_time TIMESTAMP;
9 elapsed_time INTERVAL DAY TO SECOND(9) :=
10 INTERVAL '0 00:00:00.00' DAY TO SECOND;
11 time_result VARCHAR2(30);
12
13 BEGIN
14 IF display_mode = 'XML' THEN
15 display_xml := TRUE;
16 DBMS_OUTPUT.PUT_LINE('<RDBMSUP version="10.2">');
17 DBMS_OUTPUT.PUT_LINE('<Components>');
18 ELSE
19 DBMS_OUTPUT.PUT_LINE('.');
20 DBMS_OUTPUT.PUT_LINE(
21 'Oracle Database 10.2 Upgrade Status Utility ' ||
22 LPAD(TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'),26));
23 DBMS_OUTPUT.PUT_LINE('.');
24 DBMS_OUTPUT.PUT_LINE(RPAD('Component', 35) || LPAD('Status',12) ||
25 LPAD('Version', 16) || LPAD('HH:MM:SS', 10));
26 END IF;
27 FOR log IN (SELECT comp_id, operation, optime, message
28 FROM dba_registry_log WHERE namespace = 'SERVER'
29 ORDER BY optime) LOOP
30 IF log.comp_id = 'UPGRD_BGN' THEN
31 start_time := log.optime;
32 prv_time := log.optime;
33 ELSIF log.comp_id = 'UPGRD_END' THEN
34 end_time := log.optime;
35 END IF;
36
37 IF log.comp_id LIKE '%_BGN' OR log.comp_id LIKE '%_END' OR
38 log.comp_id = 'CATPROC' THEN
39 NULL;
40 ELSE
41 IF log.comp_id = 'RDBMS' THEN
42 component := 'Oracle Database Server';
43 ELSE
44 component := dbms_registry.comp_name(log.comp_id);
45 END IF;
46 elapsed_time := log.optime - prv_time;
47 time_result := to_char(elapsed_time);
48 IF display_xml THEN
49 DBMS_OUTPUT.PUT_LINE ('<Component id="' || component ||
50 '" cid="' || log.comp_id ||
51 '" status="' || LOWER(log.operation) ||
52 '" upgradeTime="' || substr(time_result,5,8) ||
53 '">');
54 ELSE
55 DBMS_OUTPUT.PUT_LINE(rpad(component,35) ||
56 LPAD(log.operation,12) || ' ' ||
57 LPAD(substr(log.message,1,15),15) ||
58 LPAD(substr(time_result,5,8),10));
59 END IF;
60 prv_time := log.optime;
61 END IF;
62 END LOOP;
63
64 IF end_time IS NOT NULL THEN
65 elapsed_time := end_time - start_time;
66 time_result := to_char(elapsed_time);
67 IF display_xml THEN
68 DBMS_OUTPUT.PUT_LINE('<totalUpgrade time="' ||
69 substr(time_result, 5,8) || '">');
70 ELSE
71 DBMS_OUTPUT.PUT_LINE('.');
72 DBMS_OUTPUT.PUT_LINE('Total Upgrade Time: ' ||
73 substr(time_result, 5,8));
74 END IF;
75 ELSE
76 IF display_xml THEN
77 DBMS_OUTPUT.PUT_LINE('<Upgrade incomplete/>');
78 ELSE
79 DBMS_OUTPUT.PUT_LINE('Upgrade Incomplete');
80 END IF;
81 END IF;
82 IF display_xml THEN
83 DBMS_OUTPUT.PUT_LINE('</Components>');
84 DBMS_OUTPUT.PUT_LINE('</RDBMSUP>');
85 END IF;
86 END;
87 /
.
Oracle Database 10.2 Upgrade Status Utility 03-22-2011 09:49:08
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:06:59
.
Total Upgrade Time: 00:07:05
PL/SQL procedure successfully completed.
SQL>
SQL> SET SERVEROUTPUT OFF
SQL> SET VERIFY ON
SQL>
SQL>
SQL>
SQL>
let me know if I can provide any details
Also if the details are totally insufficient I can repeat the whole exercise
Regards,
OraKaran
|
|
|
Re: Upgrade 9i to 10g using RMAN backup. Is it failed? [message #500654 is a reply to message #500583] |
Tue, 22 March 2011 12:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
OraKaran
Messages: 183 Registered: March 2008 Location: United Kingdom
|
Senior Member |
|
|
Hello Mahesh
I repeated the exercise and got my mistake
I did not add tempfile to temp tablespace before executing catupgrd.sql
In fact when I created new temp tablespace, made it default, dropped old one and executed catupgrd.sql - this time everything worked fine
(of course created sysaux tbs also)
Thanks for the pointer
Quote:
Hint should be here ( in session log or spool file).
>>@?/rdbms/admin/catupgrd.sql
In my second attempt I found the eroe in the spooled file itself
Thanks and Regards,
OraKaran
|
|
|
|
Goto Forum:
Current Time: Sat Sep 07 17:33:13 CDT 2024
|