ADSM-L

EBU/ADSM & Online Redologs

1998-12-16 11:40:02
Subject: EBU/ADSM & Online Redologs
From: Thiha Than <thiha AT US.IBM DOT COM>
Date: Wed, 16 Dec 1998 09:40:02 -0700
hi,

I don't think EBU backup the redo logs.  You might have to use b/a client
to backup the redo log files.

regards,
Thiha

> Malkit,

>    Thanks for our response.

>    However, what I'm talking about are the online redo logs, not the
>archived logs.  The database I'm backing up is not running in archivelog
>mode, so there are no archivelogs to backup, and recovery is not an
option.

>    After running "restore", the database should come back up , after a
>"backup offline database" .  What I'm looking for is some indication that
>the online redologs are being backed up  during an offline backup.  This
is
>a requirement for offline backups.

>    Any ideas?

>    Again, thanks.

>    David
        -----Original Message-----
        From: malkit [mailto:malkit AT udi.co DOT il]
        Sent: Monday, December 14, 1998 4:47 AM
        To: dcgreig AT mindspring DOT com
        Cc: ADSM-L AT VM.MARIST DOT EDU
        Subject: Re: EBU/ADSM & Online Redologs


        David,
        An offline backup consisits the archived redo logs unless you
choose
not to backup them (using the 'archivelog=none' in the EBU script). EBU
backs up the archived redo logs during both online and offline backups. EBU
identifies the archive redo logs by quering the target DB  for the current
LOG_ARCHIVE_DEST location specified in initSID.ora.

        Did you use the recover option with the EBU script ? the recover
perform a recover of the DB after the DB restore.

        --
        Regards

        Malkit Hayun , UDI
        Application Engineer
        Office:972-3-9233440
        Fax:   972-3-9233441
        Mobile:972-52-834575
        Email: malkit AT udi.co DOT il

        ----------------------------------------
        David C. Greig wrote:

             I have some concerns about restores using EBU from offline
backups.  We're running EBU and the ADSMConnect Agent to do offline backups
of an Oracle database.  In the EBU script, we're doing a "backup offline
database".  However, it looks like, in the logs, that the online redologs
are not being backed up.  This is obviously a requirement of performing
offline backups, and I'm a little confused about this.We've done some
restore testing on this.  After an offline backup, we removed both copies
of
the control and performed a restore and were able to bring up the database.
We then remove several database files, including the system tablespace, and
performed a restore.  The database came up cleanly.  We left the database
up
for a while, then shut it down and ran another restore.  When we tried to
start it, we got an error about one of the redologs being newer than the
control file.  It appeared that EBU had not restored the online redo's.How
are online redologs backed up via EBU?  This is particularly a concern if
we
are doing complete restores from scratch.Info:AIX v4.2Oracle v7.3.3EBU
2.2.0.5ADSMConnect Agent 2.1.0.7ADSM Server 3.1.2.0Thanks,David
____________________________________________________
            David C. Greig
            IBM Certified Specialist - ADSM
            Mainstar Software Corporation
            Storage and Recovery Solutions
            http://www.mainstar.com
            PGP: http://dgreig.home.mindspring.com/pgp.html
<Prev in Thread] Current Thread [Next in Thread>