Re: rman expired vs obsolete

[Tanel Poder]

Hi!

Expired backups are unusable since they were not found accessible during
last crosscheck or were set to expired state manually. This means that these
backups can't and won't be used for restore operation.

Obsolete backups can be deleted since there are enough redundant backups
according to current backup retention policy. If an obsolete backup is not
manually deleted yet, it can be used for restore, unlike expired backups.
Backup retention policy can be changed using rman's "configure" command.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 9:59 PM


> Hi,
>
> I'm getting a little confused between expired backups and obsolete
backups.
> As I understand it, expired means the backups are no longer on disk.
> Obsolete means the backup is too old(?).
>
> Since I have a data ware house, I only have room on disk for 1 backup.
> Prior to running my weekly backup, do I issue a Delete Expired or Delete
> Obsolete, to remove last weeks backup that is currently on disk.
>
> Thanks
> Randy
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Steiner, Randy
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman backup

[Rich Holland]

Sorry to respond to such an old thread (man I'm way behind), but what if the
"expected" location of the archived logs isn't large enough?  For example,
let's say we have a 10G archive directory, and we dump 5-10G of logs per day.
I have to go to a backup made a week ago.  That's 35-70G worth of logs if I
need to roll forward.  Does RMAN try and cram 'em all in at once, or will it
"roll" through them?  That sure would be a nice feature.  ;-)
--
Rich Holland(913) 645-1950SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> DENNIS WILLIAMS
> Sent: Tuesday, October 28, 2003 3:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: rman backup
> 
> AK
>When you have RMAN back up archived logs, IIRC, in a recovery RMAN first
> restores those archived logs to the location that Oracle will expect them to
> be, and I believe that is done as part of the RESTORE DATABASE command. In
> my situation, I found no advantage from having RMAN store the archive logs,
> so I have no experience there, just what I've read in the manual.
> Only RMAN can perform the RESTORE DATABASE command, but once you
> complete that command, you can complete the recovery using svrmgrl. From
> everything I've seen, RMAN just issues the RECOVER DATABASE command to
> svrmgrl or SQL*Plus.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Tuesday, October 28, 2003 1:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thanks Dennis  for Reply,
> My confusion is , does RMAN sees only those archived logs which are backup
> using rman or it can use current archived log as well stored in original
> format at other disk ?
> 
> -ak
> 
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 28, 2003 10:49 AM
> 
> 
> > AK - Unless you specify otherwise, RMAN will automatically apply archive
> > logs to bring the database up to the time of failure (your recover
> database
> > statement). This is why it is good to run disaster recovery tests on a
> > regular basis, to ensure everything is ready, and you can try different
> > recovery times. You will see that RMAN will not complete its recovery if
> the
> > archived logs are not available.
> >
> >
> >
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > Sent: Tuesday, October 28, 2003 11:44 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > We take daily rman backup each nite at 10pm . Which means in worst case we
> > risk one day of work.  Now suppose something wrong goes before 10 pm .
> Then
> > Can I recover my database till time using previous day rman backup and
> > currently available archived logs.
> >
> > Or in nutshell is it possible to run { restore databse; recover database }
> > from rman and then apply remaing archived logs from a separated disk ( not
> a
> > rman backup ).
> >
> > Thanks,
> > -ak
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: AK
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).  Y

RE: rman restore question

[DENNIS WILLIAMS]

Joan - I have not used the redundancy policy, but my understanding is this
just involves how many backup copies to retain. It does not relate to
recovery as I read the manual.

Do you have Robert Freeman's book Oracle9i RMAN Backup & Recovery?

Are you attempting an incomplete recovery or a complete recovery? Any
recovery to a time prior to the current time is defined as an incomplete
recovery. 

If I am recalling your goal, you are trying to recover but not use the
latest backup sets. I always back up using an RMAN catalog, but have always
tested recovery just using the control file. On Oracle8i I found it easier
to separately issue a SQL command to back up the control file after an RMAN
backup, then I ensure that control file ends up on the backup tape. This
means that I can take the backup tape, restore the control file, then issue
RMAN commands that will restore the database. That control file only knows
about the RMAN backup that was last performed. So I could restore the data
files from any backup. Now, as you know, recovery in RMAN is basically a
shell over the Oracle recovery mechanism. You can restore using RMAN, then
recover the database using Oracle server manager (now SQL*Plus) commands. So
it should be possible to restore the database using RMAN as I described it
(but not restore), then replace the old control file with a more recent
control file, then recover the database (Oracle will apply archive log
files) until the current time is reached. Obviously by starting with an
older restore, more archive logs must be applied. Take a look at this idea
and see if it would meet your requirements. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, January 09, 2004 8:24 AM
To: Multiple recipients of list ORACLE-L


Ruth,

thanks, I am back. I took the redundancy policy to 4 now and deleted
today's backupset and try to recover from the yesterday backupset which
is a valid status in the rman report. I still got error. Rman still
looking for today's backupset sequence. If I do the crosscheck and
delete the expired today's backup. I can recover sucessfully. Is there
any possible way not using delete expired command, just recover from day
old backupset?

thanks!

Joan

Ruth Gramolini wrote:
> 
> If you don't set the redundancey policy to a recovery window of N days,
than
> the record of the backup will be kept indefinitely.  You should be able to
> restore the backups from tape and restore from a previous backup.  You may
> need to do a set until time if there was corruption or another problem.
> 
> HTH,
> Ruth
> 
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
>   Joan Hsieh
>   Sent: Tuesday, December 30, 2003 4:34 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: rman restore question
> 
>   Hi Listers,
> 
>   I have a question about rman restore. Right now, I configured RETENTION
>   POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
>   after a new rman full backup is done. The old backupset will be
>   backup-ed to tape by system group. In case of the newly backupset on
>   disk is corrupted and need to restore  the 2 days old backupset from
>   tape. Is there any way or command to restore the database using a
>   already deleted obsoleted backupset? (from rman catalog point of view) I
>   could find any command and example to restore a obsoleted backupset. Any
>   comments will be appreciated.
> 
>   Many many thanks!
> 
>   Joan
>   --
>   Please see the official ORACLE-L FAQ: http://www.orafaq.net
>   --
>   Author: Joan Hsieh
> INET: [EMAIL PROTECTED]
> 
>   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>   San Diego, California-- Mailing list and web hosting services
>   -
>   To REMOVE yourself from this mailing list, send an E-Mail message
>   to: [EMAIL PROTECTED] (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).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  I

RE: rman restore question

[DENNIS WILLIAMS]

Joan - Glad to hear your success. In the meanwhile I replied to your earlier
message. 

Just to clarify, when you used a time-based recovery, setting a time earlier
than the most recent backup, RMAN ignored the most recent backup and
restored from an earlier backup? Wouldn't that have the disadvantage that
you're stuck with a database that doesn't have all the recent transactions
applied? Just asking, you're probably suffering from "recovery fatigue" now.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, January 09, 2004 9:39 AM
To: Multiple recipients of list ORACLE-L


Sorry, I tried set until time, it works. Now I think we can move rman to
production since we tested all kinds of restore.

Thanks and have nice day!

Joan

Joan Hsieh wrote:
> 
> Ruth,
> 
> thanks, I am back. I took the redundancy policy to 4 now and deleted
> today's backupset and try to recover from the yesterday backupset which
> is a valid status in the rman report. I still got error. Rman still
> looking for today's backupset sequence. If I do the crosscheck and
> delete the expired today's backup. I can recover sucessfully. Is there
> any possible way not using delete expired command, just recover from day
> old backupset?
> 
> thanks!
> 
> Joan
> 
> Ruth Gramolini wrote:
> >
> > If you don't set the redundancey policy to a recovery window of N days,
than
> > the record of the backup will be kept indefinitely.  You should be able
to
> > restore the backups from tape and restore from a previous backup.  You
may
> > need to do a set until time if there was corruption or another problem.
> >
> > HTH,
> > Ruth
> >
> >   -Original Message-
> >   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> >   Joan Hsieh
> >   Sent: Tuesday, December 30, 2003 4:34 PM
> >   To: Multiple recipients of list ORACLE-L
> >   Subject: rman restore question
> >
> >   Hi Listers,
> >
> >   I have a question about rman restore. Right now, I configured
RETENTION
> >   POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> >   after a new rman full backup is done. The old backupset will be
> >   backup-ed to tape by system group. In case of the newly backupset on
> >   disk is corrupted and need to restore  the 2 days old backupset from
> >   tape. Is there any way or command to restore the database using a
> >   already deleted obsoleted backupset? (from rman catalog point of view)
I
> >   could find any command and example to restore a obsoleted backupset.
Any
> >   comments will be appreciated.
> >
> >   Many many thanks!
> >
> >   Joan
> >   --
> >   Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >   --
> >   Author: Joan Hsieh
> > INET: [EMAIL PROTECTED]
> >
> >   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >   San Diego, California-- Mailing list and web hosting services
> >   -
> >   To REMOVE yourself from this mailing list, send an E-Mail message
> >   to: [EMAIL PROTECTED] (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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

Re: rman restore question

[Joan Hsieh]

Sorry, I tried set until time, it works. Now I think we can move rman to
production since we tested all kinds of restore.

Thanks and have nice day!

Joan

Joan Hsieh wrote:
> 
> Ruth,
> 
> thanks, I am back. I took the redundancy policy to 4 now and deleted
> today's backupset and try to recover from the yesterday backupset which
> is a valid status in the rman report. I still got error. Rman still
> looking for today's backupset sequence. If I do the crosscheck and
> delete the expired today's backup. I can recover sucessfully. Is there
> any possible way not using delete expired command, just recover from day
> old backupset?
> 
> thanks!
> 
> Joan
> 
> Ruth Gramolini wrote:
> >
> > If you don't set the redundancey policy to a recovery window of N days, than
> > the record of the backup will be kept indefinitely.  You should be able to
> > restore the backups from tape and restore from a previous backup.  You may
> > need to do a set until time if there was corruption or another problem.
> >
> > HTH,
> > Ruth
> >
> >   -Original Message-
> >   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> >   Joan Hsieh
> >   Sent: Tuesday, December 30, 2003 4:34 PM
> >   To: Multiple recipients of list ORACLE-L
> >   Subject: rman restore question
> >
> >   Hi Listers,
> >
> >   I have a question about rman restore. Right now, I configured RETENTION
> >   POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> >   after a new rman full backup is done. The old backupset will be
> >   backup-ed to tape by system group. In case of the newly backupset on
> >   disk is corrupted and need to restore  the 2 days old backupset from
> >   tape. Is there any way or command to restore the database using a
> >   already deleted obsoleted backupset? (from rman catalog point of view) I
> >   could find any command and example to restore a obsoleted backupset. Any
> >   comments will be appreciated.
> >
> >   Many many thanks!
> >
> >   Joan
> >   --
> >   Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >   --
> >   Author: Joan Hsieh
> > INET: [EMAIL PROTECTED]
> >
> >   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >   San Diego, California-- Mailing list and web hosting services
> >   -
> >   To REMOVE yourself from this mailing list, send an E-Mail message
> >   to: [EMAIL PROTECTED] (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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Joan Hsieh]

Ruth,

thanks, I am back. I took the redundancy policy to 4 now and deleted
today's backupset and try to recover from the yesterday backupset which
is a valid status in the rman report. I still got error. Rman still
looking for today's backupset sequence. If I do the crosscheck and
delete the expired today's backup. I can recover sucessfully. Is there
any possible way not using delete expired command, just recover from day
old backupset?

thanks!

Joan

Ruth Gramolini wrote:
> 
> If you don't set the redundancey policy to a recovery window of N days, than
> the record of the backup will be kept indefinitely.  You should be able to
> restore the backups from tape and restore from a previous backup.  You may
> need to do a set until time if there was corruption or another problem.
> 
> HTH,
> Ruth
> 
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
>   Joan Hsieh
>   Sent: Tuesday, December 30, 2003 4:34 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: rman restore question
> 
>   Hi Listers,
> 
>   I have a question about rman restore. Right now, I configured RETENTION
>   POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
>   after a new rman full backup is done. The old backupset will be
>   backup-ed to tape by system group. In case of the newly backupset on
>   disk is corrupted and need to restore  the 2 days old backupset from
>   tape. Is there any way or command to restore the database using a
>   already deleted obsoleted backupset? (from rman catalog point of view) I
>   could find any command and example to restore a obsoleted backupset. Any
>   comments will be appreciated.
> 
>   Many many thanks!
> 
>   Joan
>   --
>   Please see the official ORACLE-L FAQ: http://www.orafaq.net
>   --
>   Author: Joan Hsieh
> INET: [EMAIL PROTECTED]
> 
>   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>   San Diego, California-- Mailing list and web hosting services
>   -
>   To REMOVE yourself from this mailing list, send an E-Mail message
>   to: [EMAIL PROTECTED] (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).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman restore question

[Ruth Gramolini]

If you don't set the redundancey policy to a recovery window of N days, than
the record of the backup will be kept indefinitely.  You should be able to
restore the backups from tape and restore from a previous backup.  You may
need to do a set until time if there was corruption or another problem.

HTH,
Ruth

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
  Joan Hsieh
  Sent: Tuesday, December 30, 2003 4:34 PM
  To: Multiple recipients of list ORACLE-L
  Subject: rman restore question


  Hi Listers,

  I have a question about rman restore. Right now, I configured RETENTION
  POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
  after a new rman full backup is done. The old backupset will be
  backup-ed to tape by system group. In case of the newly backupset on
  disk is corrupted and need to restore  the 2 days old backupset from
  tape. Is there any way or command to restore the database using a
  already deleted obsoleted backupset? (from rman catalog point of view) I
  could find any command and example to restore a obsoleted backupset. Any
  comments will be appreciated.

  Many many thanks!

  Joan
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Joan Hsieh
INET: [EMAIL PROTECTED]

  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Joan Hsieh]

Tanel,

Yes, rman keep asking the newer backupset which is start *450.rman. I don't 
know the command "change backuupset unavailable" command. I will give it a try. 
I know there is very rare situration that we need restore from an older 
backupset, but need to prepare it in case we do need it. I will go sqlserver 
training for next 3 days. I will post after I get back and tested it out.

Thanks,

joan

Quoting Tanel Poder <[EMAIL PROTECTED]>:

> Hi!
> 
> As Stephen pointed out, rman searches for a file named
> "/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman", but can't find it. Is
> this file a newer backupset which rman is automatically trying to use?
> 
> If you want to skip this file, you could use "change backupset unavailable"
> command for temporarily disabling this newer backupset.
> 
> Tanel.
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 31, 2003 10:49 PM
> 
> 
> > After I did some testing, it is impossble to restore and recover a
> > deleted obsolete backupset. So I took off the delete obsolete command.
> > Retention policy to redundancy still keep it to 1. I did couple backups
> > and run "list backup of database" and "report obsolete" command.
> > Although report obsolet show the backupset but they also shown in list
> > backup of database report and status is valid. Now I have to rephase my
> > question, is it possible to recover from an old backups? I tried restore
> > full, it keep give me the error
> > and asking the newest backupset which I intend move to somewhere else.
> >
> >
> > RMAN-03002: failure of restore command at 12/31/2003 15:36:27
> > ORA-19505: failed to identify file
> > "/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman"
> > ORA-27037: unable to obtain file status
> > IBM AIX RISC System/6000 Error: 2: No such file or directory
> >
> >
> > Joan
> >
> > Joan Hsieh wrote:
> > >
> > > Hi Listers,
> > >
> > > I have a question about rman restore. Right now, I configured RETENTION
> > > POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> > > after a new rman full backup is done. The old backupset will be
> > > backup-ed to tape by system group. In case of the newly backupset on
> > > disk is corrupted and need to restore  the 2 days old backupset from
> > > tape. Is there any way or command to restore the database using a
> > > already deleted obsoleted backupset? (from rman catalog point of view) I
> > > could find any command and example to restore a obsoleted backupset. Any
> > > comments will be appreciated.
> > >
> > > Many many thanks!
> > >
> > > Joan
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Joan Hsieh
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (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).
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Joan Hsieh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and w

Re: rman restore question

[Tanel Poder]

Hi!

As Stephen pointed out, rman searches for a file named
"/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman", but can't find it. Is
this file a newer backupset which rman is automatically trying to use?

If you want to skip this file, you could use "change backupset unavailable"
command for temporarily disabling this newer backupset.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 31, 2003 10:49 PM


> After I did some testing, it is impossble to restore and recover a
> deleted obsolete backupset. So I took off the delete obsolete command.
> Retention policy to redundancy still keep it to 1. I did couple backups
> and run "list backup of database" and "report obsolete" command.
> Although report obsolet show the backupset but they also shown in list
> backup of database report and status is valid. Now I have to rephase my
> question, is it possible to recover from an old backups? I tried restore
> full, it keep give me the error
> and asking the newest backupset which I intend move to somewhere else.
>
>
> RMAN-03002: failure of restore command at 12/31/2003 15:36:27
> ORA-19505: failed to identify file
> "/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman"
> ORA-27037: unable to obtain file status
> IBM AIX RISC System/6000 Error: 2: No such file or directory
>
>
> Joan
>
> Joan Hsieh wrote:
> >
> > Hi Listers,
> >
> > I have a question about rman restore. Right now, I configured RETENTION
> > POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> > after a new rman full backup is done. The old backupset will be
> > backup-ed to tape by system group. In case of the newly backupset on
> > disk is corrupted and need to restore  the 2 days old backupset from
> > tape. Is there any way or command to restore the database using a
> > already deleted obsoleted backupset? (from rman catalog point of view) I
> > could find any command and example to restore a obsoleted backupset. Any
> > comments will be appreciated.
> >
> > Many many thanks!
> >
> > Joan
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Joan Hsieh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman restore question

[Stephen.Lee]

