| tarun |
Posted: Aug 17, 2008 09:50:09 AM |
Total Post: 16
Joined: Jun, 2008
|
Hi All,
When i open the database after restoration it showing the following error after mount state:
ORA-01113 : file1 needs media recovery
ORA-01110: datafile 1: '/ora9205/oradata/XGLIV925/system01.dbf'
i have run the following commands for recover datafile:
1. startup nomount pfile=/oracle/app/product/9205/dbs/initXGLIV925.ora
2. alter database mount;
3. recover database
after follow the above steps it show the following error:
ORA-03113 : end of file on communication channel.
but when i recover individual file from the command:
recover datafile=/ora9205/oradata/XGLIV925/system01.dbf
and after that open database it show again the following error for each and every datafiles.
ORA-01113 : file 2 needs media recovery
ORA-01110:datafile 2: '/ora9205/oradata/XGLIV925/cwmlite01.dbf'
PLEASE GIVE ME SOLUTION ASAP.
THANKS IN ADVANCE
|
|
|
 chai |
| Posted: Aug 18, 2008 12:52:25 AM |  |
|
Total Post: 221
Joined: Jul, 2008
|
|
|
|
|
| tarun |
| Posted: Aug 18, 2008 11:03:59 AM | |
|
Total Post: 16
Joined: Jun, 2008
|
Hi Chai
It is a system file and it is DR server so we performe restoration from LTO BACKUP TAPE daily .
|
|
|
|
|
| chai |
| Posted: Aug 19, 2008 01:25:26 AM | |
|
Total Post: 221
Joined: Jul, 2008
|
Hello Tarun,
You have opened the database in nomount phase. I think because of it, it is showing error for all database files.
Sorry to say that i dont know much about LTO BACKUP TAPE.
|
|
|
|
|
| MOH_DBA |
| Posted: Aug 30, 2008 02:27:45 AM | |
|
Total Post: 186
Joined: Nov, 2007
|
it seem that your system tablespace need recovery. did you restore your the system tablespace from your backup and issue recovery, you need to restore your system tablespace from the backup, what backup you are using rman or physical backup (hot or cold)?
|
|
|
|
|
| tarun |
| Posted: Aug 30, 2008 11:00:46 AM | |
|
Total Post: 16
Joined: Jun, 2008
|
Dear Sir,
this is DR SERVER(Disaster Recovery Server)and restoration is taken on daily basis from DLT/LTO backup tape.this tape contain all datafiles including system datafile,control file and redo logfile also.
but after fresh restoration it again show the error ora-01113 and ora-01110 after mount state.and restoration is taken after shutddown the database.
SERVER OS: AIX5L
DATABASE : ORACLE9i
|
|
|
|
|
| MOH_DBA |
| Posted: Sep 01, 2008 12:50:15 PM | |
|
Total Post: 186
Joined: Nov, 2007
|
did you mean that backups are taken into DLT/LTO backup tape, after the database has been shutdown? in other words, you shutdown your database, take a backup of it to tape, right?
|
|
|
|
|
| tarun |
| Posted: Sep 03, 2008 11:12:47 AM | |
|
Total Post: 16
Joined: Jun, 2008
|
Dear Sir,
yes and please send me the solution how to recover from LTO tape.
THANKS
|
|
|
|
|
| MOH_DBA |
| Posted: Sep 03, 2008 11:51:58 AM | |
|
Total Post: 186
Joined: Nov, 2007
|
If you take your backup as i mentioned, then you are using cold backup.
in this case you need to restore the whole database from the tape, meaning:
You need to restore the data file, control file and redo log files. and the database will not need any recovery, just shutdown databsae and replace the whole database from your tape to the one on the disk and then start it up, just that, no need to recover. and the database will be sinsce your last backup, not last commit.
http://www.pafumi.net/backup_recovery_information.htm#Offline_or_Cold_Backup
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
