| I can't restore controlfile with set until [message #57787] |
Tue, 08 July 2003 00:01 |
bahman mirhosseini
Messages: 3
Registered: June 2003
|
Junior Member |
|
|
hello :
i'm bahman mirhosseini from iran.
i'm working oracle9i on windows 2000 os without recovery catalog;
when i use 'restore controlfile' command without 'set until' rman use the
most recent autobackup of control file according my bellow code:
run
{
set controlfile autobackup format for device type disk to 'f:/oracle/oradata/backup/bc/cf_%F';
restore controlfile from autobackup ;
}
but when i don't want to restore from most recent controlfile backup and i use 'set until' this error happens :
'rma-01507 : database not mounted' ,
according my bellow code .
run
{
SET UNTIL TIME ='date_string' # or sequence 11 thread=1
set controlfile autobackup format for device type disk to 'f:/oracle/oradata/backup/bc/cf_%F';
restore controlfile from autobackup ;
}
but we know that database should be in nomounted status for restore controlfile .
my email is b_mirh2000@yahoo.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