I have never attempted what you are doing, so I must confess some ignorance.
But, looking at your error message, it appears that rman knows what file it
needs and is unable to get it.  One must assume there is no file named

/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman

available on the hard drives.

> -Original Message-
> 
> After I did some testing, it is impossble to restore and recover a
> deleted obsolete backupset. So I took off the delete obsolete command.
> Retention policy to redundancy still keep it to 1. I did 
> couple backups
> and run "list backup of database" and "report obsolete" command.
> Although report obsolet show the backupset but they also shown in list
> backup of database report and status is valid. Now I have to 
> rephase my
> question, is it possible to recover from an old backups? I 
> tried restore
> full, it keep give me the error
> and asking the newest backupset which I intend move to somewhere else.
> 
> 
> RMAN-03002: failure of restore command at 12/31/2003 15:36:27
> ORA-19505: failed to identify file
> "/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman"
> ORA-27037: unable to obtain file status
> IBM AIX RISC System/6000 Error: 2: No such file or directory
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Joan Hsieh]

After I did some testing, it is impossble to restore and recover a
deleted obsolete backupset. So I took off the delete obsolete command.
Retention policy to redundancy still keep it to 1. I did couple backups
and run "list backup of database" and "report obsolete" command.
Although report obsolet show the backupset but they also shown in list
backup of database report and status is valid. Now I have to rephase my
question, is it possible to recover from an old backups? I tried restore
full, it keep give me the error
and asking the newest backupset which I intend move to somewhere else.


RMAN-03002: failure of restore command at 12/31/2003 15:36:27
ORA-19505: failed to identify file
"/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory


Joan

Joan Hsieh wrote:
> 
> Hi Listers,
> 
> I have a question about rman restore. Right now, I configured RETENTION
> POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> after a new rman full backup is done. The old backupset will be
> backup-ed to tape by system group. In case of the newly backupset on
> disk is corrupted and need to restore  the 2 days old backupset from
> tape. Is there any way or command to restore the database using a
> already deleted obsoleted backupset? (from rman catalog point of view) I
> could find any command and example to restore a obsoleted backupset. Any
> comments will be appreciated.
> 
> Many many thanks!
> 
> Joan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Joan Hsieh]

Thanks Tanel. I will test it out.
Happy new year!

Joan

Tanel Poder wrote:
> 
> I was actually talking from database recovery point of view (that you can do
> point in time recovery prior to current controlfile time if you use "using
> backup controlfile" option when recovering".
> 
> For restoring a de-registered backupset, I see two options (there might be
> more, more convenient ones):
> 
> 1) use a old controlfile from the time when the backupset was still
> registered in it (you can create another, temporary recovery catalog and use
> "resync catalog from controlfilecopy ''" and then can use restore
> command to read from your old backupset) See metalink note 132927.1 for
> that.
> 
> 2) use dbms_backup_restore to manually extract your files from "orphan"
> backupsets (Note 60545.1)
> 
> Tanel.
> 
> - Original Message -
> To: <[EMAIL PROTECTED]>; "Tanel Poder" <[EMAIL PROTECTED]>
> Cc: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 31, 2003 3:55 AM
> 
> > Tanel,
> > Do you mean if I am using current controlfile to recover database, It
> doesn't
> > matter the backupset is obsolete or not in the rman catalog repository
> > database, is that sounds right? So, I just have to restore the old
> backupset
> > from tape to disk and issue recover database command? At beginning, I
> thought
> > to recatalog the backupset, make it valid and then recover from it.
> However, I
> > couldn't find this kind of operation in manual. So I am wondering how to
> > recover it from an obsolete backupset?
> > Thanks again,
> >
> > Joan
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Tanel Poder]

I was actually talking from database recovery point of view (that you can do
point in time recovery prior to current controlfile time if you use "using
backup controlfile" option when recovering".

For restoring a de-registered backupset, I see two options (there might be
more, more convenient ones):

1) use a old controlfile from the time when the backupset was still
registered in it (you can create another, temporary recovery catalog and use
"resync catalog from controlfilecopy ''" and then can use restore
command to read from your old backupset) See metalink note 132927.1 for
that.

2) use dbms_backup_restore to manually extract your files from "orphan"
backupsets (Note 60545.1)

Tanel.

- Original Message - 
To: <[EMAIL PROTECTED]>; "Tanel Poder" <[EMAIL PROTECTED]>
Cc: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 31, 2003 3:55 AM


> Tanel,
> Do you mean if I am using current controlfile to recover database, It
doesn't
> matter the backupset is obsolete or not in the rman catalog repository
> database, is that sounds right? So, I just have to restore the old
backupset
> from tape to disk and issue recover database command? At beginning, I
thought
> to recatalog the backupset, make it valid and then recover from it.
However, I
> couldn't find this kind of operation in manual. So I am wondering how to
> recover it from an obsolete backupset?
> Thanks again,
>
> Joan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Joan Hsieh]

Tanel,
Do you mean if I am using current controlfile to recover database, It doesn't 
matter the backupset is obsolete or not in the rman catalog repository 
database, is that sounds right? So, I just have to restore the old backupset 
from tape to disk and issue recover database command? At beginning, I thought 
to recatalog the backupset, make it valid and then recover from it. However, I 
couldn't find this kind of operation in manual. So I am wondering how to 
recover it from an obsolete backupset? 
Thanks again,

Joan

Quoting Tanel Poder <[EMAIL PROTECTED]>:

> You can do point in time recovery using current controlfile as well. You
> just say "recover database until cancal using backup controlfile" then, that
> way Oracle ignores SCN information inside controlfile and trusts only
> datafile headers.
> 
> You have to open resetlogs after that. One issue I see with this approach is
> that when you have added log/datafiles after your backup, then there'll be
> controlfile/data dictionary mismatch, but it's anyway solvable.
> 
> Tanel.
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 31, 2003 1:29 AM
> 
> 
> > Well Roger, Suppose I still have the current control file and want to use
> days
> > old full backupset (obsolete already) to restore and recover the database
> to
> > the point of time. How it related to recover the autobackup controlfile?
> I did
> > configure controlfile autobackup on though.
> >
> > Thanks,
> >
> > Joan
> >
> > Quoting Roger Xu <[EMAIL PROTECTED]>:
> >
> > > I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
> > > which enables RMAN to automatically backup controlfile to
> > > a default location. Then you can restore the controlfile
> > > before you restore other database files.
> > >
> > > -Original Message-
> > > Sent: Tuesday, December 30, 2003 3:34 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi Listers,
> > >
> > > I have a question about rman restore. Right now, I configured RETENTION
> > > POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> > > after a new rman full backup is done. The old backupset will be
> > > backup-ed to tape by system group. In case of the newly backupset on
> > > disk is corrupted and need to restore  the 2 days old backupset from
> > > tape. Is there any way or command to restore the database using a
> > > already deleted obsoleted backupset? (from rman catalog point of view) I
> > > could find any command and example to restore a obsoleted backupset. Any
> > > comments will be appreciated.
> > >
> > > Many many thanks!
> > >
> > > Joan
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Joan Hsieh
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (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).
> > >
> > > For technical support please email [EMAIL PROTECTED] or you can
> > > call (972)721-8257.
> > > This email has been scanned for all viruses by the MessageLabs Email
> Security
> > > System.
> > >
> > > 
> > > This email has been scanned for all viruses by the MessageLabs Email
> > > Security System. For more information on a proactive email security
> > > service working around the clock, around the globe, visit
> > > http://www.messagelabs.com
> > > 
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Roger Xu
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (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).
> > >
> >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Joan Hsieh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, C

Re: rman restore question

[Tanel Poder]

Note that when you configure controlfile autobackup on, then a backup
controlfile will be saved to default location (dbs or database dir under
$ORACLE_HOME) after most physical database structure changes such is adding
a datafile, taking tablespace offline/online etc. This is the behaviour of
9.2.0.4 on W2k at least.

It may generate a good bunch of backup controfiles to Oracle software
directory without your knowing...

Anyway, I have less than 23 hours to new year here, so I wish you happy
ending of current year and happy new year!
And you probably won't hear from me for next few days ;)
Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 11:54 PM


> I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
> which enables RMAN to automatically backup controlfile to
> a default location. Then you can restore the controlfile
> before you restore other database files.
>
> -Original Message-
> Sent: Tuesday, December 30, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Listers,
>
> I have a question about rman restore. Right now, I configured RETENTION
> POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> after a new rman full backup is done. The old backupset will be
> backup-ed to tape by system group. In case of the newly backupset on
> disk is corrupted and need to restore  the 2 days old backupset from
> tape. Is there any way or command to restore the database using a
> already deleted obsoleted backupset? (from rman catalog point of view) I
> could find any command and example to restore a obsoleted backupset. Any
> comments will be appreciated.
>
> Many many thanks!
>
> Joan
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>
> For technical support please email [EMAIL PROTECTED] or you can
> call (972)721-8257.
> This email has been scanned for all viruses by the MessageLabs Email
Security System.
>
> 
> This email has been scanned for all viruses by the MessageLabs Email
> Security System. For more information on a proactive email security
> service working around the clock, around the globe, visit
> http://www.messagelabs.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Roger Xu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman restore question

[Tanel Poder]

You can do point in time recovery using current controlfile as well. You
just say "recover database until cancal using backup controlfile" then, that
way Oracle ignores SCN information inside controlfile and trusts only
datafile headers.

You have to open resetlogs after that. One issue I see with this approach is
that when you have added log/datafiles after your backup, then there'll be
controlfile/data dictionary mismatch, but it's anyway solvable.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 31, 2003 1:29 AM


> Well Roger, Suppose I still have the current control file and want to use
days
> old full backupset (obsolete already) to restore and recover the database
to
> the point of time. How it related to recover the autobackup controlfile?
I did
> configure controlfile autobackup on though.
>
> Thanks,
>
> Joan
>
> Quoting Roger Xu <[EMAIL PROTECTED]>:
>
> > I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
> > which enables RMAN to automatically backup controlfile to
> > a default location. Then you can restore the controlfile
> > before you restore other database files.
> >
> > -Original Message-
> > Sent: Tuesday, December 30, 2003 3:34 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Listers,
> >
> > I have a question about rman restore. Right now, I configured RETENTION
> > POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> > after a new rman full backup is done. The old backupset will be
> > backup-ed to tape by system group. In case of the newly backupset on
> > disk is corrupted and need to restore  the 2 days old backupset from
> > tape. Is there any way or command to restore the database using a
> > already deleted obsoleted backupset? (from rman catalog point of view) I
> > could find any command and example to restore a obsoleted backupset. Any
> > comments will be appreciated.
> >
> > Many many thanks!
> >
> > Joan
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Joan Hsieh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> >
> > For technical support please email [EMAIL PROTECTED] or you can
> > call (972)721-8257.
> > This email has been scanned for all viruses by the MessageLabs Email
Security
> > System.
> >
> > 
> > This email has been scanned for all viruses by the MessageLabs Email
> > Security System. For more information on a proactive email security
> > service working around the clock, around the globe, visit
> > http://www.messagelabs.com
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Roger Xu
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> >
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---

RE: rman restore question

[Joan Hsieh]

Well Roger, Suppose I still have the current control file and want to use days 
old full backupset (obsolete already) to restore and recover the database to 
the point of time. How it related to recover the autobackup controlfile?  I did 
configure controlfile autobackup on though. 

Thanks,

Joan 

Quoting Roger Xu <[EMAIL PROTECTED]>:

> I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
> which enables RMAN to automatically backup controlfile to
> a default location. Then you can restore the controlfile
> before you restore other database files.
> 
> -Original Message-
> Sent: Tuesday, December 30, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Listers,
> 
> I have a question about rman restore. Right now, I configured RETENTION
> POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> after a new rman full backup is done. The old backupset will be
> backup-ed to tape by system group. In case of the newly backupset on
> disk is corrupted and need to restore  the 2 days old backupset from
> tape. Is there any way or command to restore the database using a
> already deleted obsoleted backupset? (from rman catalog point of view) I
> could find any command and example to restore a obsoleted backupset. Any
> comments will be appreciated.
> 
> Many many thanks!
> 
> Joan
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 
> For technical support please email [EMAIL PROTECTED] or you can
> call (972)721-8257. 
> This email has been scanned for all viruses by the MessageLabs Email Security
> System.
> 
> 
> This email has been scanned for all viruses by the MessageLabs Email
> Security System. For more information on a proactive email security
> service working around the clock, around the globe, visit
> http://www.messagelabs.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Roger Xu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman restore question

[Joan Hsieh]

Dennis,

9.2.0.4

Joan

Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> Joan - Which Oracle version?
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Tuesday, December 30, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Listers,
> 
> I have a question about rman restore. Right now, I configured RETENTION
> POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> after a new rman full backup is done. The old backupset will be
> backup-ed to tape by system group. In case of the newly backupset on
> disk is corrupted and need to restore  the 2 days old backupset from
> tape. Is there any way or command to restore the database using a
> already deleted obsoleted backupset? (from rman catalog point of view) I
> could find any command and example to restore a obsoleted backupset. Any
> comments will be appreciated.
> 
> Many many thanks!
> 
> Joan
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman restore question

[DENNIS WILLIAMS]

Joan - Which Oracle version?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 30, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I have a question about rman restore. Right now, I configured RETENTION
POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
after a new rman full backup is done. The old backupset will be
backup-ed to tape by system group. In case of the newly backupset on
disk is corrupted and need to restore  the 2 days old backupset from
tape. Is there any way or command to restore the database using a
already deleted obsoleted backupset? (from rman catalog point of view) I
could find any command and example to restore a obsoleted backupset. Any
comments will be appreciated.

Many many thanks!

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman restore question

[Roger Xu]

I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
which enables RMAN to automatically backup controlfile to
a default location. Then you can restore the controlfile
before you restore other database files.

-Original Message-
Sent: Tuesday, December 30, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I have a question about rman restore. Right now, I configured RETENTION
POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
after a new rman full backup is done. The old backupset will be
backup-ed to tape by system group. In case of the newly backupset on
disk is corrupted and need to restore  the 2 days old backupset from
tape. Is there any way or command to restore the database using a
already deleted obsoleted backupset? (from rman catalog point of view) I
could find any command and example to restore a obsoleted backupset. Any
comments will be appreciated.

Many many thanks!

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email Security System.


This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN - the time has come

[Jared Still]

I would say it is like chess.

Learning how the pieces move is easy.

Learning to put it altogether and use and manage it
is not quite as simple.  There are a lot of nuances
to RMAN, and I don't pretend to have a handle on it.

Yet.

Jared

On Mon, 2003-12-22 at 08:04, Mercadante, Thomas F wrote:
> Raj,
>  
> It really is a quick learn.  The best way is to get some scripts (great
> examples in the rdbms/demo directory) and try them on a test database.  Once
> you get something running, the rest is simple.  If you need some samples,
> let me know.  It's really basic stuff.
>  
> 
> Tom Mercadante 
> Oracle Certified Professional 
> 
> -Original Message-
> Sent: Monday, December 22, 2003 10:35 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Okay, 
> 
> its time to bite the bullet ... time to learn RMAN. 
> 
> Outside of TFM (which I just started reading), are there any good
> books/articles on RMAN? I know there is one by RFreeman, and it is for 9i
> (Robert, will there be a 10g version?) 
> 
> Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time
> permits. 
> Raj 
> 
>  
> Rajendra dot Jamadagni at nospamespn dot com 
> All Views expressed in this email are strictly personal. 
> QOTD: Any clod can have facts, having an opinion is an art ! 
> 
> 
> 
> **
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged, attorney
> work product or exempt from disclosure under applicable law. If you have
> received this message in error, or are not the named recipient(s), please
> immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
> message from your computer, Thank you.
> 
> **4 
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN - the time has come

[Freeman Robert - IL]

We have talked about a 10g version of the book, which I'm sure will happen
at some point in time :-)

Robert

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/22/2003 2:39 PM

Try Robert Freeman's book.  I have only heard good things about it.  
 
Ruth

-Original Message-
Jamadagni, Rajendra
Sent: Monday, December 22, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L



Okay, 

its time to bite the bullet ... time to learn RMAN. 

Outside of TFM (which I just started reading), are there any good
books/articles on RMAN? I know there is one by RFreeman, and it is for
9i (Robert, will there be a 10g version?) 

Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever
time permits. 
Raj 

 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 



**
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged,
attorney work product or exempt from disclosure under applicable law. If
you have received this message in error, or are not the named
recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.

**4 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN - the time has come

[Ruth Gramolini]

Title: RMAN - the time has come



Try Robert Freeman's 
book.  I have only heard good things about it.  
 
Ruth

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, 
  RajendraSent: Monday, December 22, 2003 10:35 AMTo: 
  Multiple recipients of list ORACLE-LSubject: RMAN - the time has 
  come
  Okay, 
  its time to bite the bullet ... time to 
  learn RMAN. 
  Outside of TFM (which I just started 
  reading), are there any good books/articles on RMAN? I know there is one by 
  RFreeman, and it is for 9i (Robert, will there be a 10g version?) 
  Yeah, I am also google'ing, taeoma'ing and 
  in general stfw'ing whenever time permits. Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  **This 
  e-mail message is confidential, intended only for the named recipient(s) above 
  and may contain information that is privileged, attorney work product or 
  exempt from disclosure under applicable law. If you have received this message 
  in error, or are not the named recipient(s), please immediately notify 
  corporate MIS at (860) 766-2000 and delete this e-mail message from your 
  computer, Thank 
  you.**4 

Re: RMAN - the time has come

[Arup Nanda]

Title: RMAN - the time has come



In addition to the Freeman book, I would also 
suggest the RMAN Pocket Reference from O'Reilly. It predates the RF book and 
certainly comes handy for learning - I learned from there.
 
HTH.
 
