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
follows:The data file backup file is/u01/app/oracle/backup/orcl01.dbf'Controlfile, spfile backup file for/u01/app/oracle/backup/c-1351646173-20130822-00After copying to rac8, it is still placed in the same path and configured with the same permissions. Generally, it is the oracle: oinstall permission.
3. rman recovery
. Restore spfile:RMAN> restore spfile from '/mnt/hgfs/software/backup/20120829_SPFILE_05njss0m_1_1 ';RMAN> shutdown immediate;2. Edit the parameter file to change the relevant path in the parameter to a new path.$ Oracle @ model ~> Sqlplus/as sysdbaSYS @ test> create pfile from spfile;Edit the generated $ ORACLE_HOME/d
'/u01/app/oracle/backup/c-1351646173-20130822-00′;It will tell you to be successful again.Restoring a data file requires the database to be placed in Mount state[[email protected] ~]$ uniread sqlplus '/as Sysdba 'sql> shutdown immediate;sql> shutdown Mount;Note: The status of boot to mount may require parameter resetlogs[Email protected] ~]$ Uniread Rman target/
all used by Oracle user operations on the target sideCD $ORACLE _basemkdir Flash_recovery_areaMkdir-p ADMIN/SCPDB01CD ADMIN/SCPDB01mkdir {A,b,c,d,u}dumpStart recovery, at which point the restored instance is named ScpdbExport oracle_sid=scpdbRman Target/==================================================== = in Rman start dat
1. Create a database directory2. Copy the Pfile file from the original host and change the ORACLE_SIDVi. Bash_profilesource. Bash_profile3. Start data to Nomount status$ sqlplus/as sysdbasql> startup nomount pfile= ' pfile file absolute location '; ORACLE instance started. Sql> exit4. View the backup Controlfile list$/usr/openv/netbackup/bin/bplist-s Backup Server
export or after the import recompile. The stored procedure did not import successfully, so I finally took advantage of Navicat to import the stored procedure successfully.Note: (1) To ensure that two databases have the same character set, if the difference will be an error. I checked the next two database character sets are the same, so I'm not sure what is wrong with the specific report. To view the database
Use SHELL script to verify Oracle Database RMAN Validity of backup setsauthor : Zhao Full text Network name : Guestart Our production environment oracle database has been made Rman Backup, is a week of
Use rman to migrate 10 Gb servers across databases and servers: 192.168.182.133Oracle10.2.0.1.0RHEL432bit11g server: Server 192.168
Use rman to migrate 10 Gb servers across databases and servers: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit
integration steps are required for this process.(iv) All platforms, consistent in quality. Oracle has more rigorous testing of new software releases than third-party products.(v) All platforms with consistent functionality. For example, some third-party cluster products limit the number of nodes that can be supported within a cluster. With Oracle RAC 10g, all platforms can support up to 64 nodes. Users can
Tags: stored procedure eva puzzle SYS attach should be obtained by modifyingDuring the backup and restore of the database, I encountered a problem "the media set has 2 media families, but only 1 are available." Must provide all members ", the following is a detailed description of the problems encountered and problem-solving methods!One, backup and restore encoun
RMAN replication and the same machine copy operation procedures are the same, the difference is that we need to copy the backup files to the secondary library
Experimental platform: REDHAT Linux 4.7 + Oracle 10g
Target Library Information:
Oracle_base:/u01/app/oracle
Oracle_home:/u01/app/oracle/product/10.2.0/db_1
physical standby database has become extremely simple, and an RMAN command can complete the entire process. In the past, you may need to use the Grid Control wizard interface to complete Data Guard settings between two computers. At the time of writing this article, the Oracle Enterprise Manager Grid Control 11g has n
---------ORCLsql> drop database;Database dropped.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the partitioning, OLAP, Data Mining and Real application testing optionsSql> exit[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:
The rman backup script in the Oracle database is very practical.
The rman backup script in the Oracle database is very practical.
Query character sets
SQL> select * from nls_database_parameters;
NLS_CHARACTERSETAL32UTF8
Character
The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see:
C: \ oracle \ product \ 10.2.0 \ client_1 \ BIN> rman target sys/password @ DGPRecovery Manager: Release 10.2.0.1.0-Production on Tue
Restore databases in different locations
Restore databases in different locations
Machine:
Select instance_name from v $ instance;
Select name from v $ database;
Select name from v $ datafile;
Log query mode:
Archive log list;
Shutdown immediate;
Startup mount;
Change the log archive mode:
Alter database archivelog;
A
: (Wending.lk is the source of the name of the library, to ensure that the source library has been started listening)
$ nohup rman target sys/iamwangnc@192.168.137.199:1521/wending.lk auxiliary/@recover. RCV Log Recover.log
$ tail-50f Recover.log
...
Database opened
Finished Duplicate Db at 2008-11-21 13:02:39
The following error occurred while regulating the dat
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.