**

Rman backups are complex enough that I can say you haven't supplied
enough information. What version of Oracle? Rman in 8.0.5 had a bug
that could only be fixed by upgrading to 8.0.6. Is your database in
archivelog mode? I asume it is but you didn't say. Most importantly,
are you using a database catalog or just the control files? Some
restores will not work without a catalog database and in all cases, it
is easier (but maybe more confusing) to restore from the catalog.

You might consider the Oracle class on rman. It is pretty complicated.
At least pay $50 bucks and get a book. You downloaded the pdf covering
your version of rman from the Oracle web site, correct? If not, do that
now and read it. It might shed some light.


Dana Bourgeois

> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Oertel, F
> Sent: Thursday, April 18, 2002 7:17 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: [ARSLIST] AW: remedy/oracle backups/restore
>
>
> **
>
> Hi,
>
> which problems you have?
> When backing up an ARS-DB online, you have to ensure
> transactional integrity. That means you have to backup the
> entire db in one transaction, otherwise you may run into
> trouble, for example with entry ids. When performing your
> backup using the exp tool you should specify CONSISTENT=Y.
> But keep in mind that (for large dbs) this will blow up your
> redo logs.
> I never had any problems backing up dbs with the imp/exp tools.
>
> Frank
>
> -----Ursprungliche Nachricht-----
> Von: KOSOSKI, RAYMOND S (ASI) [mailto:rk5686@SBC.COM]
> Gesendet: Donnerstag, 18. April 2002 15:28
> An: ARSLIST@LISTSERV.VISTAIT.COM
> Betreff: remedy/oracle backups/restore
>
>
> **
>
> does anybody out there use RMAN to backup remedy's oracle
> database? i have been able to perform a 'hot' oracle backup
> using RMAN, but i am having problems with restore. was
> wondering if anybody has any procedures to do a full remedy
> (oracle) database restore? thanks!
>
> Raymond S. Kososki
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com You may also control your
> subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com You may also control your
> subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
>

**

