Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: backup Oracle controlfile
Alex,
Thanks your help.
I understood how to recover database.
Case1. When I recover database with text backup file of control file,
I can use "$ svrmgrl < rebuild.sql".
Case2. When I recover database with binary backup file of control file,
I can use the follwing commands.
$ svrmgrl SVRMGRL> connect internal; Connected. SVRMGRL> alter database datafile 'backup.controlfile'
Regards,
Masafumi Hikawa
"Alex Ivascu" <alexdivascu_at_yahoo.com> wrote in message
news:1qar8.13621$071.2872061_at_typhoon1.we.ipsvc.net...
> It depends on what kind of a BACKUP/RECOVERY solution you have
implemented.
>
> Alex Ivascu
> DBA
>
>
> "Masafumi Hikawa" <mhikawa_at_wbs.jp> wrote in message
> news:a8j9qu$lo$1_at_mail.wbs.ne.jp...
> > Hi,
> >
> > I back up Oracle control files that are binary and text.
> >
> > Those backup files are generated by the following commands.
> >
> > alter database backup controlfile to 'backup.controlfile';
> > alter database backup controlfile to trace;
> >
> > Please tell me how to use those file when I recover database.
> >
> > Regards,
> > Masafumi Hikawa
> >
> >
>
>
Received on Thu Apr 04 2002 - 23:58:42 CST
![]() |
![]() |