Oracle rman Introduction

Oracle rman local connection: $ rman target/or $ rman target/nocatalog remote connection: $ rman target sys/sys @ skyRMAN command execution method: 1. single command execution 2. run {} 3. script Execution rman target/@ XXXX. rmanrman target/destination file = XXXX. rmanrman target/LOG/HOME/ORACLE/RMAN. log append @ XXXX. RMAN can use @ XXXX in RMAN. RMANRMAN command type: independent command: change connect create catrman, RESYNC catrman create script, delete script, replace script note: the independent command can no longer RUN the job command: RUN in the RUN, independent Command Execution Command sets or job command job commands are usually divided into several groups, which are executed sequentially by RMAN In the RUN Command block. If any command in the block fails, RMAN stops processing, and does not continue to execute other commands in the block. Some commands can be issued independently at the prompt or in the RUN command. RMAN configuration Introduction: RMAN> show all; RMAN configuration parameters are: configure retention policy to redundancy 1; # default -- configure backup optimization off; # default -- whether TO enable backup optimization configure default device type to disk; # default -- channel configuration supports two SBT and DISK types, and SBT is the tape configure controlfile autobackup off; # default -- whether to automatically back up the control file CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE D Isk to '% F'; # default -- specify the automatic BACKUP control file format and path configure device type disk parallelism 1 backup type to backupset; # default -- set parallel backup configure datafile backup copies for device type disk to 1; # default -- default BACKUP copy quantity FOR data file backup configure archivelog backup copies for device type disk to 1; # default -- default backup copy quantity FOR archive backup configure maxsetsize to unlimited; # default -- maximum configure encryption for database off by default ;# Default -- backup encryption configure encryption algorithm 'aes128 '; # default -- encryption algorithm configure archivelog deletion policy to none; # default -- archive file deletion policy, NONE disable the archive deletion policy configure snapshot controlfile name to '/app/oracle/product/10.2.0/db_1/dbs/snapcf_skyread.f'; # default is the default configuration, the above describes several common configurations. The following describes several common commands: The show: SHOW command is used to view the permanent configuration settings specified by the CONFIGURE command. These settings will be used for any RMAN session. It is an independent command. You can use the SHOW command to display the following information: ⊙ automatic CHANNEL configuration to set show channel; show device type; show default device type ⊙ rman retention policy configuration settings show retention policy; ⊙ Number of backup copies show datafile backup copies; ⊙ maximum backup set size show maxsetsize; ⊙ show exclude, which is not included in the entire database BACKUP policy; ⊙ show backup optimization; this command is very simple and displays different configurations directly with different configuration parameters. List: list backup; # list all backups of the Database LIST backup OF datafile 'xxxxxx'; # list all backups of data files list backup of controlfile; # list backup information OF control files list backup of archivelog all; # list all backup archives list copy of tablespace 'system '; # LIST copy Copies of data files in the system tablespace list device type disk backup; # list all backup information on the disk device list archivelog all; # list all the currently archived list expired backups of the database; # list invalid BACKUP reports: report SCHEMA; # database structure report need backup ..; # Those files need to be backed up report obsolete; # Those backups can be deleted RE Port need backup command is used to identify all data files to be backed up. This report assumes that the latest BACKUP is used during restoration. This command has three options: ⊙ increment (Incremental ): is an integer that specifies the maximum number of incremental backups that should be restored during the restoration process. If you need this number or more incremental backups, You need to perform a new full backup on the data file. For example, to REPORT files that require three or more incremental backups for recovery: RMAN> report need backup incremental 3 database; ⊙ Days ): is an integer that specifies the maximum number of days from the last full or Incremental backup operation of the file. If the number of days from the last backup to the current is equal to or greater than this number, the file needs to be backed up. For example, reporting system files not backed up for three days: RMAN> report need backup days 3 tablespace system; ⊙ Redundancy (Redundancy): an integer that specifies the required minimum Redundancy level. For example, if there are no two or more backups, redundancy Level 2 requires a backup CROSSCHECK. The CROSSCHECK command is used to check the status of the backup or archive physical files. If the physical file exists, if a matching record exists in the control file (or recovery directory), the status of the object is marked as AVAILABLE (valid). If the object does not exist, the status of the object is marked as EXPIRED (invalid) crosscheck archivelog all; # Check ALL archive files crosscheck backup; # Check all backup sets CHANGE: the CHANGE command can be used to modify the status of BACKUP files or archive files, not physical files, but the status of the corresponding records of these files in the control file (or recovery directory). There are two statuses: AVAILABLE (AVAILABLE) and UNAVAILABLE (UNAVAILABLE) change backupset n UNAVAILABLE; # modify the status OF the specified BACKUP machine change backup of tablespace users unavailable; # change archivelog logseq = n UNAVAILABLE when the status OF the specified tablespace backup set is UNAVAILABLE; # changing the status of a specified archive file change archivelog logseq = n DELETE; # deleting an archive