the version of oracle is 8.1.6; i have set up archive logging and a catalog.
what was happening was i was simply trying to restore the whole database
with the rman command (per the O'Reilly Oracle RMAN Pocket Reference):

run {
allocate channel d1 type disk;
restore database;
recover database;
}

and got various errors: if the database is shutdown and restarted with
'startup nomount', it complains the catalog database is not available. if i
use a 'startup mount', it says that oracle is initializing - and lets me got
no further (even after waiting for a long period of time for it to
initialize). if i use 'startup', i cannot get an exclusive enqueue.

what i ended up doing in rman was:

sql 'alter tablespace X offline';
run {
allocate channel d1 type disk;
restore tablespace X;
recover tablespace X;
}
sql 'alter tablespace X online';

and was able to restore all tablespaces except SYSTEM, RBS and CATALOG, so i
think i can use the tablespace version of the restore in rman and get the
remedy data back, if i had to. i still would like to run the
restore/recover database command, but my work-around will do for now -

-----Original Message-----
From: Dana Bourgeois [mailto:kunda1@TELOCITY.COM]
Sent: Thursday, April 18, 2002 2:25 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: AW: remedy/oracle backups/restore


**

Rman backups are complex enough that I can say you haven't supplied
enough information. What version of Oracle? Rman in 8.0.5 had a bug
that could only be fixed by upgrading to 8.0.6. Is your database in
archivelog mode? I asume it is but you didn't say. Most importantly,
are you using a database catalog or just the control files? Some
restores will not work without a catalog database and in all cases, it
is easier (but maybe more confusing) to restore from the catalog.

You might consider the Oracle class on rman. It is pretty complicated.
At least pay $50 bucks and get a book. You downloaded the pdf covering
your version of rman from the Oracle web site, correct? If not, do that
now and read it. It might shed some light.


Dana Bourgeois

> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Oertel, F
> Sent: Thursday, April 18, 2002 7:17 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: [ARSLIST] AW: remedy/oracle backups/restore
>
>
> **
>
> Hi,
>
> which problems you have?
> When backing up an ARS-DB online, you have to ensure
> transactional integrity. That means you have to backup the
> entire db in one transaction, otherwise you may run into
> trouble, for example with entry ids. When performing your
> backup using the exp tool you should specify CONSISTENT=Y.
> But keep in mind that (for large dbs) this will blow up your
> redo logs.
> I never had any problems backing up dbs with the imp/exp tools.
>
> Frank
>
> -----Ursprungliche Nachricht-----
> Von: KOSOSKI, RAYMOND S (ASI) [mailto:rk5686@SBC.COM]
> Gesendet: Donnerstag, 18. April 2002 15:28
> An: ARSLIST@LISTSERV.VISTAIT.COM
> Betreff: remedy/oracle backups/restore
>
>
> **
>
> does anybody out there use RMAN to backup remedy's oracle
> database? i have been able to perform a 'hot' oracle backup
> using RMAN, but i am having problems with restore. was
> wondering if anybody has any procedures to do a full remedy
> (oracle) database restore? thanks!
>
> Raymond S. Kososki
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com You may also control your
> subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com You may also control your
> subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
>



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

OK, so you have an example of trying something reasonable and symptoms
of it not working. Now call up Oracle under your support contract and
work with them on it. They should be able to tell you how to get a
readout on your ORA errors and whether your problems are related to
bugs, needed patches plus sanity check that your restore technique
should work. They won't set up the script for you but if you have
specific questions about the docs or about how it behaves when you try
to "..." then they will probably help you with it.

No support? You better buy a day or two of consultant time.

Is your catalog in its own instance? I mean, you're not using the
backed up database as the catalog database, are you? I didn't think you
could configure it that way but it sure sounds like it the kind of
problem you'd have if the same instance is trying to restore itself.
You really should have at least two databases when using rman with
catalog. The rman catalog database is small - the default install is
fine. You can run it noarchivelog mode and just shut it down before
doing a file backup of the machine. Better would be to have two
database machines each acting as the catalog for the other. This,
naturally, would double your cost if you don't have any other need for a
second host with Oracle licenses.

Maybe you want to go back to Oracle 7 style tablespace hot backup mode
and just copy database files to free disk space. That is fast compared
to tape, works well, and the target disk can be mirrored for redudancy
then striped for performance and the files can then be pushed to tape at
your leisure after the database is back up. A lot of the bigger
installations do exactly this for exactly all the reasons above and to
avoid the kind of issues you're having.

Sorry I'm not giving you more explicit advice.


Dana Bourgeois

> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of KOSOSKI,
> RAYMOND S (ASI)
> Sent: Thursday, April 18, 2002 2:41 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: [ARSLIST] AW: remedy/oracle backups/restore
>
>
> **
>
> the version of oracle is 8.1.6; i have set up archive logging
> and a catalog. what was happening was i was simply trying to
> restore the whole database with the rman command (per the
> O'Reilly Oracle RMAN Pocket Reference):
>
> run {
> allocate channel d1 type disk;
> restore database;
> recover database;
> }
>
> and got various errors: if the database is shutdown and
> restarted with 'startup nomount', it complains the catalog
> database is not available. if i use a 'startup mount', it
> says that oracle is initializing - and lets me got no further
> (even after waiting for a long period of time for it to
> initialize). if i use 'startup', i cannot get an exclusive enqueue.
>
> what i ended up doing in rman was:
>
> sql 'alter tablespace X offline';
> run {
> allocate channel d1 type disk;
> restore tablespace X;
> recover tablespace X;
> }
> sql 'alter tablespace X online';
>
> and was able to restore all tablespaces except SYSTEM, RBS
> and CATALOG, so i think i can use the tablespace version of
> the restore in rman and get the remedy data back, if i had
> to. i still would like to run the restore/recover database
> command, but my work-around will do for now -
>
> -----Original Message-----
> From: Dana Bourgeois [mailto:kunda1@TELOCITY.COM]
> Sent: Thursday, April 18, 2002 2:25 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: AW: remedy/oracle backups/restore
>
>
> **
>
> Rman backups are complex enough that I can say you haven't
> supplied enough information. What version of Oracle? Rman
> in 8.0.5 had a bug that could only be fixed by upgrading to
> 8.0.6. Is your database in archivelog mode? I asume it is
> but you didn't say. Most importantly, are you using a
> database catalog or just the control files? Some restores
> will not work without a catalog database and in all cases, it
> is easier (but maybe more confusing) to restore from the catalog.
>
> You might consider the Oracle class on rman. It is pretty
> complicated. At least pay $50 bucks and get a book. You
> downloaded the pdf covering your version of rman from the
> Oracle web site, correct? If not, do that now and read it.
> It might shed some light.
>
>
> Dana Bourgeois
>
> > -----Original Message-----
> > From: Action Request System discussion list(ARSList)
> > [mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Oertel, F
> > Sent: Thursday, April 18, 2002 7:17 AM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: [ARSLIST] AW: remedy/oracle backups/restore
> >
> >
> > **
> >
> > Hi,
> >
> > which problems you have?
> > When backing up an ARS-DB online, you have to ensure
> > transactional integrity. That means you have to backup the
> > entire db in one transaction, otherwise you may run into
> > trouble, for example with entry ids. When performing your
> > backup using the exp tool you should specify CONSISTENT=Y.
> > But keep in mind that (for large dbs) this will blow up your
> > redo logs.
> > I never had any problems backing up dbs with the imp/exp tools.
> >
> > Frank
> >
> > -----Ursprungliche Nachricht-----
> > Von: KOSOSKI, RAYMOND S (ASI) [mailto:rk5686@SBC.COM]
> > Gesendet: Donnerstag, 18. April 2002 15:28
> > An: ARSLIST@LISTSERV.VISTAIT.COM
> > Betreff: remedy/oracle backups/restore
> >
> >
> > **
> >
> > does anybody out there use RMAN to backup remedy's oracle
> > database? i have been able to perform a 'hot' oracle backup
> > using RMAN, but i am having problems with restore. was
> > wondering if anybody has any procedures to do a full remedy
> > (oracle) database restore? thanks!
> >
> > Raymond S. Kososki
> >
> >
> >
> > To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> > listserv@listserv.vistait.com You may also control your
> > subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
> >
> >
> >
> > To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> > listserv@listserv.vistait.com You may also control your
> > subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
> >
>
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com
> You may also control your subscription options, including
> UNSUBSCRIBE, at
> www.ARSLIST.org
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com
> You may also control your subscription options, including
> UNSUBSCRIBE, at www.ARSLIST.org
>

**

-----Original Message-----
From: Pham, Tuan
Sent: Wednesday, April 24, 2002 3:59 PM
To: Butera, Joe C
Subject: RE: AW: remedy/oracle backups/restore


You can user RMAN without catalog by:
startup database nomount (with existing control files, of course)
rman target username/password nocatalog
and run your scripts:

run {
> allocate channel d1 type disk;
> restore database;
> recover database;
> }


-----Original Message-----
From: Butera, Joe C
Sent: Wednesday, April 24, 2002 11:23 AM
To: Pham, Tuan
Subject: FW: AW: remedy/oracle backups/restore


Tuan,

Below is the correspondenace over RMAN from the Remedy User list.

-----Original Message-----
From: Dana Bourgeois [mailto:kunda1@TELOCITY.COM]
Sent: Thursday, April 18, 2002 7:59 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: AW: remedy/oracle backups/restore


**

OK, so you have an example of trying something reasonable and symptoms
of it not working. Now call up Oracle under your support contract and
work with them on it. They should be able to tell you how to get a
readout on your ORA errors and whether your problems are related to
bugs, needed patches plus sanity check that your restore technique
should work. They won't set up the script for you but if you have
specific questions about the docs or about how it behaves when you try
to "..." then they will probably help you with it.

No support? You better buy a day or two of consultant time.

Is your catalog in its own instance? I mean, you're not using the
backed up database as the catalog database, are you? I didn't think you
could configure it that way but it sure sounds like it the kind of
problem you'd have if the same instance is trying to restore itself.
You really should have at least two databases when using rman with
catalog. The rman catalog database is small - the default install is
fine. You can run it noarchivelog mode and just shut it down before
doing a file backup of the machine. Better would be to have two
database machines each acting as the catalog for the other. This,
naturally, would double your cost if you don't have any other need for a
second host with Oracle licenses.

Maybe you want to go back to Oracle 7 style tablespace hot backup mode
and just copy database files to free disk space. That is fast compared
to tape, works well, and the target disk can be mirrored for redudancy
then striped for performance and the files can then be pushed to tape at
your leisure after the database is back up. A lot of the bigger
installations do exactly this for exactly all the reasons above and to
avoid the kind of issues you're having.

Sorry I'm not giving you more explicit advice.


Dana Bourgeois

> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of KOSOSKI,
> RAYMOND S (ASI)
> Sent: Thursday, April 18, 2002 2:41 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: [ARSLIST] AW: remedy/oracle backups/restore
>
>
> **
>
> the version of oracle is 8.1.6; i have set up archive logging
> and a catalog. what was happening was i was simply trying to
> restore the whole database with the rman command (per the
> O'Reilly Oracle RMAN Pocket Reference):
>
> run {
> allocate channel d1 type disk;
> restore database;
> recover database;
> }
>
> and got various errors: if the database is shutdown and
> restarted with 'startup nomount', it complains the catalog
> database is not available. if i use a 'startup mount', it
> says that oracle is initializing - and lets me got no further
> (even after waiting for a long period of time for it to
> initialize). if i use 'startup', i cannot get an exclusive enqueue.
>
> what i ended up doing in rman was:
>
> sql 'alter tablespace X offline';
> run {
> allocate channel d1 type disk;
> restore tablespace X;
> recover tablespace X;
> }
> sql 'alter tablespace X online';
>
> and was able to restore all tablespaces except SYSTEM, RBS
> and CATALOG, so i think i can use the tablespace version of
> the restore in rman and get the remedy data back, if i had
> to. i still would like to run the restore/recover database
> command, but my work-around will do for now -
>
> -----Original Message-----
> From: Dana Bourgeois [mailto:kunda1@TELOCITY.COM]
> Sent: Thursday, April 18, 2002 2:25 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: AW: remedy/oracle backups/restore
>
>
> **
>
> Rman backups are complex enough that I can say you haven't
> supplied enough information. What version of Oracle? Rman
> in 8.0.5 had a bug that could only be fixed by upgrading to
> 8.0.6. Is your database in archivelog mode? I asume it is
> but you didn't say. Most importantly, are you using a
> database catalog or just the control files? Some restores
> will not work without a catalog database and in all cases, it
> is easier (but maybe more confusing) to restore from the catalog.
>
> You might consider the Oracle class on rman. It is pretty
> complicated. At least pay $50 bucks and get a book. You
> downloaded the pdf covering your version of rman from the
> Oracle web site, correct? If not, do that now and read it.
> It might shed some light.
>
>
> Dana Bourgeois
>
> > -----Original Message-----
> > From: Action Request System discussion list(ARSList)
> > [mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Oertel, F
> > Sent: Thursday, April 18, 2002 7:17 AM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: [ARSLIST] AW: remedy/oracle backups/restore
> >
> >
> > **
> >
> > Hi,
> >
> > which problems you have?
> > When backing up an ARS-DB online, you have to ensure
> > transactional integrity. That means you have to backup the
> > entire db in one transaction, otherwise you may run into
> > trouble, for example with entry ids. When performing your
> > backup using the exp tool you should specify CONSISTENT=Y.
> > But keep in mind that (for large dbs) this will blow up your
> > redo logs.
> > I never had any problems backing up dbs with the imp/exp tools.
> >
> > Frank
> >
> > -----Ursprungliche Nachricht-----
> > Von: KOSOSKI, RAYMOND S (ASI) [mailto:rk5686@SBC.COM]
> > Gesendet: Donnerstag, 18. April 2002 15:28
> > An: ARSLIST@LISTSERV.VISTAIT.COM
> > Betreff: remedy/oracle backups/restore
> >
> >
> > **
> >
> > does anybody out there use RMAN to backup remedy's oracle
> > database? i have been able to perform a 'hot' oracle backup
> > using RMAN, but i am having problems with restore. was
> > wondering if anybody has any procedures to do a full remedy
> > (oracle) database restore? thanks!
> >
> > Raymond S. Kososki
> >
> >
> >
> > To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> > listserv@listserv.vistait.com You may also control your
> > subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
> >
> >
> >
> > To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> > listserv@listserv.vistait.com You may also control your
> > subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
> >
>
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com
> You may also control your subscription options, including
> UNSUBSCRIBE, at
> www.ARSLIST.org
>
>
>
> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
> listserv@listserv.vistait.com
> You may also control your subscription options, including
> UNSUBSCRIBE, at www.ARSLIST.org
>



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org