Oracle 11g Manual Cold Backup

Manual Cold Backup
---------------------

Note: For ASM based backup use RMAN

For Non-ASM

1.
$ cd /u01/oracle
$ mkdir orabackup
$ cd orabackup
$ mkdir orcl1
$ cd orcl1
$ mkdir cold
$ cd cold

$ ls
$ pwd -> /u01/oracle/orabackup/orcl1/cold

2.
sqlplus sys as sysdba
SQL>

3.
SQL> Select tablespace_name, file_name
From DBA_DATA_FILES;

4.
SQL> Select member
From v$logfile;

5.
SQL> Select name
From v$controlfile;

6.
SQL> shutdown immediate;

7.
SQL> exit

8.
Copy all the necessary files from based on o/p from step 3, 4 and 5

e.g.
$ cp /u01/app/oracle/oradata/orcl1/*.* /u01/oracle/orabackup/orcl1/cold

Note: TEMP file need not be copied.
Copy datafiles, logfiles and controlfiles.

9.
sqlplus sys as sysdba

SQL> startup


------------------------------------------------------------------------------

- Suresh