SQL> shutdown
c. Move the control files to a different location.
d. Restart the database:
SQL> startup
Examples for moving the control files and redo logs to different
locations
Example - Moving Online Redo Logs
In the following example for Oracle9i on HP-UX, the data files are on the same source
volume as the control files and redo logs, which is
/opt/oracle/product/9.2.0.
To move the online redo log files from /opt/oracle/product/9.2.0 to
/oracle/logs (which is not replicated):
1. List the online redo log files:
$ sqlplus
SQL> select member from v$logfile;
/opt/oracle/product/9.2.0/oradata/redo01.log
/opt/oracle/product/9.2.0/oradata/redo02.log
/opt/oracle/product/9.2.0/oradata/redo03.log
List the filenames and tablespaces to check whether they are on the same source
volumes as the control files:
SQL> select FILE_NAME,TABLESPACE_NAME,BYTES from
dba_data_files;
FILE_NAME
---------------------------------------------------------
TABLESPACE_NAME BYTES
------------------------------ ----------
/opt/oracle/product/9.2.0/oradata/system01.dbf
SYSTEM 419430400
/opt/oracle/product/9.2.0/oradata/undotbs01.dbf
UNDOTBS1 377487360
/opt/oracle/product/9.2.0/oradata/cwmlite01.dbf
CWMLITE 20971520
Zero downtime backup integration guide 423
To Next Page
Loading...
Need help?
General