COLD BACKUP PROCESS MANUAL

BEFORE COLD BACKUP
select count(*) from v$controlfile;--    Present:3                     Previous: 3
select count(*)from v$logfile; --        Present:6                     Previous: 6
select count(*) from dba_temp_files;--    Present:4                    Previous: 3
select count(*) from v$datafile;--        Present:33                     Previous: 75
SELECT DBID FROM V$DATABASE;---- ----    Present: 468172852            Previous: 416759732
select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ARCHIVER,DATABASE_STATUS from v$INSTANCE;

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
FROM   sys.v_$instance;   -----            Present:29-AUG-2010 13:41:44Previous: 27-JUN-2010 16:15:28

select sum(cnt) from (select count(*) cnt from v$controlfile
union
select count(*)from v$logfile
union
select count(*) from dba_temp_files
union
select count(*) from v$datafile
)
------TOTAL :46
AFTER COLD BACKUP 
select count(*) from v$controlfile;--    Present:3                     Previous: 3
select count(*)from v$logfile; --        Present:6                     Previous: 6
select count(*) from dba_temp_files;--    Present:4                    Previous: 3
select count(*) from v$datafile;--        Present:33                     Previous: 75
SELECT DBID FROM V$DATABASE;---- ----    Present: 468172852             Previous: 416759732
select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ARCHIVER,DATABASE_STATUS from v$INSTANCE;

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
FROM   sys.v_$instance;   -----            Present:26-SEP-2010 15:16:41 Previous: 29-AUG-2010 13:23:59

select sum(cnt) from (select count(*) cnt from v$controlfile
union
select count(*)from v$logfile
union
select count(*) from dba_temp_files
union
select count(*) from v$datafile
)
------TOTAL :46

COLDBACKUP 
Step1. Preparation:
a)
File Checks
CONTROL FILES    V$CONTROLFILE  ((To check the controlfiles Information))
select name,status from v$controlfile;
b)
REDOLOGFILES    V$LOGFILE (To check the Redolog Files Information)
select group#,member from v$logfile order by group#;
c)
DATFILES        V$DATAFILE (To check the Data Files Information)
select name,bytes,creation_time from v$datafile;
d)
Tempfiles:( To check the tempfiles Information)
select * from dba_temp_files ;
select * from v$instance;
select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ARCHIVER,DATABASE_STATUS from v$INSTANCE;
--select * from v$database;

Step 2:
a)
Sql>
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
OR
b)
Sql>
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS ;

c)
Sql>
ALTER SYSTEM SWITCH LOGFILE;

d)
Sql>
SELECT DBID FROM V$DATABASE;---- ----416759732
 
Step 3: Shutdown the Database
a)
SQL>shutdown immediate
 
Step 4:
a)
Copy the C/R/D Files to Backup Destination
 
Step 5: Start the Database (UP the Database)
a)
SQL>startup
 
Step 6: Check C/R/D Files
----Check all C/R/D files whether offline or online.