Home » RDBMS Server » Backup & Recovery » Tablaspace recovery
Tablaspace recovery [message #244521] Wed, 13 June 2007 03:08 Go to next message
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 Go to previous messageGo to next message
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
Re: Tablaspace recovery [message #244633 is a reply to message #244521] Wed, 13 June 2007 10:07 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?

Re: Tablaspace recovery [message #244720 is a reply to message #244719] Wed, 13 June 2007 23:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Tablaspace recovery [message #244741 is a reply to message #244521] Thu, 14 June 2007 00:41 Go to previous messageGo to next message
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?
Re: Tablaspace recovery [message #244744 is a reply to message #244521] Thu, 14 June 2007 00:48 Go to previous messageGo to next message
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!!!!!!!!!!!
Re: Tablaspace recovery [message #244776 is a reply to message #244744] Thu, 14 June 2007 01:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: RMAN recovery using a backup Control File and RESETLOGS concepts
Next Topic: Attaching DBF / ORA files to Oracle 10g express
Goto Forum:
  


Current Time: Sun Dec 04 02:21:39 CST 2016

Total time taken to generate the page: 0.07398 seconds