COLD BACKUP / Best Practic

[oracle@AZDB ~]$ export ORACLE_SID=AZKKDB

[oracle@AZDB ~]$ sqlplus sys as sysdba
SQL*Plus: Release – Production on Fri Oct 31 11:17:25 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.

SQL> startup;
ORACLE instance started.
Total System Global Area 348127232 bytes
Fixed Size 1219328 bytes
Variable Size 289408256 bytes
Database Buffers 50331648 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.

SQL> select name from v$datafile;

SQL> select name from v$controlfile;

SQL> show parameter pfile;
———————————— ———– ——————————
spfile string /home/oracle/oracle/product/10.2.0/db_1/dbs/spfileAZKKDB.ora

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> exit

[oracle@AZDB ~]$ mkdir backup

[oracle@AZDB ~]$ ls
oracle Desktop oraInventory backup AZKKDB

[oracle@AZDB ~]$ cd AZKKDB/

[oracle@AZDB AZKKDB]$ cd datafiles/

[oracle@AZDB datafiles]$ ls
redo01.log redo02.log sysaux01.dbf system01.dbf temp01.dbf undotbs1.dbf users01.dbf

[oracle@AZDB datafiles]$ cp * /home/oracle/backup/

[oracle@AZDB datafiles]$ cd ..

[oracle@AZDB AZKKDB]$ cd control/
[oracle@AZDB control]$ ls

[oracle@AZDB control]$ cp a1.ctl /home/oracle/backup/

[oracle@AZDB control]$ cd ..

[oracle@AZDB AZKKDB]$ cd $ORACLE_HOME/dbs
[oracle@AZDB dbs]$ ls
initAZKKDB.ora spfileAZKKDB.ora

[oracle@AZDB dbs]$ cp initAZKKDB.ora /home/oracle/backup/

[oracle@AZDB dbs]$ cp spfileAZKKDB.ora /home/oracle/backup/

[oracle@AZDB dbs]$ cd

[oracle@AZDB ~]$ cd backup/

[oracle@AZDB backup]$ ls
a1.ctl spfileAZKKDB.ora system01.dbf undotbs1.dbf redo01.log redo02.log
initAZKKDB.ora sysaux01.dbf temp01.dbf users01.dbf

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: