Home » RDBMS Server » Backup & Recovery » Problem with Recovery (Oracle9i)
Problem with Recovery [message #348233] Tue, 16 September 2008 03:00 Go to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Hello all,

Please help because I did something stupid and I do not know how to correcti.

I copied (using cp command) some .dbf file under /u01/ofa to another directory (/u04/backup_dbf) and then delete the .dbf files from /u01/ofa.

These are the files I copied:
PP_STAS1.dbf
TEMP01.dbf
indx01.dbf
rbs01.dbf
system01.dbf
temp01.dbf
tools01.dbf
users01.dbf


Now I need to restore these .dbf files because I receive an error of "system01.dbf missing".

Also when I try to restore the specific datafile (RMAN> restore datafile '/u04/backup_dbf/system01.dbf'Wink or all of them I receive the following error:

RMAN-03002: failure of restore command at 09/16/2008 10:38:34
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "sys/manager"
ORA-01031: insufficient privileges


How can I restore these files?

Thanks in advance
Mimas
Re: Problem with Recovery [message #348250 is a reply to message #348233] Tue, 16 September 2008 03:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

I copied (using cp command) some .dbf file under /u01/ofa to another directory (/u04/backup_dbf) and then delete the .dbf files from /u01/ofa
Which type of backup?
when you copied datafile then database is open/close which stage?

Now I need to restore these .dbf files because I receive an error of "system01.dbf missing".

where is the exact error message?


RMAN-03002: failure of restore command at 09/16/2008 10:38:34
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "sys/manager"
ORA-01031: insufficient privileges
connect as sysdba privileged user.
Re: Problem with Recovery [message #348262 is a reply to message #348233] Tue, 16 September 2008 04:07 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Which type of backup?
What do you mean? I took before some days a backup using RMAN (database backup;) if that's what you mean.
when you copied datafile then database is open/close which stage?
It was open.

Now I need to restore these .dbf files because I receive an error of "system01.dbf missing".

where is the exact error message?
This error was received when I try to give an Insert command via sql. The error was saying that system01.dbf was missing from u01/ofa.
This is the path were this system01.dbf together with more .dbf files were existed before I copy and remove them.

Re: Problem with Recovery [message #348265 is a reply to message #348262] Tue, 16 September 2008 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I recommend you to read: Database Backup and Recovery Basics

You can't cp when the database is open (unless you put the tablespace in backup mode)
You can't restore with rman something you don't back up with rman (actually this is not completly true but at your level it is).

Regards
Michel
Re: Problem with Recovery [message #348276 is a reply to message #348265] Tue, 16 September 2008 05:12 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Now I know that I cannot do all the above.

The thing is what can I do now...!!
Re: Problem with Recovery [message #348277 is a reply to message #348265] Tue, 16 September 2008 05:20 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Michel Cadot wrote on Tue, 16 September 2008 05:12
(actually this is not completly true but at your level it is).

Now that's funny !
Re: Problem with Recovery [message #348279 is a reply to message #348276] Tue, 16 September 2008 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The thing is what can I do now...!!

First read the book and stop trying to back up and restore or you will lose your database.

Regards
Michel
Re: Problem with Recovery [message #348639 is a reply to message #348233] Wed, 17 September 2008 08:15 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Thanks for your answers.

I amnaged to do the restore and recover but when I give Alter Database open I receive the following error:

RMAN> alter database open;

using target database controlfile instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/17/2008 16:09:06
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '/u01/ofa/SMS/system01.dbf'

Any idea?
Re: Problem with Recovery [message #348642 is a reply to message #348233] Wed, 17 September 2008 08:26 Go to previous message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
ALTER command solved the problem!!!
Previous Topic: auto backup on oracle xe
Next Topic: RMAN recovery to DR with Roll-forward
Goto Forum:
  


Current Time: Fri Dec 02 18:45:47 CST 2016

Total time taken to generate the page: 0.22267 seconds