rman is hanging [message #311138] |
Thu, 03 April 2008 09:38 |
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 #311143 is a reply to message #311141] |
Thu, 03 April 2008 09:56 |
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 #311168 is a reply to message #311149] |
Thu, 03 April 2008 11:08 |
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 #311383 is a reply to message #311175] |
Fri, 04 April 2008 05:52 |
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 |
|
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
|
|
|