Re: Rman - Curious Question

amerar@xxxxxxx wrote: 
Hi All,

Just a curious question:

When you are duplicating a database which is on a differnt host, why
does it require you to copy the files to the remote host?  Why can't
RMAN use the files on the primiary host?

If you are using a recovery catalog, you use the catalog on the primary
host, so, why not also use the backup pieces?  All the manual says is
that it requires you to copy the file.....


There is (at least) one misconception in your post: The catalog does only hold
metainformation about the backups, so the fact that it is accessible
is rather irrelevant for the question why the backup pieces ain't used.
(In fact, it is recommended that the catalog and the target database are
on different HW, so the files wouldn't be accessible through the catalog db).

So the backup files are accessible primarily through the target
- except if they are on tape and both machines can access the tape library
- except if they are on a filesystem accessible to both machines.

Why does Oracle not use Net 8? Because RMAN creates a server process on the
target db and no-one in their right minds would like the production server
to flood his network interface with the 1 TB you mention later in this
thread.

I hope this clears the smoke

Holger
.

Relevant Pages

  • Re: SQL 2005 Failed to PAUSERESUME Errors
    ... Yes this server was upgraded from SQL2000 to SQL2005. ... I had similar error myself and all I can do is a file group backup. ... Director of Text Mining and Database Strategy ... They all have one catalog referred to one table. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Rman - Curious Question
    ... >> When you are duplicating a database which is on a differnt host, ... >> If you are using a recovery catalog, you use the catalog on the primary ... > is rather irrelevant for the question why the backup pieces ain't used. ... I find the NFS method Sybrand quoted odd, as I think any NFS data ...
    (comp.databases.oracle.server)
  • Re: Backup SQL Server on local PC
    ... You could make the back up on the host pc and copy the file over. ... I am working with SQL Server 2005 and connecting to a databse which is ... I tried to make a backup of the database I work with, ...
    (microsoft.public.sqlserver)
  • Re: SQL 2005 Failed to PAUSERESUME Errors
    ... from a backup of one of the problem databases and the problem copied over. ... Director of Text Mining and Database Strategy ... Yes this server was upgraded from SQL2000 to SQL2005. ... They all have one catalog referred to one table. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Backing up and restoring database to remote server
    ... Your best bet is to have the Old Host do a FULL database backup using the ... SQL Server Backup command and send you that file. ... Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.programming)