Home » RDBMS Server » Backup & Recovery » Backup & Recovery
Backup & Recovery [message #548589] Fri, 23 March 2012 05:38 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #548596 is a reply to message #548595] Fri, 23 March 2012 06:13 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sorry sir,
thanx for feedback.
my database name is "aepdvfcg" and user was "aepuser" instead of "newuser" but the procedure was same as described above.thanx again.
Re: Backup & Recovery [message #548597 is a reply to message #548596] Fri, 23 March 2012 06:15 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #548603 is a reply to message #548597] Fri, 23 March 2012 07:20 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
please sir tell me where the command prompt should be used in this whole process , because i didnot use it , i did this whole process in toad.
Re: Backup & Recovery [message #548605 is a reply to message #548603] Fri, 23 March 2012 07:59 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
and when i tried to login through a "aepuser" to the "aepdvfcg" database after backup process then it shows the error
"ORA-01033-ORACLE initialization or shutdown in progress " and when i tried to connect by sys as sysdba then it through an error "Connections to Oracle 7 servers require Oracle 8.1.7 clients or older", but version of both database (target and source database) is same that is 11.1.0.6.0
Re: Backup & Recovery [message #548611 is a reply to message #548605] Fri, 23 March 2012 09:18 Go to previous messageGo to next message
John Watson
Messages: 8922
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>

Re: Backup & Recovery [message #549650 is a reply to message #548611] Mon, 02 April 2012 14:55 Go to previous message
Sticker Printing
Messages: 7
Registered: March 2012
Location: USA
Junior Member
please sir tell me where the command prompt should be used in this whole process , because i didnot use it , i did this whole process in toad.
Previous Topic: RESTORE DATABASE SKIP TABLESPACE
Next Topic: how to recover before 15 minutes table data from flashback
Goto Forum:
  


Current Time: Thu Mar 28 17:38:54 CDT 2024