DanBrother的部落格

Solving ORA-01180: can not create datafile When restoring DB for ASM disk files

sqlplus / as sysdba
SQL> startup nomount;
SQL> exit

$ rman target / nocatalog
RMAN> run{
delete noprompt archivelog all;
change archivelog all crosscheck;
shutdown immediate;
startup nomount;
allocate channel t1 type disk;
allocate channel t2 type disk;
restore controlfile from '/backup/2011-08-04/testdb/CTRL/control.bk';
alter database mount;
catalog start with '/backup/2011-08-04/testdb';
restore database;
recover database;
release channel t1;
release channel t2;
}

alter database open resetlogs;