Solved

Restoration of Oracle database fails with ORA-01460

Posted on 2007-12-05
9
1,765 Views
Last Modified: 2013-12-18
I am evaluating Backup Exec's ability to backup and restore Oracle 10g databases.  The backups seem to work without error, but when I try to restore from one of them, it bails with an RMAN script failure.  

Now my database is at a point where it will not start -- it says ORA-01610: recovery using the BACKUP CONTROLFILE must be done.

I've attached the RMAN results below.

Has anyone successfully recovered an Oracle database with Backup Exec 11d

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Dec 6 01:30:46 2007
 
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
 
 Connected.
 ORA-01109: database not open
 
 
Database dismounted.
ORACLE instance shut down.
 ORACLE instance started.
 
Total System Global Area  612368384 bytes
Fixed Size    2056864 bytes
Variable Size  205524320 bytes
Database Buffers  398458880 bytes
Redo Buffers    6328320 bytes
 Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
 
Recovery Manager: Release 10.2.0.3.0 - Production on Thu Dec 6 01:31:01 2007
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=192.14.14.25,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={8FDDD645-52BE-4C77-B98D-FC755CF9370A},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\candc-ora1.candc-uk.com\abc';
 
 RESTORE CONTROLFILE FROM 'BE_03j2skbl_1_1';
 
 ALTER DATABASE MOUNT;
 
 RESTORE
     DATABASE;
 
 RELEASE CHANNEL ch0;
 }
 
connected to target database: abc (not mounted)
 
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=157 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
 
sent command to channel: ch0
 
Starting restore at 06-DEC-07
 
channel ch0: restoring control file
channel ch0: restore complete, elapsed time: 00:01:46
output filename=D:\ORACLE\DATABASES\ABC\CONTROL\CONTROL01.CTL
output filename=D:\ORACLE\DATABASES\ABC\CONTROL\CONTROL02.CTL
output filename=D:\ORACLE\DATABASES\ABC\CONTROL\CONTROL03.CTL
Finished restore at 06-DEC-07
 
database mounted
 
Starting restore at 06-DEC-07
Starting implicit crosscheck backup at 06-DEC-07
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/06/2007 01:32:52
ORA-01460: unimplemented or unreasonable conversion requested
 
Recovery Manager complete.

Open in new window

0
Comment
Question by:jimbobmcgee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 2

Expert Comment

by:hamita
ID: 20418501
1) connect to database, wchih while be restored.
2) execute command : ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
3) Start the oracle server in nomount state and create the control file in target server .
4) After controlfile created recover Database using
recover database using backup controlfile until cancel
5) Once recovery completed open the Databse in RESETLOGS mode.
SQL>alter database open resetlogs;
0
 
LVL 16

Author Comment

by:jimbobmcgee
ID: 20418660
Thanks, hamita;  I must admit I'm a bit of a beginner with Oracle.  I have followed your steps up to 3, which I took to mean:

    3.1 SHUTDOWN IMMEDIATE
    3.2 STARTUP NOMOUNT

but after shutting down, I get ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.  If I run LSNRCTL SERVICES I cannot find my database in the list, so I guess that's the problem, but how do I fix this?  I am using LDAP (over AD) to resolve names and if I TNSPING the database, I get a reply.

I will also need clarification on what you mean by 'create the control file in target server'.

J.
0
 
LVL 2

Expert Comment

by:hamita
ID: 20418766
what is your operating system?
windows or unix, linux???
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 2

Expert Comment

by:hamita
ID: 20418796
1.Check the file $ORACLE_HOME/host_sid/sysman/config/emoms.properties
In this case this had -

oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraserver)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))

2. Then check the oupt from lsnrctl status and lsnrctl services, in this case we saw -
lsnrctl status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORASERVER)(PORT=1521)))
STATUS of the LISTENER
------------------------
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /u01/app/oracle/OraHome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/OraHome_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORASERVER)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORASERVER)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORASERVER)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "ORABDE.world" has 2 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD.world" has 1 instance(s).
Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully
lsnrctl services
----------------
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraserver)(PORT=1521)))
Services Summary...
Service "PROD.world" has 2 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "PROD", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:552 refused:0 state:ready
LOCAL SERVER
Service "PROD.world" has 1 instance(s).
Instance "PROD", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: oraserver, pid: 19216>
(ADDRESS=(PROTOCOL=tcp)(HOST=oraserver)(PORT=32803))
The command completed successfully

3. Then check the tnsnames.ora used, in this case we had -
tnsnames.ora
-------------
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORASERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD)
)
)

SQL> select * from global_name;

4. Last of all check the database GLOBAL_NAME, in this case we had -
GLOBAL_NAME
--------------------------------------------------------------------------------
PROD


So In this case the reason for the emoms.log showing -
ERROR conn.ConnectionService verifyRepositoryEx.418 - Invalid Connection Pool. ERROR = Listener
refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Was that the SERVICE_NAME contained  PROD but the entry for
oracle.sysman.eml.mntr.emdRepConnectDescriptor= in
$ORACLE_HOME/host_sid/sysman/config/emoms.properties contained just PROD for the SERVICE_NAME

The fix would be -Amend the entry oracle.sysman.eml.mntr.emdRepConnectDescriptor in emoms.properties

example -
oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraserver)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))
0
 
LVL 16

Author Comment

by:jimbobmcgee
ID: 20419247
I am running on Windows, and have found and looked at the emoms.properties file, but I'm not sure how the above applies to me.

The server is intended to house a number of development databases (not schemas), and I currently have two installed.  The one I am using to test backup/recovery is the one I have shutdown.  TNSPING can see both databases, via their LDAP-registered names, but SQLPLUS cannot.  SQLPLUS can see the second database, though.

J.
0
 
LVL 2

Accepted Solution

by:
hamita earned 500 total points
ID: 20419792
shutdown all database services, and disable second db services
open 1st database services and try it
0
 
LVL 16

Author Comment

by:jimbobmcgee
ID: 20419925
Any way to do it without shutting down the second database?
I have got people using the second one and I'm trying not to have to take them down too.

It surely must be possible to shutdown and startup a database without affecting other services...
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question