Shulou(Shulou.com)05/31 Report--

This article will explain in detail what are the migration server solutions in the database. Xiaobian thinks it is quite practical, so share it with you as a reference. I hope you can gain something after reading this article.

Two scenarios were used to migrate the database

Option 1:

Data pump export method, you need to modify the undo parameter of the clob field table separately

Pros: This approach solves the users table space problem,

Disadvantages: but export import time is too long, light export takes at least 8 hours, and a number of large tables for clob large field, the largest clob table 60G more.

Too long, the program will be rejected.

Option 2:

Cold Backup Recovery

Disadvantages: Can't solve USERS table space problem directly.

Although you can migrate tablespaces later, the clob is found to be too large by the data pump operation, and it is prudent not to migrate tablespaces

Advantages: fast time, high efficiency, strong controllability.

Issues to be noted:

Data file copy time problem, 270G size using mobile hard disk copy time is about 4 hours. If you add the time of admission to copy, it is not feasible in terms of time.

Later, by using the method of sharing folders, the new bak directory of the new library is copied to the original database data file, and then the data file is copied to the new database data file directory.

Do not share data file directories to ensure security.

The shared mode takes about an hour to transmit data. Short time, good effect, export and import effect

Cold backup steps:

1. Guanyuan Library

2. Copy library 31 to the new library

3. Backup new library data files

4. Start-up of new library--shutdown of library copy 270G takes 1 hour, startup is normal

5. Temporary Tablespace View to see if rebuild is needed--no rebuild needed this time, identified

6. Check monitoring, see plsql connection is normal

7. Check if there are invalid indexes

--Log in important users to check the failure index

select t.index_name,t.table_name,t.status,t.last_analyzed from user_indexes t

where t.status'VALID';

Change system password

alter user system identified by oracle;

8. Finally, make a full RMAN backup

About "What are the migration server solutions in the database" This article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.