OraFAQ Forum: Backup & Recovery » Problem with Recovery

Home » RDBMS Server » Backup & Recovery » Problem with Recovery (Oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Recovery [message #348233]

Tue, 16 September 2008 03:00

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

Report message to a moderator

Re: Problem with Recovery [message #348250 is a reply to message #348233]

Tue, 16 September 2008 03:50

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.

Report message to a moderator

Re: Problem with Recovery [message #348262 is a reply to message #348233]

Tue, 16 September 2008 04:07

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.

Report message to a moderator

Re: Problem with Recovery [message #348265 is a reply to message #348262]

Tue, 16 September 2008 04:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Problem with Recovery [message #348276 is a reply to message #348265]

Tue, 16 September 2008 05:12

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...!!

Report message to a moderator

Re: Problem with Recovery [message #348277 is a reply to message #348265]

Tue, 16 September 2008 05:20

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 !

Report message to a moderator

Re: Problem with Recovery [message #348279 is a reply to message #348276]

Tue, 16 September 2008 05:33

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Problem with Recovery [message #348639 is a reply to message #348233]

Wed, 17 September 2008 08:15

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?

Report message to a moderator

Re: Problem with Recovery [message #348642 is a reply to message #348233]

Wed, 17 September 2008 08:26

Mimas
Messages: 40
Registered: September 2008
Location: Athens

Member

ALTER command solved the problem!!!

Report message to a moderator

Previous Topic:	auto backup on oracle xe
Next Topic:	RMAN recovery to DR with Roll-forward

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:35:13 CST 2024