Re: Disabling Redo Logs

curtm_at_ix.netcom.com wrote:
>
> In article <33290FC1.64EF_at_spam.bibip1.wgw.bt.co.uk>,
> Colin Polykett <polyketc_at_spam.bibip1.wgw.bt.co.uk> wrote:
> >
> > Step 1 : Edit your init.ora file.
> > Step 2 : Include the line (without quotes) : "_disable_logging=true"
> > Step 3 : Claim your pay rise for the performance increase in your
> > database.
> > Step 4 : If anyone needs to recover anything.....go off sick/deny all
> > knowledge.
> >
> > Health Warning : Using "_disable_logging" can seriously damage your
> > database.
> >
> > ------------------------------------------------------------
> > These views are mine, all mine.
> >
> > Colin Polykett polyketc_at_bibip1.wgw.bt.co.uk
> > Open Systems ORACLE DBA
>
> The _disable_logging=true in init.ora does'nt seem to work. Here's
> what I'm trying to do: First I make a full export on server A, then
> move the export file to server B. On server B, add the line
> _disable_logging=true to init.ora. Create a blank database, and start
> the import. When I check the ALRT.LOG trace logs, I see that
> there it's still switching redo logs, and the size and timestamp
> of the redo logs indicate that redo is still being generated. Also
> the rollback segs are growing. I would like to turn off,
> both rollback and redo (not just archiving redo) temporarily for the
> import, and then set everything back to normal. Is there an easy
> way to do this ??

You still are in archive log mode

So what you do is :

1. use the underbar
2. startup mount
   • alter database noarchivelog
   • open the db
3. load the data nohup can help reduce the disaster rate
4. shutdown immediate
5. cycle through ALL on-line redo by manualy switching the logfiles
6. put the db back in archivelog
7. hot backup
8. let users log on

Worse comes to worse - rebuild the db from the create db script

Cheers,

Brian Murphy Received on Mon Mar 17 1997 - 00:00:00 CST