Problems with RESET DATABASE
Recently I wanted to do RESET DATABASE. Oracle documentation suggests the following commands
connect target /
startup force nomount
reset database to incarnation 2
run {
set until time "date time"
restore controlfile from autobackup
alter database mount
restore database
recover database
}
alter database open resetlogs
In this view my db has given error: db not mounted. I haven't recovery catalog. So I changed: startup force mount.
Command reset database to incarnation 2 has given a result. But the command restore controlfile from autobackup
has given an error: need to use clause TO in mount or open mode. Then I put the command startup force nomount
before the command restore controlfile from autobackup. At this time rman has given an error: db not mounted.
I don't know in what work is. Please help me !
Best
kindman