How do I use Oracle for cold backup?

The usual steps for Oracle cold backup:

1 Shut down the database gracefully.

2 Back up all important files to the backup directory (data files, control files, redo log files, etc.) 3 Start the database after the backup is complete.

When restoring with a cold backup, you only need to restore all the files to their original location and you can start the database.

1 Go to the database sqlplus"/as sysdba"

2 Start if you don't have one: sql>startup

3 Query the directory where the datafile is located

sql>select name from v$datafile;

Query the directory where the control file is located

sql>select name from v$controlfile;

Query the directory where the redo log file is located

sql>select member from v$logfile;

4 Close the database.

sql>shutdown

5 Back up the file to the directory where you backed it up.

cp /u01/app/oracle/oradata/orcl/*.dbf /home/mzl/backupdatabase＃cp /u01/app/oracle/oradata/orcl/*.ctl /home/mzl/backupdatabase＃cp /u01/app/oracle/oradata/orcl/*.

log home mzl backupdatabase6 and then start the database.

sqlplus "/as sysdba"

sql>startup

The cold backup is complete.

The current strength of the local tyrant to accompany the funeral while sending.

Hot backup allows you to back up the tablespace when the database is not down, and cold backup is a backup that must be copied from the tablespace after the database is shut down and the operating system commands are used.

Hot backup is suitable for important databases, such as 7x24 production systems, and can ensure that the database can be restored to any point in time in combination with archive logs in the event of a crash without data loss.

Cold backup cannot be restored only to the point in time when the database is restored, and all new data and modification records cannot be restored during the period from the time the backup is completed to the time when the database has a problem and needs to be restored.

Hot backup can only be carried out in archive mode, cold backup does not need archive mode, archive mode will have a certain impact on system performance, especially disk IO, but compared with the benefits and security of archive, I believe that most DBAs will choose archive mode.