Remote recovery of Oracle Database cold backup

1. Copy the cold backup data files, log files, and control files to the target folder. 2. Create a pfile of init: $ ORACLE_SID.ora.

1. Copy the cold backup data files, log files, and control files to the target folder. 2. Create a pfile of init: $ ORACLE_SID.ora.

1. Copy the cold backup data files, log files, and control files to the target folder.

2. Create a pfile of init: $ Oracle_SID.ora, which can be copied from the template in the samples folder.

3. Modify the control_files parameter of the pfile and specify it as the location of the control file with recovery.

Modify the db_name attribute to make it consistent with the db_name of the cold backup (you can also change it in the next step and a prompt will appear)

4. sqlplus/nolog; conn/as sysdba; startup mount;

Mount the instance (errors may occur during the process. Follow the prompts to modify the. ora file) until the instance is successfully loaded.

5. select name from v $ datafile;

The result is that all data files and log files are located in the original database. If the folder you copied is consistent with the original database, you do not need to modify this attribute.

Alter database rename file 'source. dir' to dest. dir;

6. After completing the above steps, you can start your database.

Alter database open;

7. Verify that the database is successfully started.

Select user_name from user_tables; you can obtain information about all users.

Obtain the username of the data table space and log on to the database.

Select count (*) from user_tables;

If it is not 0, it indicates that there is data. select any table from the table to see if there is any data.

,