Backing Up Individual Tablespaces with RMAN
You can backup one or more individual tablespaces with the BACKUP TABLESPACE
command. You can use this command when the database is mounted or open.
To back up a tablespace:
After starting RMAN, run the BACKUP TABLESPACE command at the RMAN prompt.
This example backs up the users and tools tablespaces to tape, using the
MAXSETSIZE parameter to specify that no backup set should be greater than 10 MB:
BACKUP DEVICE TYPE sbt MAXSETSIZE = 10M TABLESPACE users, tools;
Oracle translates the tablespace name internally into a list of datafiles.
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1005244/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backing Up Server Parameter Files with RMANServer
- Backing Up Control Files with RMAN
- Backing up the tailAI
- Backing Up Logs with BACKUP … PLUS ARCHIVELOGHive
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- ''Sbt Error = 7011, Errno = 959'' Error When Backing Up To TapeError
- How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]ROSPlatform
- Oracle 12C RMAN Duplicating Tablespaces Within a PDBOracle
- Oracle 12c RMAN Duplicating a Subset of the Source Database TablespacesOracleDatabase
- Details on individual partitionsAI
- Oracle Encrypted TablespacesOracle
- Overview of Tablespaces (38)View
- 個人專案 Individual ProjectProject
- Individual Project - Word_frequencyProject
- Individual Project - Word frequency programProject
- Oracle Transporting TablespacesOracle
- oracle bigfile tablespacesOracle
- Record for Individual Project ( Word frequency program )Project
- Using Multiple Tablespaces (46)
- Transport of Tablespaces Between Databases (59)Database
- 2.5 Overview of Tablespaces and Database Files in a CDBViewDatabase
- Temporary tablespaces in RAC ? Oracle databas...Oracle
- wake up
- Level Up
- Transporting Tablespaces with Self-ContainedAI
- Step 8: Create Additional Tablespaces (66)
- ORACLE撤銷表空間(Undo Tablespaces)Oracle
- DELETE from DBA_TABLESPACES IN 10Gdelete
- use multiple tablespaces to perform the following tasks (47)ORM
- Transportable Tablespaces (TTS) for Oracle Database [ID 1461278.2]TTSOracleDatabase
- Incremental checkpoint up to RBAREM
- Gross up by wage typeROS
- E. Level Up
- Speed Up Your WordPress Site
- UP還是敏捷方法?敏捷
- look up the sql_textSQL
- How to set up printers for GUI?GUI
- Set up the Android SDKAndroid