Database Cold Backup

We are taking the cold backup of the database.

Connect to the database.

Ex: $sqlplus ‘/as sysdba’

Find the Path of the data files, control file and redo log files.
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/narniaprodb/orainfprod/oradata/narniap/pnarnia/system01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/undotbs01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/sysaux01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/users01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/dcm.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/portal.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/ptldoc.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/ptlidx.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/ptllog.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/oca.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/discopltc1.dbf

NAME
--------------------------------------------------------------------------------
/narniaprodb/orainfprod/oradata/narniap/pnarnia/discopltm1.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/oss_sys01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/wcrsys01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/uddisys01.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/b2b_dt.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/b2b_rt.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/b2b_idx.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/b2b_lob.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/bam.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/orabpel.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/attrs1_oid.dbf

NAME
--------------------------------------------------------------------------------
/narniaprodb/orainfprod/oradata/narniap/pnarnia/battrs1_oid.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/gcats1_oid.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/gdefault1_oid.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/svrmg1_oid.dbf
/narniaprodb/orainfprod/oradata/narniap/pnarnia/ias_meta01.dbf

27 rows selected.

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/narniaprodb/orainfprod/oradata/narniap/pnarnia/control01.ctl
/narniaprodb/orainfprod/oradata/narniap/pnarnia/control02.ctl
/narniaprodb/orainfprod/oradata/narniap/pnarnia/control03.ctl

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/narniaprodb/orainfprod/oradata/narniap/pnarnia/redo03.log
/narniaprodb/orainfprod/oradata/narniap/pnarnia/redo02.log
/narniaprodb/orainfprod/oradata/narniap/pnarnia/redo01.log

Before shutting down the database all the services should be down (Both midtier and infrastructure)

SQL>shutdown immediate;

Goto “/narniaprodb/portalbkup” folder and create a diretory with today’s date and copy all the datafiles,controlfile and the redolog files to backup folder

$cp /narniaprodb/orainfprod/oradata/narniap/pnarnia/*

Start the database

SQL>startup