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

Report message to a moderator

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: 4579
Registered: April 1998
Senior Member
Three commands:

1) alter database add datafile ...
2) recover datafile ...
3) alter database datafile ... online;

Report message to a moderator

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

Report message to a moderator

Previous Topic: rman and security
Next Topic: New Database Creation in another Host
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 10:33:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.