Arup Nanda

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, December 22, 2003 10:34 
  AM
  Subject: RMAN - the time has come
  
  Okay, 
  its time to bite the bullet ... time to 
  learn RMAN. 
  Outside of TFM (which I just started 
  reading), are there any good books/articles on RMAN? I know there is one by 
  RFreeman, and it is for 9i (Robert, will there be a 10g version?) 
  Yeah, I am also google'ing, taeoma'ing and 
  in general stfw'ing whenever time permits. Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  **This 
  e-mail message is confidential, intended only for the named recipient(s) above 
  and may contain information that is privileged, attorney work product or 
  exempt from disclosure under applicable law. If you have received this message 
  in error, or are not the named recipient(s), please immediately notify 
  corporate MIS at (860) 766-2000 and delete this e-mail message from your 
  computer, Thank 
  you.**4 

RE: RMAN - the time has come

[Mercadante, Thomas F]

Title: RMAN - the time has come



Raj,
 
It 
really is a quick learn.  The best way is to get some scripts (great 
examples in the rdbms/demo directory) and try them on a test database.  
Once you get something running, the rest is simple.  If you need some 
samples, let me know.  It's really basic stuff.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Monday, December 22, 2003 
  10:35 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RMAN - the time has come
  Okay, 
  its time to bite the bullet ... time to 
  learn RMAN. 
  Outside of TFM (which I just started 
  reading), are there any good books/articles on RMAN? I know there is one by 
  RFreeman, and it is for 9i (Robert, will there be a 10g version?) 
  Yeah, I am also google'ing, taeoma'ing and 
  in general stfw'ing whenever time permits. Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  **This 
  e-mail message is confidential, intended only for the named recipient(s) above 
  and may contain information that is privileged, attorney work product or 
  exempt from disclosure under applicable law. If you have received this message 
  in error, or are not the named recipient(s), please immediately notify 
  corporate MIS at (860) 766-2000 and delete this e-mail message from your 
  computer, Thank 
  you.**4 

RE: RMAN Retention Policy

[MacGregor, Ian A.]

Thanks,  for the example script.  I had already reached the conclusion that  "change 
backuppiece ..." was needed, but
hadn't yet figured how to query for the proper pieces.

Ian MacGregor
Stanford linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, December 18, 2003 5:07 AM
To: '[EMAIL PROTECTED]'
Cc: MacGregor, Ian A.


Ian,

I think retention policy is new in 9i.

I purge my repository of backups that are older than 90 days (because our tape systems 
rotates and reuses tapes after that time) using the "change backuppiece 330783 delete; 
" command.  I run a sql script againts the rman repository looking for pieces that 
satisfy this requirement.  The sql looks like this:

select 'change backuppiece bp.bp_key delete;'
from rc_backup_piece bp,rc_database db
where db.name = upper('ORACLE_SID')
and bp.db_id = db.dbid
and bp.start_time < sysdate-90
/

This is in an 8i database.

Hope this is what you were looking for.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


How is this set on 8.1.7 and 8.1.6 databases

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "compatible"
RMAN-01008: the bad identifier was: RETENTION
RMAN-01007: at line 1 column 11 file: standard input

I looked at commands such as 

crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of 
database completed before 'SYSDATE-7';

But crosscheck only expires backups which are in the catalog, but not available on the 
backup media.

Do I have to use the change command and designate each backup piece?


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN Retention Policy

[Ruth Gramolini]

Did you connect to the target database first?  I know this is a simple thing
but sometimes we forget.

Regards,
Ruth

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
  MacGregor, Ian A.
  Sent: Wednesday, December 17, 2003 5:04 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN Retention Policy


  How is this set on 8.1.7 and 8.1.6 databases

  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

  RMAN-00571: ===
  RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
  RMAN-00571: ===
  RMAN-00558: error encountered while parsing input commands
  RMAN-01005: syntax error: found "identifier": expecting one of:
  "compatible"
  RMAN-01008: the bad identifier was: RETENTION
  RMAN-01007: at line 1 column 11 file: standard input

  I looked at commands such as

  crosscheck backup of database completed before 'SYSDATE-7';
  delete expired backup of database completed before 'SYSDATE-7';

  But crosscheck only expires backups which are in the catalog, but
  not available on the backup media.

  Do I have to use the change command and designate each backup piece?


  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]

  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN Retention Policy

[Ramón Estevez]

Thomas,
You are right it's new in 9i

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Sent: Thursday, December 18, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L


Ian,

I think retention policy is new in 9i.

I purge my repository of backups that are older than 90 days (because our tape systems 
rotates and reuses tapes after that time) using the "change backuppiece 330783 delete; 
" command.  I run a sql script againts the rman repository looking for pieces that 
satisfy this requirement.  The sql looks like this:

select 'change backuppiece bp.bp_key delete;'
from rc_backup_piece bp,rc_database db
where db.name = upper('ORACLE_SID')
and bp.db_id = db.dbid
and bp.start_time < sysdate-90
/

This is in an 8i database.

Hope this is what you were looking for.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


How is this set on 8.1.7 and 8.1.6 databases

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "compatible"
RMAN-01008: the bad identifier was: RETENTION
RMAN-01007: at line 1 column 11 file: standard input

I looked at commands such as 

crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of 
database completed before 'SYSDATE-7';

But crosscheck only expires backups which are in the catalog, but not available on the 
backup media.

Do I have to use the change command and designate each backup piece?


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?Q?Ram=F3n_Estevez?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN Retention Policy

[Mercadante, Thomas F]

Ian,

I think retention policy is new in 9i.

I purge my repository of backups that are older than 90 days (because our
tape systems rotates and reuses tapes after that time) using the "change
backuppiece 330783 delete; " command.  I run a sql script againts the rman
repository looking for pieces that satisfy this requirement.  The sql looks
like this:

select 'change backuppiece bp.bp_key delete;'
from rc_backup_piece bp,rc_database db
where db.name = upper('ORACLE_SID')
and bp.db_id = db.dbid
and bp.start_time < sysdate-90
/

This is in an 8i database.

Hope this is what you were looking for.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


How is this set on 8.1.7 and 8.1.6 databases

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "compatible"
RMAN-01008: the bad identifier was: RETENTION
RMAN-01007: at line 1 column 11 file: standard input

I looked at commands such as 

crosscheck backup of database completed before 'SYSDATE-7';
delete expired backup of database completed before 'SYSDATE-7';

But crosscheck only expires backups which are in the catalog, but not
available on the backup media.

Do I have to use the change command and designate each backup piece?


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN restore on another server

[Josh Collier]

why not use the RMAN duplicate database process. that sounds like what you
are trying to do.  Have you ever let the script run to completion? Maybe its
slow for another reason. I have used duplicate database on Solaris many
times with great success.

Josh

-Original Message-
Sent: Monday, December 08, 2003 8:20 AM
To: Multiple recipients of list ORACLE-L



Dennis and all,

 I have no problem getting the controlfile... I just comment out the SET
commands to change the directories of the dbfs...and I replicate the control
according to the init file specifications.. So This operation actually
extract the controlfile out of the backup piece so I know the location and
connections are working fine.

But since the controlfile is backup and I am restoring it with the same RMan
command I think I should have no problem.. I know other DBAs.. run this same
script and restore the database on another server with no problem if the
controlfile is restored before the database is restored and recovered.

Here is the restore controlfile script and resulting log file

==
Controlfile restore Script
==
connect catalog rman81740/[EMAIL PROTECTED]

connect target /


run

{

allocate channel d1 type disk ;

sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
set until time = '2003-12-02 05:50:00';


#restore controlfile to '/u02/vssppln/restored_cf.ctl';

replicate controlfile from '/u02/vssppln/restored_cf.ctl';

release channel d1;
}

==
Successful Controlfile restore log
==
Recovery Manager: Release 8.1.7.4.0 - Production

RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2>
3> connect target /
4>
5>
6> run
7>
8> {
9>
10> allocate channel d1 type disk ;
11>
12> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
13> set until time = '2003-12-02 05:50:00';
14>
15>
16> restore controlfile to '/u02/vssppln/restored_cf.ctl';
17>
18> replicate controlfile from '/u02/vssppln/restored_cf.ctl';
19>
20> release channel d1;
21> }
22>
23>
RMAN-06008: connected to recovery catalog database

RMAN-06006: connected to target database: vssppln (not mounted)

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=12 devtype=DISK

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"
RMAN-03023: executing command: sql

RMAN-03022: compiling command: set

RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

Recovery Manager complete.


=
Here is the orignal entire script to restore controlfile and database
but it just hangs on the set commands..
=

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15

RE: RMAN restore on another server

[Spears, Brian]

Dennis and all,

 I have no problem getting the controlfile... I just comment out the SET commands to 
change the directories of the dbfs...and I replicate the control according to the init 
file specifications.. So This operation actually extract the controlfile out of the 
backup piece so I know the location and connections are working fine.

But since the controlfile is backup and I am restoring it with the same RMan command I 
think I should have no problem.. I know other DBAs.. run this same script and restore 
the database on another server with no problem if the controlfile is restored before 
the database is restored and recovered.

Here is the restore controlfile script and resulting log file

==
Controlfile restore Script
==
connect catalog rman81740/[EMAIL PROTECTED]

connect target /


run

{

allocate channel d1 type disk ;

sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
set until time = '2003-12-02 05:50:00';


#restore controlfile to '/u02/vssppln/restored_cf.ctl';

replicate controlfile from '/u02/vssppln/restored_cf.ctl';

release channel d1;
}

==
Successful Controlfile restore log
==
Recovery Manager: Release 8.1.7.4.0 - Production

RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2>
3> connect target /
4>
5>
6> run
7>
8> {
9>
10> allocate channel d1 type disk ;
11>
12> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
13> set until time = '2003-12-02 05:50:00';
14>
15>
16> restore controlfile to '/u02/vssppln/restored_cf.ctl';
17>
18> replicate controlfile from '/u02/vssppln/restored_cf.ctl';
19>
20> release channel d1;
21> }
22>
23>
RMAN-06008: connected to recovery catalog database

RMAN-06006: connected to target database: vssppln (not mounted)

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=12 devtype=DISK

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"
RMAN-03023: executing command: sql

RMAN-03022: compiling command: set

RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

Recovery Manager complete.


=
Here is the orignal entire script to restore controlfile and database
but it just hangs on the set commands..
=

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index0

RE: RMAN restore on another server

[DENNIS WILLIAMS]

Brian - My sys admin pleads amnesia on the NFS problem. My recollection was
that it was misconfigured or had a default configuration that expected only
a couple of connections and RMAN actually opens MANY file connections. My
specific symptoms is that RMAN would create the first few data files and
then just stop. Oracle Support made me take NFS out of the mix and then
everything worked.
   In your case, I am also concerned about the control file. I was unable to
get 8i to create the control file from the backup although others on this
list reported success with that. I would feel better if you said that you
separately backed up the control file at the end of the RMAN backup, and
manually moved that control file into place on the test system. At least you
would eliminate that as the problem.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, December 08, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L


DENNIS...Thanks for your feedback. Here it is.. (NSF problem??)

1. I am not using Tape only disk backups..
2. I ftp'd the backup pieces to new machine
3. I created a link to duplicate the backup location on the original machine
   and other locations as pfiles...edited the init file for new control
locations
etc.
4. The controlfile was wrapping in the backup piece same backup command
5. It is an NSF mount point. (Netapp) 

 Is there a solution with the NFS issue?

Brian Spears
Database Services
[EMAIL PROTECTED]
Limitedbrands
TECHNOLOGY SERVICES

 



-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
   1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database  and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
   2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
   3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
 
Sorry, but that is all my brain can think up on Friday.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L


Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
 
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  
 
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...
 
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
 
 
 
 
Here is the command in operation
 
 
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for

RE: RMAN restore on another server

[DENNIS WILLIAMS]

Brian - I think that is the problem -- you can't tell RMAN you are on a
different server. The part I'm not getting a clear picture on is your
control file. For this specific recovery, how is it getting a control file?
Did you move one over from production, or are you waiting for RMAN to cough
it up from the backup pieces? On 8i this tends to be a problem.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, December 08, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


I have ftp'd  the backup pieces into the identical backup location as the
orignal server so I have all the stuff available... Im just wondering if I
have to do something to tell it that I am on a different server...

I've restored the controlfile mannually before but on the same server. I
backup the controlfile and wrap in the backup piece with the normal backup.


Brian

-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Janardhana - That's a good point. 
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L



May be you try the following:

 

If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.

 

-- Janardhana

 

-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L

 

Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.

Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.

 

Some of the steps to setup the new machine.

1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over

4) duplicated the Admin directories for the database to be restored

5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on

6) Created a backup mount point to store the RMAN backup pieces and
archivelogs

7) moved the backup pieces and archivelogs to the new machine

8) Setup and confirm connectivity to Rman catalog

9) No mount the database to be on the new machine

10) Launch the Rman command

rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  

 

Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...

 

Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..

 

 

 

 

Here is the command in operation

 

 

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   

 

Recovery Manager: Release 8.1.7.4.0 - Production

 

RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aims

RE: RMAN restore on another server

[Spears, Brian]

DENNIS...Thanks for your feedback. Here it is.. (NSF problem??)

1. I am not using Tape only disk backups..
2. I ftp'd the backup pieces to new machine
3. I created a link to duplicate the backup location on the original machine
   and other locations as pfiles...edited the init file for new control locations
etc.
4. The controlfile was wrapping in the backup piece same backup command
5. It is an NSF mount point. (Netapp) 

 Is there a solution with the NFS issue?

Brian Spears
Database Services
[EMAIL PROTECTED]
Limitedbrands
TECHNOLOGY SERVICES

 



-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
   1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database  and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
   2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
   3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
 
Sorry, but that is all my brain can think up on Friday.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L


Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
 
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  
 
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...
 
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
 
 
 
 
Here is the command in operation
 
 
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/a

RE: RMAN restore on another server

[Spears, Brian]

I have ftp'd  the backup pieces into the identical backup location as the orignal 
server so I have all the stuff available... Im just wondering if I have to do 
something to tell it that I am on a different server...

I've restored the controlfile mannually before but on the same server. I backup the 
controlfile and wrap in the backup piece with the normal backup.


Brian

-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Janardhana - That's a good point. 
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L



May be you try the following:

 

If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.

 

-- Janardhana

 

-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L

 

Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.

Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.

 

Some of the steps to setup the new machine.

1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over

4) duplicated the Admin directories for the database to be restored

5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on

6) Created a backup mount point to store the RMAN backup pieces and
archivelogs

7) moved the backup pieces and archivelogs to the new machine

8) Setup and confirm connectivity to Rman catalog

9) No mount the database to be on the new machine

10) Launch the Rman command

rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  

 

Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...

 

Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..

 

 

 

 

Here is the command in operation

 

 

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   

 

Recovery Manager: Release 8.1.7.4.0 - Production

 

RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87> 
88>  set newname for datafile 

Re: RMAN restore on another server

[Jared Still]

I did this exercise a few months ago and created some rough
but detailed docs that you may find helpful.

http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc

Jared

