| Backup & Recovery [message #548589] |
Fri, 23 March 2012 05:38  |
 |
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
|
Senior Member |
|
|
hello experts,
i have an issue while in backup and recovery.
first of all i want to explain what i did, at first i create a database and named "testdatabase" on my machine then i create a new user say "newuser" and gave some roles and i created tablespaces and some tables in it and after that i stopped the service of "testdatabase",then i copied the folder of "testdatabase" from admin,oradata,flash_recovery_area and rdbms from diag folders at another location on my system.
then i login to "testdatabase" through sys after starting the service,then i drop "newuser" and stop the service again then i replace the folders of "testdatabase" from coressponding copied folders(from its original files) then i start the service and login to "testdatabase" through the "newuser" then all data is recovered successfully.
but when i tried to replace these all folders to the folders of the same named database which is on another machine (i have copied it by stopping the service of it)after stopping the service and then i tried to connect it then it throughs an error-
"ORA-01033:
ORACLE initialization or shutdown in progress" and i wait for 3-4 hours for it , but same error.
what is the issue in behind it,plz tell me,how to recover it thanx in advance.
[Updated on: Fri, 23 March 2012 05:45] Report message to a moderator |
|
|
|
| Re: Backup & Recovery [message #548595 is a reply to message #548589] |
Fri, 23 March 2012 05:55  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
First, is your database actually named "testdatabase"? The docs say that db_name can be maximum 8 characters.
It would be better if you showed what you are doing (use copy/paste from your OS prompt) rather than trying to describe it.
|
|
|
|
|
|
| Re: Backup & Recovery [message #548597 is a reply to message #548596] |
Fri, 23 March 2012 06:15 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:It would be better if you showed what you are doing (use copy/paste from your OS prompt) rather than trying to describe it.
|
|
|
|
|
|
|
|
| Re: Backup & Recovery [message #548611 is a reply to message #548605] |
Fri, 23 March 2012 09:18 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You need to stop using Toad for this, Toad may have its uses but fixing this sort of issue is not one of them. So open a CMD shell, and run the sqlplus.exe tool after connecting to the correct Oracle home and instance name. Like this:c:\users\john\home>where sqlplus
C:\app\john\product\10.2.0\dbhome_1\BIN\sqlplus.exe
C:\app\john\product\11.2.0\dbhome_1\BIN\sqlplus.exe
C:\app\john\product\11.2.0\client_1\bin\sqlplus.exe
c:\users\john\home>set ORACLE_HOME=c:\app\john\product\11.2.0\dbhome_1
c:\users\john\home>set PATH=%ORACLE_HOME%\bin;%PATH%
c:\users\john\home>set ORACLE_SID=orcl
c:\users\john\home>sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 23 14:15:26 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SP2-0640: Not connected
> connect / as sysdba
Connected.
Session altered.
orcl>
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
