| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: questiones
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:t8gdh6iqemgi5d_at_beta-news.demon.nl...
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3a87d812_at_news.iprimus.com.au...
> >
> > <alexberi_at_my-deja.com> wrote in message
news:968i2e$q0c$1_at_nnrp1.deja.com...
> > > In article <968gv9$p7t$1_at_nnrp1.deja.com>,
> > > sybrandb_at_my-deja.com wrote:
> > > > In article <968fie$o9o$1_at_nnrp1.deja.com>,
> > > > alexberi_at_my-deja.com wrote:
> > > > >
> > > > >
> > > > > Hi,
> > > > > I have some simple questions, but I couldn't find the answers by
now:
> > > > > -How can I see if I use o password file and where it is?
> > > > > -For a COLD backup of whole database, do I need to backup Redo
Logs?
> > > > > -When I want to delete some old ArchiveLog files, how do I delete
> > > > > references to them from Control File and RMAN recovery catalog?
> > > > > -Finaly, where I find the Alert Log?
> > > > >
> > > > > Thx, Alex.
> > > > >
> > > > > Sent via Deja.com
> > > > > http://www.deja.com/
> > > > >
> > > > 1 As you don't mention your platform this is a bit difficult to
answer.
> > > > The default for Unix is $ORACLE_HOME/dbs/orapw<SID>
> > > > You always use a password file
> > > > 2 yes.
> > >
> > > But I don't understand why, shoudn't be no uncommited transactions in
a
> > > normal closed database.
> > >
> >
> > What has that got to do with backing up the Redo Logs? The rules are
that
> > you don't precisely *need* to backup your redo logs if you've shut the
> > database down in a clean fashion, precisely because there can, in that
> > situation, be no uncommitted transactions in the datafiles (try and be
more
> > precise -a database comprises datafiles, control files AND the redo
logs).
> >
> > Nevertheless, most people backup cold because they are in noarchivelog
mode.
> > In that case, being able to restore consistent images of the redo logs
as
> > they were at the time of last night's backup makes things one hell of a
lot
> > easier.
> >
> > If you are doing cold backups in archivelog mode, then (as I posted
> > earlier), my advice remains NOT to backup the redo logs -there are too
many
> > examples of casual restoration of such redo logs -on top of perfectly
good
> > copies of the online logs which are needed for complete recovery.
> >
> > > > 3 Obviously you can delete old archivelog files only *after* a
> > > > cold,consistent backup, and after a separate backup during your
> > > > hotbackup. You should not manipulate the controlfile nor RMAN as the
> > > > software is already taking into account which archivelogs it needs
and
> > >
> > > Why do I need another hotbackup besides the COLD one, and what sould I
> > > backup in this one? Archivelogs?
> >
> > Yes, I'm not entirely clear what Sybrand is getting at here, but I've no
> > doubt the explanation will be forthcoming. Myself, I think it sounds
> > horribly confused: either you have opted to do cold backups, or you have
> > gone the hot route. Whatever: it really doesn't matter. Provided you
> > retain all archives since the start of the last complete backup of
whatever
> > nature, you will be OK.
> >
> > > Have this anything to do with having more copies of the backup?
> >
> > Don't understand the question, and don't get yourself confused. If you
are
> > worried about duplexing (or quintuplexing your archivelogs) then fair
> > enough: archives are *sooooo* important, it makes sense to ensure that
there
> > are multiple copies of them floating around.
> >
> > >
> > > > which it doesn't. Manipulating the controlfile or the RMAN catalog
> > > > yourself is one of the most efficient Career Limiting Moves (tm)
> > >
> > > Hahahah, this is a good one!! You did register the mark:).
> > >
> > > > 4 The alert is by design in the background_dump_dest directory.
> > > >
> > > > Hth,
> > > >
> > > > --
> > > > Sybrand Bakker, Oracle DBA
> > > >
> > > > All standard disclaimers apply
> > >
No, I think it was me. You're saying that archives are so important, they need backing up too. Absolutely agreed. And you're right that in RMAN, for example, it must be a separate backup job from the database backup to do the deed (though the two jobs can be contained within the one script) (in other words, you'll end up with two separate backup sets).
True, true.
Best Regards
HJR
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Tue Feb 13 2001 - 00:56:57 CST
 |
 |