On Fri, 2003-12-05 at 14:14, Spears, Brian wrote:
> Goal:  To restore the database from RMAN backup on a different server by means of 
> moving the backup pieces and logs over to the new machine and use Rman to unpack the 
> database files.
> Strategy: To restore the database  from the RMAN backup pieces into a new directory 
> locations on the machine and extract the control file and startup the database.
>  
> Some of the steps to setup the new machine.
> 1) Install oracle 8i
> 2) install the patch 4.0
> 3) copy .profile over
> 4) duplicated the Admin directories for the database to be restored
> 5) created a big mount  /u02/vssppln/ point for all the datafiles and controlfiles 
> and so on
> 6) Created a backup mount point to store the RMAN backup pieces and archivelogs
> 7) moved the backup pieces and archivelogs to the new machine
> 8) Setup and confirm connectivity to Rman catalog
> 9) No mount the database to be on the new machine
> 10) Launch the Rman command
> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  
>  
> Problem... I run this restore from Rman backup...but it gets to processing the 
> command and gets to the  "RMAN-03022: compiling command: set "  and just 
> hangs...adding another line every 1/2 hour or so...
>  
> Anybody seen this or have ideas? I talked to one guy who did have this but couldn't 
> remember the solution. This is the first time doing this so I might be missing 
> something simple..
>  
>  
>  
>  
> Here is the command in operation
>  
>  
> ==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
>  
> Recovery Manager: Release 8.1.7.4.0 - Production
>  
> RMAN> 
> RMAN> connect catalog rman81740/[EMAIL PROTECTED]
> 2> 
> 3> connect target /
> 4> 
> 5> 
> 6> 
> 7> run
> 8> 
> 9> {
> 10> 
> 11> allocate channel disk_channel1 type disk ;
> 12> 
> 13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
> 14> set until time = '2003-12-02 05:50:00';
> 15> 
> 16>  set newname for datafile 1 to
> 17> '/u02/vssppln/system01.dbf';
> 18> 
> 19>  set newname for datafile 2 to
> 20> '/u02/vssppln/rbs01.dbf';
> 21> 
> 22>  set newname for datafile 3 to
> 23> '/u02/vssppln/rbs02.dbf';
> 24> 
> 25>  set newname for datafile 4 to
> 26> '/u02/vssppln/AIMFACT01.dbf';
> 27> 
> 28>  set newname for datafile 5 to
> 29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
> 30> 
> 31>  set newname for datafile 6 to
> 32> '/u02/vssppln/AIMFACT101.dbf';
> 33> 
> 34>  set newname for datafile 7 to
> 35> '/u02/vssppln/AIMFACT102.dbf';
> 36> 
> 37>  set newname for datafile 8 to
> 38> '/u02/vssppln/aimfact1_index01.dbf';
> 39> 
> 40>  set newname for datafile 9 to
> 41> '/u02/vssppln/aimfact1_index02.dbf';
> 42> 
> 43>  set newname for datafile 10 to
> 44> '/u02/vssppln/aimfact1_index03.dbf';
> 45> 
> 46>  set newname for datafile 11 to
> 47> '/u02/vssppln/aimfact1_index04.dbf';
> 48> 
> 49>  set newname for datafile 12 to
> 50> '/u02/vssppln/aimfact201.dbf';
> 51> 
> 52>  set newname for datafile 13 to
> 53> '/u02/vssppln/aimfact202.dbf';
> 54> 
> 55>  set newname for datafile 14 to
> 56> '/u02/vssppln/aimfact2_index01.dbf';
> 57> 
> 58>  set newname for datafile 15 to
> 59> '/u02/vssppln/aimfact2_index02.dbf';
> 60> 
> 61>  set newname for datafile 16 to
> 62> '/u02/vssppln/aimfact2_index03.dbf';
> 63> 
> 64>  set newname for datafile 17 to
> 65> '/u02/vssppln/aimfact2_index04.dbf';
> 66> 
> 67>  set newname for datafile 18 to
> 68> '/u02/vssppln/aimstruct01.dbf';
> 69> 
> 70>  set newname for datafile 19 to
> 71> '/u02/vssppln/aimstruct_index01.dbf';
> 72> 
> 73>  set newname for datafile 20 to
> 74> '/u02/vssppln/aimstruct101.dbf';
> 75> 
> 76>  set newname for datafile 21 to
> 77> '/u02/vssppln/aimstruct1_index01.dbf';
> 78> 
> 79>  set newname for datafile 22 to
> 80> '/u02/vssppln/aimwork01.dbf';
> 81> 
> 82>  set newname for datafile 23 to
> 83> '/u02/vssppln/mipsdata01.dbf';
> 84> 
> 85>  set newname for datafile 24 to
> 86> '/u02/vssppln/mipsindex01.dbf';
> 87> 
> 88>  set newname for datafile 25 to
> 89> '/u02/vssppln/mipsdata101.dbf';
> 90> 
> 91>  set newname for datafile 26 to
> 92> '/u02/vssppln/mipsdata1_index01.dbf';
> 93> 
> 94>  set newname for datafile 27 to
> 95> '/u02/vssppln/mipsdata201.dbf';
> 96> 
> 97>  set newname for datafile 28 to
> 98> '/u02/vssppln/nipsdata2_index01.dbf';
> 99> 
> 100>  set newname for datafile 29 to
> 101> '/u02/vssppln/tools01.dbf';
> 102> 
> 103>  set newname for datafile 30 to
> 104> '/u02/vssppln/users01.dbf';
> 105> 
> 106>  set newname for datafile 31 to
> 107> '/u02/vssppln/AIMINDEX01.dbf';
> 108> 
> 109>  set newname for datafile 32 to
> 110> '/u02/vssppln/aimfact1_index05.dbf';
> 111> 
> 112>  set newname for datafile 33 to
> 113> '/u02/vssppln/aimfact2_index05.dbf';
> 114> 
> 115> 
> 116> restore database;

RE: RMAN restore on another server

[DENNIS WILLIAMS]

Janardhana - That's a good point. 
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L



May be you try the following:

 

If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.

 

-- Janardhana

 

-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L

 

Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.

Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.

 

Some of the steps to setup the new machine.

1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over

4) duplicated the Admin directories for the database to be restored

5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on

6) Created a backup mount point to store the RMAN backup pieces and
archivelogs

7) moved the backup pieces and archivelogs to the new machine

8) Setup and confirm connectivity to Rman catalog

9) No mount the database to be on the new machine

10) Launch the Rman command

rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  

 

Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...

 

Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..

 

 

 

 

Here is the command in operation

 

 

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   

 

Recovery Manager: Release 8.1.7.4.0 - Production

 

RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87> 
88>  set newname for datafile 25 to
89> '/u02/vssppln/mipsdata101.dbf';
90> 
91>  set newname for datafile 26 to
92> '/u02/vssppln/mipsdata1_index01.dbf';
93> 
94>  set newname for datafile 27 to
95> '/u02/vssppln/mipsdata201.dbf';
96> 
97>  set newname for datafile 28 to
98> '/u02/vssppln/nipsdata2_index01.dbf';
99> 
100>  set newname for datafile 29 to
101> '/u02/vssppln/tools01.dbf';
102> 
103>  set newname for datafile 30 to
104> '/u02/vssppln/users01.dbf';
105> 
106>  set newname for datafile 31 to
107> '/u02/vssppln/AIMIND

RE: RMAN restore on another server

[Janardhana Babu Donga]

Title: Message









May be you try the following:

 

If you get errors restoring controlfile, You
may ftp the controlfiles manually to the new server and startup mount the
database first. Then, Try your restore database.

 

-- Janardhana

 

-Original Message-
From: Spears, Brian
[mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003
2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RMAN restore on another
server

 



Goal:  To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new machine
and use Rman to unpack the database files.





Strategy: To restore the database  from the RMAN backup pieces into a
new directory locations on the machine and extract the control file and startup
the database.





 





Some of the steps to
setup the new machine.





1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over





4) duplicated the Admin
directories for the database to be restored





5) created a big
mount  /u02/vssppln/ point for all the datafiles and controlfiles and so
on





6) Created a backup mount
point to store the RMAN backup pieces and archivelogs





7) moved the backup
pieces and archivelogs to the new machine





8) Setup and confirm
connectivity to Rman catalog





9) No mount the database
to be on the new machine





10) Launch the Rman
command





rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log  





 





Problem... I run this
restore from Rman backup...but it gets to processing the command and gets
to the  "RMAN-03022: compiling command: set "  and
just hangs...adding another line every 1/2 hour or so...





 





Anybody seen this or have
ideas? I talked to one guy who did have this but couldn't remember the
solution. This is the first time doing this so I might be missing something
simple..





 





 





 





 





Here is
the command in operation





 





 





==> rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log   





 





Recovery Manager: Release
8.1.7.4.0 - Production





 





RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87> 
88>  set newname for datafile 25 to
89> '/u02/vssppln/mipsdata101.dbf';
90> 
91>  set newname for datafile 26 to
92> '/u02/vssppln/mipsdata1_index01.dbf';
93> 
94>  set newname for datafile 27 to
95> '/u02/vssppln/mipsdata201.dbf';
96> 
97>  set newname for datafile 28 to
98> '/u02/vssppln/nipsdata2_index01.dbf';
99> 
100>  set newname for datafile 29 to
101> '/u02/vssppln/tools01.dbf';
102> 
103>  set newname for datafile 30 to
104> '/u02/vssppln/users01.dbf';
105> 
106>  set newname for datafile 31 to
107> '/u02/vssppln/AIMINDEX01.dbf';
108> 
109>  set newname for datafile 32 to
110> '/u02/vssppln/aimfact1_index05.dbf';
111> 
112>  set newname for datafile 33 to
113> '/u02/vssppln/aimfact2_index05.dbf';
114> 
115> 
116> restore da

RE: RMAN restore on another server

[Janardhana Babu Donga]

Title: Message









I am sorry, I thought you are restoring
from Tape. In either case, you connect to target and catalog database on the
new server and see if you can access the backups that were backed up on the
original server.

 

-- Janardhana

 

-Original Message-
From: Spears, Brian
[mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003
2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RMAN restore on another
server

 



Goal:  To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new machine
and use Rman to unpack the database files.





Strategy: To restore the database  from the RMAN backup pieces into a
new directory locations on the machine and extract the control file and startup
the database.





 





Some of the steps to
setup the new machine.





1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over





4) duplicated the Admin
directories for the database to be restored





5) created a big
mount  /u02/vssppln/ point for all the datafiles and controlfiles and so
on





6) Created a backup mount
point to store the RMAN backup pieces and archivelogs





7) moved the backup
pieces and archivelogs to the new machine





8) Setup and confirm
connectivity to Rman catalog





9) No mount the database
to be on the new machine





10) Launch the Rman
command





rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log  





 





Problem... I run this
restore from Rman backup...but it gets to processing the command and gets
to the  "RMAN-03022: compiling command: set "  and
just hangs...adding another line every 1/2 hour or so...





 





Anybody seen this or have
ideas? I talked to one guy who did have this but couldn't remember the
solution. This is the first time doing this so I might be missing something
simple..





 





 





 





 





Here is
the command in operation





 





 





==> rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log   





 





Recovery Manager: Release
8.1.7.4.0 - Production





 





RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87> 
88>  set newname for datafile 25 to
89> '/u02/vssppln/mipsdata101.dbf';
90> 
91>  set newname for datafile 26 to
92> '/u02/vssppln/mipsdata1_index01.dbf';
93> 
94>  set newname for datafile 27 to
95> '/u02/vssppln/mipsdata201.dbf';
96> 
97>  set newname for datafile 28 to
98> '/u02/vssppln/nipsdata2_index01.dbf';
99> 
100>  set newname for datafile 29 to
101> '/u02/vssppln/tools01.dbf';
102> 
103>  set newname for datafile 30 to
104> '/u02/vssppln/users01.dbf';
105> 
106>  set newname for datafile 31 to
107> '/u02/vssppln/AIMINDEX01.dbf';
108> 
109>  set newname for datafile 32 to
110> '/u02/vssppln/aimfact1_index05.dbf';
111> 
112>  set newname for datafile 33 to
113> '/u02/vssppln/aimfact2_index05.dbf';
114> 
115> 
116> re

RE: RMAN restore on another server

[Janardhana Babu Donga]

Title: Message









By default RMAN restores the backup to the
machine from where it is backedup. If you need to restore the backup on to
alternate client, your netbackup admin has to setup the access. You have not mentioned
whether you are using Netbackup or legato or something else. Once the access is
set up, you can test it by connecting to rman target / catalog rman/[EMAIL PROTECTED] on
the new machine ,and issuing the command list backup at RMAN prompt on the new
machine. If you see the backups, you can restore the backup. If you are using
NETBACKUP, use the var NB_ORA_CLIENT, If not substitute with the corresponding
variable.

 

Startup nomount;

Run {

Allocate channel t1 type 'sbt_tape'
 parms="ENV=(NB_ORA_CLIENT=backedupclient; export NB_ORA_CLIENT);

Restore controlfile;

Alter database mount;

Restore database;

Alter database open;

}

 

-- Janardhana

-Original Message-
From: Spears, Brian
[mailto:[EMAIL PROTECTED] 
Sent: Friday,
 December 05, 2003 2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RMAN restore on another
server

 



Goal:  To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new machine
and use Rman to unpack the database files.





Strategy: To restore the database  from the RMAN backup pieces into a
new directory locations on the machine and extract the control file and startup
the database.





 





Some of the steps to
setup the new machine.





1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over





4) duplicated the Admin
directories for the database to be restored





5) created a big
mount  /u02/vssppln/ point for all the datafiles and controlfiles and so
on





6) Created a backup mount
point to store the RMAN backup pieces and archivelogs





7) moved the backup
pieces and archivelogs to the new machine





8) Setup and confirm
connectivity to Rman catalog





9) No mount the database
to be on the new machine





10) Launch the Rman
command





rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log  





 





Problem... I run this
restore from Rman backup...but it gets to processing the command and gets
to the  "RMAN-03022: compiling command: set "  and
just hangs...adding another line every 1/2 hour or so...





 





Anybody seen this or have
ideas? I talked to one guy who did have this but couldn't remember the
solution. This is the first time doing this so I might be missing something
simple..





 





 





 





 





Here is
the command in operation





 





 





==> rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log   





 





Recovery Manager: Release
8.1.7.4.0 - Production





 





RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87> 
88>  set newname for datafile 25 to
89> '/u02/vssppln/mipsdata101.dbf';
90> 
91>  set newname for datafile

Re: RMAN restore on another server

[Joe Testa]

How did you expect the restore to work w/o first restoring the 
controlfile? or am i missing something here?

joe

Spears, Brian wrote:

*Goal:*  To restore the database from RMAN backup on a different 
server by means of moving the backup pieces and logs over to the new 
machine and use Rman to unpack the database files.
*Strategy:* To restore the database  from the RMAN backup pieces into 
a new directory locations on the machine and extract the control file 
and startup the database.
 
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount  /u02/vssppln/ point for all the datafiles and 
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and 
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log 
 
Problem... I run this restore from Rman backup...but it gets to 
processing the command and gets to the  "RMAN-03022: compiling 
command: set "  and just hangs...adding another line every 1/2 hour or 
so...
 
Anybody seen this or have ideas? I talked to one guy who did have this 
but couldn't remember the solution. This is the first time doing this 
so I might be missing something simple..
 
 
 
 
*Here is the command in operation*
 
 
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log  
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED] 

2>
3> connect target /
4>
5>
6>
7> run
8>
9> {
10>
11> allocate channel disk_channel1 type disk ;
12>
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15>
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18>
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21>
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24>
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27>
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30>
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33>
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36>
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39>
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42>
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45>
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48>
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51>
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54>
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57>
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60>
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63>
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66>
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69>
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72>
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75>
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78>
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81>
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84>
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87>
88>  set newname for datafile 25 to
89> '/u02/vssppln/mipsdata101.dbf';
90>
91>  set newname for datafile 26 to
92> '/u02/vssppln/mipsdata1_index01.dbf';
93>
94>  set newname for datafile 27 to
95> '/u02/vssppln/mipsdata201.dbf';
96>
97>  set newname for datafile 28 to
98> '/u02/vssppln/nipsdata2_index01.dbf';
99>
100>  set newname for datafile 29 to
101> '/u02/vssppln/tools01.dbf';
102>
103>  set newname for datafile 30 to
104> '/u02/vssppln/users01.dbf';
105>
106>  set newname for datafile 31 to
107> '/u02/vssppln/AIMINDEX01.dbf';
108>
109>  set newname for datafile 32 to
110> '/u02/vssppln/aimfact1_index05.dbf';
111>
112>  set newname for datafile 33 to
113> '/u02/vssppln/aimfact2_index05.dbf';
114>
115>
116> restore database;
117>
118> restore controlfile to '/u02/vssppln/restored_cf.ctl';
119>
120> mount database;
121>
122> switch datafile all;
123>
124> release channel disk_channel1;
125> }
126>
127>
RMAN-06008: connected to recovery catalog database
 
RMAN-06006: connected to target database: vssppln (not mounted)
 
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: disk_channel1
RMAN-08500

RE: RMAN restore on another server

[DENNIS WILLIAMS]

Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
   1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database  and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
   2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
   3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
 
Sorry, but that is all my brain can think up on Friday.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L


Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
 
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  
 
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...
 
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
 
 
 
 
Here is the command in operation
 
 
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for data

RE: RE: RMAN questions

[DENNIS WILLIAMS]

Ryan - No, the documents imply that it is one or the other. My tasks was to
perform a disaster recovery, and it seemed pretty hard to configure a
catalog on a test server, so I just tried the controlfile method and
discovered it worked. If you are on Oracle 9i, it backups the control file
for you.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, December 04, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L


i must have misread the docs. i thought it was either catalog or control
file. didnt know you could do both
thanks. 

> 
> From: <[EMAIL PROTECTED]>
> Date: 2003/12/04 Thu AM 11:04:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RMAN questions
> 
> 
> I suppose just how much redundancy makes you sleep well is up to you.
But,
> one additional bit of info to keep in mind is that the backup info also
gets
> stored in the control files, and rman can use those too if no catalog
> database is available.  Making a copy of a control file after the backup
> finishes, and saving that copy, can be a part of the rman backup.  That
way,
> if you lost all control files and your catalog database, rman can use your
> saved control file copy get back at least most, if not all, of your stuff.
> 
> > -Original Message-
> > 
> > Any suggestions would be appreciated. I can handle the 
> > scripting my self. Im just looking for a viable plan. 
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN questions

[Yechiel Adar]

> backup of all the environment for this small backup.
It should have been: for this small database.
Sorry about the mistake.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 6:44 PM


> I do not think you need 2 Rman catalogs.
> Build a small database just for Rman. After the daily backup finished
bring
> it down and do os level backup of all the environment for this small
backup.
> You can then easily restore it in case of disk problems.
>
> Remember: A backup is good only when you can restore from it.
> Test restores.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, December 04, 2003 4:44 PM
>
>
> > We have both 8i and 9i instances, but 'eventually' plan to migrate
> everything to 9i. I'm looking at using RMAN for our backup and recovery.
We
> have many instances but essentially 2 types.
> >
> > 1. Production instances that have both OLAP and OLTP. These must be in
> archive log mode.
> > 2. We have staging instances where we do data loads. We do not put these
> in archive log mode for obvious reasons. We do our backups of these with
> transportable tablespaces and running dbverify.
> >
> > We also have 2 locations. One is remote. Its not practical to store our
> backups from the remote location at our local location or vice versa. So
we
> will need 2 seperate RMAN setups.
> >
> > I have seen that some people like to use two instances that have RMAN.
> Many people will just put the RMAN catalog in an existing instance. Is
that
> really a good idea? The idea behind two instances is that they can back
each
> other up. Is that really enough? You can lose both instances, then your
> backup sets are useless. We have a shared NAS, so each location uses the
> same set of storage. We do backup to tape as well.
> >
> > Any suggestions would be appreciated. I can handle the scripting my
self.
> Im just looking for a viable plan.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <[EMAIL PROTECTED]
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RE: RMAN questions

[ryan_oracle]

i must have misread the docs. i thought it was either catalog or control file. didnt 
know you could do both
thanks. 

