Re: RMAN NEWNAME FEATURE

On Jan 27, 11:39 am, p...@xxxxxxxxxxxxxxxxxxx wrote:
On 27 Jan, 19:27, joel garry <joel-ga...@xxxxxxxx> wrote:





On Jan 27, 11:09 am, p...@xxxxxxxxxxxxxxxxxxx wrote:

On 27 Jan, 18:33, joel garry <joel-ga...@xxxxxxxx> wrote:

On Jan 27, 7:28 am, p...@xxxxxxxxxxxxxxxxxxx wrote:

We have recently upgrade one of our systems to a new server which has
a different file structure in both location and size.

 Is there a way to split a single datafile over many datafiles when
using RMAN clone features.

For Example

Source file INDEX_01.dbf size 20GB

Destination file(s) INDEX_01.dbf size 10GB and INDEX_02.dbf size 10GB

RUN

{

set newname for datafile 1 to 'e:\Oracle\oradata\INDEX_01.DBF','e:
\Oracle\oradata\INDEX_02.DBF';

}

Many Thanks for all your advice.

RMAN is a physical backup, so won't make a structural change like
this.  You either need to use logical backups or make the change
before or after the clone.  You may want to specify tablespaces with
create index to control where things go.

jg
--
@home.com is bogus.
stupid now or stupid later.http://media.www.thelantern.com/media/storage/paper333/news/2009/01/2...text -

- Show quoted text -

Thanks for the response I didn't think it was possible we are unable
to do the change before due to the source being a Production server,
and there is not enough space on the Destination server for the large
datafiles that exist in Production.

We will use exp/imp to do the clone until we are able to gain more
space on the test server.

Again many thanks for your response.

You might be able to skip the index tablespace in the restore, and
script creation of index ts and indexes.  Haven't really thought it
through.  Note you can get the index creation scripts from exp/imp,
among other ways.

jg
--
@home.com is bogus.
In case of problems, please call your organisation's IT Helpdesk.- Hide quoted text -

- Show quoted text -

The script in my description was for demostration purposes and is not
just an index tablespace all datafiles are of a large size on
Production. I intend to badger my Support teams to get more disk space
allocated to the test server and was looking for possible other
solutions. I am unable to specify the exact sizes as I am out of the
office.

Again thank you for your time on this matter.

Hey, oftentimes the more relevant detail you give of the problem you
want to solve, the better answer you can get. Another solution I've
used when going between disparate platforms on a decent network is
CTAS with a link. This can be quite fast, I've used it when I had
some largish tables that needed to be migrated in a nightly window.
There's a similar datapump option. Not too dangerous when you only go
one way.

jg
--
@home.com is bogus.
This web page was blocked because it is considered inappropriate.


.

Relevant Pages

  • Re: RMAN NEWNAME FEATURE
    ... using RMAN clone features. ... datafiles that exist in Production. ... The script in my description was for demostration purposes and is not ... allocated to the test server and was looking for possible other ...
    (comp.databases.oracle.server)
  • RMAN Duplicate Question
    ... We are trying to duplicate our production database onto a test server. ...
    (comp.databases.oracle.server)
  • Re: Moving ASP.Net programs to production
    ... My manager> wants everything rewritten in ASP.Net. ... I don't have a clue on how to organize everything so he can> move programs into production easily. ... > After the programs are programmer tested, they are moved to the Users> Test Server. ... > Jim Smith ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Backup - Restore
    ... test server from existing production ... ... "Content index restore failed. ... I restored the following databases ...
    (microsoft.public.sharepoint.portalserver)
  • Re: [PHP] logging erros and user access to logs
    ... just delete the debug script. ... I moved it to a test server and could get it to work but only if ... me that get_ini would show it has having been changed but phpinfo doesn't. ... per vhost) or .htaccess (per folder and below) ...
    (php.general)