dbf' to
3 '/u06/oradata/xport.dbf';
Database altered.
In step 5, you open the database to make it available to users:
SQL> alter database open;
Database altered.
Finally, in step 6, you can make a backup copy of the updated control file:
SQL> alter database backup controlfile to trace;
Database altered.
SQL>
Alternatively, you can use RMAN to perform an incremental backup that includes a backup of
the control file.
Moving Datafiles with ALTER TABLESPACE
If the datafile you want to move is part of a tablespace other than SYSTEM, SYSAUX, the active
undo tablespace, or the temporary tablespace, then it is preferable to use the alter tablespace
method to move a tablespace for one primary reason: The database, except for the tablespace
whose datafile will be moved, remains available to all users during the entire operation.
The steps for moving one or more datafiles with alter tablespace are as follows:
1. Using an account with the ALTER TABLESPACE privilege, take the tablespace offline.
2. Use operating system commands to move the datafile(s).
3. Use alter tablespace to change the references to the datafile in the database.
4. Bring the tablespace back online.
94 Oracle Database 11g DBA Handbook
In the alter database example, assume that you moved the datafile for the XPORT tablespace
to the wrong file system. In this example, you??™ll move it from /u06/oradata to /u05/oradata:
SQL> alter tablespace xport offline;
Tablespace altered.
Pages:
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190