> 
> From: <[EMAIL PROTECTED]>
> Date: 2003/12/04 Thu AM 11:04:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RMAN questions
> 
> 
> I suppose just how much redundancy makes you sleep well is up to you.  But,
> one additional bit of info to keep in mind is that the backup info also gets
> stored in the control files, and rman can use those too if no catalog
> database is available.  Making a copy of a control file after the backup
> finishes, and saving that copy, can be a part of the rman backup.  That way,
> if you lost all control files and your catalog database, rman can use your
> saved control file copy get back at least most, if not all, of your stuff.
> 
> > -Original Message-
> > 
> > Any suggestions would be appreciated. I can handle the 
> > scripting my self. Im just looking for a viable plan. 
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN questions

[Yechiel Adar]

I do not think you need 2 Rman catalogs.
Build a small database just for Rman. After the daily backup finished bring
it down and do os level backup of all the environment for this small backup.
You can then easily restore it in case of disk problems.

Remember: A backup is good only when you can restore from it.
Test restores.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 4:44 PM


> We have both 8i and 9i instances, but 'eventually' plan to migrate
everything to 9i. I'm looking at using RMAN for our backup and recovery. We
have many instances but essentially 2 types.
>
> 1. Production instances that have both OLAP and OLTP. These must be in
archive log mode.
> 2. We have staging instances where we do data loads. We do not put these
in archive log mode for obvious reasons. We do our backups of these with
transportable tablespaces and running dbverify.
>
> We also have 2 locations. One is remote. Its not practical to store our
backups from the remote location at our local location or vice versa. So we
will need 2 seperate RMAN setups.
>
> I have seen that some people like to use two instances that have RMAN.
Many people will just put the RMAN catalog in an existing instance. Is that
really a good idea? The idea behind two instances is that they can back each
other up. Is that really enough? You can lose both instances, then your
backup sets are useless. We have a shared NAS, so each location uses the
same set of storage. We do backup to tape as well.
>
> Any suggestions would be appreciated. I can handle the scripting my self.
Im just looking for a viable plan.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN questions

[Stephen.Lee]

I suppose just how much redundancy makes you sleep well is up to you.  But,
one additional bit of info to keep in mind is that the backup info also gets
stored in the control files, and rman can use those too if no catalog
database is available.  Making a copy of a control file after the backup
finishes, and saving that copy, can be a part of the rman backup.  That way,
if you lost all control files and your catalog database, rman can use your
saved control file copy get back at least most, if not all, of your stuff.

> -Original Message-
> 
> Any suggestions would be appreciated. I can handle the 
> scripting my self. Im just looking for a viable plan. 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN Script

[Gilles PARC]

Hi Ramon,

I guess you are on 8i :
your setsize and fileperset specs should be 
inside the backup command not outside i.e.
something like this :

backup
 fileperset 2
 setsize 2000
 database

Re: RMAN restore to different machine

[Tanel Poder]

Wait till 10g.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 11:29 PM


> My apologies, I bumped the "send" button.
> Stephen - my understanding is that you are correct, the platforms have to
be
> the same at the binary level - i.e.., both Solaris, both Windows, etc.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Monday, November 24, 2003 3:20 PM
> To: '[EMAIL PROTECTED]'
>
>
> Good catch Stephen. My understanding is that you
>
> -Original Message-
> Sent: Monday, November 24, 2003 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> More food for thought:
>
> There is a good chance that the hardware platform is different.  I
> think that RMAN is not a valid way of changing to a new platform and you
> would need to export/import.  I'm certain the experts on the list will
> correct me if I'm wrong.
>
> Thanks
> Stephen
>
> >>> [EMAIL PROTECTED] 11/24/03 11:54AM >>>
> Randy
>First, you may want to investigate your company's attitude toward
> recovering their proprietary data on your personal machine.
>I can give you some ideas on your task, but my experience is on
> 1)Unix,
> and 2) Oracle 8i.
>I would recommend you purchase Robert Freeman's book Oracle9i RMAN
> Backup
> & Recovery. Well worth the money.
>In Oracle8i I wasn't able to extract the control file from the RMAN
> backup, so I just backed that up separately. But I think Robert's book
> describes how to do that.
>I never worried about the init.ora file in Oracle8i, relying on the
> normal system backup to back that up. You could probably either copy
> the
> spfile from your production system (if you tell me you don't have
> access to
> that system, then you'll really concern me about what you are trying to
> do)
> or create a dummy init.ora to get the instance started.
>I don't know if you used the controlfile or catalog backup to create
> this
> RMAN backup. I use the catalog backup, but found it easier to recover
> using
> just the controlfile.
>The one sticky point is that RMAN will want its backup pieces in the
> same
> path that it backed them up. I haven't found any way of changing that.
> In
> Unix you can fool RMAN by creating a link. When you say that you
> couldn't
> get RMAN to look at the CD drive, that may be the problem you are
> encountering. If you are using Windows, perhaps you could find the
> drive
> letter used to create the backup and use that same drive letter on
> your
> personal machine.
>You can change the location where RMAN will restore the files with
> the
> SET NEWNAME command for each data file.
>RMAN will restore the database with the original instance name.
>Hope this is of some assistance.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Monday, November 24, 2003 7:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I have an online backup of my 9i production database on CD.  I want to
> restore it to my home PC, which has a completely different file
> structure
> and an empty database.  I did the backup with rman.  I spent most of
> Saturday trying this and can not even get rman to look at the backup
> set on
> the CD.  I'd be real happy if someone can just explain how to restore
> the
> spfile and the control file.
>
> Thanks
> Randy
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Steiner, Randy
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stephen Andert
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity

RE: RMAN restore to different machine

[DENNIS WILLIAMS]

Good catch Stephen. My understanding is that you

-Original Message-
Sent: Monday, November 24, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


More food for thought:

There is a good chance that the hardware platform is different.  I
think that RMAN is not a valid way of changing to a new platform and you
would need to export/import.  I'm certain the experts on the list will
correct me if I'm wrong.

Thanks
Stephen

>>> [EMAIL PROTECTED] 11/24/03 11:54AM >>>
Randy
   First, you may want to investigate your company's attitude toward
recovering their proprietary data on your personal machine.
   I can give you some ideas on your task, but my experience is on
1)Unix,
and 2) Oracle 8i. 
   I would recommend you purchase Robert Freeman's book Oracle9i RMAN
Backup
& Recovery. Well worth the money.
   In Oracle8i I wasn't able to extract the control file from the RMAN
backup, so I just backed that up separately. But I think Robert's book
describes how to do that.
   I never worried about the init.ora file in Oracle8i, relying on the
normal system backup to back that up. You could probably either copy
the
spfile from your production system (if you tell me you don't have
access to
that system, then you'll really concern me about what you are trying to
do)
or create a dummy init.ora to get the instance started.
   I don't know if you used the controlfile or catalog backup to create
this
RMAN backup. I use the catalog backup, but found it easier to recover
using
just the controlfile. 
   The one sticky point is that RMAN will want its backup pieces in the
same
path that it backed them up. I haven't found any way of changing that.
In
Unix you can fool RMAN by creating a link. When you say that you
couldn't
get RMAN to look at the CD drive, that may be the problem you are
encountering. If you are using Windows, perhaps you could find the
drive
letter used to create the backup and use that same drive letter on
your
personal machine.
   You can change the location where RMAN will restore the files with
the
SET NEWNAME command for each data file.
   RMAN will restore the database with the original instance name.
   Hope this is of some assistance.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 24, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L


I have an online backup of my 9i production database on CD.  I want to
restore it to my home PC, which has a completely different file
structure
and an empty database.  I did the backup with rman.  I spent most of
Saturday trying this and can not even get rman to look at the backup
set on
the CD.  I'd be real happy if someone can just explain how to restore
the
spfile and the control file.

Thanks
Randy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Steiner, Randy
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

RE: RMAN restore to different machine

[DENNIS WILLIAMS]

My apologies, I bumped the "send" button.
Stephen - my understanding is that you are correct, the platforms have to be
the same at the binary level - i.e.., both Solaris, both Windows, etc.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 24, 2003 3:20 PM
To: '[EMAIL PROTECTED]'


Good catch Stephen. My understanding is that you

-Original Message-
Sent: Monday, November 24, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


More food for thought:

There is a good chance that the hardware platform is different.  I
think that RMAN is not a valid way of changing to a new platform and you
would need to export/import.  I'm certain the experts on the list will
correct me if I'm wrong.

Thanks
Stephen

>>> [EMAIL PROTECTED] 11/24/03 11:54AM >>>
Randy
   First, you may want to investigate your company's attitude toward
recovering their proprietary data on your personal machine.
   I can give you some ideas on your task, but my experience is on
1)Unix,
and 2) Oracle 8i. 
   I would recommend you purchase Robert Freeman's book Oracle9i RMAN
Backup
& Recovery. Well worth the money.
   In Oracle8i I wasn't able to extract the control file from the RMAN
backup, so I just backed that up separately. But I think Robert's book
describes how to do that.
   I never worried about the init.ora file in Oracle8i, relying on the
normal system backup to back that up. You could probably either copy
the
spfile from your production system (if you tell me you don't have
access to
that system, then you'll really concern me about what you are trying to
do)
or create a dummy init.ora to get the instance started.
   I don't know if you used the controlfile or catalog backup to create
this
RMAN backup. I use the catalog backup, but found it easier to recover
using
just the controlfile. 
   The one sticky point is that RMAN will want its backup pieces in the
same
path that it backed them up. I haven't found any way of changing that.
In
Unix you can fool RMAN by creating a link. When you say that you
couldn't
get RMAN to look at the CD drive, that may be the problem you are
encountering. If you are using Windows, perhaps you could find the
drive
letter used to create the backup and use that same drive letter on
your
personal machine.
   You can change the location where RMAN will restore the files with
the
SET NEWNAME command for each data file.
   RMAN will restore the database with the original instance name.
   Hope this is of some assistance.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 24, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L


I have an online backup of my 9i production database on CD.  I want to
restore it to my home PC, which has a completely different file
structure
and an empty database.  I did the backup with rman.  I spent most of
Saturday trying this and can not even get rman to look at the backup
set on
the CD.  I'd be real happy if someone can just explain how to restore
the
spfile and the control file.

Thanks
Randy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Steiner, Randy
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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

RE: RMAN restore to different machine

[Stephen Andert]

More food for thought:

There is a good chance that the hardware platform is different.  I
think that RMAN is not a valid way of changing to a new platform and you
would need to export/import.  I'm certain the experts on the list will
correct me if I'm wrong.

Thanks
Stephen

>>> [EMAIL PROTECTED] 11/24/03 11:54AM >>>
Randy
   First, you may want to investigate your company's attitude toward
recovering their proprietary data on your personal machine.
   I can give you some ideas on your task, but my experience is on
1)Unix,
and 2) Oracle 8i. 
   I would recommend you purchase Robert Freeman's book Oracle9i RMAN
Backup
& Recovery. Well worth the money.
   In Oracle8i I wasn't able to extract the control file from the RMAN
backup, so I just backed that up separately. But I think Robert's book
describes how to do that.
   I never worried about the init.ora file in Oracle8i, relying on the
normal system backup to back that up. You could probably either copy
the
spfile from your production system (if you tell me you don't have
access to
that system, then you'll really concern me about what you are trying to
do)
or create a dummy init.ora to get the instance started.
   I don't know if you used the controlfile or catalog backup to create
this
RMAN backup. I use the catalog backup, but found it easier to recover
using
just the controlfile. 
   The one sticky point is that RMAN will want its backup pieces in the
same
path that it backed them up. I haven't found any way of changing that.
In
Unix you can fool RMAN by creating a link. When you say that you
couldn't
get RMAN to look at the CD drive, that may be the problem you are
encountering. If you are using Windows, perhaps you could find the
drive
letter used to create the backup and use that same drive letter on
your
personal machine.
   You can change the location where RMAN will restore the files with
the
SET NEWNAME command for each data file.
   RMAN will restore the database with the original instance name.
   Hope this is of some assistance.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 24, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L


I have an online backup of my 9i production database on CD.  I want to
restore it to my home PC, which has a completely different file
structure
and an empty database.  I did the backup with rman.  I spent most of
Saturday trying this and can not even get rman to look at the backup
set on
the CD.  I'd be real happy if someone can just explain how to restore
the
spfile and the control file.

Thanks
Randy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Steiner, Randy
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN restore to different machine

[DENNIS WILLIAMS]

Randy
   First, you may want to investigate your company's attitude toward
recovering their proprietary data on your personal machine.
   I can give you some ideas on your task, but my experience is on 1)Unix,
and 2) Oracle 8i. 
   I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup
& Recovery. Well worth the money.
   In Oracle8i I wasn't able to extract the control file from the RMAN
backup, so I just backed that up separately. But I think Robert's book
describes how to do that.
   I never worried about the init.ora file in Oracle8i, relying on the
