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