OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » migrate ful db

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migrate ful db [message #573676]

Wed, 02 January 2013 04:41

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

Michel Cadot
Messages: 68418
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

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

Michel Cadot
Messages: 68418
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

alan.kendall@nfl.com
Messages: 163
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

Michel Cadot
Messages: 68418
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 20:27:11 CDT 2023