oracle 11g rman restore database on another server
oracle 11g rman restore database on another server
Discover oracle 11g rman restore database on another server, include the articles, news, trends, analysis and practical advice about oracle 11g rman restore database on another server on alibabacloud.com
SetWholeKingdeeEAS DatabaseMove to another environment for development and testing:
BackupOracle Database: (you can also PL-SQL through external tools)
[Oracle @ rcno8 ~] $Sqlplus
SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Enter user-name:Conn/as sysdba
Enter password:
Connected:
If a problem occurs in our operating system, how should we restore the ORACLE database after the system is reinstalled? The following describes how to restore the ORACLE database after reinstalling the system. We often use the
. Configuring Oracle User Environment variablesVI. bash_profileExport Oracle_base=/u01/app/oracleExport Oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1Export ORACLE_SID=ORCLExport path= $ORACLE _home/bin: $PATH 8. Open Xmanager Passive, execute in system[Email protected] ~]# export display=192.168.1.100:0.0(IP for machines that need to receive
Oracle Database Instant Client 11g 11.2.0.3.0
Instant client is a lightweight database client published by ORACLE (R) that allows you to run OCI, OCCI, Pro*c, ODBC, and JDBC programs without having to install standard clients.For those who only need to connect to a remo
Create an Oracle 11g database using commands
This document describes how to create an Oracle database that complies with the OFA specification using the create database Command of the Oracle
access/etc/x11/xinit/xinitrc:no such file or Directory[[emailprote CTED] ~]# Find/-name xinitrc[[emailprotected] ~]# adopted the scheme is to comment out/root/.vnc/xstartup inside the EXEC/ETC/X11/XINIT/XINITRC , let Vncserver choose the default, let VNC load the default graphical interface program It's OK.--------------------------------------------------------------------change the permissions of Xstartup This is a problem that many people tend to overlook, is also the cause of the black scre
Label:System environment: Win7 32-bit system Installation steps: 1,oracle (Oracle) Download the appropriate database installation package,http://www.oracle.com/technetwork/cn/indexes/downloads/index.html#database 2, download There are two packages Win32_11gr2_database_1of2 and WIN32_11GR2_DATABASE_2OF2 unzip and gene
will take over the IIS service), its default startup type is manual. The service process is APACHE.EXE, the parameter file is httpd.conf, and the default port is 80.(9) Oraclehome_namepagingserver by a digital pager or email with a modem (not tried), its default startup type is manual. Service process PAGNTSRV.EXE, log file Paging.log.Oraclehome_namenames Oracle Names Service, only the server is required a
Tags: backing up data files archive IDT initializing Redolog ada GES versionRestore the Oracle database by manual backup: Although the Rman tool is already available But restoring Oracle manually will give you a deeper understanding of Oracle
, which means the two have the same effect. To put it simply, dynamic parameters are directly written into spfile after modification, rather than manually modifying text documents like pfile. Modify spfile: the types of parameters include Database, system, and session. In fact, we need to understand static and dynamic parameters, which determine how to modify them.
Why is the above scenario. First, we must start with static and dynamic attributes.
If you want to restore a database on a colleague's machine to your own machine, the DMP file provided by the colleague cannot be used. I suddenly thought of Oracle 10 Gb, and I was still in the Oracle 9I stage. Back up again with your own 9I client, resulting in a EXP-00003 error. I checked on the Internet that the BLO
I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and delete the old user! Next we will introduce this new feature in the 11g rac environment!
1. Create a test user xxx and
registry key, all the keys that contain Oracle.11. My Computer----high-level----environment variables, delete environment variables classpath and path for Oracle settings.12. Remove all Oracle-related groups and icons from the desktop, startup Group, and Programs menu.13. Delete all Oracle-related directories (if not
Tags: connect database src Microsoft Replace OGR technology http sql2000 altOn the database server, when you want to restore a database to a backup file, the server's database file itself is stored in theD:\DEVDB DirectoryConnect
From:http://blog.sina.com.cn/s/blog_6734ea6d0102v6sn.htmlAdd operating system environment variable: oracle_hostname=localhostThen run Emca-config Dbcontrol db under cmd (if multiple DB instances, first execute set oracle_unqname= Oralcle_sid, where Oralcle_sid is your instance name)C:\Documents and Settings\administrator>emca-config Dbcontrol dbEMCA started on 2012-3-10 18:01:26EM Configuration Assistant, 11.2.0.0.2 official versionCopyright (c) 2003, 2005,
Tags: style blog http color os file Data 2014Today, when restoring a database, first establish a database of the same name, and then right-click on the database to restore the database. An error has been encountered:"The database
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.