Oracle Database cold backup and cold Backup Remote recovery methods

HowOracle DatabaseProceedCold backupWhat about it? If yesCold Backup Remote recoveryWhat settings are needed? This article mainly introduces this aspect. Next we will start to introduce it.

I. Cold backup

Take oracle10g as an example.

Coldbak script:

-- Connect database

Connect sys/the password you set as sysdba;

-- Shutdown database

Shutdown immediate;

-- Copy Data file

Host xcopy d: \ Oracle \ product \ 10.2.0 \ oradata \ orcl \ *. dbf d: \ DbBakup;

-- Copy Control file

Host xcopy d: \ Oracle \ product \ 10.2.0 \ oradata \ orcl \ *. ctl d: \ DbBakup;

-- Copy Log file

Host xcopy d: \ Oracle \ product \ 10.2.0 \ oradata \ orcl \ *. log d: \ DbBakup;

-- Startup database

Startup;

Note: copy the above Code to notepad and save it as *. SQL is a cold backup script. The control file (*. ctl), data file (*. dbf), and log file (*. log) paths are modified according to their own paths. "D: \ DbBakup" is the backup path and can be modified by yourself. To back up all the data files, some dbf may not be in a directory. You need to check all the data file paths in EM.

Cold backup procedure:

1. Enter cmd at run.

2. Enter sqlplus/nolog In the cmd interface to enter SQL * plus.

3. Connect to the database conn sys/your set password as sysdba as a dba.

4. Perform the cold backup operation. @ Cold backup angular path.

2. Remote recovery

Note: copy the backup file to another machine to ensure that the backup machine is installed with the same version of oracle and the installation directory is the same ).

Normal recovery steps:

1. Enter cmd at run.

2. Enter sqlplus/nolog In the cmd interface to enter SQL * plus.

3. Connect to the database conn sys/your set password as sysdba as a dba.

4. Input: shutdown immediate.

5. manually copy the backup files to the corresponding oracle directory.

6. In the command window, enter startup at SQL> cursor.

Note: if you cannot log on to EM, restart the oracle service. The above is the normal local recovery process. If you only perform the preceding steps for remote recovery, the host connection string of the database is the host name of the backup machine. Therefore, apart from normal recovery steps, we need to re-build EM during Remote recovery.

EM reconstruction steps:

We recommend that you disable the EM service.

1. Delete EM

A. Enter emca-repos drop in the cmd command window.

B. Enter your database information in the following information.

2. Create EM

A. Enter emca-repos create in the cmd command window.

B. Enter your database information in the following information.

3. Configure EM

A. Enter emca-config dbcontrol db in the cmd command window.

B. Enter your database information in the following information.

Here is an introduction to Oracle Database cold Backup Remote recovery. I hope this introduction will bring you some benefits. Thank you!