restore or create controlfile

[maswien]

I'm testing RMAN with oracle netbackup client. I deleted all the datafiles as well as the control files. Then I wasn't able to restore the database from RMAN, because the database should be in mount mode to start restore.

so I wanted to create controlfiles, it seems I can't create control files from the trace file I got from "alter database backup controlfile to trace;" because there are no datafiles any more.

Any idea ?

Thanks in advance.

 

[LKBrwnDBA]

1) Restore the backup files from tape.
2) Recover the controlfiles from the backup:

STARTUP NOMOUNT PFILE=init.ora;
RUN {
 ALLOCATE CHANNEL CH1 TYPE DISK;
 SET UNTIL SEQUENCE=1234 THREAD=1;
 RESTORE CONTROLFILE;
}
SQL ‘ALTER DATABASE MOUNT’;
...etc...

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[maswien]

Thank you LKBrwnDBA!

I will give it a try.