Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: backup Oracle controlfile

Re: backup Oracle controlfile

From: Masafumi Hikawa <mhikawa_at_wbs.jp>
Date: Fri, 5 Apr 2002 14:58:42 +0900
Message-ID: <a8jeej$s3v$1@mail.wbs.ne.jp>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US