-
Datafile recovery -- Urgent
The status of the datafile is RECOVER, I have flash back recovery enable.
In my 1.6 yrs carear this is the first time, I never recover the datafile, there are three datafiles for the tablespace. But all of the important objects of the schema is stored in that tablespace
Need guidance to recover.
-
Supply following info
1. database archive log or noarchive log mode
2. What kind of backups you have RMAN or others. to tape or disk. What is the latest backuo
3. How many data files in recover mode
4. Database version
5. Do you have all the archive logs after the last backup of the lost data files.
-
The database is in Archive Log Mode, only one Datafile is in Recovery mode, the last backup is of 21-Jul-2006. I have archive logs after the last backup. The backup is taken through RMAN to disk
The version of Database is 10gr2.
Is it possible to recover only specific datafile, without effecting the other?
-
1. identify the FILE_ID of the lost datafile
2. Start rman
3. RMAN> restore datafile file_id;
4. RMAN> recover datafile file_id;
If should recover the datafile if all the archive logs are available.
-
Is it all, the fileid is 10
Should I wait for senior DBA, or if it is all then I will go through it.
Waiting for ur valuable input.
Thanks
-
If you have a Sr. DBA.. definitely talk him before you do anything.
-
just offline the tablespace and recover the tablespace
-
dear pando do u mean to recover the entire tablespace or a specifc datafile, after making the tablespace offline?
HTML Code:
According to Thomasps
1. identify the FILE_ID of the lost datafile
2. Start rman
3. RMAN> restore datafile file_id;
4. RMAN> recover datafile file_id;
-
alter tablespace x offline
recover tablespace x
alter tablespace x online
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|