I have a couple of comments for you on your scripts. First make sure you "TAG"
your backups so that you can use a "FROM TAG" when restoring. Make sure you
only allocate one type of channel on your restore script, not both disk and
tape. I have a few questions also. Is your databases in archivelog mode? Do
you resync your catalog manually?
Tom Tyson
Exodus Communications, Inc.
- cemail_at_sprintmail.com wrote:
>
> I am confused about how Recovery Manager works with Media Management
> software.
>
> I am using Recovery Manager with Recovery Catalog and Veritos.
> Suppose I am running hot backups and then shut down the database
> and do a cold backup. Then I want to do a test restore from
> a hot backup, how can I know that what is put back on disk is
> from the hot backup and not the cold backup?
>
> To do the hot backup, I am doing something like this:
>
> Run {
> Allocate channel t1 type ‘SBT_TAPE’;
> Backup full
> Fileperset 2
> Format ‘RIGNS_full.%n.%s.%p’
> (database);
>
> To restore the database, I want to do something like this:
>
> Run {
> Allocate channel t1 type ‘SBT_TAPE’;
> Allocate channel d1 type disk;
>
> Restore controlfile to
> ‘/disk1/oradata/RIGNS/control01.ctl
> replicate controlfile
> from ‘disk1/oradata/RIGNS/control01.ctl’;
> sql ‘alter database mount’;
> restore (database);
> recover database;
> sql ‘alter database open’;
> }
>
>
>
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --
> Author:
> INET: cemail_at_sprintmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
Received on Wed Aug 30 2000 - 08:57:59 CDT
