Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp.
C:/Documents and Settings/Administrator>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 26 01:23:22 2007
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
SQL> connect sys/change_on_install as sysdba; Connected.
SQL> select file_name from dba_data_files;
FILE_NAME -------------------------------------------------------------------- C:/ORACLE/ORADATA/WBQ/SYSTEM01.DBF C:/ORACLE/ORADATA/WBQ/UNDOTBS01.DBF C:/ORACLE/ORADATA/WBQ/MYDATABLESPACE01.DBF C:/ORACLE/ORADATA/WBQ/MYDATABLESPACE02.DBF C:/ORACLE/ORADATA/WBQ/MYDATABLESPACE03.DBF
SQL> select * from v$logfile;
GROUP# STATUSTYPEMEMBER ---------- ------- ------- ------------------------------------------ 1ONLINE C:/ORACLE/ORADATA/WBQ/REDO01.LOG 2ONLINE C:/ORACLE/ORADATA/WBQ/REDO02.LOG 3ONLINE C:/ORACLE/ORADATA/WBQ/REDO03.LOG
SQL> select * from v$controlfile;
STATUS NAME --------------------------------------------------------------------- C:/ORACLE/ORADATA/WBQ/CONTROL01.CTL C:/ORACLE/ORADATA/WBQ/CONTROL02.CTL C:/ORACLE/ORADATA/WBQ/CONTROL03.CTL
SQL>shutdown immediate Datebase clodes. Datebase dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle9iEnterpriseEdition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
C:/Documents and Settings/Administrator>cd/
C:/>cd C:/oracle/oradata/wbq
C:/oracle/oradata/wbq>md backup
C:/oracle/oradata/wbq>copy control01.ctl backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy control02.ctl backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy control03.ctl backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy REDO01.LOG backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy REDO02.LOG backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy REDO03.LOG backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy SYSTEM01.DBF backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy UNDOTBS01.DBF backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy MYDATABLESPACE01.DBF backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy MYDATABLESPACE02.DBF backup 1 file(s) copied.
C:/oracle/oradata/wbq>copy MYDATABLESPACE03.DBF backup 1 file(s) copied.
C:/oracle/oradata/wbq>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 26 01:37:07 2007
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
SQL> connect sys/change_on_install as sysdba; Connected to an idle instance. SQL> startup ORACLE instance started.
Total System Global Area105978600 bytes Fixed Size453352 bytes Variable Size79691776 bytes Database Buffers25165824 bytes Redo Buffers667648 bytes Database mounted. Database opened. SQL> | 
