Shulou(Shulou.com)05/31 Report--

This article shares with you the content of an example analysis of ORACLE cold backup and recovery. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Directly copy the three folders admin, oradata (datafile, controlfile,redo) and flash_recovery_area under the oracle directory, database (PWDfile, pfile), dbs (spfile) and NETWORK/ADMIN (listener.ora, tnsnames.ora) under the db_1 directory, and back up to other storage.

To look at the character set, it is best to keep the character set consistent.

SQL > select * from v$nls_parameters

Control file

Select * from v$controlfile

Data file

Select name from v$datafile

REDO LOG file

Select * from v$logfile

Parameter file

Select * from V$PARAMETER where name like'% spfile%'

Show parameter spfile

Temporary file

Select name from v$tempfile

Restore

Method 1: the simplest method (need to build a library)

1. Create the same database as before. (the installation path and database name must be the same as before)

two。 Stop the database shutdown immediate

3. Copy admin, oradata, flash_recovery_area overrides in the installation directory, and copy database (PWDfile, pfile) overrides

4. Start the database startup

Method 2: (no need to build a library, a little bit of trouble)

(1): reinstall the operating system. If you do cold backup recovery, make sure that you have the same operating system and the same database version.

(2): to install oracle software normally, you only need to install the software and do not need to build an instance.

(3): data overwrite, including data files, parameter files, control files, log files, pwd files, placed in the same directory as the original system. If the directory changes, you need to create an additional control file and modify the pfile.

(4): establish services:

Using the oradim command cmd, oradim-new-sid ggdb (actual sid name) means to set up a service, and sid is ggdb.

If you are under linux, you do not need this step.

Oradim-new-sid xxx-intpwd xxx-startmode a-pfile E:\ xxx\ init.ora

(5): set up listening: netca to build (it is recommended to copy the files under the network of the source system and modify them according to the actual situation).

(6): open database: cmd

Set oracle_sid=ggdb

Sqlplus / nolog

Conn / as sysdba

Startup

Verify the database

SQL > select count (*) from user_tables

At this point, the cold backup was restored successfully.

Thank you for reading! This is the end of this article on "sample Analysis of ORACLE Cold backup and recovery". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.