| RMAN...can not restore or recover tablespace [message #72315] |
Mon, 12 May 2003 10:22 |
Anson Abraham
Messages: 2
Registered: May 2003
|
Junior Member |
|
|
Using 9.2.0.1 archivelogmode, under win2k env.
There are daily incremental and weekly full early morning backups. The 7th was the full backup, and the 8th was the daily incremental. The tablespace users consisted of three datafiles. One of the datafiles was taken offline by the database. So on that day of failure:
-I took tablespace users offline.
-Then tried restoring datafile users02.dbf;
:Came back with an error. Saying that the RMAN file was not there.(RMAN backing by control file).
-Had to wait next day for tape to restore that file to server.
-Forgot about scheduled task, that ran RMAN. So another daily incremental backup was done on the 9th.
-Unfortunately the days had passed, and there was a 12-MAY-03 incremental backup.
-So when I got all those files into the directory RMAN was looking for:
-Restore tablespace users until time '08-MAY-03';
It's starting to restore from most recent backup. So i.e. today it would say
>Starting restore at 12-May-03
>Failure of restore command at 5/12/2003 time.
>Some targets not found - aborting restore
>No backup or copy of datafile 12 found to restore.
>No backup or copy of datafile 11 found to restore.
>No backup or copy of datafile 9 found to restore.
So I try a restore of datafile:
-Restore datafile 'path/users02/dbf' until time '08-MAY-03';
>Starting restore at 12-May-03
>Failure of restore command at 5/12/2003
>Some targets not found - aborting restore
>No backup or copy of datafile 11 found to restore.
So now have no idea what to do.
Tried
-Alter database mount; or startup mount;
-Restore database until time '07-MAY-03';
Error still getting datafiles not found.
I'm very new/fresh to RMAN, so forgive my interpretation. RMAN creates a trace file, a control file, and some other file(which I think might be a compression of the datafiles).
I still can't figure as to why I couldn't restore tablespace for '08-MAY-03' I know, I should have shut off RMAN at that point, when file wasn't existing, and tablespace was offline. But I wasn't aware that a task schedule was setup through windows to run RMAN. Now caught in a bind.
Help would be really appreciated here. If anyone has been in the situation before, may I ask how you resolved it?
Thank You
Anson Abraham
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
