Performing a 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.