Offline (Cold) backup (User Managed) practical

Offline (Cold) backup:-

$ export ORACLE_SID=prod

$ sqlplus / as sysdba

SQL> startup

SQL> select file_name,tablespace_name from dba_data_files;

SQL> select member from v$logfile;

SQL> select name from v$controlfile;

SQL> shut immediate

SQL> exit

~]$ mkdir offlinebkp

~]$ cd offlinebkp/

offlinebkp]$ pwd

offlinebkp]$ cd

~]$ cd prod

prod]$ cp -rvf *.dbf /u01/home/offlinebkp

prod]$ cp -rvf *.log /u01/home/offlinebkp

prod]$ cp -rvf *.ctl /u01/home/offlinebkp

prod]$ cd

~]$ cd offlinebkp/

VIEWS:-

dba_data_files;

v$logfile;

v$controlfile;