Databases Reference
In-Depth Information
2. Read the statistics about I/O on data files querying
V$FILESTAT
dynamic
performance view:
COL FILE_NAME FOR A40
SELECT DF.FILE_NAME, FS.PHYRDS,
FS.PHYWRTS, FS.READTIM, FS.WRITETIM
FROM V$FILESTAT FS, DBA_DATA_FILES DF
WHERE FS.FILE# = DF.FILE_ID;
3. Read the statistics about I/O on temporary files querying
V$TEMPSTAT
dynamic
performance view:
SELECT DF.FILE_NAME, FS.PHYRDS,
FS.PHYWRTS, FS.READTIM, FS.WRITETIM
FROM V$TEMPSTAT FS, DBA_DATA_FILES DF
WHERE FS.FILE# = DF.FILE_ID;
4. Identify the log files by querying
V$LOGFILE
dynamic performance view:
COL MEMBER FOR A40
SELECT * FROM V$LOGFILE;
CLEAR COL
5. Put redo log files on disk without other activities; to move log files perform the
following steps, otherwise go to step 10. Shut down the database:
SHUTDOWN IMMEDIATE
6. Move the log files using the O/S commands:
!mv /u01/oradata/TESTDB/redo01.log
/u01/oradata/TESTDB2/redo01.log
!mv /u01/oradata/TESTDB/redo02.log
/u01/oradata/TESTDB2/redo02.log
!mv /u01/oradata/TESTDB/redo03.log
/u01/oradata/TESTDB2/redo03.log
7.
Mount the database:
STARTUP MOUNT
