Home » RDBMS Server » Backup & Recovery » system datafile recovery
system datafile recovery [message #282501] Thu, 22 November 2007 03:20 Go to next message
kirakast
Messages: 4
Registered: November 2007
Junior Member
hi all
im trying torecover my system datafile as i restore it from the backup using veritas netbackup.
and then i used
recover datafile '/oradata1/pay10g/pay10g/system01.dbf'

but its not working as i tried a lot then i also tried
recover database using backup controlfile;
and its asking me the mode of auto|cacel so i used auto then also its not working its trhowing an error.
so kindly help me out...

REGARDS
KK
Re: system datafile recovery [message #282505 is a reply to message #282501] Thu, 22 November 2007 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

its not working

Make it work and it will be OK.

Seriously, how do you expect we can help you if you don't tell us what error you got?

By the way, I hope you make an OS backup of your files before you started your tries otherwise it is likely you lost it.

Regards
Michel
Re: system datafile recovery [message #282535 is a reply to message #282505] Thu, 22 November 2007 04:51 Go to previous messageGo to next message
kirakast
Messages: 4
Registered: November 2007
Junior Member
recover database using backup controlfile;
ORA-00279: change 3389521682120 generated at 11/21/2007 16:43:34 needed for
thread 1
ORA-00289: suggestion : /oraarch/archive/pay10g/PAY61107454613083.arc
ORA-00280: change 3389521682120 for thread 1 is in sequence #3083


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/oraarch/archive/pay10g/PAY61107454613083.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


THIS IS AN ERROR AND I ALSO UPLOADED THE FILE BUT THERE WAS SOME PROBLEM...
DO U HAVE ANY OTHER WAY BY RMAN??/

[Updated on: Thu, 22 November 2007 05:02]

Report message to a moderator

Re: system datafile recovery [message #282573 is a reply to message #282535] Thu, 22 November 2007 07:02 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

DO U HAVE ANY OTHER WAY BY RMAN??/
But first tell us which backup method your using ?
it is RMAN or USER MANAGED BACKUP ?


According your recovery method ..your using user managed backup with alter database begin...end backup statement.

Now if you taken backup through proper method like
1. alter database begin backup.
2. copy all datafile to bkp location.
3. alter database end backup.
4. alter database backup controlfile to 'bkp_location';
5. alter system switch logfile;

then through below procedure you can recover your database.
1. startup mount
2. set autorecovery on
3. recover database using backup controlfile until canel;
canel;
4. alter database open resetlogs;

[Updated on: Thu, 22 November 2007 07:04]

Report message to a moderator

Previous Topic: rman
Next Topic: rman error
Goto Forum:
  


Current Time: Sun Dec 04 20:56:31 CST 2016

Total time taken to generate the page: 0.06510 seconds