Want to know create standby database using rman backup? we have a huge selection of create standby database using rman backup information on alibabacloud.com
(1) Create an OS directory for storing backup database-Related Files
(2) create a routine service
(3) configure the listener and Network Service name
(4) Prepare the parameter file of the primary database
(5) Prepare backup
(1) Create an OS directory for storing backup database-Related Files
(2) create a routine service
(3) configure the listener and Network Service name
(4) Prepare the parameter file of the primary database
(5) Prepare backup
= (SID_LIST = (SID_DESC = (SID_NAME = TESTM) (ORACLE_HOME =/oracle/12.1) # static registration of the master databaseLISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 188.188.1.176) (PORT = 1521 ))(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))))
For more details, please continue to read the highlights on the next page:
Recommended reading:
Use the Duplicate function of RMAN to crea
Tags: redo content orm Pre base class make Device tabStep 1:create the Incremental Backuprman> BACKUP DEVICE TYPE DISK INCREMENTAL from SCN 750983 DATABASE
FORMAT '/tmp/incr_for_standby/bkup_%u ';Step 2:make the Incremental Backup Accessible at the Standby DatabaseFTP o
(1) Create an OS directory for storing backup database-Related Files
(2) create a routine service
(3) configure the listener and Network Service name
(4) Prepare the parameter file of the primary database
(5) Prepare backup
Using rman to create standby is quite simple and the master database does not need to be stopped. This experiment demonstrates the process of using Rman for Hot
Step 1:create the Incremental Backuprman> BACKUP DEVICE TYPE DISK INCREMENTAL from SCN 750983 DATABASE FORMAT '/tmp/incr_for_standby/bkup_%u ';Step 2:make the Incremental Backup Accessible at the Standby DatabaseFTP or SCP copy incremental
When using RMAN to copy a physical standby database, it is prone to errors and the error is very strange. I have summarized the issues below. 1. RMAN-04006ORA-12528, boot slave database to nomoun
When
When using RMAN to copy a physical standby database, it is prone to errors and the error is very strange.The author summarizes the following points.
1. RMAN-04006 ORA-12528
Start the slave database to nomount
SQL> startup nomount
1. General steps
The steps for creating a standby database through RMAN backup are roughly as follows:
1) set the primary database to force loggin Mode
2) set the primary database to archived log mode.
3) configure the parameter f
Note:I originally wanted to create a replica uard test for the no target database by using the backup set of the target database. I found that it could not be implemented in principle, but it has a very useful function, allows you to quickly recover data from different
Tags: type local max exp use _id ASE BSP outputThis is a time ago to the customer to do the Rman backup strategy, there is time to sort out today, I hope that some help, if there is no place to welcome everyone to give advice, thank you!Create a Recovery catalog database If the Rma
also provides a for standby clause that creates a backup control file to be used by an alternate database. You can use the backup command's
Controlfilecopy parameter to create a backup set containing externally created control f
RMANgt; backupdatabaseincludecurrentcontrolfileforstandbyplusarchivelog; note that the standby control is created when the database is backed up.
RMANgt; backup database include current controlfile for standby plus archivelog; // note that the
RMAN recovery catalogRMAN recovery directory
1. Create another database to restore the directory database.Dbca, netmgr not explained2. Connect to the database instance to create an independent tablespace.Create tablespace rmantbs datafile '/opt/ora10g/oradata/
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.