Oracle cold backup and oracle backup
Prerequisites for cold backup:
The operating system is the same. You can execute scripts from Win32 to Win64 and from Win32 to Win64.
Procedure:
A. view the control files, data files, and log files of the two instances.
B. Disable two instances.
C. overwrite the corresponding file
D. Enable the instance.
FAQs:
A. If the number of control files is inconsistent.
A: Reduce the number of 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: You can create instances with few data files (tablespace) or delete tablespaces with multiple data files.
C. The number of log files is inconsistent.
A:
Method 1: Add log files to instances with fewer log files
Alter database add logfile group 4'e: \ APP \ ADMINISTRATOR \ ORADATA \ YANTAI2 \ REDO01.LOG 'size 100 m;
Method 2: delete log files from instances with many log files.
Switch logs
Alter system switch logfile;
If the log to be deleted is inactive, delete it.
Select group #, status from v $ log;
Alter database drop logfile group 1;
To avoid unnecessary troubles, I often keep the data files, control files, and log files of the two instances in the same quantity and location. The same instance name.
SQL statements used to view data files, control files, and log files.
Select name from v $ datafile;
Select name from v $ controlFile;
Select member from v $ logFile;