Performing Closed Database Backup in Oracle
- At the prompt type
SET ORACLE_SID=ORCL
and press Enter. The purpose of setting Oracle SID is to make sure it points to the correct database.
- To call Server Manager, type
SVRMGR30
at the prompt and press Enter.
- To access the database as sysdba, type
CONNECT INTERNAL
at the prompt and press Enter.
- Type
ORACLE
as the password.
- To find the location of all the data files you are required to copy, type
SELECT FILE_NAME FROM DBA_DATA_FILES;
at the prompt and press Enter.
- To find the location of the control files to back up, type
SELECT NAME FROM V$CONTROLFILE;
at the prompt and press Enter.
- To find the location of all control files to back up, type
SELECT MEMBER FROM V$LOGFILE;
at the prompt and press Enter.
- To shut down the database, type
SHUTDOWN IMMEDIATE
and press Enter.
- To access the operation system, type
HOST
and press Enter.
- To copy a file, type
copy C:\ORANT\DATABASE\OEM.ORA
and press Enter. In a real world situation, you would repeat these steps for all the files listed on the previous screens as well as for the parameter files,
but we will skip those steps here. Since you are working in the Windows environment, you can use file system as a shortcut to copy all the files.
- To return to Server Manager, type
EXIT
at the prompt and press Enter.
- To start the Oracle instance, type
STARTUP OPEN PFILE=INITORCL.ORA
and press Enter.
- This is the end of the Simulation.