Home » RDBMS Server » Backup & Recovery » recover my datafile
recover my datafile [message #250142] Sun, 08 July 2007 11:36 Go to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi all

I have backup with rman of 12 tablespace but later i create more one tablespace for which i dont have backup

later when i was opening my database i stuck an error for recovery of datafile 13 for which i dont have any backup as my backup is till tablespace 12. I do have all my archive

How can i recover my datafile

Please could you guide me for this querry
Re: recover my datafile [message #250144 is a reply to message #250142] Sun, 08 July 2007 11:49 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Three commands:

1) alter database add datafile ...
2) recover datafile ...
3) alter database datafile ... online;
Re: recover my datafile [message #250151 is a reply to message #250144] Sun, 08 July 2007 12:14 Go to previous message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
HI Frank Naude

thanks for your guidence thanks very much
i forgot this steps you made it for me thanks once again
Previous Topic: rman and security
Next Topic: New Database Creation in another Host
Goto Forum:
  


Current Time: Thu Dec 08 12:10:27 CST 2016

Total time taken to generate the page: 0.10898 seconds