Oracle Backup Common Commands

　　

Oracle is also one of the most commonly used databases, is it sometimes tricky to back up? Save the following information, I believe it will help you.

I. Common BACKUP commands

1.list backup; Lists all the back up information in the database.

2.list backup of controlfile; Lists all backup control files.

The ID number of the corresponding data file for the 3.list backup of datafile ' or list backup of datafile. Data file full path. dbf '; Lists the data files for the specified backup.

4.list backup of Archivelog all; Lists all backed up archive files.

5.list copy of tablespace ' table space name '; Lists the backup information for the specified table space.

6.list expired backup; lists invalid backups.

7.delete obsolete; Delete outdated backups.

8.delete expired backup; Delete invalid backups.

9.delete expired copy; Delete expired copy.

10.delete backupset backup set number; Deletes the specified backup set.

11.delete backup; Delete all backup sets.

12.delete copy; Delete all copies of the image.

13.report need backup; View the required file

14.report need backup tablespace table space name; see if a backup is required for the specified tablespace.

15.crosscheck Archivelog All; Check that the archive file is valid

16.crosscheck backup; Check all backup sets.

Related to Rman

List backup of database (see full Library backup of databases, all details included)

List Backup of tablespace users (view a backup of the users table space)

List backup of datafile 5; (5 is the file ID of the tablespace)

List backup of Controlfile (see Backup of control text information)

List backup of datafile ' +datadg/cboms/datafile/users.264.735423243 ';(view backups based on specific location of data files

List expired backup; (invalid backup)

List expired archivelog all; (View invalid archive log logs)

List Backup of database summary (this is an overview, an intuitive, comprehensive understanding of the database)

List Backup of database summary

List Backup of Archivelog all summary

List Backup of Tablespace users summary

List Backup of DataFile 5 summary

Crosscheck archivelog All; Verify the DB archive log is missing

Crosscheck backup; Verify that the database back-up set is missing

Delete expired archivelog all; command to delete all expired archive logs

Rman> crosscheck Backup;

Using channel Ora_disk_1

crosschecked backup Piece:found to be ' AVAILABLE '

Backup Piece HANDLE=/U01/FLASH_RECOVERY_AREA/DBTEST/BACKUPSET/2012_04_21/O1_MF_NNNDF_TAG20120421T153359_7S4RQ7V6 _.BKP recid=22 stamp=781198439

crosschecked backup Piece:found to be ' AVAILABLE '

Backup Piece handle=/u01/flash_recovery_area/dbtest/backupset/2012_04_21/o1_mf_ncnnf_tag20120421t153359_7s4rsm9k _.BKP recid=23 stamp=781198515

Crosschecked 2 Objects

Rman>

17. Modify the backup status with change, such as modify table space

Rman> backup tablespace users format '/BACKUP/RMANBACKUP/USERSCP ';

Starting backup at 21-apr-12

Using channel Ora_disk_1

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

Input datafile fno=00004 name=/u01/oradata/dbtest/users01.dbf

Channel ora_disk_1:starting piece 1 at 21-apr-12

Channel ora_disk_1:finished piece 1 at 21-apr-12

Piece HANDLE=/BACKUP/RMANBACKUP/USERSCP tag=tag20120421t155115 comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:00:01

Finished backup at 21-apr-12

Rman> list Backup of tablespace users;

List of Backup Sets

===================

BS Key type LV Size Device Type Elapsed Time Completion time

------- ---- -- ---------- ----------- ------------ ---------------

2.02M DISK 00:00:00 21-apr-12

BP key:28 status:available Compressed:no tag:tag20120421t155115

Piece Name:/BACKUP/RMANBACKUP/USERSCP

List of Datafiles in backup set 24

File LV Type Ckp SCN Ckp time Name

---- -- ---- ---------- --------- ----

4 Full 1388204 21-APR-12/U01/ORADATA/DBTEST/USERS01.DBF

Rman> change backup of tablespace users unavailable;

Changed backup piece unavailable

Backup piece HANDLE=/BACKUP/RMANBACKUP/USERSCP recid=28 stamp=781199475

Changed 1 objects to unavailable status

Rman> list Backup of tablespace users;

List of Backup Sets

===================

BS Key type LV Size Device Type Elapsed Time Completion time

------- ---- -- ---------- ----------- ------------ ---------------

2.02M DISK 00:00:00 21-apr-12

BP key:28 status:unavailable Compressed:no tag:tag20120421t155115

Piece Name:/BACKUP/RMANBACKUP/USERSCP

List of Datafiles in backup set 24

File LV Type Ckp SCN Ckp time Name

---- -- ---- ---------- --------- ----

4 Full 1388204 21-APR-12/U01/ORADATA/DBTEST/USERS01.DBF

Rman>

If you do not specify a tablespace location to change the state, it will not succeed. Such as:

rman> change backupset unavailable;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============

RMAN-00571: ===========================================================

Rman-03009:failure of unavailable command on Ora_disk_1 channel at 04/21/2012 15:46:29

Ora-19813:cannot have unavailable file/u01/flash_recovery_area/dbtest/backupset/2012_04_21/o1_mf_annnn_ TAG20120421T154318_7S4S8PX3_.BKP in Db_recovery_file_dest

Two. Use data backup software--multi-backup.

Download multi-backup clients can start easy backup, can't remember the backup command let the multi-backup to help you finish it!

1. Unzip the download and then double-click the multi-backup icon to let it run.

Then a page pops up ↓

　　

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6D/A5/wKiom1VoIuqwjTa3AAGO6xCESxk119.jpg "title=" Picture 10.png "alt=" Wkiom1voiuqwjta3aago6xcesxk119.jpg "/>

2. Then click Oracle

　　

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6D/A5/wKiom1VoIv-y-2WnAACqWqPK10k517.jpg "title=" Picture 121.png "alt=" Wkiom1voiv-y-2wnaacqwqpk10k517.jpg "/>

　　

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6D/A1/wKioL1VoJKTxN324AADJdym_PaE952.jpg "title=" Picture 123.png "alt=" Wkiol1vojktxn324aadjdym_pae952.jpg "/>

3. After selecting the temporary file directory backup, you can click "Save" to start the backup.

　　

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6D/A5/wKiom1VoIyXhpyVfAACDSqYEfjs862.jpg "title=" Picture 124.png "alt=" Wkiom1voiyxhpyvfaacdsqyefjs862.jpg "/>

4. The backup succeeds without a moment.

So, sometimes choosing the right backup software is more than a multiplier. Multiple backups support not only database backup, but also file class backup. At the same time, support for local data backup, cloud Backup and hybrid backup, basically meet the needs of the vast numbers of users. Whether you are an individual or a business, you can use a multi-backup client.

Heart than action, speed to backup it!

Oracle Backup common commands