normal system backup to back that up. You could probably either copy the
spfile from your production system (if you tell me you don't have access to
that system, then you'll really concern me about what you are trying to do)
or create a dummy init.ora to get the instance started.
   I don't know if you used the controlfile or catalog backup to create this
RMAN backup. I use the catalog backup, but found it easier to recover using
just the controlfile. 
   The one sticky point is that RMAN will want its backup pieces in the same
path that it backed them up. I haven't found any way of changing that. In
Unix you can fool RMAN by creating a link. When you say that you couldn't
get RMAN to look at the CD drive, that may be the problem you are
encountering. If you are using Windows, perhaps you could find the drive
letter used to create the backup and use that same drive letter on your
personal machine.
   You can change the location where RMAN will restore the files with the
SET NEWNAME command for each data file.
   RMAN will restore the database with the original instance name.
   Hope this is of some assistance.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 24, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L


I have an online backup of my 9i production database on CD.  I want to
restore it to my home PC, which has a completely different file structure
and an empty database.  I did the backup with rman.  I spent most of
Saturday trying this and can not even get rman to look at the backup set on
the CD.  I'd be real happy if someone can just explain how to restore the
spfile and the control file.

Thanks
Randy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steiner, Randy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN: connecting target DB with SYS account using connect string

[Ruth Gramolini]

IF you set your ORACLE_SID to the target database as the Oracle user, all
you have to do is say >RMAN connect target and it will automatically
connect.  If you are working from the command line you connect
user_with_sysdba_privs/[EMAIL PROTECTED] and you will be connected.  If
does not recognize the "as sysdba".

HTH,
Ruth

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
  Saminathan
  Sent: Tuesday, November 04, 2003 10:15 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN: connecting target DB with SYS account using connect
  string


  Hi list,

  I have problem connecting to target DB using account SYS with
  connect string. But SQL*Plus works fine.

  For example,

  SQL>connect sys/[EMAIL PROTECTED]
  connected.

  but in RMAN (using same OS account and server)
  ==

  RMAN> connect target sys/[EMAIL PROTECTED]  failed
  RMAN-00571: ===
  RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
  RMAN-00571: ===
  RMAN-04005: error from target database: ORA-01017: invalid
  username/password; logon denied

  Any help will be really appreciated.

  -Sami


  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Saminathan
INET: [EMAIL PROTECTED]

  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN: connecting target DB with SYS account using connect str

[DENNIS WILLIAMS]

Sami - You may also need to create an orapw file in order to connect as
SYSDBA remotely.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 04, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
str


Sami,

RMAN connects as SYSDBA. The password may actually be different. 

The good one is that works

SQL>connect sys/[EMAIL PROTECTED] as SYSDBA

HTH
Vadim

-Original Message-
Sent: Tuesday, November 04, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
string


Hi list,

I have problem connecting to target DB using account SYS with connect
string. But SQL*Plus works fine.

For example,

SQL>connect sys/[EMAIL PROTECTED]
connected.

but in RMAN (using same OS account and server)
==

RMAN> connect target sys/[EMAIL PROTECTED]  failed
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-04005: error from target database: ORA-01017: invalid
username/password; logon denied

Any help will be really appreciated.

-Sami


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saminathan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gorbounov,Vadim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN: connecting target DB with SYS account using connect str

[Gorbounov,Vadim]

Sami,

RMAN connects as SYSDBA. The password may actually be different. 

The good one is that works

SQL>connect sys/[EMAIL PROTECTED] as SYSDBA

HTH
Vadim

-Original Message-
Sent: Tuesday, November 04, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
string


Hi list,

I have problem connecting to target DB using account SYS with connect
string. But SQL*Plus works fine.

For example,

SQL>connect sys/[EMAIL PROTECTED]
connected.

but in RMAN (using same OS account and server)
==

RMAN> connect target sys/[EMAIL PROTECTED]  failed
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-04005: error from target database: ORA-01017: invalid
username/password; logon denied

Any help will be really appreciated.

-Sami


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saminathan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gorbounov,Vadim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN: SVR4 Error: 27: File too large

[Andy Rivenes]

It looks like you need to "SET LIMIT ..." for the channel allocation, if 
8i, to less than 2GB. In 9i this can be set with MAXSETSIZE (not sure if 
SET LIMIT is still supported in 9i).

Note that you cannot back up a file larger than the SET LIMIT size, so 
based on your  ulimit command I assume that you don't have any datafiles 
larger the 2GB as well.

Andy Rivenes
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Andy Rivenes
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN: SVR4 Error: 27: File too large

[Ron Rogers]

Tamizh,
 To set the limit on the size of the output file use
"set limit channel d1 kbytes=30;" for a 3 gig file .
Ron

>>> [EMAIL PROTECTED] 10/30/03 10:04AM >>>
Hi List,

How to fix this error without changing something in OS level? Is tehre
any command to set max block size in RMAn before we do backup?

Thanks in advance?


RMAN-08031: released channel: c1
RMAN-08031: released channel: c2
RMAN-08031: released channel: c3
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
===
RMAN-00571:
===
RMAN-10035: exception raised in RPC: O
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-03015: error occurred in stored script ts_noncrm_data_backup
RMAN-03007: retryable error occurred during execution of command:
backup
RMAN-07004: unhandled exception during command execution on channel c1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file
"/u03/backup/rman/al_HSBC5087585421"
ORA-27044: unable to write the header block of file
SVR4 Error: 27: File too large
Additional information: 3
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
 
RMAN> 


$ ulimit -sa
time(seconds)unlimited
file(blocks) unlimited
data(kbytes) 2097148
stack(kbytes)8192
coredump(blocks) 0
nofiles(descriptors) 64
vmemory(kbytes)  unlimited



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN: SVR4 Error: 27: File too large

[Mladen Gogala]

Have you ever considered purchasing Robert Freeman's RMAN book?
If memory  serves me right, it does describe MAXPIECESIZE option 
to configure and allocate channel commands. 

On 10/30/2003 10:04:32 AM, [EMAIL PROTECTED] wrote:
> Hi List,
> 
> How to fix this error without changing something in OS level? Is tehre any command 
> to set max block size in RMAn before we do backup?
> 
> Thanks in advance?
> 
> 
> RMAN-08031: released channel: c1
> RMAN-08031: released channel: c2
> RMAN-08031: released channel: c3
> RMAN-00571: ===
> RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
> RMAN-00571: ===
> RMAN-10035: exception raised in RPC: O
> RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
> RMAN-03015: error occurred in stored script ts_noncrm_data_backup
> RMAN-03007: retryable error occurred during execution of command: backup
> RMAN-07004: unhandled exception during command execution on channel c1
> RMAN-10035: exception raised in RPC: ORA-19504: failed to create file 
> "/u03/backup/rman/al_HSBC5087585421"
> ORA-27044: unable to write the header block of file
> SVR4 Error: 27: File too large
> Additional information: 3
> RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
>  
> RMAN> 
> 
> 
> $ ulimit -sa
> time(seconds)unlimited
> file(blocks) unlimited
> data(kbytes) 2097148
> stack(kbytes)8192
> coredump(blocks) 0
> nofiles(descriptors) 64
> vmemory(kbytes)  unlimited
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN Error

[Tim Gorman]

Tamizh,

You are probably running out of space in the file-system you
were located within when you invoked RMAN.  It would be
better to specify a full path-name in the "FORMAT=" clause
(i.e. specify directory as well as filename), to make sure
that the file-system where you are creating the backupsets
is the one you intend.

Hope this helps...

-Tim


> Hi List,
> 
> I am getting the following RMAN error. Any help would be
> really appreciated. 
> RMAN script:-
> ==
> RMAN> replace script ts_system_backup
> {
> allocate channel c1 type disk;
> allocate channel c2 type disk;
> allocate channel c3 type disk;
> sql 'alter system switch logfile';
> resync catalog;
> backup tablespace system format='al_%d%t%p';
> }
> 
> OUTPUT
> 
> 
> RMAN-03022: compiling command: backup
> RMAN-03023: executing command: backup
> RMAN-08008: channel c1: starting full datafile backupset
> RMAN-08502: set_count=7 set_stamp=508754890
> creation_time=30-OCT-03 RMAN-08010: channel c1: specifying
> datafile(s) in backupset RMAN-08522: input datafile
> fno=1 name=/dev/vx/rdsk/dbdg10/System.dbf RMAN-08011:
> including current controlfile in backupset RMAN-03026:
> error recovery releasing channel resources RMAN-08031:
> released channel: c1 RMAN-08031: released channel: c2
> RMAN-08031: released channel: c3
> RMAN-00571:
> ==
> = RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
> === RMAN-00571:
> ==
> = RMAN-03015: error occurred in stored script
> ts_system_backup RMAN-03007: retryable error occurred
> during execution of command: backup RMAN-07004: unhandled
> exception during command execution on channel c1
> RMAN-10035: exception raised in RPC: ORA-19502: write
> error on file "al_HSBC5087548901", blockno 2040833
> (blocksize=512) ORA-27063: skgfospo: number of bytes
> read/written is incorrect Additional information: 52736
> Additional information: 131072
> RMAN-10031: ORA-19624 occurred during call to
> DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
>  
> RMAN> 
>  
> Recovery Manager complete.
> 
> Thanks
> -tamizh
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com San Diego, California--
> Mailing list and web hosting services
> --
> --- To REMOVE yourself from this mailing list,
> send an E-Mail message to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman backup

[DENNIS WILLIAMS]

AK
   When you have RMAN back up archived logs, IIRC, in a recovery RMAN first
restores those archived logs to the location that Oracle will expect them to
be, and I believe that is done as part of the RESTORE DATABASE command. In
my situation, I found no advantage from having RMAN store the archive logs,
so I have no experience there, just what I've read in the manual. 
Only RMAN can perform the RESTORE DATABASE command, but once you
complete that command, you can complete the recovery using svrmgrl. From
everything I've seen, RMAN just issues the RECOVER DATABASE command to
svrmgrl or SQL*Plus.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 28, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L


Thanks Dennis  for Reply,
My confusion is , does RMAN sees only those archived logs which are backup
using rman or it can use current archived log as well stored in original
format at other disk ?

-ak


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 10:49 AM


> AK - Unless you specify otherwise, RMAN will automatically apply archive
> logs to bring the database up to the time of failure (your recover
database
> statement). This is why it is good to run disaster recovery tests on a
> regular basis, to ensure everything is ready, and you can try different
> recovery times. You will see that RMAN will not complete its recovery if
the
> archived logs are not available.
>
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Tuesday, October 28, 2003 11:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We take daily rman backup each nite at 10pm . Which means in worst case we
> risk one day of work.  Now suppose something wrong goes before 10 pm .
Then
> Can I recover my database till time using previous day rman backup and
> currently available archived logs.
>
> Or in nutshell is it possible to run { restore databse; recover database }
> from rman and then apply remaing archived logs from a separated disk ( not
a
> rman backup ).
>
> Thanks,
> -ak
>
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman backup

[Ruth Gramolini]

As long as you have 
the database in archivelog mode and have a level 0 backup as your starting point 
then you can recover.  Make sure that your level 0 includes the 
controlfiles.
 
HTH,
Ruth

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Tuesday, 
  October 28, 2003 12:44 PMTo: Multiple recipients of list 
  ORACLE-LSubject: rman backup
  We take daily rman backup each nite at 10pm . 
  Which means in worst case we risk one day of work.  Now suppose something 
  wrong goes before 10 pm . Then Can I recover my database till time using 
  previous day rman backup and currently available archived logs.
   
  Or in nutshell is it possible to run { restore 
  databse; recover database } from rman and then apply remaing archived logs 
  from a separated disk ( not a rman backup ).
   
  Thanks,
  -ak
   
   
   

Re: rman backup

[AK]

Thanks Dennis  for Reply,
My confusion is , does RMAN sees only those archived logs which are backup
using rman or it can use current archived log as well stored in original
format at other disk ?

-ak


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 10:49 AM


> AK - Unless you specify otherwise, RMAN will automatically apply archive
> logs to bring the database up to the time of failure (your recover
database
> statement). This is why it is good to run disaster recovery tests on a
> regular basis, to ensure everything is ready, and you can try different
> recovery times. You will see that RMAN will not complete its recovery if
the
> archived logs are not available.
>
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Tuesday, October 28, 2003 11:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We take daily rman backup each nite at 10pm . Which means in worst case we
> risk one day of work.  Now suppose something wrong goes before 10 pm .
Then
> Can I recover my database till time using previous day rman backup and
> currently available archived logs.
>
> Or in nutshell is it possible to run { restore databse; recover database }
> from rman and then apply remaing archived logs from a separated disk ( not
a
> rman backup ).
>
> Thanks,
> -ak
>
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: rman backup

[Mladen Gogala]

You can restore database and open it to the mount phase using RMAN. 
Then you can get into sqlplus and type something like:

alter system set log_archive_dest_1=/directory/where/log/archives/reside
set autorecovery on
recover database auto until cancel

On 10/28/2003 12:44:24 PM, AK wrote:
> We take daily rman backup each nite at 10pm . Which means in worst case we risk one 
> day of work.  Now suppose something wrong goes before 10 pm . Then Can I recover my 
> database till time using previous day rman backup and currently available archived 
> logs.
> 
> Or in nutshell is it possible to run { restore databse; recover database } from rman 
> and then apply remaing archived logs from a separated disk ( not a rman backup ).
> 
> Thanks,
> -ak
> 
> 
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: rman backup

[DENNIS WILLIAMS]

AK - Unless you specify otherwise, RMAN will automatically apply archive
logs to bring the database up to the time of failure (your recover database
statement). This is why it is good to run disaster recovery tests on a
regular basis, to ensure everything is ready, and you can try different
recovery times. You will see that RMAN will not complete its recovery if the
archived logs are not available.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 28, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L


We take daily rman backup each nite at 10pm . Which means in worst case we
risk one day of work.  Now suppose something wrong goes before 10 pm . Then
Can I recover my database till time using previous day rman backup and
currently available archived logs.
 
Or in nutshell is it possible to run { restore databse; recover database }
from rman and then apply remaing archived logs from a separated disk ( not a
rman backup ).
 
Thanks,
-ak
 
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN Incremental

[Tim Gorman]

Title: Re: RMAN Incremental



Michael,

Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at “http://www.EvDBT.com/papers.htm”, entitled “Managing the Data Lifecycle”.

-Tim

on 10/24/03 4:34 PM, Michael Kline at [EMAIL PROTECTED] wrote:

I'm working at a Data Warehouse and they are looking for backup possibilities... 
 
This is almost a TB, a baby, and it may be that RMAN with incremental could be a good solution.
 
If say for instance there is a single tablespace of some 100 gig and they add 200,000,000 records to one of the tables and we do an incremental backup. Is the whole tablespace slated for backup?
 
Also if this tablespace was lost, and we recover.. What happens during that process? Does RMAN basically have to filter through two complete copies of that tablespace or just once and then get changed blocks?
 
What solutions have some doing this found to be "best practice"?
 
Thanks.

Michael Kline, Principal Consultant
Business To Business Solutions, LLC
Richmond, VA
804-744-1545

Re: RMAN Incremental

[Arup Nanda]

Michael,
 
I hope you have the tables partitioned on some date 
column. You can make some of the older partitions read only and back them up 
only once.
 
Another solution is to exchange the partitions with 
a table to convert your old partitions to tables, transporting them to a tape 
and keep it on the tape. If the database crashed, you will plug these TSs back 
to the DB and exchange the partitions with the tables created 
earlier.
 
I presented a session at Oracle World this year 
describing a case study of a datawarehouse where I have described the backup and 
recovery approach. You can download it from OTN or from my website (www.proligence.com/downloads.html). 
Be sure to download both the paper and the presentation.
 
HTH.
 
Arup Nanda

  - Original Message - 
  From: 
  Michael 
  Kline 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, October 24, 2003 7:34 
  PM
  Subject: RMAN Incremental
  
  I'm working at a 
  Data Warehouse and they are looking for backup possibilities... 
  
   
  This is almost a 
  TB, a baby, and it may be that RMAN with incremental could be a good 
  solution.
   
  If say for 
  instance there is a single tablespace of some 100 gig and they add 200,000,000 
  records to one of the tables and we do an incremental backup. Is the whole 
  tablespace slated for backup?
   
  Also if this 
  tablespace was lost, and we recover.. What happens during that process? Does 
  RMAN basically have to filter through two complete copies of that 
  tablespace or just once and then get changed blocks?
   
  What solutions 
  have some doing this found to be "best practice"?
   
  Thanks.
  
  
  Michael Kline, Principal ConsultantBusiness To Business 
  Solutions, LLCRichmond, 
  VA804-744-1545

Re: RMAN Incremental

[Jared Still]

Michal,

Are you using partitioning, and if so, are there
tablespaces you can set to read only?

If so, then you only need to back up the read only
tablespaces often enough that your backup software
retention time doesn't cause the RO TBS's to all be
aged out.

This could eliminate a lot of backup time/tape.

Jared

On Fri, 2003-10-24 at 16:34, Michael Kline wrote:
> I'm working at a Data Warehouse and they are looking for backup
> possibilities...
> 
> This is almost a TB, a baby, and it may be that RMAN with incremental could
> be a good solution.
> 
> If say for instance there is a single tablespace of some 100 gig and they
> add 200,000,000 records to one of the tables and we do an incremental
> backup. Is the whole tablespace slated for backup?
> 
> Also if this tablespace was lost, and we recover.. What happens during that
> process? Does RMAN basically have to filter through two complete copies of
> that tablespace or just once and then get changed blocks?
> 
> What solutions have some doing this found to be "best practice"?
> 
> Thanks.
> 
> Michael Kline, Principal Consultant
> Business To Business Solutions, LLC
> Richmond, VA
> 804-744-1545
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN problem: RMAN-20242

[Joe Testa]

I consider a 20242 error as an acceptable one, here is why:

If i ask rman to backup archivelogs that are  more than 2days old and 
there are none, thats not an error.  That is when i see it the most, now 
most companies will force a log switch after a set amount of time during 
the day so in DR, you dont lose days worth of redo that might still be 
hanging in a redo log if it gets lost.

joe

Daiminger, Helmut wrote:

Hi there!

We are having problems with an Oracle backup. The compiling of the backup
command fails with the error message: RMAN-20242: specification does not
match any archivelog in the recovery catalog
But RMAN is only supposed to backup any archived logs that are there and
then insert them in the catalog...
Did anybody experience anything similar?

This is 8.1.7 on HP-UX with Legato Networker

Thanks,
Helmut
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN - Compressing using named piped

[Avnish.Rastogi]

I dont 
think you can compress rman files while backups are running. RMAN doesnt support 
external compression while backups are running 'cause RMAN has to validate 
backups. You can compress all the files once your backup is completed. I tried 
that in the past but didnt work. Infect there are some technical 
forums on metalink about that. 
I have 
a script which I used to validate backups and gzip files after backups are 
completed. If you are interested I can send you offline, script is not very good 
but worked fine.

  -Original Message-From: laura pena 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 
  7:45 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RMAN - Compressing using named piped
  I am running Oracle 9i R2 and want my RMAN files gzipped to save disk 
  space.
   
  Is is possible to either use this new DBMS_PIPE oracle has or just 
  creates a script that uses a namped piped and compresses as rman is performing 
  a backup? 
  If someone has done this before, can you let me know how ?
   
  My rman backups are 71g compresed they are 12g.
   
  Thanks ahead of time.
  -Lizz
  
  
  Do you Yahoo!?The 
  New Yahoo! Shopping - with improved product 
searchDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.

RE: RMAN - Compressing using named piped

[laura pena]

I can use mknod and create a named pipe a head of time.
I do this when I use the exp or imp utilites (just wondering if  I can do same with RMAN):
 
==
export EXP_DIR="/oracle/export"export PIPE_DIR="/oracle/export"export PIPE_FILE="$PIPE_DIR/imp_pipe"mydump="DBAFULL_090403.DMP.gz"
i=1for db in voicelog authcode_cp authcode_user crd_user crd_cp vlsuperdo   echo $i   rm -f ${PIPE_FILE}.$i   mknod ${PIPE_FILE}.$i p   echo `date`   echo "Running gzip"   nohup cat $EXP_DIR/$mydump | /usr/bin/gunzip -c > ${PIPE_FILE}.$i &   echo `date`   echo "Running imp"    imp system/$1 FROMUSER=$db TOUSER=$db file=${PIPE_FILE}.$i log=$db.imp.log buffer=1024000 rows=y indexes=n constraints=n feedback=1000 RESUMABLE=Y grants=n commit=y ignore=y    echo `date`    echo "Done with imp for $i"    i=`expr $i + 1`doneecho "Import for Users complete"
=
"Orr, Steve" <[EMAIL PROTECTED]> wrote:


Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create?
 


-Original Message-From: laura pena [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped
I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space.
 
Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? 
If someone has done this before, can you let me know how ?
 
My rman backups are 71g compresed they are 12g.
 
Thanks ahead of time.
-Lizz


Do you Yahoo!?The New Yahoo! Shopping - with improved product search
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

RE: RMAN - Compressing using named piped

[Orr, Steve]

Title: Message



Can 
you figure out what to name the pipe in advance? Is there a way to reliably 
determine what file name RMAN will create?
 

  
  -Original Message-From: laura pena 
  [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 
  2003 8:45 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RMAN - Compressing using named 
  piped
  I am running Oracle 9i R2 and want my RMAN files gzipped to save disk 
  space.
   
  Is is possible to either use this new DBMS_PIPE oracle has or just 
  creates a script that uses a namped piped and compresses as rman is performing 
  a backup? 
  If someone has done this before, can you let me know how ?
   
  My rman backups are 71g compresed they are 12g.
   
  Thanks ahead of time.
  -Lizz
  
  
  Do you Yahoo!?The 
  New Yahoo! Shopping - with improved product 
search

Re: RMAN error while registering the target database

[Tanel Poder]

Are you sure $ORACLE_HOME is properly set in shell executing RMAN?
When registering a database in rman, it usually makes a controlfile backup
copy under $ORACLE_HOME/dbs or database directory. If it's not set, maybe it
tries some default (or old) location who knows...

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 9:14 PM


> Hi Robert,
>
> The directory does not exist. I am just trying to
> register the database(RMAN>register database).
>
> My question is...
> from where did it pick up the name of
> the control file "/dev/vx/rdsk/dbdg13/Rcatctrl.ctl".
>
> Also i tried the same operation(register database) for
> different database which is running on the same box
> and it works fine.
>
> Thanks
> Sami
>
> --- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> > /dev/vx/rdsk/dbdg13/Rcatctrl.ctl
> >
> > Does this directory exist, does Oracle have priv's
> > on it? Does the file
> > already exist, and of so who owns it and what are
> > the privs?
> >
> > RF
> >
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L
> > Sent: 9/25/2003 12:39 PM
> >
> > Hi List,
> >
> > Does anyone come across this issue? What should i do
> > to resolve this?
> > Any help would be really appreciated.
> > TIA
> >
> >
> > RMAN> register database;
> >
> > RMAN-03022: compiling command: register
> > RMAN-03023: executing command: register
> > RMAN-08006: database registered in recovery catalog
> > RMAN-03023: executing command: full resync
> > RMAN-03026: error recovery releasing channel
> > resources
> > RMAN-00571:
> >
> ===
> > RMAN-00569: === ERROR MESSAGE STACK
> > FOLLOWS ===
> > RMAN-00571:
> >
> ===
> > RMAN-03008: error while performing automatic resync
> > of
> > recovery catalog
> > RMAN-07004: unhandled exception during command
> > execution on channel default
> > RMAN-10035: exception raised in RPC: ORA-01580:
> > error
> > creating control backup file
> > /dev/vx/rdsk/dbdg13/Rcatctrl.ctl
> > ORA-27040: skgfrcre: create error, unable to create
> > file
> > SVR4 Error: 2: No such file or directory
> > RMAN-10031: ORA-1580 occurred during call to
> > DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT
> >
> >
> > __
> > Do you Yahoo!?
> > The New Yahoo! Shopping - with improved product
> > search
> > http://shopping.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Oracle DBA
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (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).
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Freeman Robert - IL
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (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!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://w

RE: RMAN error while registering the target database

[Oracle DBA]

Hi Robert,

The directory does not exist. I am just trying to
register the database(RMAN>register database).

My question is... 
from where did it pick up the name of
the control file "/dev/vx/rdsk/dbdg13/Rcatctrl.ctl".

Also i tried the same operation(register database) for
different database which is running on the same box
and it works fine.

Thanks
Sami

--- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> /dev/vx/rdsk/dbdg13/Rcatctrl.ctl 
> 
> Does this directory exist, does Oracle have priv's
> on it? Does the file
> already exist, and of so who owns it and what are
> the privs?
> 
> RF
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 9/25/2003 12:39 PM
> 
> Hi List,
> 
> Does anyone come across this issue? What should i do
> to resolve this? 
> Any help would be really appreciated.
> TIA
> 
> 
> RMAN> register database;
>  
> RMAN-03022: compiling command: register
> RMAN-03023: executing command: register
> RMAN-08006: database registered in recovery catalog
> RMAN-03023: executing command: full resync
> RMAN-03026: error recovery releasing channel
> resources
> RMAN-00571:
>
===
> RMAN-00569: === ERROR MESSAGE STACK
> FOLLOWS ===
> RMAN-00571:
>
===
> RMAN-03008: error while performing automatic resync
> of
> recovery catalog
> RMAN-07004: unhandled exception during command
> execution on channel default
> RMAN-10035: exception raised in RPC: ORA-01580:
> error
> creating control backup file
> /dev/vx/rdsk/dbdg13/Rcatctrl.ctl
> ORA-27040: skgfrcre: create error, unable to create
> file
> SVR4 Error: 2: No such file or directory
> RMAN-10031: ORA-1580 occurred during call to
> DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT
> 
> 
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product
> search
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Freeman Robert - IL
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (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!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN error while registering the target database

[Freeman Robert - IL]

/dev/vx/rdsk/dbdg13/Rcatctrl.ctl 

Does this directory exist, does Oracle have priv's on it? Does the file
already exist, and of so who owns it and what are the privs?

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/25/2003 12:39 PM

Hi List,

Does anyone come across this issue? What should i do
to resolve this? 
Any help would be really appreciated.
TIA


RMAN> register database;
 
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-03026: error recovery releasing channel resources
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03008: error while performing automatic resync of
recovery catalog
RMAN-07004: unhandled exception during command
execution on channel default
RMAN-10035: exception raised in RPC: ORA-01580: error
creating control backup file
/dev/vx/rdsk/dbdg13/Rcatctrl.ctl
ORA-27040: skgfrcre: create error, unable to create
file
SVR4 Error: 2: No such file or directory
RMAN-10031: ORA-1580 occurred during call to
DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN Problem

[Josh Collier]

Make sure that your oracle service is stopped and started correctly. If you
can't mount the database, it may be that your oracle service has started
incorrectly and is holding locks on the files that your instance needs in
order for it to mount.

Then check the alert log for more information. 


-Original Message-
Sent: Tuesday, September 23, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L


I am trying to learn RMAN using the Oracle Backup & Recovery 101 book.

I keep running into the error below. 
ORA-01102 cannot mount database in EXCLUSIVE mode

This is on an NT server.  I can't see that the database is already up.
Never had this problem before.

Any ideas?

Ron Smith
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Josh Collier
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN in NOCATALOG mode?

[Craig Munday]

All,

I also backup the control file as the last step within the backup and use 
the PL/SQL procedure within the documentation to restore the control file 
manually if needed - I think 9i has this in RMAN now.

I found this was necessary if you wanted to get the last change from your 
backup and the recovery catalog was not available for some reason.  Also 
meant that I didn't have the extra work of restoring our recovery catalog 
during Disaster Recovery.

What is everyone's opinion on using the recovery catalog?  I still have one 
configured because it records a lot more history (which I needed at one 
point), but is it really necessary?

Cheers,
Craig.


At 09:39 AM 18/09/2003 -0800, Mercadante, Thomas F wrote:
me too.  learned this from testing Rman back in 8.1.6.  plus, you need this
control file to recover from to get as late (most recent) timestamp as
possible for recovery purposes.
-Original Message-
Sent: Thursday, September 18, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
I always backup the controlfile as a separate statement AFTER the back
is done so hopefully the backup i just completed is in there :)
joe

Denham Eva wrote:

>Hello
>
>Wondering about this. If backing up the database with RMAN in NOCATALOG
>mode.
>When would be the best time to do backup of the controlfile? Before backup
/
>after backup /before and after backup.
>Does this aid your recovery from a crash? What advantage would it have?
>
>Many Thanks
>Regards
>Denham Eva
>Oracle DBA
>Linux like TeePee... No Windows, No Gates and Apache inside!
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Craig Munday
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN in NOCATALOG mode?

[Tanel Poder]

No, controlfile is irrelevant as long as you got your physical structure
somewhere (eg. controlfile trace) and all your redologs intact. You just
recover "using backup controlfile" then (which means whatever controlfile
you got, ignore it's checkpoint progress and other SCN information). That
way you can recover to any point in time, providing that you recover all
online datafiles to consistent SCN (you can't open a database recovered
until SCN 1000 when one file has checkpoint SCN 1200 for example)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 18, 2003 8:39 PM


> me too.  learned this from testing Rman back in 8.1.6.  plus, you need
this
> control file to recover from to get as late (most recent) timestamp as
> possible for recovery purposes.
>
> -Original Message-
> Sent: Thursday, September 18, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I always backup the controlfile as a separate statement AFTER the back
> is done so hopefully the backup i just completed is in there :)
>
> joe
>
>
> Denham Eva wrote:
>
> >Hello
> >
> >Wondering about this. If backing up the database with RMAN in NOCATALOG
> >mode.
> >When would be the best time to do backup of the controlfile? Before
backup
> /
> >after backup /before and after backup.
> >Does this aid your recovery from a crash? What advantage would it have?
> >
> >Many Thanks
> >Regards
> >Denham Eva
> >Oracle DBA
> >Linux like TeePee... No Windows, No Gates and Apache inside!
> >
> >
> >
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Joe Testa
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN in NOCATALOG mode?

[Mercadante, Thomas F]

me too.  learned this from testing Rman back in 8.1.6.  plus, you need this
control file to recover from to get as late (most recent) timestamp as
possible for recovery purposes.

-Original Message-
Sent: Thursday, September 18, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L


I always backup the controlfile as a separate statement AFTER the back 
is done so hopefully the backup i just completed is in there :)

joe


Denham Eva wrote:

>Hello
>
>Wondering about this. If backing up the database with RMAN in NOCATALOG
>mode.
>When would be the best time to do backup of the controlfile? Before backup
/
>after backup /before and after backup.
>Does this aid your recovery from a crash? What advantage would it have?
>
>Many Thanks
>Regards
>Denham Eva
>Oracle DBA
>Linux like TeePee... No Windows, No Gates and Apache inside!
>
>  
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN in NOCATALOG mode?

[Tanel Poder]

Hi!

> Denham
>Whether you need to back up the control file depends on whether you can
> recover the database without it. On Oracle8i, I gave up trying to extract
> the controlfile from the RMAN backup, and simply back the controlfile up
> after the backup completes. Others on this list have reported they were
able
> to extract the controlfile from the RMAN backup. I believe that on
Oracle9i
> this is much improved. The important thing is that you validate your
backup
> regularly because an untested backup can't be trusted.

In 9i RMAN you can "configure controlfile autobackup on" - that way RMAN
always backs up controlfile as well during any backup. You just have to note
that if you configure controlfile autobackup on, then this is remembered in
controlfile and during several physical database operations like adding
datafile, creating/dropping tablespace, taking tablespace/datafile online a
controlfile backup is also created (default location $ORACLE_HOME/dbs or
database). If you don't take it into account you could have hundreds of old
controlfiles lying around if your environment involves a lot of physical
structure changes (transportable tablespaces, read only/read write
tablespaces etc).

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RMAN in NOCATALOG mode?

[Joe Testa]

I always backup the controlfile as a separate statement AFTER the back 
is done so hopefully the backup i just completed is in there :)

joe

Denham Eva wrote:

Hello

Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the controlfile? Before backup /
after backup /before and after backup.
Does this aid your recovery from a crash? What advantage would it have?
Many Thanks
Regards
Denham Eva
Oracle DBA
Linux like TeePee... No Windows, No Gates and Apache inside!
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN in NOCATALOG mode?

[Hemant K Chitale]

It's so much easier to include an "sql "alter database backup controlfile 
to  ";
in the rman script.
Backup the Database first.
Then backup the archive logs.
Then backup the controlfile.

Hemant

At 06:54 AM 18-09-03 -0800, you wrote:
Denham
   Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have reported they were able
to extract the controlfile from the RMAN backup. I believe that on Oracle9i
this is much improved. The important thing is that you validate your backup
regularly because an untested backup can't be trusted.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 18, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Hello

Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the controlfile? Before backup /
after backup /before and after backup.
Does this aid your recovery from a crash? What advantage would it have?
Many Thanks
Regards
Denham Eva
Oracle DBA
Linux like TeePee... No Windows, No Gates and Apache inside!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Denham Eva
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN in NOCATALOG mode?

[DENNIS WILLIAMS]

Denham
   Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have reported they were able
to extract the controlfile from the RMAN backup. I believe that on Oracle9i
this is much improved. The important thing is that you validate your backup
regularly because an untested backup can't be trusted.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, September 18, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L


Hello

Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the controlfile? Before backup /
after backup /before and after backup.
Does this aid your recovery from a crash? What advantage would it have?

Many Thanks
Regards
Denham Eva
Oracle DBA
Linux like TeePee... No Windows, No Gates and Apache inside!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Denham Eva
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: RE: RMAN error - can someone help ?

[Prem Khanna J]

Ruth,

>Set you ORACLE_SID which will be the target and try again.

c:> set ORACLE_SID=AUX92

AUX92 is the name of my auxiliary instance on Host A ( target host ).

c:> rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys 
trace=c:\tspitr.log
where "PE92" is the target on same Host A and "LAT92" is my recovery catalog on a 
diff. host.

This is what metalink doc. 180436.1 says:
 "rman target sys/[EMAIL PROTECTED] catalog rman/[EMAIL PROTECTED] auxiliary  / 
trace=d:\tspitr.log"

>It looks like you don't have your ORACLE_SID specified correctly since, if I
>read this correctly, the database you are trying to restore is on dick c:.

my target database is in d:\oracle\

but even then where did this path come from ??
  ORA-19504: failed to create file "D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"

those ;\ in the path look strange and wonder oracle appends that ??

any clues Ruth.just stuck up here and not able to proceed further.
i tried it repeatedly.

Thanx once again.
Jp.

>  -Original Message-
>  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
>  Prem Khanna J
>  Sent: Tuesday, September 16, 2003 10:35 PM
>  To: Multiple recipients of list ORACLE-L
>  Subject: RMAN error - can someone help ?
>
>
>  Hi,
>
>  My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
>  My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).
>
>  My target destination for backup files is R:\ which resides
>  on Host C (WinNT).This drive R:\ is common to both Host A and B.
>  Things work fine accessing R:\ from both Host A and B.
>
>  I tried a TSPITR following the doc. 180436.1. It is for 8i.
>  Question #1: is it applicable for 9i also ?
>
>  If YES,
>
>  when i say (on Host A,the target),
>
>  run {
> ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK;
> ALLOCATE CHANNEL c1 TYPE DISK;
> recover tablespace users until time "TO_DATE('MAR-05-2002
>  11:27:00', 'MON-DD- HH:MI:SS')";
>  }
>
>  i get the error below:
>
>  channel a1: starting datafile backupset restore
>  channel a1: specifying datafile(s) to restore from backup set
>  restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
>  released channel: a1
>  released channel: c1
>  RMAN-00571: ==
>  RMAN-00569: === ERROR MESSAGE STACK FOLLOWS =
>  RMAN-00571: ==
>  RMAN-03002: failure of recover command at 09/16/2003 17:48:32
>  RMAN-03015: error occurred in stored script Memory Script
>  ORA-19504: failed to create file "D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"
>  ORA-27040: skgfrcre: create error, unable to create file
>  OSD-04002: unable to open file
>  O/S-Error: (OS 3) Path not found.
>
>  Question #2:
>
>  db_file_name_convert=("d:\oracle\oradata\pe92","d:\oracle\oradata\aux92");
>
>  log_file_name_convert=("d:\oracle\oradata\pe92","d:\oracle\oradata
>  \aux92");
>
>  why does RMAN try to restore SYSTEM01.DBF to
>D:\ORACLE\ORA92\DATABASE\  ?
>
>  i have not mentioned this path anywhere in my recovery action.
>
>  Question #3:
>
>  though it is not restore path,why does RMAN's Memory script
>  append ";\" in the path
>
>  i.e.,"D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"
>
>  this is where it fails.
>
>  can someone explain me where the problem is ?
>
>  TIA.
>  Jp.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN error - can someone help ?

[Ruth Gramolini]

It looks like you don't have your ORACLE_SID specified correctly since, if I
read this correctly, the database you are trying to restore is on dick c:.
Set you ORACLE_SID which will be the target and try again.

HTH,
Ruth

p.s I do not have any databases on Windows so I am not sure how to set the
SID.


  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
  Prem Khanna J
  Sent: Tuesday, September 16, 2003 10:35 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN error - can someone help ?


  Hi,

  My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
  My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).

  My target destination for backup files is R:\ which resides
  on Host C (WinNT).This drive R:\ is common to both Host A and B.
  Things work fine accessing R:\ from both Host A and B.

  I tried a TSPITR following the doc. 180436.1. It is for 8i.
  Question #1: is it applicable for 9i also ?

  If YES,

  when i say (on Host A,the target),

  run {
 ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK;
 ALLOCATE CHANNEL c1 TYPE DISK;
 recover tablespace users until time "TO_DATE('MAR-05-2002
  11:27:00', 'MON-DD- HH:MI:SS')";
  }

  i get the error below:

  channel a1: starting datafile backupset restore
  channel a1: specifying datafile(s) to restore from backup set
  restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
  released channel: a1
  released channel: c1
  RMAN-00571: ==
  RMAN-00569: === ERROR MESSAGE STACK FOLLOWS =
  RMAN-00571: ==
  RMAN-03002: failure of recover command at 09/16/2003 17:48:32
  RMAN-03015: error occurred in stored script Memory Script
  ORA-19504: failed to create file "D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"
  ORA-27040: skgfrcre: create error, unable to create file
  OSD-04002: unable to open file
  O/S-Error: (OS 3) Path not found.

  Question #2:

  db_file_name_convert=("d:\oracle\oradata\pe92","d:\oracle\oradata\aux92");

  log_file_name_convert=("d:\oracle\oradata\pe92","d:\oracle\oradata
  \aux92");

  why does RMAN try to restore SYSTEM01.DBF to
D:\ORACLE\ORA92\DATABASE\  ?

  i have not mentioned this path anywhere in my recovery action.

  Question #3:

  though it is not restore path,why does RMAN's Memory script
  append ";\" in the path

  i.e.,"D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"

  this is where it fails.

  can someone explain me where the problem is ?

  TIA.
  Jp.




  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Prem Khanna J
INET: [EMAIL PROTECTED]

  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: Rman equivalent for MS-SQL server

[Farnsworth, Dave]

This 
beast does not exist.  You can use the Database Maintenance Plans in EM to 
manage your backups.  I have found these to be flaky and prefer writing my 
own custom backup plans in scripts and schedule these as jobs.  >From my 
experience on SQL Server I recommend doing a native SQL Server backup to disk, 
then have the third party backup software pickup those files to 
tape.
Just 
my $.02
 
Dave

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 4:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: Rman 
  equivalent for MS-SQL server
  
  Hi good 
  people-
  Does anyone out there know of the 
  equivalent of oracle’s RMAN in MS SQL server environs.
  I’m investigating the possibility 
  of having my SQL server dump the backups direct to a third party tape library 
  –VERITAS to be specific.
   
  Your input on this thread will be 
  highly appreciated.
   
  CSW 
  Simon.

RE: Rman equivalent for MS-SQL server

[Mark Leith]

You can actually use Database Maintenance Plans, to mimic RMAN to a certain
extent. Database Maintenance Plans is basically a wizard that generates a
load of MSDB jobs that get run by the SQL*Agent. This does have some
limitations though. It has no support for differential backups, doesn't
support appended backups to an already existing "device", you can't duplex
back up files, and a number of the backup options aren't available.

This is described in some detail in  "SQLServer for Oracle DBAs" an e-book
that I would highly recommend to all primarily Oracle DBAs that have to do a
certain amount of SQLServer work too.

http://www.chriskempster.com/

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance



-Original Message-
Gudmundur Josepsson
Sent: 16 September 2003 11:19
To: Multiple recipients of list ORACLE-L


There is no MSSQL utility that is directly equivalent to RMAN.  You use
Enterprise Manager or Query Analyzer to manage backups.

Gudmundur
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 16, 2003 9:39 AM


Hi good people-
Does anyone out there know of the equivalent of oracle’s RMAN in MS SQL
server environs.
I’m investigating the possibility of having my SQL server dump the backups
direct to a third party tape library –VERITAS to be specific.

Your input on this thread will be highly appreciated.

CSW Simon.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: Rman equivalent for MS-SQL server

[Gudmundur Josepsson]

There is no MSSQL utility that is directly 
equivalent to RMAN.  You use Enterprise Manager or Query Analyzer to manage 
backups.
 
Gudmundur

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, September 16, 2003 9:39 
  AM
  Subject: Rman equivalent for MS-SQL 
  server
  
  
  Hi good 
  people-
  Does anyone out there know of the 
  equivalent of oracle’s RMAN in MS SQL server environs.
  I’m investigating the possibility 
  of having my SQL server dump the backups direct to a third party tape library 
  –VERITAS to be specific.
   
  Your input on this thread will be 
  highly appreciated.
   
  CSW 
  Simon.

Re: RE: RMAN backup and recovery scenarios

[Prem Khanna J]

Thanx Dennis,Robert,and Ruth.

I'm going thro' Roberts's book now.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one .

but just thought, i could some more inputs from you Gurus.
thanx a lot guys.

I will continue with the book.

Regards,
Jp.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN backup and recovery scenarios

[GovindanK]

Besides you may refer to Backup & Recovery by Rama Velpuri (8/8i). A bit
old but nevertheless good. All said and done, create a clone database
and keep crashing it in all ways you can think of, and try to recover it.
That should give you the confidence , letting you know how oracle handles
the internals etc. Go thru Recovery principles, Case Studies by Rama
Velpuri. (Add RF's book too). Try doing the same with Standby too.


HTH
GovindanK

> My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
> devoted to case studies and RMAN.
>
> RF
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 9/4/2003 11:44 AM
>
> Look at the Backup and Recovery Doc's.  And there are sample scripts in
> OH/rdbms/demo/case1.rcv thru case4.rcv.  The backup and recovery manual
> is a
> great resource!
>
> HTH,
> Ruth
>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
>> Prem Khanna J
>> Sent: Thursday, September 04, 2003 2:44 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RMAN backup and recovery scenarios
>>
>>
>> Hi all,
>>
>> Is there any doc./URL which lists out RMAN backup and recovery
> scenarios ?
>> did not find one in metalink.
>>
>> Thanks & Regards,
>> Jp.
>>
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Prem Khanna J
>>   INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> San Diego, California-- Mailing list and web hosting services
>> -
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (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).
>>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Freeman Robert - IL
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN backup and recovery scenarios

[Freeman Robert - IL]

My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
devoted to case studies and RMAN.

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/4/2003 11:44 AM

Look at the Backup and Recovery Doc's.  And there are sample scripts in
OH/rdbms/demo/case1.rcv thru case4.rcv.  The backup and recovery manual
is a
great resource!

HTH,
Ruth

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Prem Khanna J
> Sent: Thursday, September 04, 2003 2:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RMAN backup and recovery scenarios
>
>
> Hi all,
>
> Is there any doc./URL which lists out RMAN backup and recovery
scenarios ?
> did not find one in metalink.
>
> Thanks & Regards,
> Jp.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN backup and recovery scenarios

[Ruth Gramolini]

Look at the Backup and Recovery Doc's.  And there are sample scripts in
OH/rdbms/demo/case1.rcv thru case4.rcv.  The backup and recovery manual is a
great resource!

HTH,
Ruth

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Prem Khanna J
> Sent: Thursday, September 04, 2003 2:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RMAN backup and recovery scenarios
>
>
> Hi all,
>
> Is there any doc./URL which lists out RMAN backup and recovery scenarios ?
> did not find one in metalink.
>
> Thanks & Regards,
> Jp.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN backup and recovery scenarios

[DENNIS WILLIAMS]

Prem - I haven't found anything significant online. Perhaps someone else
(Bwill point to a resource. If you want to learn RMAN, my recommendation is to
(Bget a couple of books. The advantage of a book is you end up with a
(Bcomprehensive resource for reference. Myself, I need to go back and refresh
(Bmyself now and then.
(B  - Oracle9i RMAN Backup & Recovery by Robert Freeman
(B  - I found Oracle 101 Backup & Recovery (Smith and Haisley) helpful to get
(Bstarted. About half of it is RMAN. It has very simple tutorials that you can
(Bfollow step-by-step to understand the basic RMAN concepts. But Robert's book
(Bwasn't published when I was trying to set up RMAN.
(B
(BDennis Williams
(BDBA, 80%OCP, 100% DBA
(BLifetouch, Inc.
(B[EMAIL PROTECTED] 
(B
(B
(B-Original Message-
(BSent: Thursday, September 04, 2003 1:44 AM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BHi all,
(B
(BIs there any doc./URL which lists out RMAN backup and recovery scenarios ?
(Bdid not find one in metalink.
(B
(BThanks & Regards,
(BJp.
(B
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Prem Khanna J
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: DENNIS WILLIAMS
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

RE: Rman disk performance

[DENNIS WILLIAMS]

Brian
  Sorry, the mail system mangled my message. It's all there, just part is
below the signature. Here it is again:

I think that is about the performance we get. Maybe faster than what we get.
   One idea would be to copy some big files using file system commands like
"cp" and see what the performance is. My guess is that would be your
theoretical upper limit.
 
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, August 21, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L


ok... I just hanging on here...don't let me fall...

 what ..what?

Brian :)

-Original Message-
Sent: Thursday, August 21, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L


Brian
   I think that is about the performance we get. Maybe faster than what we
get.
   One idea would be to 


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED]   

copy some big files using file system commands like "cp" and see what the
performance is. My guess is that would be your theoretical upper limit.
 

-Original Message-
Sent: Thursday, August 21, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Anybady have values of how many GIGS per HOUR they can Backup and RESTORE
the database
using RMAN backup to disk.
 
What kind of machine, Memory, storage?
 
1) I am using cheap network attached disk 
2) I am getting about 40 Gigs an hour for Backup
3) I am getting about 34 Gigs an hour for Restore
4) 350 Meg of SGA on an Hp9000
 
Anybody find a good way to improve performance other than increasing
channels?
 
Cheers,
Thanks for any help
 
Brian Spears 
Sr. DBA
[EMAIL PROTECTED] 
DC4 (614)577-2677 
DC3 (614)415-1398 
Limitedbrands 
TECHNOLOGY SERVICES 


-Original Message-
Sent: Thursday, August 21, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Thanks Julio,
 
But that didnt work either..
 
Maybe I need to reinstall both Linux and 9i.
 
Thanks
 
Anjan

-Original Message-
QuijadaReina, Julio C
Sent: Wednesday, August 20, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L



Anjan,

 

Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try
setting the following on the user's .profile or on your user's shell startup
file:

 

LD_LIBRARY_PATH = $ORACLE_HOME/lib

LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib

 

Maybe oracle is looking for 64 bit library files!

 

Julio 

 

-Original Message-
Sent: Wednesday, August 20, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

 

Gurus,

 

Would appreciate any help that I can get on this...

 

I have 9.2.0.1 on redhat 9 ...

 

However I cannot seen to start the agent on the server...

 

agentctl start just bails out.. no messages...

 

This what I see in the dbsnmp.nohup

 

/db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared
libraries: libvppdc.so: cannot open shared object file: No such file or
directory
Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127
Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003

 

libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit
file..

 

 

Thanks in advance...

 

Anjan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Spears, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the 

RE: Rman disk performance

[Spears, Brian]

ok... I just hanging on here...don't let me fall...

 what ..what?

Brian :)

-Original Message-
Sent: Thursday, August 21, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L


Brian
   I think that is about the performance we get. Maybe faster than what we
get.
   One idea would be to 


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED]   

copy some big files using file system commands like "cp" and see what the
performance is. My guess is that would be your theoretical upper limit.
 

-Original Message-
Sent: Thursday, August 21, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Anybady have values of how many GIGS per HOUR they can Backup and RESTORE
the database
using RMAN backup to disk.
 
What kind of machine, Memory, storage?
 
1) I am using cheap network attached disk 
2) I am getting about 40 Gigs an hour for Backup
3) I am getting about 34 Gigs an hour for Restore
4) 350 Meg of SGA on an Hp9000
 
Anybody find a good way to improve performance other than increasing
channels?
 
Cheers,
Thanks for any help
 
Brian Spears 
Sr. DBA
[EMAIL PROTECTED] 
DC4 (614)577-2677 
DC3 (614)415-1398 
Limitedbrands 
TECHNOLOGY SERVICES 


-Original Message-
Sent: Thursday, August 21, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Thanks Julio,
 
But that didnt work either..
 
Maybe I need to reinstall both Linux and 9i.
 
Thanks
 
Anjan

-Original Message-
QuijadaReina, Julio C
Sent: Wednesday, August 20, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L



Anjan,

 

Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try
setting the following on the user's .profile or on your user's shell startup
file:

 

LD_LIBRARY_PATH = $ORACLE_HOME/lib

LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib

 

Maybe oracle is looking for 64 bit library files!

 

Julio 

 

-Original Message-
Sent: Wednesday, August 20, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

 

Gurus,

 

Would appreciate any help that I can get on this...

 

I have 9.2.0.1 on redhat 9 ...

 

However I cannot seen to start the agent on the server...

 

agentctl start just bails out.. no messages...

 

This what I see in the dbsnmp.nohup

 

/db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared
libraries: libvppdc.so: cannot open shared object file: No such file or
directory
Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127
Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003

 

libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit
file..

 

 

Thanks in advance...

 

Anjan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Spears, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: Rman disk performance

[DENNIS WILLIAMS]

Brian
   I think that is about the performance we get. Maybe faster than what we
get.
   One idea would be to 


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED]   

copy some big files using file system commands like "cp" and see what the
performance is. My guess is that would be your theoretical upper limit.
 

-Original Message-
Sent: Thursday, August 21, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Anybady have values of how many GIGS per HOUR they can Backup and RESTORE
the database
using RMAN backup to disk.
 
What kind of machine, Memory, storage?
 
1) I am using cheap network attached disk 
2) I am getting about 40 Gigs an hour for Backup
3) I am getting about 34 Gigs an hour for Restore
4) 350 Meg of SGA on an Hp9000
 
Anybody find a good way to improve performance other than increasing
channels?
 
Cheers,
Thanks for any help
 
Brian Spears 
Sr. DBA
[EMAIL PROTECTED] 
DC4 (614)577-2677 
DC3 (614)415-1398 
Limitedbrands 
TECHNOLOGY SERVICES 


-Original Message-
Sent: Thursday, August 21, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Thanks Julio,
 
But that didnt work either..
 
Maybe I need to reinstall both Linux and 9i.
 
Thanks
 
Anjan

-Original Message-
QuijadaReina, Julio C
Sent: Wednesday, August 20, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L



Anjan,

 

Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try
setting the following on the user's .profile or on your user's shell startup
file:

 

LD_LIBRARY_PATH = $ORACLE_HOME/lib

LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib

 

Maybe oracle is looking for 64 bit library files!

 

Julio 

 

-Original Message-
Sent: Wednesday, August 20, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

 

Gurus,

 

Would appreciate any help that I can get on this...

 

I have 9.2.0.1 on redhat 9 ...

 

However I cannot seen to start the agent on the server...

 

agentctl start just bails out.. no messages...

 

This what I see in the dbsnmp.nohup

 

/db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared
libraries: libvppdc.so: cannot open shared object file: No such file or
directory
Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127
Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003

 

libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit
file..

 

 

Thanks in advance...

 

Anjan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN recovery

[Anne Yu]

Title: Message



 

  Dear 
  List, I have renamed a datafile in a production 
  database ten days ago.  I have no error to back up this database 
  but  I cannot duplicate/recover this database since.   I 
  am getting ora-19502 write error on this file.   Please 
  advise.
   
  Many 
  thanks,
   

RE: rman implementation

[DENNIS WILLIAMS]

Sai
Are you planning to do a RMAN backup to disk and the disk is Netapp? We
ran into a couple of hitches. If you are able to mount a tablespace on the
Netapp device, you should be past the first thing we ran into. The other
issue had to do with the fact that RMAN opens many connections to disk, so
when we tried to recover the backup, RMAN would recover some files, then
quit. Changing a Netapp configuration parameter fixed that problem.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Sunday, August 10, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


hi
 
can someone give me pointers on pros and cons of implementing rman with
netapp filers.
 
any pointers,white papers,case study,implementation doc will be very
helpful.
 
thanks
sai

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN recovery

[DENNIS WILLIAMS]

Anne
   Gee, things must appear better from Texas! Thanks for the comment.
   The only other thing I can suggest is to have your network administrator
take a careful look at any connection settings. I'm sorry I can't be more
specific, but we had a situation where the network/system administrator
assumed RMAN would be opening just one or two connections and it turned out
that RMAN was opening a whole bunch of connections. That can cause weird
problems.
   I think you are at the point of opening a TAR with Metalink and hoping
they will have some other suggestions. In our case, we had an NFS-mounted
drive and they insisted we move off that. We did, the problem went away, so
the sys admin got real interested in digging into his setup. Again, this is
a long shot. Good luck.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, August 07, 2003 1:01 PM
To: '[EMAIL PROTECTED]'
Cc: DENNIS WILLIAMS


Dennis,  
I have been admiring you from far.  Thank you so much to reply to my email.

The renamed data file has been tested and there is no corruption of any
kind.  The nightly physical and logical backups were successful completed
with no error.  However, I got an ora-19502 error when I tried to use these
backups to restore/duplicate the database from a remote node.  It might be
asynch io problem.   I am trying to set the 'fileperset to 1'.   Do you have
any other ideas?

Thanks again,
Anne

-Original Message-
Sent: Thursday, August 07, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L


Anne
 What version of Oracle is this?
 Okay, you renamed a production database file 10 days ago. Since then,
has Oracle been able to use this file? Can you export the table that is
stored on this file without error? Have you examined your RMAN backup log to
ensure this file is specifically listed as being backed up? Is it possible
that the error you are receiving has nothing to do with the production
database, but is entirely due to your backup or test database? In other
words, maybe the test system has a bad drive? Another possibility, awhile
back on this list several people reported that they had datafiles with
errors, but RMAN did not detect these errors when it was backing them up.
That is why I suggest exporting the table.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, August 07, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L


 

Dear List, I have renamed a datafile in a production database ten days
ago.  I have no error to back up this database but  I cannot
duplicate/recover this database since.   I am getting ora-19502 write error
on this file.   Please advise.
 
Many thanks,
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: RMAN Backup piece being placed in wrong directory

[Freeman Robert - IL]

Syntax error:

backup database format =
'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;

add the = after the format and it should run. RMAN is trying to "help" you
by ignoring this error and proceeding to backup the database to the default
location.

RF


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/7/2003 12:14 PM

Robert? Dennis?  Anyone?
 
-Original Message-
Sent: Thursday, August 07, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L


OS: Win2K
DB: 8.1.7.4
 
All, 
 
Here is what I am running:
run{
set archivelog destination to 'D:\backup\oracle\Hotbackup';
set controlfile autobackup format for device type disk to 
'D:\backup\oracle\Hotbackup\cf_%F.bak';
backup database format
'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;
}
 
 
Here is a the result after I run it: 
(The part I'm concerned about is in red.  I would like that stuff to go
to 'D:\backup\oracle\Hotbackup').
 
executing command: SET ARCHIVELOG DESTINATION
executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting backup at 07-AUG-03
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=2 stamp=500738572
channel ORA_DISK_1: starting piece 1 at 07-AUG-03
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=5 recid=1 stamp=500738568
input archive log thread=1 sequence=6 recid=3 stamp=500738573
input archive log thread=1 sequence=7 recid=4 stamp=500738574
input archive log thread=1 sequence=8 recid=5 stamp=500815654
input archive log thread=1 sequence=9 recid=6 stamp=500824391
input archive log thread=1 sequence=10 recid=7 stamp=501340112
channel ORA_DISK_2: starting piece 1 at 07-AUG-03
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=8 stamp=501343673
input archive log thread=1 sequence=12 recid=9 stamp=501343804
input archive log thread=1 sequence=13 recid=10 stamp=501347437
input archive log thread=1 sequence=14 recid=11 stamp=501347562
input archive log thread=1 sequence=15 recid=12 stamp=501407160
input archive log thread=1 sequence=16 recid=13 stamp=501407288
channel ORA_DISK_3: starting piece 1 at 07-AUG-03
channel ORA_DISK_1: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
channel ORA_DISK_3: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=17 recid=14 stamp=501407709
input archive log thread=1 sequence=18 recid=15 stamp=501407832
input archive log thread=1 sequence=19 recid=16 stamp=501407991
channel ORA_DISK_1: starting piece 1 at 07-AUG-03
channel ORA_DISK_1: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20
Finished backup at 07-AUG-03
 
Starting backup at 07-AUG-03
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF
input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF
input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF
input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF
channel ORA_DISK_1: starting piece 1 at 07-AUG-03
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF
input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF
input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF
input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF
channel ORA_DISK_2: starting piece 1 at 07-AUG-03
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBF
input datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBF
input datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBF
input datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBF
channel ORA_DISK_3: starting piece 1 at 07-AUG-03
channel ORA_DISK_2: finished piece 1 at 07-AUG-03
piece
handle=D:\BACKUP\ORACLE\HOTBACKU