OraFAQ Forum: Backup & Recovery » Tablaspace recovery

Home » RDBMS Server » Backup & Recovery » Tablaspace recovery

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

Tablaspace recovery [message #244521]

Wed, 13 June 2007 03:08

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I have backup of tablespace data02 image copy named '/oradata/THERAP/datafile/o1_mf_data02_36tbsz3l_.dbf'
And my current database tablespace of data02 is in
'/oradata/oradata/THERAP/data02.dbf'

I have then deleted tablespace data02 including datafiles, contents and cascade contraints.

Now I need to recover my tablespace in prior time which I mean to go in state 'sysdate-2'....
I followed following steps but it does not work...

1. I created new tablespace named data02 and datafile in '/oradata/oradata/THERAP/data02.dbf'

2. Then I invoked following command,

run{
set newname for datafile '/oradata/oradata/THERAP/data02.dbf'
to '/oradata/THERAP/datafile/o1_mf_data02_36tbsz3l_.dbf'
recover tablespace data02 until time 'SYSDATE-2'
auxiliary destination '/oradata';
}

But it does not work.

Please anyone of you can give me solution how I can get back my tablespace data02...............

[Updated on: Wed, 13 June 2007 03:10]

Report message to a moderator

Re: Tablaspace recovery [message #244524 is a reply to message #244521]

Wed, 13 June 2007 03:16

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

If I use rocover tablespace until time 'sysdate-2'after creating tablespace that I dropped then the following error comes....

RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "DATA02"
RMAN-05517: temporary file /oradata/oradata/THERAP/temp01.dbf conflicts with file used by target database
RMAN-05001: auxiliary filename /oradata/oradata/THERAP/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /oradata/oradata/THERAP/system01.dbf conflicts with a file used by the target database

help please.I need to tablespace recover.

N.B I already read the document of TSPITR

Report message to a moderator

Re: Tablaspace recovery [message #244633 is a reply to message #244521]

Wed, 13 June 2007 10:07

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

run{
set newname for datafile '/oradata/oradata/THERAP/data02.dbf'
to '/oradata/THERAP/datafile/o1_mf_data02_36tbsz3l_.dbf'
recover tablespace data02 until time 'SYSDATE-2'
auxiliary destination '/oradata';
}

try this command

run {  
      set newname for datafile '/oradata/oradata/THERAP/data02.dbf'
       to '/oradata/THERAP/datafile/o1_mf_data02_36tbsz3l_.dbf'
     restore tablespace DATA; 
     switch datafile all;  
     recover tablespace DATA;  
     }

[Updated on: Wed, 13 June 2007 10:21]

Report message to a moderator

Re: Tablaspace recovery [message #244719 is a reply to message #244521]

Wed, 13 June 2007 22:56

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Dream,

Whenever I imput in rman prompt restore tablespace DATA and press enter all the time this error comes.

=============-------------
run{
2> set newname for datafile '/oradata/oradata/THERAP/data02.dbf'
3> to '/oradata/THERAP/datafile/o1_mf_data02_36tbsz3l_.dbf'
4> restore tablespace DATA;
=============-------------

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "restore": expecting one of: ";"
RMAN-01007: at line 4 column 1 file: standard input

I think I have not made any syntax error.. What I will do?

Report message to a moderator

Re: Tablaspace recovery [message #244720 is a reply to message #244719]

Wed, 13 June 2007 23:15

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Are you recovering it through recovery catalog? if yes then
create catalog tablespace by this command and then try.

RMAN>>CREATE CATALOG TABLESPACE 'yourtablespacename';

[Updated on: Wed, 13 June 2007 23:16]

Report message to a moderator

Re: Tablaspace recovery [message #244721 is a reply to message #244521]

Wed, 13 June 2007 23:18

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

No man I have not created any recovery catalog. I used control file to recover.
Whenever I press third line(restore tablespace ...... Wink

then syntax error comes.. It does not prompt me to enter another line.

[Updated on: Wed, 13 June 2007 23:20]

Report message to a moderator

Re: Tablaspace recovery [message #244725 is a reply to message #244721]

Wed, 13 June 2007 23:29

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

YOU sure your tablespace name is correct??

check this

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96566/rcmtroub.htm

Report message to a moderator

Re: Tablaspace recovery [message #244741 is a reply to message #244521]

Thu, 14 June 2007 00:41

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Yes tablespace name is correct.
Dream will you please try it in your pc and then make a solution of it.
1. First create a tablesapace and put some table inside its datafile.
2. backup the tablespace.

3. drop the tablespace including contents and datafiles.

4. Try to recover the tablespace just 20 minutes ago.

Please then make me confirm will it work?

Report message to a moderator

Re: Tablaspace recovery [message #244744 is a reply to message #244521]

Thu, 14 June 2007 00:48

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Michel where are u? Did u see this problem in oracle? Dropped tablespaces cant be recovered!!!!!!!!!!!

Report message to a moderator

Re: Tablaspace recovery [message #244776 is a reply to message #244744]

Thu, 14 June 2007 01:44

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

Senior Member
Account Moderator

I didn't follow this thread as I saw DreamzZ answered you and his advices in this matter are almost always pretty good.
In this case, I would try exactly what he said.

What I can add is what RMAN already said you: a ";" is missing at the end of "set newname" statement.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN recovery using a backup Control File and RESETLOGS concepts
Next Topic:	Attaching DBF / ORA files to Oracle 10g express

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 12:32:44 CST 2025