RelationalDBDesign RelationalDBDesign


Physical Backups  «Prev 

Performing a closed database backup in Oracle

  1. 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.
  2. To call Server Manager, type SVRMGR30 at the prompt and press Enter.
  3. To access the database as sysdba, type CONNECT INTERNAL at the prompt and press Enter.
  4. Type ORACLE as the password.
  5. 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.
  6. To find the location of the control files to back up, type SELECT NAME FROM V$CONTROLFILE; at the prompt and press Enter.
  7. To find the location of all control files to back up, type SELECT MEMBER FROM V$LOGFILE; at the prompt and press Enter.
  8. To shut down the database, type SHUTDOWN IMMEDIATE and press Enter.
  9. To access the operation system, type HOST and press Enter.
  10. 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.
  11. To return to Server Manager, type EXIT at the prompt and press Enter.
  12. To start the Oracle instance, type STARTUP OPEN PFILE=INITORCL.ORA and press Enter.
  13. This is the end of the Simulation.