Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> [Fwd: Oracle Back-up]
This is a multi-part message in MIME format.
--------------E4AFABCC36399502FBEBD018 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Tanks to
Suhen Pather
Jagan Rao
Best Regards
Corneliu Chelemen
--------------E4AFABCC36399502FBEBD018 Content-Type: message/rfc822 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Return-Path: <jaganr_at_dubal.co.ae>
Received: from fwb.dubal.co.ae (fwr1.dubal.co.ae [195.229.36.242] (may be forged))
by cce.sidex.ro (8.9.3/8.9.3) with SMTP id NAA09710 for <chc_at_cce.sidex.ro>; Wed, 4 Oct 2000 13:49:53 +0300Received: by fwb.dubal.co.ae; (5.65v4.0/1.3/10May95) id AA06767; Wed, 4 Oct 2000 14:38:26 +0400 Received: from somewhere by smtpxd
Hello Corneliu,
I did not try sbt_tape. I also used only channel type disk and the followed up by os commands to copy to the tape.
RMAN has bugs. Since you are using only 8.0.3 check up from oracle support on the list of bugs not yet fixed in that version. I used 8.0.5 in that incremental backup does not work. I heard that is fixed in 8.0.6 or so.
However, following info from Oracle doc might help you:
Backing Up to Sequential Media
If you use Recovery Manager to perform backups to sequential media, such as tape, you must have media management software integrated with your Oracle software.
Figure 7-2 MML Architecture
In Figure 7-2 <ch7.htm> , the Oracle executable is the same executable that is started when a user connects to the database. MML is the Media Management Library, which is media management, vendor-supplied software. Software routines in the MML are called by Oracle to back up and restore.
In the following example, a Recovery Manager script performs a datafile
backup:
run {
allocate channel t1 type `SBT_TAPE';
backup
format `df_%s_%t'
(datafile 10);
}
When Recovery Manager executes this command, it sends the backup request to the Oracle server process that will be performing the backup. The Oracle server process identifies the output channel as the type `SBT_TAPE', and requests the MML to load the tape and write the output, among other things.
If the channel type was disk, Oracle would not have connected to the MML software because Oracle can write to disk without the assistance of third-party integration software.
See Also: For information about vendors offering software integrated with Recovery Manager, see your Oracle representative.
-----Original Message-----
From: Corneliu Chelemen [SMTP:chc_at_cce.sidex.ro] Sent: Wednesday, October 04, 2000 2:29 PM To: JAGAN RAO Subject: Re: Oracle Back-up Hi Jagan, We have RMAN on our server ORACLE 8.0.3. but when we tried to do a back-up on a channel type "SBT_TAPE" didn't work. On a channel type disk this works fine. Which can be the problem? Corneliu Chelemen JAGAN RAO wrote:Received on Wed Oct 04 2000 - 06:04:00 CDT
> USE RMAN. It is very good. In my it is much better than EBU.
>
> If you need more information on RMAN do let me know. Refer Oralce8
Generic
> on-line doc for more details.
>
> Warm Regards,
> Jagan Rao.
>
> -----Original Message-----
> From: Corneliu Chelemen [SMTP:chc_at_cce.sidex.ro]
> Sent: Wednesday, October 04, 2000 2:06 PM
> To: Fat City Network Services; OracleDba QuickDoc
> Subject: Oracle Back-up
>
> Hi Gurus,
>
> Environment:
>
> HP-UX 10.20
> ORACLE Server 8.0.3
>
> Our previous version for ORACLE was 7.3.3.
> In this version we had ORACLE 7 Enterprise Back-up
Utilities.
>
> Which will be the corespondent product for ORACLE Server
8.0.3?
>
> Tanks in advance for your valuable help,
>
> Corneliu Chelemen
>
> --------
> If you're bored, then visit the list's website:
> http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
![]() |
![]() |