| system datafile recovery [message #282501] |
Thu, 22 November 2007 03:20  |
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 #282535 is a reply to message #282505] |
Thu, 22 November 2007 04:51  |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
