Hi
Hmm can you just substitute the set until date format temporarily with SCN values and check if we can restore the control files.
(note for restoring this way you have a catalog configured)
somethin like
set until sequence
regards
Hrishy
Printable View
Hi
Hmm can you just substitute the set until date format temporarily with SCN values and check if we can restore the control files.
(note for restoring this way you have a catalog configured)
somethin like
set until sequence
regards
Hrishy
Hi
I tested this and it works for me.I do not have a catalog so i have configured a snapshot controlfile to on.
I first did a backup of my database and then tried restoring the controlfile.
Code:run {
set until time "to_date('08-07-2005 18:58:00','dd-mm-yyyy hh24:mi:ss')";
restore controlfile to '/tmp/control01.ctl';
}
executing command: SET until clause
Starting restore at 08-JUL-05
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring controlfile
output filename=/tmp/control01.ctl
channel ORA_DISK_1: restored backup piece 1
piece handle=/xxxxx/app/oracle/product/9.2.0.4.0/dbs/c-3446257643-20050708-01 tag=null params=NUL
L
channel ORA_DISK_1: restore complete
Finished restore at 08-JUL-05
cd /tmp
ls -ltr
-rw-r----- 1 oracle dba 6676480 Jul 8 18:59 control01.ctl
regards
Hrishy
Hi
The controlfile is autobackup or manually? :rolleyes:
Hi
I am not using a catalog .So for me to restore the controlfile i am using a autobackup.
regards
Hrishy
Hi
I am not using a catalog too. I have autobackup the controlfile too, but i am still encountering error... :confused:
I have listed the backup to ensure that the controlfile has been backup:
Starting Control File and SPFILE Autobackup at 14-JUL-05
piece handle=/oracle/app/product/9204/dbs/c-2272111974-20050714-02 comment=NONE
Finished Control File and SPFILE Autobackup at 14-JUL-05
Then I tried to restore the controlfile and I got the following error:
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the controlfile found to restore
Any help please??
Hi
Can you try this whole excersise again.
create a tablespace
Please take a complete backup of your database with the controlfiel backup set to auto
drop the tablespace
and now restore the controlfile which was backed up above.
I am asking you this becoz atleast this time its saying the controlfile was not found.
regards
Hrishy
Hi Hrishy
It was my mistake for the error as the controlfile cannot be overwritten which resulted in the error message the controlfile was not found! :o
Anyway I have restored the controlfile and overwrite my current control file. I brought down the db and startup mount. I did a restore and recover database before opening the database with resetlogs. I can see from the messages that my deleted tablespace has been restored.
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00011 to /oracle/oradata/test.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/t563728056_s127_p1 tag=TAG20050715T150736 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 15-JUL-05
However when i did a query on dba_tablespaces, I did not see the tablespace that I have deleted. Why? :confused: :confused:
Hi Mooks
what about v$datafile does that show you the file associated with the tablespace.
what about v$tablespace
regards
Hrishy
Hi Hrishy
I have checked those tables too, they do not reflect my dropped tablespace has been restored. :confused:
Hi Mooks
Well i suggest that you carry out this test once again a fresh and if you are able to reproduce this then i assume its a bug and probably time to raise a TAR with oracle :-)
regards
Hrishy