REPOST: Re: Online Backup Doubt

Hi,

The trace file is useful in the case of cold backup. Is it corrct?

">> I'd be interested to know how you *know* the backup is invalid."

I tested the backup by restoring it.

Tx
Augustine

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<3c2e3cbd$0$5269$afc38c87_at_news.optusnet.com.au>...
> Comments below
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Augustine Joseph" <kunjaathi_at_hotmail.com> wrote in message
> news:bde72cc6.0112282014.40efabf3_at_posting.google.com...
> > Hi,
> >
> > 1) For online backup is it mandatory that the 'backup controlfile' be
> > executed at the end of the backup process. I mean after all the
> > tablespacess are backed up.
> >
>
> Nothing is "mandatory". It's up to you whether you want a backup of your
> control file -which happens to be just as an intrinsic part of your database
> as the datafile/tablespaces you've carefully backed up. Commonsense would
> suggest that you *should* take a backup of it, though whther that's a binary
> backup or atrace file backup is more open to discussion. Personally, I'd
> recommend nightly trace file backups and weekly binary ones. The point
> being is that the trace file version is an extremely easy way of recovering
> from total controlfile loss, but the binary version is useful if a
> tablespace ever gets dropped.
>
> > 2) I've this statement in my unix script(Solaris)
> >
> > Alter tablespace AJAPP begin backup;
> > host`cp /u01/datafiles/db/aj.dbf /bkp/datafiles/aj/aj.dbf`
> > Alter tablespace AJAPP end backup;
> >
> > does the oracle waits the copy to be completed before proceeds with
> > the 'alter' statement.
>
> I rather think it depends on Unix. Al I can tell you is that, on Windows
> 2000, if you have a SQL script containing the lines...
>
> alter tablespace system begin backup;
> host copy d:\oracle\oradata\db2\system01.dbf d:\backup1.dbf
> alter tablespace system end backup;
>
> ...then SQL Plus performs the actions synchronously, waiting for each one to
> finish before moving on to the next (meaning the backup is useful and
> valid). I can't comment as to whether Solaris works the same way -though
> it's not difficult to knock up a three-line script and then run it within
> SQL Plus and watch to see what happens. If this is a *shell* script you're
> running, and not a SQL script, someone who knows the O/S will have to
> comment.
>
> >I'm getting invalid online backup. My doubt is
> > here.
> >
>
> I'd be interested to know how you *know* the backup is invalid.
>
> Regards
> HJR
>
>
>
> > If i come out of oracle(svrmgrl) after alter begin statement and does
> > a OS copy, backup is valid.
> >
> > Any ideas?
> >
> > Thanks
> > Augusitne

• WAS CANCELLED BY =======: Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: kunjaathi_at_hotmail.com (Augustine Joseph) Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <bde72cc6.0112292010.6a9c3b00_at_posting.google.com> Control: cancel <bde72cc6.0112292010.6a9c3b00_at_posting.google.com> Date: Mon, 31 Dec 2001 06:43:18 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.bde72cc6.0112292010.6a9c3b00_at_posting.google.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788901 26548 166.102.15.34 (31 Dec 2001 08:55:01 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:55:01 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Sat Dec 29 2001 - 22:10:43 CST