RMAN backups are performed using the BACKUP statement
To perforn a full database backup use:
To backup all archive logs use:
To backup the database and all archive log files use:
Note that the PLUS ARCHIVELOG clause performs the following:
- For example, 8.1.7, 9.0.1 or 10.2. The features affected by SQLPLUSCOMPATIBILITY are tabulated in the SQL.Plus Compatibility Matrix shown. You can also set the value of SQLPLUSCOMPATIBILITY using the -COMPATIBILITY argument of the SQLPLUS command when starting SQL.Plus from the command line.
- The PLUS+1® user forum is designed to help you find information and share your own experience. We hope this forum will become a valuable resource of knowledge and ideas for the PLUS+1 programming community. The PLUS+1 help desk team provides comments and answers to questions posted, complementing the phone and email support we already provided.
Command + J: Forward message. Command + 1: Access mail tab. Command + 2: Access calendar tab. Command + 3: Access files tab. Command + 4: Access people tab. Command + 5: Access settings tab.
IMPACT LX88+ MIDI KEYBOARD. The 88 note velocity sensitive keyboard is a semi-weighted action with medium tension. Carefully balanced with an even and dynamic response, the Impact LX88+ offers 4 velocity curves that gradually increase in dynamics so there is a match for any playing style. Ctrl + Shift + Tab. Move back through tabs. Ctrl + number (number 1–9) Move to nth tab. Move forward through options. Move back through options. Alt + underlined letter. Perform the command (or select the option) that is used with that letter. Select or clear the check box if the active option is a check box.
- Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command
- Runs the BACKUP ARCHIVELOG ALL command. If backup optimization is enabled only backs up logs that have not already been backed up.
- Backs up files specified in the BACKUP command
- Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command
- Backs up any remaining archived logs including those generated during thebackup
A FORMAT can be specified for each subclause in the BACKUP DATABASE PLUS ARCHIVELOG command. For example:
Note that FORMAT clause precedes the DATABASE clause, but follows the PLUSARCHIVELOG clause.
The BACKUP command can be extended to backup the current control file and the SPFILE.
For example:
Controlfile backups
The current controlfile can be automatically backed up by the BACKUP command by configuring the CONTROLFILE AUTOBACKUP parameters
To backup the current controlfile explicitly use:
SPFILE backups
The SPFILE can be automatically backed up with the control file during database backups by configuring the CONTROLFILE AUTOBACKUP parameters
To backup up the SPFILE explicitly use:
Datafile backups
To backup a specific data file use BACKUP DATAFILE. For example:
Altermatively specify the data file number. For example:
The data file number can be obtained from V$DATAFILE. For example:
Tablespace Backups
To backup a tablespace use the BACKUP TABLESPACE command. For example:
Compressed Backups
To compress the backup use:
The resulting compressed backup is around 20%-30% of the size of the uncompressed equivalent.
Format clause
The format clause allows the backup files to be directed to a specificlocation.
For example:
The above statement created the following files in /u01/app/oracle/backup:
Other formats can be specified. For example:
In the above example %t is the backup set timestamp, %s is the backup set number and %p is the piece number within the backup set.
Tags
A backup tag can optionally be specified with the BACKUP command.
For example:
The tag is reported by the LIST command.
If a tag is not specified then a system-generated tag is assigned.
Incremental Backups
By default backups are full (level 0). Backups can also be incremental (level 1).
Incremental backups can be:
- Differential - includes all changes since the last full or incrementalbackup
- Cumulative - includes all changes since the last full backup
Differential backups require less space. Cumulative backups are faster to restore
Differential backups are the default.
To run a diffential incremental backup use:
To run a cumulative incremental backup use:
Note that in order to take a level 1 backup, a level 0 backup must alreadyexist.
Command Tab Plus 1 88 +
A full backup using BACKUP DATABASE is not the same as a level 0 backup. - the LV column of the LIST BACKUP output is NULL after a full backup.
In order to take a level 0 backup use
To create an image copy of an entire database use:
To create an image copy of a specific datafile use:
Command Tab Plus 1 88 Resz
For example:
Alternatively specify the source file name. For example:
Recovery Area
To backup the recovery area use:
Command Tab Plus 1 88 Hp
Note that a destination must be specified if the recovery area is being backed up to disk.