Oracle Cold Backup

Cold Backup Prerequisites:
The operating system is the same, you can Win32 to Win64,win32 to Win64 to execute the script.
Operation Steps:
A, view two instances of control files, data files, log files
b, close two instances
c, overwrite the corresponding file
D, open the instance

Problems:
A, if the number of control files is inconsistent.
A: Reduce the number of control files of the instance control files.
Alter system set control_files= '/u02/flash_recovery_area/bkt/control02.ctl ' scope=spfile;
b, the number of data files is inconsistent.
A: There are fewer instances of the data File New (tablespace), you can also delete more data files table space.
C, the number of log files is inconsistent.
For:
Method One: Log files with fewer instances increase the log file
ALTER DATABASE Add logfile Group 4 ' E:\APP\ADMINISTRATOR\ORADATA\YANTAI2\REDO01. LOG ' size 100m;
Method Two: Log file multiple instances delete the log file.
Toggle Log
alter system switch logfile;
If the log you want to delete is inactive, delete
Select Group#,status from V$log;
ALTER DATABASE drop logfile Group 1;

In order to avoid unnecessary trouble, I often keep two instances of the data files, control files, log files and the number of exactly the same location. The instance name is the same.

View SQL statements for data files, control files, and log files.
Select name from V$datafile;
Select name from V$controlfile;
Select member from V$logfile;

Oracle Cold Backup