restore oracle database from rman backup with different name
restore oracle database from rman backup with different name
Alibabacloud.com offers a wide variety of articles about restore oracle database from rman backup with different name, easily find your restore oracle database from rman backup with different name information here online.
After 12.1.0.2, duplicate target database for standby from active database is always hang dead in restore Controlfile. This is caused by bug 19664695. (Bug22468652 and bug 20721271 can end up with bug 19664695.) )
The workaround is to set up Disable_oob=on in the Sqlnet.ora file of Oracle_home and Grid_home. Please refer to
1. Use rman to back up Oracle Data in the open state
Rman backup must be in archive Mode
Check whether the archive mode is used.
SQL> archivelog list;
Change to archive Mode
Shutdown immediate
Startup mount
Alter database archivelog; (alter
Backup | data | database
Oracle9i begins Rman to provide the plus archivelog option, greatly simplifying the operation of the Rman backup.
When you define the plus Archivelog statement, Rman performs the following steps:
1. Run a
sysdba way into sqlplus environment, through startup pfile= ' $ORACLE _home/dbs/initorcl.ora ' way to start the database.5, create SPFile from pfile; Creates a binary parameter file. The cold standby migration is complete.different machine recovery: platform: rhel6.4~rhel6.5 version: Oracle 11g 11.2.0.1~oracle 11g 11.
Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble,
Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble,
modify the control file content. Assume that you have modified the database name in the parameter file, that is, the value of DB_NAME. But at Oracle startup, because DB_NAME In the parameter file is inconsistent with the database name in the control file, causing
RMAN to back up the database. Here I only backed up the data files that are prepared to create bad blocks for quick experiments.
[Oracle @ bys001 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Fri Sep 13 13:28:36 2013Copyright (c) 1982,200 9, Oracle an
;
(2) If there are multiple archived log directories, that is, multiple archived logs are saved during archiving, then:
Delete input after archiving logs are backed up, all archived logs under the first archive directory (for example, log_archive_dest_1) are deleted;
Delete all input: After archiving logs are backed up, all archivelog backups in log_archive_dest_n will be deleted.
3. When can I useAll delete input or all delete all inputWhat about it?
The method mentioned in "1" and "2" is to ba
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/
/rman_bak DB2 (Rw,no_root_squash)2. Node2 Configuration, Node 2 is mounted as an NFS client, and the two directories remain consistent.# manual Mount# mount-t NFS Db1:/data/rman_bak/data/rman_bak# Configure boot Auto mount# Cat/etc/fstabDb1:/data/rman_bak/data/rman_bak NFS Defaults 0 0Third, Oracle 11g RAC database parameter modification 1. To modify the save backup
[Translated from mos] How To restore database and mosrestore when backup of control files is lost
How can I restore the database when the backup of the control file is lost?
Source:How to rest
parameter value to set LARGE_POOL_SIZE so that the backup can use a continuous buffer pool. By setting DB_FIL_DIRECT_IO_COUNT, you can improve the utilization of the buffer zone. If you use tape backup, you can also set BACKUP_TYPE_IO_SLAVES to improve the write capability of the tape.4. Use parallel backup to open up multiple channels for parallel
Reprint please specify the address.Backup slice file name wildcard character:Number of copies of%c backup slices%d The day ordinal (DD) in the month%M in the month of the year (MM)%F a unique name based on dbid, which is in the form of C-IIIIIIIIII-YYYYMMDD-QQ,%d database name
1. Close the database completely. 2. Close the database and modify the server parameter file to use Oracle Managed Files (OMF ). 3. edit and execute the following RMAN Script: startup nomount; restore controlfile from '/u1/c1.ctl'; alter
have completely removed the table and then imported it. Attention: You need to have enough permissions, not enough permissions, and it will prompt you. Database, you can connect to the. You can use tnsping test to get the database test to connect Appendix I: Adding permissions to the import data to the user First, start sql*puls Second, landing with System/manager Third, create user username identified by
Oracle 11g backup-based rman duplicate, rmanduplicateBackup-based rman duplicate command to create standby databasePrerequisites: ensure the backup of the original database and archive is completely visible to the standby end,It i
Tags:idt nodes borderjdbc2.0 contains add1.5oracle database Format one: Use ServiceName mode:Jdbc:oracle:thin:@//Example Jdbc:oracle:thin:@//xxx.xxx.xxx.xxx:1526/cdevAfter @ there is//, which is the main difference from using SIDS. (11g does not add after @//OK)This format is the recommended format for Oracle.Because the SID for each node is different for the cluster, the service
_ % T ';
SQL 'alter system archive log current ';
Crosscheck archivelog all;
Backup filesperset 3 archivelog all tag 'arch 'format'/home/oracle/oarch _ % u _ % s _ % P' delete input;
Release channel c1;
Release channel c2;
Release channel c3;
}
Exit;
EOF
Note:
The last format of the log file name is bk _ year, month, hour, minute, second. log
Experimental purpose: Migrating an Oracle database from one machine to another (same as Linux platform), set to a different path, different instance nameSOURCE side:Oracle_base=/u01/app/oracleOracle_home=/u01/app/oracle/product/10.2.0/db_1Oracle_sid=testData File location:/o
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.