| emca -x What happen? How to recover datbase. [message #68935] |
Mon, 14 February 2005 19:33  |
Anil Khadka
Messages: 1
Registered: February 2005
|
Junior Member |
|
|
I mistakely issue command emca -x <db-name>, i am loosing folder in /u01/app/oracle/product/10.1.0/Db_2/ .. When i start the database in sqlplus using startup then the database will mount but not open....But i have files
control01.ctl redo01.log sysaux01.dbf undotbs01.dbf
control02.ctl redo02.log system01.dbf users01.dbf
control03.ctl redo03.log temp01.dbf
in some folder... i know this is the main file... but how do i do the rest???
While issuing commnad emca... and after giving some parameter it issue error like:
[[oracle@fedora Db_2]]$ emca -a
STARTED EMCA at Tue Feb 15 10:16:14 NPT 2005
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: orcl
Service name: orcl
Email address for notification: asdf
Email gateway for notification: asdf
ASM ORACLE_HOME [[ /u01/app/oracle/product/10.1.0/Db_2 ]]:
ASM SID [[ +ASM ]]:
ASM port [[ 1521 ]]:
ASM user role [[ SYSDBA ]]:
ASM user name [[ SYS ]]:
ASM user password:
Password for dbsnmp:
Password for sysman:
Password for sys:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/Db_2
Enterprise Manager ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/Db_2
Database host name ................ localhost.localdomain
Listener port number ................ 1521
Database SID ................ orcl
Service name ................ orcl
Email address for notification ............... asdf
Email gateway for notification ............... asdf
ASM ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/Db_2
ASM SID ................ +ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM user name ................ SYS
-----------------------------------------------------------------
Do you wish to continue? [[yes/no]]: yes
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig checkConfiguration
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig updateReposVars
INFO: Updating file /u01/app/oracle/product/10.1.0/Db_2/sysman/emdrep/config/repository.variables ...
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository. Repository creation could not be completed successfully
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig perform
INFO: Please refer to the log file at /u01/app/oracle/product/10.1.0/Db_2/cfgtoollogs/emca_repos_create<DATE>.log for more details.
Could not complete the configuration. Refer to the log file for details
Any one Please help me, give me some hints...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
