Home » RDBMS Server » Server Utilities » migrate ful db
migrate ful db [message #573676] Wed, 02 January 2013 04:41 Go to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
i want to migrate full db to another server .
what is the best way to do this?

if i take full expdp of the database.and then impdp on other serevr
will it be good option?
but i wonder this always give errors for system user as the objects already exists?

[Updated on: Wed, 02 January 2013 04:41]

Report message to a moderator

Re: migrate ful db [message #573678 is a reply to message #573676] Wed, 02 January 2013 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN bakcup/restore is the best and fastest way (unless you have incompatible plaform or versions).

Regards
Michel

Report message to a moderator

Re: migrate ful db [message #573692 is a reply to message #573678] Wed, 02 January 2013 06:13 Go to previous messageGo to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
what if we are working in noarchivelog mod?

Report message to a moderator

Re: migrate ful db [message #573697 is a reply to message #573692] Wed, 02 January 2013 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No change, you have to do the backup when the database is closed, as you shold do it now.

Regards
Michel

Report message to a moderator

Re: migrate ful db [message #574922 is a reply to message #573692] Wed, 16 January 2013 14:03 Go to previous messageGo to next message
alan.kendall@nfl.com
Messages: 160
Registered: June 2012
Location: Culver City, California
Senior Member
I usually alter all the indexes to be nologging (prior to the export) if I import into another database because it will cut down on redo log writes and speed up the import.
ECSCDAD3 > @alter_indexes_nologgingO.sql dev117

LOG 'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'NOLOGGING;'
--- -------------------------------------------------------------
YES alter index DEV117.CLUB_AUTHOR_LINK_PK nologging;
YES alter index DEV117.CLUB_AUTHOR_PK nologging;
YES alter index DEV117.CMS_META_DATA_PATH_IDX nologging;
YES alter index DEV117.CONTENT_COMP1 nologging;
YES alter index DEV117.CONTENT_TAGLIST_PK nologging;
YES alter index DEV117.MODULE_VIEW_PK nologging;
YES alter index DEV117.PK_CONTENTLIST_CONTENT_ID nologging;
YES alter index DEV117.PK_JUMP_MENU nologging;
YES alter index DEV117.PK_UNIQUE_PERSONNEL_ID nologging;
YES alter index DEV117.SYS_C0013289 nologging;
YES alter index DEV117.SYS_C0013290 nologging;
YES alter index DEV117.SYS_C0013295 nologging;
YES alter index DEV117.SYS_C0013299 nologging;
YES alter index DEV117.SYS_C0013302 nologging;
YES alter index DEV117.SYS_C0013304 nologging;
YES alter index DEV117.SYS_C0013308 nologging;
YES alter index DEV117.SYS_C0013311 nologging;
YES alter index DEV117.SYS_C0013312 nologging;
YES alter index DEV117.SYS_C0013314 nologging;
YES alter index DEV117.SYS_C0013315 nologging;
YES alter index DEV117.SYS_C0013317 nologging;
YES alter index DEV117.SYS_C0013322 nologging;
YES alter index DEV117.SYS_C0013332 nologging;
YES alter index DEV117.SYS_C0013346 nologging;
YES alter index DEV117.SYS_C0013347 nologging;
YES alter index DEV117.SYS_C0013349 nologging;
YES alter index DEV117.SYS_C0013353 nologging;
YES alter index DEV117.SYS_C0013356 nologging;
YES alter index DEV117.SYS_C0013363 nologging;
YES alter index DEV117.SYS_C0013364 nologging;
YES alter index DEV117.SYS_C0013368 nologging;
YES alter index DEV117.SYS_C0013377 nologging;
YES alter index DEV117.SYS_C0013382 nologging;
YES alter index DEV117.SYS_C0013387 nologging;
YES alter index DEV117.SYS_C0013390 nologging;
YES alter index DEV117.SYS_C0013393 nologging;
YES alter index DEV117.SYS_C0013397 nologging;
YES alter index DEV117.SYS_C0013398 nologging;
YES alter index DEV117.SYS_C0013401 nologging;
YES alter index DEV117.SYS_C0013407 nologging;
YES alter index DEV117.SYS_C0013414 nologging;
YES alter index DEV117.SYS_C0013415 nologging;
YES alter index DEV117.SYS_C0013419 nologging;
YES alter index DEV117.SYS_C0013424 nologging;
YES alter index DEV117.TAGLISTLIST_TAGLIST2 nologging;
YES alter index DEV117.TAGLISTLIST_TAGLIST_PK nologging;
YES alter index DEV117.TAG_LIST_LIST_PK nologging;
YES alter index DEV117.TAG_LIST_PK nologging;
YES alter index DEV117.UNIQUE_ALERT_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_AUTHORITIES_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_CENTERPIECE_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_CLUB_CLUBSITEBRANCHPATH nologging;
YES alter index DEV117.UNIQUE_CLUB_CODE nologging;
YES alter index DEV117.UNIQUE_CLUB_DOMAIN_NAME_TOKEN nologging;
YES alter index DEV117.UNIQUE_CLUB_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_CONTACT_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_CONTENT_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_DEPTH_CHART_CLUB_ID nologging;
YES alter index DEV117.UNIQUE_DEPTH_CHART_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_FORGOT_PWD_CLUB_ID nologging;
YES alter index DEV117.UNIQUE_FORGOT_PWD_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_FORM_RCPTS_EMAILALIAS nologging;
YES alter index DEV117.UNIQUE_GAMESTATUS_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_GAME_DAY_STATUS_CLUB_ID nologging;
YES alter index DEV117.UNIQUE_JUMP_MENU_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_PAGE_TITLE_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_PERSONNEL_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_POLL_ANSWERS_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_POLL_CONFIG_ID nologging;
YES alter index DEV117.UNIQUE_POLL_COUNT_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_POLL_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_ROSTER_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_TAG_EXTERNALID nologging;
YES alter index DEV117.UNIQUE_USERS_ADDITIONAL_NAME nologging;
YES alter index DEV117.UNIQUE_USERS_EMAIL nologging;
YES alter index DEV117.UNIQUE_USERS_USERNAME nologging;
YES alter index DEV117.UNIQUE_USERS_USERNAME_COMP1 nologging;
YES alter index DEV117.UNIQUE_WEEK_INJURY_EXTERNALID nologging;
YES alter index DEV117.UQ_CLUB_YEAR nologging;
YES alter index DEV117.USERS_ADDITIONAL_CLUB_ID nologging;
YES alter index DEV117.USERS_CLUB_ID nologging;
YES alter index DEV117.USERS_PK nologging;

ECSCDAD3 > list
  1  select logging,'alter index '||owner||'.'||index_name||' nologging;'
  2  from dba_indexes where owner =upper('&1')
  3* order by status, index_name

Report message to a moderator

Re: migrate ful db [message #574928 is a reply to message #574922] Wed, 16 January 2013 14:42 Go to previous message
Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Beware to take a full backup after the import in this case.

Regards
Michel

Report message to a moderator

Previous Topic: Control file help
Next Topic: EXP-00008: ORACLE error 6552 encountered
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 22 18:46:55 CDT 2013

Total time taken to generate the page: 0.16249 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.