oracle数据库备份
oracle备份
我把"d:oracleoradata"里的数据库文件夹和"d:oracleadmin"中的数据库文件夹从机器a复制到机器b中对应的文件夹,然后改了listener.ora、tnsnames.ora文件
listener.ora文件为
# listener.ora network configuration file: d:oracleora92networkadminlistener.ora
# generated by oracle configuration tools.listener =
(description_list =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc0))
)
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
)
)sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = d:oracleora92)
(program = extproc)
)
(sid_desc =
(global_dbname = jiegou)
(oracle_home = d:oracleora92)
(sid_name = jiegou)
)
(sid_desc =
(global_dbname = jiegou2)
(oracle_home = d:oracleora92)
(sid_name = jiegou2)
)
)
tnsnames.ora文件# tnsnames.ora network configuration file: d:oracleora92networkadmintnsnames.ora
# generated by oracle configuration tools.jiegou =
(description =
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
(connect_data =
(service_name = jiegou)
)
)inst1_http =
(description =
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
(connect_data =
(server = shared)
(service_name = modose)
(presentation = http://hrservice)
)
)extproc_connection_data =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc0))
)
(connect_data =
(sid = plsextproc)
(presentation = ro)
)
)jiegou2 =
(description =
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
(connect_data =
(service_name = jiegou2)
)
)
其中jiegou2是我这边自己建的一个新数据库,应该不会有影响。
不过用plsql登录时报错ora-12500:tns:监听程序无法启动专用服务器进程
问题有两个:①按理说这种方法应该是没有问题的,估计是我没对应上oracle里的某个映射关系,不知道有没有人遇到我这种类似的问题,讨论讨论这种方法能不能做出来
②ora-12500这个错误我在网上也查了

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Oracle RAC hard disk new and replacement operations: Add hard disk: Add new disks, create ASM disk groups, add to clusters, move data files. Replace hard disk: Identify the failed hard disk, close the disk group, replace the hard disk, reopen the disk group, repair the failed disk, and move the data files.

Oracle garbled problems are usually caused by improper character set settings. Solutions include: Checking the server, database, and client character sets. Set up the server, database, and client character sets as needed. Use the CONVERT function or the DBMS_LOB.CONVERT_LOB function to fix garbled data. Always specify the character set and set the NLS parameters correctly.

Oracle provides multiple deduplication query methods: The DISTINCT keyword returns a unique value for each column. The GROUP BY clause groups the results and returns a non-repetitive value for each group. The UNIQUE keyword is used to create an index containing only unique rows, and querying the index will automatically deduplicate. The ROW_NUMBER() function assigns unique numbers and filters out results that contain only line 1. The MIN() or MAX() function returns non-repetitive values of a numeric column. The INTERSECT operator returns the common values of the two result sets (no duplicates).

To query the Oracle tablespace size, follow the following steps: Determine the tablespace name by running the query: SELECT tablespace_name FROM dba_tablespaces; Query the tablespace size by running the query: SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_

The steps to connect to a cloud server through an Oracle client are as follows: Create an SSH key and copy the public key to the cloud server. Configure the Oracle client and add the connection information of the cloud server to the tnsnames.ora file. Create a new database connection in the Oracle client, enter the username, password, and DSN. Click OK and verify that the connection is successful.

Oracle Database is a reliable, scalable and feature-rich relational database management system (RDBMS). Its architecture follows the client-server model, including server-side components (Oracle Net), instances, shared memory areas (SGAs), background processes, and database files that store data. Basic concepts include tables, rows, columns, primary keys, foreign keys, indexes and cursors. The database is known for its advantages such as high availability, big data support, rich features, strong security and ease of use.

To modify the Oracle character set, you need to: back up the database; modify the character set settings in the init.ora file; restart the database; modify existing tables and columns to use the new character set; reload the data; modify the database link (optional).

A stored procedure is a set of SQL statements that can be stored in a database and can be called repeatedly as a separate unit. They can accept parameters (IN, OUT, INOUT) and provide the advantages of code reuse, security, performance and modularity. Example: Create a stored procedure calculate_sum to calculate the sum of two numbers and store them in the OUT parameter.
