In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Environment: win 2008 oracle 11g
At the request of the developer, migrate the local automap data file to the magnetic array.
Database non-archiving mode
Data file migration:
SQL > select name from v$datafile
D:\ app\ oradata\ orcl\ automap01.dbf
D:\ app\ oradata\ orcl\ automap02.dbf
.
SQL > shutdown immediate
(the following $move command should be equivalent to the operating system's cut-and-paste command)
SQL > $move D:\ app\ oradata\ orcl\ automap01.dbf E:\ app\ oradata\ orcl\ automap01.db'
SQL > $move D:\ app\ oradata\ orcl\ automap02.dbf E:\ app\ oradata\ orcl\ automap02.db'
The SQL > startup mount ORACLE routine has been started. The Total System Global Area 209715200 bytes Fixed Size 1248140 bytes Variable Size 92275828 bytes Database Buffers 113246208 bytes Redo Buffers 2945024 bytes database has been loaded. SQL > alter database rename file'D:\ app\ oradata\ orcl\ automap01.dbf' to'E:\ app\ oradata\ orcl\ automap01.db'; SQL > alter database rename file'D:\ app\ oradata\ orcl\ automap02.dbf' to'E:\ app\ oradata\ orcl\ automap02.db'
The SQL > alter database open; database has changed. SQL > select name,status from v$datafile
In addition, other ways to move data files (when the database starts archiving, you can start migration): move Oracle database tablespace files purpose: to move oracle tablespace files from one place to another. Detailed operation steps: first, enable media recovery mode: a, Shutdown immdiate; B, Startup mount; C, Alter database archivelog; D, Alter database open; second, uninstall tablespace: a, Alter tablespace tablespace name offline; (note: add Drop after non-archive mode); third, move files to a new location under the operating system. Fourth, tell the tablespace data file has been moved: a, Alter database rename file 'original file path' to 'new file path'; fifth, load tablespace: a, Alter tablespace tablespace name online; sixth, close database: a, Shutdown; seventh, start database: a, Startup force; Oracle database tablespace file moved successfully.
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.