Failure phenomenon:
How do I make a cold backup of an Oracle database in case of an emergency, without opening the Oracle log archive?
Solution:
A cold backup of the Oracle database, sorted as follows:
When do I have to use cold backup?
1. Database mode is not archive mode
2. For field protection
The process of cold backup:
1. First view the location of the backup file:
Data files, control files, log files
Select name from V$datafile
UNION ALL
Select name from V$controlfile
UNION ALL
Select member from V$logfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/control01.ctl
/u01/app/oracle/oradata/orcl/control02.ctl
/u01/app/oracle/oradata/orcl/control03.ctl
/u01/app/oracle/oradata/orcl/redo03.log
/u01/app/oracle/oradata/orcl/redo02.log
/u01/app/oracle/oradata/orcl/redo01.log
Parameter file:
CD $ORACLE _home/dbs/
Spfileorcl.ora
Password file:
CD $ORACLE _home/dbs/
Orapworcl
To stop a database:
Shutdown immediate
Copy all of the above files to the backup directory:
Mkdir-p/U01/BACKUP/COLDBK
To start a database:
Startup
Note: In non-archive mode, if the database has undergone log switching since the backup, a cold backup can only be used for incomplete recovery, the
database can only be restored to the backup point, and data from the backup point will be lost.