Cold Backup

Lists all the data files used in the database

select name from v$datafile;

Backup the control file and perform a trace of the control file using

alter database backup controlfile to '/u10/backup/control.ctl';

alter database backup controlfile to trace;

Init.ora and config.ora Located under $ORACLE_HOME/dbs directory

Shut down the database

shutdown

Perform a backup

cp /u01/oracle/users01.dbf /u10/backup

You can perform the backup of the Init.ora and config.ora files as follows:

cp $ORACLE_HOME/dbs/init.ora /u10/backup

cp $ORACLE_HOME/dbs/config.ora /u10/backup

Start the database

After the backup is complete, you can start the database as follows:

su – oracle

sqlplus "/ as sysdba"

SQL> startup