, Oracle applies the archived redo log (and any incremental backups that need to be applied) to the defined recovery target (not including the recovery target itself).
Note: If you attempt to recover to the completion point of a specific backup, you must revert to the CKP SCN or CKP time of the file in the backup set, which is listed in the Rman List command for the different backup sets. Sometimes it is n
Tags: database backup Oracle Solutionneed more information to contact Q2748165793Course OutlineFirst Lecture: Introduction to Backup and recovery-related operationsGoals for backup and recoveryBackup and Recovery SolutionsOracle Flashback TechnologySecond: Starting the Rman operation and the Rman architectureEnvironment of RmanRMAN ChannelsRMAN RepositoryRman Bac
Tags: Oracle training Oracle Tutorial Oracle video Oracle Video tutorial Oracle Database tutorialOracle Video Tutorial Goals Oracle Video tutorial, wind Brother this set of Oracle Tuto
Oracle RMAN restores the database to different hosts
I. RMAN backup content
When RMAN is used for full backup, it contains data files, archive logs, control files, parameter files, and backup logs, as shown below:
Arch_20160223_08qukp2t_1_1 arch_20160223_0bqukp92_1_1 ctl_c-3234695588-20160223-01 rmanbak-20160223-0852.l
backed up by file Controlfile.In addition, because Nocatalog uses Controlfile to store backup information, it is recommended to increase the Control_file_record_keep_time value in the ORACLE parameter file (by default, 7 days), which is $oracle_home/dbs /initsid.ora (9i may also be in SPFile, can only be changed by Oracle statements).The recovery catalog (that is, catalog mode) supports the following
backup is performed in other days, which improves the backup performance.Provides the Script Function for merging multiple tasks.
One of the ways for RMAN to improve your backup, restore, and recovery operations is to allow RMAN to be scripted. This script may consume multiple RMAN commands stored in the recovery dire
RMAN is a required management tool for Oracle Database Backup management. There are many ways to operate it. I sorted out some common operation commands and summarized them to facilitate work.
1. database backup operation commands
Simplified Version
Backup database plus archivelog format '/backup/
Oracle-RMAN full recovery 1. concepts related to RMAN full recovery 1. mainly two commands are used in RMAN full recovery, one is restore and the other is recover. 2. Data can be restored at three levels: database, tablespace, and data file. 3. In
only one day a week, and an incremental backup for the other days, which improves the performance of the backup.Provides scripting features for multiple tasks merge execution
One way that Rman improves your backup, restore, and restore operations is to allow the Rman command to be scripted. The script may eat multiple RMAN c
How to encrypt rman backup sets in oracle
Let's take a look at an oracle rman backup set encryption method. I hope this example will help you.
Data security is becoming more and more important. It doesn't mean that your production database is secure and your data is secure. rman
Using Oracle's own backup recovery tool, Rman (Recovery Manager) has several advantages:
Support for incremental backups
Ability to automatically manage backup files
Automated backup and Recovery
File validity Check for backups
Configuring the Flash Recovery Zone (recovery area)The Flash recovery area is the store where backup and recovery data files and related information are stored. You need to set two parameters: Db_recov
Oracle RMAN backup and restoration, and mongolerman backup
RMANYou can perform Incremental Backup: databases, tablespaces, and data files.
Only usedBlockCan be backed upBackup set
Ing between tablespaces and data files:Dba_data_files/v $ datafile_header
InNoarchivelogMode, you can useRMANBackupRead-onlyAndOfflineTablespace
ORACLE RMANDowntime backup:
Backup
Oracle uses RMAN to directly Restore the database from 10 Gb to 11 GB.
Oracle uses RMAN to directly Restore the database from 10g to 11g.
With the upgrade of the Oracle version, RMAN is also enhanced.
Data security is more and more important, not to say that your production database security, your data must be safe, Rman backup is also an important place to leak data, if someone else got your backup set, same as the intrusion of your production library. For Rman backups to be secure, the easiest way to do this is to set the password in the Rman backup process
1. The concept of the channel
A channel represents a stream of data to a device (disk or tape) and produces a corresponding server session on the target database or a secondary database instance (server sessions)
Multiple channels generate multiple server sessions, which will complete backup, restore, and recovery operations, and so on
Channels are divided into disk channels for backup or restore to disk (disk channel), Backup to tape channel (SBT)
Channels must be allocated before backups a
Label:2015-10-24DirectoryResources[1] Lin Shuze. Oracle 11g R2 dba operation Guide [M]. Beijing: Tsinghua University Press, 2013[2] Introduction to Oracle Backup and recovery (physical and logical backups)[3] Oracle Backup and recovery case[4] ORACLE Backup and recovery[5] Backup method for
Single command
Run the command only at the RMAN prompt.
Executed separately
Cannot be used as a run sub-command
Such as backup database
The following commands cannot be used as Batch Commands
Connect
Configure
Create catalog, drop catalog, upgrade catalog
Create script, delete script, replace script
List
Report
Batch command
The Run Com
Single command
Only executed at the Rman prompt
Be executed alone
Cannot be run as a child command
such as backup database
The following commands cannot be used as batch commands to use the
CONNECT
CONFIGURE
CREATE CATALOG, DROP CATALOG, UPGRADE CATALOG
CREATE script, DELETE script, REPLACE script
LIST
The
Batch Command
Used in parentheses around the Run command
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.