Home » RDBMS Server » Backup & Recovery » rman is hanging (oracle 10g 10.2.0.1 linux 32 bit)
rman is hanging [message #311138] Thu, 03 April 2008 09:38 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I want to restore my database through RMAN backup in new server,
I have installed Oracle software (not database) and when i am trying to connect to RMAN like following it is hanging.

RMAN> connect target /

When i check the process it is hogging CPU.

Kindly help me
Re: rman is hanging [message #311141 is a reply to message #311138] Thu, 03 April 2008 09:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I have installed Oracle software (not database) and when i am trying to connect to RMAN like following it is hanging.
Quote:
RMAN> connect target /

What do you think this command will do?
Re: rman is hanging [message #311143 is a reply to message #311141] Thu, 03 April 2008 09:56 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i want to connect to rman to restore the database. This command will give me access to restore spfile, controlfile and then i will restore database from my backup
Re: rman is hanging [message #311146 is a reply to message #311143] Thu, 03 April 2008 10:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov002.htm#sthref723
Re: rman is hanging [message #311149 is a reply to message #311146] Thu, 03 April 2008 10:17 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i follow steps 1 and 2 RMAN is still hanging
Re: rman is hanging [message #311152 is a reply to message #311149] Thu, 03 April 2008 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Copy and paste your RMAN session.

Regards
Michel
Re: rman is hanging [message #311168 is a reply to message #311149] Thu, 03 April 2008 11:08 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Thank you for your help
Hanging problem was due to the reasoin that i did not apply patch

Here after login
setting DBID and starting up in nomount
and when After restore the spfile,
i restarted the datbase in no mount state like following

startup force nomount.
it is giving following error

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/03/2008 17:49:27
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
RMAN-04017: startup error description: ORA-32004: obsolete and/or deprecated parameter(s) specified
Re: rman is hanging [message #311173 is a reply to message #311168] Thu, 03 April 2008 11:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be your spfile has entries for non existent files/directories.
reset the entries to existing directories, try again.
Re: rman is hanging [message #311175 is a reply to message #311168] Thu, 03 April 2008 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file

This is the reason you can't do anything with SYS.
Check you audit directory and file system (space, permission, quota...).

Regards
Michel
Re: rman is hanging [message #311383 is a reply to message #311175] Fri, 04 April 2008 05:52 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
No everything is fine, actually i did not create folder cdump,bdump,udump and dpdump on the correct location,It is all running fine now except enterprise manager, when i write command

emctl status dbconsole
result is
TZ set to GB-Eire
OC4J Configuration issue. /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_test not found.

then i look at it and shift all the contents of folder (OC4J_DBConsole)in the same place to OC4J_DBConsole_localhost_test after creating it

After it again when i write command
emctl status dbconsole
TZ set to GB-Eire
EM Configuration issue. /u01/app/oracle/product/10.2.0/db_1/localhost_test not found.

When i am trying to recreate EM by using following command
emca -config dbcontrol db -repos recreate
it is hanging after i insert SID name


Re: rman is hanging [message #311385 is a reply to message #311383] Fri, 04 April 2008 05:57 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is the relation between this post and your first one?
How your RMAN error is related to your Db Console problem?

Regards
Michel
Previous Topic: problem with registering database
Next Topic: Recovering database from archive log files
Goto Forum:
  


Current Time: Thu Dec 05 17:20:36 CST 2024