Database Reference
In-Depth Information
exeRCiSe 1.3 (continued)
C:\ORACLE\ORADATA\ORCL\REDO02.LOG
C:\ORACLE\ORADATA\ORCL\REDO01.LOG
C:\ORACLE\ORADATA\ORCL\REDO03B.LOG
3. You use the NAME column in V$CONTROLFILE to find the control files:
SQL> select name from v$controlfile;
NAME
-------------------------------------
C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL
C:\ORACLE\ORADATA\ORCL\CONTROL02.CTL
C:\ORACLE\ORADATA\ORCL\CONTROL03.CTL
C:\ORACLE\ORADATA\ORCL\CONTROL04.CTL
4. Having found all the files you will need for your backup, create a directory to back up
all your files to. Of course, you might back up your files to tape or a thumb drive or
some such thing. In this case, you will just copy the files to a directory that you will
create called c:\backup\orcl\backup1 :
SQL> host mkdir c:\backup\orcl\backup1
5. Having created your backup directory, you need to shut down the database with the
SHUTDOWN IMMEDIATE command before you start your backup:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
6. Now copy the files that you found in steps 1, 2, and 3 to the backup directory created in
step 4. Notice that all the files in this example reside in one directory, c:\oracle\ora-
data\orcl , so the COPY command is quite easy. Backups can take a while, so be patient.
It's probably a good time to go grab a cool refreshment from the vending machine!
C:\>copy c:\oracle\oradata\orcl\*.* c:\backup\orcl\backup1
c:\oracle\oradata\orcl\CONTROL01.CTL
c:\oracle\oradata\orcl\CONTROL02.CTL
c:\oracle\oradata\orcl\CONTROL03.CTL
c:\oracle\oradata\orcl\CONTROL04.CTL
c:\oracle\oradata\orcl\REDO01.LOG
Search WWH ::




Custom Search