Cold backup data recovery

Backup

Directly copy the admin, oradata (datafile, controlfile, redo), and flash_recovery_area folders under the Oracle directory, database (pwdfile, pfile) and DBS (spfile) under the db_1 directory), network/admin (listener. ora, tnsnames. to other storage for backup.

Restore

Method 1: the simplest method (database creation required)

1. Create a database that is the same as the original one. (The installation path and database name must be consistent with the original one)
2. Stop the database shutdown immediate;
3. Copy and overwrite admin, oradata, and flash_recovery_area under the installation directory, and copy the database (pwdfile, pfile) to overwrite
4. Start the database startup;

Method 2: (database creation is not required, which is a little effort)

(1): reinstalls the operating system. If cold Backup recovery is performed, ensure that the same operating system and database version are the same.
(2): Oracle software is installed normally. You only need to install the software without creating an instance.
(3) data coverage, including data files, parameter files, control files, log files, and PWD files, which are placed in the same directory as the original system. If the directory changes, you need to create another control file to modify pfile.
(4) create a service: Run oradim-New-Sid gbicc in cmd to create a service. The SID is gbicc. This step is not required in Linux.
(5): Set up a listener: Net configuration assintant. (We recommend that you copy the files in the network of the source system and modify them according to the actual situation ).
(6): Open the database: cmd
Set oracle_sid = gbicc;
Sqlplus/nolog;
Conn/As sysdba;
Startup;

Now, the cold backup is successfully restored.

This article is from the "kingdba" blog, please be sure to keep this source http://kingdba.blog.51cto.com/801693/1440956

Cold backup data recovery