rman backup and recovery

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 rman backups. Previously, you had to perform many steps to back up recovery from different mach

[Terry Note] backup http://www.cnblogs.com/kkterry/p/3308405.html for RMAN Integrated Learning [Terry Notes] recovery http://www.cnblogs.com/kkterry/p/3308407.html for RMAN Integrated Learning [Terry Note] configuration http://www.cnblogs.com/kkterry/p/3308409.html for RMAN

Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night. It corresponds to full-Database Backup: Http://blog.csdn.net/jacson_bai/article/details/39636915 1. env:IP Address: 10.244.171.180/181Oracle Database Oracle 11.2.0.3OS RHEL 5.5Backup toos: rman, Shell, crontab 2.

I. Basic Theoretical knowledge of rman backup Rman (recovery manager) is used to manage backup, dumping, and recovery operations. When the rman command is executed, Oracle parses these

= tag20180205t100514Channel Ora_disk_1: restored backup Fragment 1Channel Ora_disk_1: Restore Complete, spents: 00:01:05In May-February-18 completed the Restore rman> Recover database; Starting from recover, located in May-February-18Using channel Ora_disk_1 Starting recovery of mediaMedia recovery complete, spents: 0

archivelog from logseq = 20 until logseq = 30 thread = 1;You must use the run code block to restore archived redo logs in a directory other than the default location.Run{Set archivelog destination to "d: \ Oracle \ newarch ";Restore archivelog all;}Note that if RMAN deems that an archived redo log already exists, it will not be restored on the disk, even if it is set to restore to another location.3. Restoration of data file copiesYou can restore dat

1. Backup; 1: connect to the target database: RMAN> connect target sys/sysray @ dB or RMAN target = sys/sysray @ DB 2: query the configuration of the target database; RMAN> show all; Modify the configuration as follows: Configure retention policy to redundancy 1; # defaultConfigure

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 Set is very important during backup, otherwis

the restored State and consistent with other data files in the database. -------------------------------------- Split line -------------------------------------- Data backup and Database Replication in Oracle user management mode RMAN: Configure an archive log deletion policy Basic Oracle tutorial-copying a database through RMAN Reference for

target sys/[emailprotected] ; connected to the target database: ORCL (dbid= 1392118573 , not open) rman> restore datafile 4 ; start Restore in 2 January-December -14 Use the target database control file instead of the channel that restores the directory allocation: ora_disk_ 1-channel ora_disk_1:sid=10 device type =disk Channel ora_disk_1: Starting restore data file backup set Channel Ora_disk_1: Specify

/ygdg/pfile/directory and init.ora.25201817331Copy to DBS directory:CP Init.ora.25201817331/u01/app/oracle/product/11.2.0/db_1/dbs/initygdg.orasql> startup Nomount;The ORACLE routine has been started.Total System Global area 830930944 bytesFixed Size 2257800 bytesVariable Size 536874104 bytesDatabase buffers 285212672 bytesRedo buffers 6586368 bytesSql> exitFrom Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the partitioning, OLAP, Data Mining and Real application

Restore database backup in a new environment. An error occurs during data file restoration. Environment Description: Oracle 10.2.0.3 for solaris 10, the backup database is RAC, and the recovery is performed on a single instance. The operation process is as follows: The first step is to restore the database to a certain point in time and restore errors.

Five Backup command Options 5.1 Compression By default, RMAN performs the compression of NULL data blocks. 5.1.1 NULL Control Compression When using this form of compression, Oracle does not back up unused blocks of data. There are two scenarios where null block compression is performed: (1) Data blocks that have never been used are not compressed (2) A block of data that has been used once is not bac

steps: For basic RMAN operations, refer to the http://blog.csdn.net/kkdelta/article/details/7202958 1. grade 0 backup on Sunday RMAN> run {2> allocate channel C1 type disk;3> Backup incremental level 0 database format 'd: \ oracle \ rmanrep \ butdblv0 % u. dmp ';4>} 2. Data changes in the database from Sunday to Monda

1 Backup parameter file $oracle_home$/dbs2 copy files and backup requirements according to the path of Ramn backup 3 delete the old library exactly as the original server path [emailprotected]> shutdownimmediate; [emailprotected]>startupmountrestrict; [emailprotected]>dropdatabase;4 Restore parameter file cp/backup/oth

Description It was meant to be no. The target library creates Dataguard tests from the target library backup set, and discovery is not possible in principle, but it has a very useful feature that enables fast Rman backup and machine recovery. Prior to the Rman

Reprinted please indicate the source http://blog.csdn.net/guoyjoe/article/details/30965303 The experiment steps are as follows: 1. Use rman to back up the entire database Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jun 8 15:30:35 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: PROD (DBID=254815294)

This article focuses on backing up and recovering data files. For more information about rman, see my other article: First, let's look at the data files: SQL> selectfile_name, file_id, tablespace_name from dba_data_files; FILE_NAME FILE_ID TABLESPACE_NAME ---------------------------------------------------------------------------------------------------- E: \ Oracle \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ USERS01.DBF 4 USERS E: \ ORACLE \ PRODUCT \ 10.

/backup_rmanChmod 755/backup_rman Step 2: Write the backup script program1. Create a backup scriptSwitch to the oracle user, create the bin directory under the oracle Home directory, and create the file rman_backup.shMkdir binCd binTouch rman_backup.shChmod 755 rman_backup.shEdit the rman_backup.sh file and add the following content:#! /Bin/bashSource/home/oracle/. bash_profile/U01/app/oracle/product/10.2.0