Backup3G/DA-Oracle/Command Reference
This page was last modified 08:10, 3 September 2007.From Documentation
< Backup3G(Difference between revisions)
| Revision as of 02:29, 18 April 2006 Moff (Talk | contribs) (→ORAarch) ← Previous diff |
Current revision Moff (Talk | contribs) (→ORArestre) |
||
| Line 1: | Line 1: | ||
| - | This section describes the [[DA-Oracle]] backup and restore methods. | ||
| - | |||
| - | |||
| == ORAofflne == | == ORAofflne == | ||
| Line 9: | Line 6: | ||
| '''SYNOPSIS''' | '''SYNOPSIS''' | ||
| - | :<tt>ORAofflne [ -v ] [ -n ] [ -p <params_pattern> ] [ -s <file_patterns> ] [ -D ] [ -U ] [ -u logname ] Host SID</tt> | + | :<code>ORAofflne [-v] [-n] [-p <params_pattern>] [-s <file_patterns>] [-D] [-U] [-u <logname>] <host> <sid></code> |
| Line 25: | Line 22: | ||
| :;-v:Verbose mode. List the files to be backed up in the backup log. | :;-v:Verbose mode. List the files to be backed up in the backup log. | ||
| :;-n:Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link. | :;-n:Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link. | ||
| - | :;-p params_pattern:Specifies the directory and file pattern for the Oracle configuration files of this SID which should be backed up along with Oracle backup. Note that the <tt>–p</tt> flag can only be specified once. If -p is not supplied, one of the directories <tt>$ORACLE_BASE/admin/$SID</tt>, <tt>$ORACLE_HOME/dbs</tt>, or <tt>$ORACLE_HOME/admin</tt> is backed up. | + | :;-p <params_pattern>:Specifies the directory and file pattern for the Oracle configuration files of this SID which should be backed up along with Oracle backup. Note that the <tt>–p</tt> flag can only be specified once. If -p is not supplied, one of the directories <tt>$ORACLE_BASE/admin/$SID</tt>, <tt>$ORACLE_HOME/dbs</tt>, or <tt>$ORACLE_HOME/admin</tt> is backed up. |
| - | :;-s file_patterns: Specifies additional files which should be backed up along with Oracle backup. Note that file-patterns can be a spaceseparated list of patterns, and that the –s flag can be specified multiple times. | + | :;-s <file_patterns>: Specifies additional files which should be backed up along with Oracle backup. Note that file-patterns can be a spaceseparated list of patterns, and that the –s flag can be specified multiple times. |
| :;-D :Do not restart the database after backup. | :;-D :Do not restart the database after backup. | ||
| :;-U :Restart the database after backup. | :;-U :Restart the database after backup. | ||
| - | :;-u logname:The Oracle user login name. If <tt>-u</tt> is not supplied, the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> or will default to oracle7. | + | :;-u <logname>:The Oracle user login name. If <tt>-u</tt> is not supplied, the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> or will default to oracle7. |
| - | :;Host:The host where the database resides. | + | :;<host>:The host where the database resides. |
| - | :;SID: The Oracle SID of the database to backup. | + | :;<sid>: The Oracle SID of the database to backup. |
| '''SEE ALSO''' | '''SEE ALSO''' | ||
| - | :FScpio(1), FSmimage(1) | + | :[[backup3G Man Pages#FScpio|FScpio(1)]], [[backup3G Man Pages#FSmimage|FSmimage(1)]] |
| '''COPYRIGHT''' | '''COPYRIGHT''' | ||
| - | :Copyright © 1990-2006 Functional Software. All rights reserved. | + | :Copyright © 1990-{{CURRENTYEAR}} Functional Software. All rights reserved. |
| <br> | <br> | ||
| Line 50: | Line 47: | ||
| '''SYNOPSIS''' | '''SYNOPSIS''' | ||
| - | :<tt>ORAonline [ -v ] [ -n ] [ -r | -R ] [ -p <params_pattern> ] [ -s <file_pattern> ] [ -t <tablespaces> | -x <tablespaces> ] [ -u logname ] Host SID</tt> | + | :<code>ORAonline [-v] [-n] [-r|-R] [-p <params_pattern>] [-s <file_pattern>] [-t <tablespaces>|-x <tablespaces>] [-u <logname>] <host> <sid></code> |
| Line 62: | Line 59: | ||
| :When all tablespaces are backed up, ORAonline sends a request to the database to perform a log switch and obtains the next SLN to archive, and all relevant archive logs are backed up. Then ORAonline sends a request to the Oracle server to back up the control files by running the ‘<tt>alter database backup controlfile …</tt>’ command, and they are then backed up. ORAonline will then attempt to save the parameter and configuration files from <tt>ORACLE_HOME/admin/$SID</tt>. If this directory does not exist the job will give a warning and return an error status 1 on completion. Finally any additional files (see the <tt>-s</tt> flag) are backed up. | :When all tablespaces are backed up, ORAonline sends a request to the database to perform a log switch and obtains the next SLN to archive, and all relevant archive logs are backed up. Then ORAonline sends a request to the Oracle server to back up the control files by running the ‘<tt>alter database backup controlfile …</tt>’ command, and they are then backed up. ORAonline will then attempt to save the parameter and configuration files from <tt>ORACLE_HOME/admin/$SID</tt>. If this directory does not exist the job will give a warning and return an error status 1 on completion. Finally any additional files (see the <tt>-s</tt> flag) are backed up. | ||
| - | :Each tablespace data file is backed up as multi-part image backup (FSmimage). Each archive log and control file is backed up as a single part cpio backup (FScpio). | + | :Each tablespace data file is backed up as multi-part image backup (FSmimage). Each archive log and control file is backed up as a single part cpio backup ([[backup3G Man Pages#FScpio|FScpio(1)]]). |
| Line 70: | Line 67: | ||
| :;-r: Backup read only tablespaces. This is the default. | :;-r: Backup read only tablespaces. This is the default. | ||
| :;-R: Do not backup, that is, skip read only tablespaces. | :;-R: Do not backup, that is, skip read only tablespaces. | ||
| - | :;-p params_pattern: Specifies the directory and file pattern for the Oracle configuration files of this SID which should be backed up along with Oracle backup. Note that the <tt>–p</tt> flag can only be specified once. If <tt>-p</tt> is not supplied, one of the directories <tt>$ORACLE_BASE/admin/$SID</tt>, <tt>$ORACLE_HOME/dbs</tt>, or <tt>$ORACLE_HOME/admin</tt> is backed up. | + | :;-p <params_pattern>: Specifies the directory and file pattern for the Oracle configuration files of this SID which should be backed up along with Oracle backup. Note that the <tt>–p</tt> flag can only be specified once. If <tt>-p</tt> is not supplied, one of the directories <tt>$ORACLE_BASE/admin/$SID</tt>, <tt>$ORACLE_HOME/dbs</tt>, or <tt>$ORACLE_HOME/admin</tt> is backed up. |
| - | :;-s file-pattern: Specifies additional files which should be backed up together with Oracle backup. | + | :;-s <file-pattern>: Specifies additional files which should be backed up together with Oracle backup. |
| - | :;-t <ts-list>: A space-separated list of tablespace names which are to be backed up. If the option is omitted all tablespaces are backed up. | + | :;-t <tablespace-list>: A space-separated list of tablespace names which are to be backed up. If the option is omitted all tablespaces are backed up. |
| - | :;-x <ts-list>: A space-separated list of tablespace names which should not be backed up. The <tt>-t</tt> and <tt>-x</tt> options must not be supplied together. | + | :;-x <tablespace-list>: A space-separated list of tablespace names which should not be backed up. The <tt>-t</tt> and <tt>-x</tt> options must not be supplied together. |
| - | :;-u logname: The Oracle user login name. If <tt>-u</tt> is not supplied, the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> or will default to oracle7. | + | :;-u <logname>: The Oracle user login name. If <tt>-u</tt> is not supplied, the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> or will default to oracle7. |
| - | :;Host: The Oracle host. | + | :;<host>: The Oracle host. |
| - | :;SID: The Oracle SID. | + | :;<sid>: The Oracle SID. |
| '''EXAMPLES''' | '''EXAMPLES''' | ||
| - | :<tt>ORAonline wombat ORCL</tt> | + | :<code>ORAonline wombat ORCL</code> |
| + | ::Performs an online backup of all tablespaces of the ORCL database on host wombat. | ||
| - | :Performs an online backup of all tablespaces of the ORCL database on host wombat. | + | :<code>ORAonline -t "SYSTEM TEMP" wombat ORCL</code> |
| + | ::Performs an online backup of tablespaces SYSTEM and TEMP. | ||
| - | :<tt>ORAonline -t "SYSTEM TEMP" wombat ORCL</tt> | + | :<code>ORAonline -x "SYSTEM TEMP" wombat ORCL</code> |
| - | + | ::Performs an online backup of all tablespaces except SYSTEM and TEMP. | |
| - | :Performs an online backup of tablespaces SYSTEM and TEMP. | + | |
| - | + | ||
| - | :<tt>ORAonline -x "SYSTEM TEMP" wombat ORCL</tt> | + | |
| - | + | ||
| - | :Performs an online backup of all tablespaces except SYSTEM and TEMP. | + | |
| '''FILES''' | '''FILES''' | ||
| - | :<tt>orafiles</tt> The temporary backup table with a list of data files and corresponding tablespaces, archive logs and control files. | + | :;<tt>orafiles</tt>:The temporary backup table with a list of data files and corresponding tablespaces, archive logs and control files. |
| '''SEE ALSO''' | '''SEE ALSO''' | ||
| - | :FScpio(1), FSmimage(1) | + | :[[backup3G Man Pages#FScpio|FScpio(1)]], [[backup3G Man Pages#FSmimage|FSmimage(1)]] |
| '''COPYRIGHT''' | '''COPYRIGHT''' | ||
| - | :Copyright © 1990-2006 Functional Software. All rights reserved. | + | :Copyright © 1990-{{CURRENTYEAR}} Functional Software. All rights reserved. |
| <br> | <br> | ||
| Line 112: | Line 106: | ||
| '''SYNOPSIS''' | '''SYNOPSIS''' | ||
| - | :<tt>ORAarch [ -v ] [ -n ] [ -k num_logs_to_keep] [ -u logname ] Host SID</tt> | + | :<code>ORAarch [-v] [-n] [-k <num_logs_to_keep>] [-u <logname>] <host> <sid></code> |
| Line 122: | Line 116: | ||
| :;-v: Verbose mode. List the files to be backed up in the backup log. | :;-v: Verbose mode. List the files to be backed up in the backup log. | ||
| :;-n: Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link. | :;-n: Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link. | ||
| - | :;-k num_logs_to_keep: Specifies the number of latest archive log files which should be left on disk. All others are removed. | + | :;-k <num_logs_to_keep>: Specifies the number of latest archive log files which should be left on disk. All others are removed. |
| - | :;-u logname: The Oracle user login name. If -u is not supplied the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> or will default to oracle7. | + | :;-u <logname>: The Oracle user login name. If -u is not supplied the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> or will default to oracle7. |
| - | :;Host: The Oracle host. | + | :;<host>: The Oracle host. |
| - | :;SID: The Oracle SID. | + | :;<sid>: The Oracle SID. |
| '''EXAMPLES''' | '''EXAMPLES''' | ||
| - | :<tt>ORAarch wombat ORCL</tt> | + | :<code>ORAarch wombat ORCL</code> |
| - | :The archive log files for the Oracle SID ORCL on host wombat are located in <tt>/usr/opt/oracle/arch</tt>: | + | ::The archive log files for the Oracle SID ORCL on host wombat are located in <tt>/usr/opt/oracle/arch</tt>: |
| ::<tt>arch_233.log</tt>, <tt>arch_234.log</tt>, …, <tt>arch_256.log</tt> | ::<tt>arch_233.log</tt>, <tt>arch_234.log</tt>, …, <tt>arch_256.log</tt> | ||
| - | :The next log sequence number to archive is 260. ORAarch will switch the archive logs, then back up all files from <tt>/usr/opt/oracle/arch</tt> | + | ::The next log sequence number to archive is 260. ORAarch will switch the archive logs, then back up all files from <tt>/usr/opt/oracle/arch</tt> |
| '''SEE ALSO''' | '''SEE ALSO''' | ||
| - | :FScpio(1) | + | :[[backup3G Man Pages#FScpio|FScpio(1)]] |
| '''COPYRIGHT''' | '''COPYRIGHT''' | ||
| - | :Copyright © 1990-2006 Functional Software. All rights reserved. | + | :Copyright © 1990-{{CURRENTYEAR}} Functional Software. All rights reserved. |
| <br> | <br> | ||
| Line 150: | Line 144: | ||
| '''SYNOPSIS''' | '''SYNOPSIS''' | ||
| - | :<tt>ORAexport -f|-i|-t tables|-o owner -l <username/password> [ -p <params_file> ] [ -P <export_params> ] [-u <ora_logname>] [-d <tmpdir>] Host SID</tt> | + | :<code>ORAexport -f|-i|-t <tables>|-o <owner> -l <username/password> [-p <params_file>] [-P <export_params>] [-u <ora_logname>] [-d <tmpdir>] <host> <sid></code> |
| Line 160: | Line 154: | ||
| :;-f: Perform a full (complete) Oracle export. | :;-f: Perform a full (complete) Oracle export. | ||
| :;-i: Perform an incremental Oracle export. Only tables modified since the last full export are saved. Note that Oracle calls this type of export cumulative. | :;-i: Perform an incremental Oracle export. Only tables modified since the last full export are saved. Note that Oracle calls this type of export cumulative. | ||
| - | :;-t tables: Perform an Oracle export of the space-separated list of tables. | + | :;-t <tables>: Perform an Oracle export of the space-separated list of tables. |
| - | :;-o owners: Perform Oracle export of tables which belong to the spaceseparated list of owners. | + | :;-o <owners>: Perform Oracle export of tables which belong to the spaceseparated list of owners. |
| :;-l <username/password>: Perform the export as the user username. | :;-l <username/password>: Perform the export as the user username. | ||
| - | :;-d tmpdir: Use the given temporary directory to store the exported data prior to being copied to the removable medium. Default is /tmp. | + | :;-d <tmpdir>: Use the given temporary directory to store the exported data prior to being copied to the removable medium. Default is /tmp. |
| - | :;-p params_file: Use the given file to specify all the export parameters. | + | :;-p <params_file>: Use the given file to specify all the export parameters. |
| - | :;-P export_params: Use the additional specified export parameters. The specified export parameters must be enclosed by a single set of double quotes. | + | :;-P <export_params>: Use the additional specified export parameters. The specified export parameters must be enclosed by a single set of double quotes. |
| - | :;-u logname: Use the specified Oracle login name. This is the UNIX login name for the Oracle user; it is NOT a user of the Oracle database. If -u is not supplied, the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> which is set in the Oracle backup profile. | + | :;-u <logname>: Use the specified Oracle login name. This is the UNIX login name for the Oracle user; it is NOT a user of the Oracle database. If -u is not supplied, the login name will be picked up from the environment variable <tt>ORA_LOGNAME</tt> which is set in the Oracle backup profile. |
| - | :;Host: The host where the database resides. | + | :;<host>: The host where the database resides. |
| - | :;SID: The Oracle SID of the database. | + | :;<sid>: The Oracle SID of the database. |
| '''EXAMPLES''' | '''EXAMPLES''' | ||
| - | :<tt>ORAexport -t ’finance dept’ -l scott/tiger wombat ORCL</tt> | + | :<code>ORAexport -t ’finance dept’ -l scott/tiger wombat ORCL</code> |
| - | :Create an Oracle export file of tables finance and dept of the Oracle database ORCL on host wombat. Perform the Oracle export as user scott (password tiger). | + | ::Create an Oracle export file of tables finance and dept of the Oracle database ORCL on host wombat. Perform the Oracle export as user scott (password tiger). |
| '''SEE ALSO''' | '''SEE ALSO''' | ||
| - | :FSmimage(1) | + | :[[backup3G Man Pages#FSmimage|FSmimage(1)]] |
| '''COPYRIGHT''' | '''COPYRIGHT''' | ||
| - | :Copyright © 1990-2006 Functional Software. All rights reserved. | + | :Copyright © 1990-{{CURRENTYEAR}} Functional Software. All rights reserved. |
| <br> | <br> | ||
| Line 191: | Line 185: | ||
| '''SYNOPSIS''' | '''SYNOPSIS''' | ||
| - | :<tt>ORArestre [Directory]</tt> | + | :<code>ORArestre [Directory]</code> |
| Line 207: | Line 201: | ||
| '''SEE ALSO''' | '''SEE ALSO''' | ||
| - | :FScpio(1), FSmimage(1) | + | :[[backup3G Man Pages#FScpio|FScpio(1)]], [[backup3G Man Pages#FSmimage|FSmimage(1)]] |
| '''COPYRIGHT''' | '''COPYRIGHT''' | ||
| - | :Copyright © 1990-2006 Functional Software. All rights reserved. | + | :Copyright © 1990-{{CURRENTYEAR}} Functional Software. All rights reserved. |
| - | + | ||
| - | <br> | + | |
Current revision
Contents |
[edit]
ORAofflne
NAME
- ORAofflne — Offline Oracle backup
SYNOPSIS
ORAofflne [-v] [-n] [-p <params_pattern>] [-s <file_patterns>] [-D] [-U] [-u <logname>] <host> <sid>
DESCRIPTION
- ORAofflne implements full backup of Oracle control files, redo logs and tablespaces with the database shut down. Control files and redo logs are backed up using cpio format. Each data file in a tablespace is backed up as a multi-part image.
- Before starting a backup ORAofflne shuts down the database if it is up, restarts it in restricted mode, determines the files to back up, and then shuts the database down. ORAofflne also backs up the contents of one of the directories $ORACLE_BASE/admin/$SID, $ORACLE_HOME/dbs, or $ORACLE_HOME/admin, which should contain parameter and configuration files.
- If none of these directories exist the backup will give a warning and return an error status 1 on completion.
- When all files are backed up ORAofflne sends a request to bring the database up, unless the -D flag is specified or the database was already down before the backup started.
OPTIONS
- -v
- Verbose mode. List the files to be backed up in the backup log.
- -n
- Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link.
- -p <params_pattern>
- Specifies the directory and file pattern for the Oracle configuration files of this SID which should be backed up along with Oracle backup. Note that the –p flag can only be specified once. If -p is not supplied, one of the directories $ORACLE_BASE/admin/$SID, $ORACLE_HOME/dbs, or $ORACLE_HOME/admin is backed up.
- -s <file_patterns>
- Specifies additional files which should be backed up along with Oracle backup. Note that file-patterns can be a spaceseparated list of patterns, and that the –s flag can be specified multiple times.
- -D
- Do not restart the database after backup.
- -U
- Restart the database after backup.
- -u <logname>
- The Oracle user login name. If -u is not supplied, the login name will be picked up from the environment variable ORA_LOGNAME or will default to oracle7.
- <host>
- The host where the database resides.
- <sid>
- The Oracle SID of the database to backup.
SEE ALSO
COPYRIGHT
- Copyright © 1990-2024 Functional Software. All rights reserved.
[edit]
ORAonline
NAME
- ORAonline — Online Oracle backup
SYNOPSIS
ORAonline [-v] [-n] [-r|-R] [-p <params_pattern>] [-s <file_pattern>] [-t <tablespaces>|-x <tablespaces>] [-u <logname>] <host> <sid>
DESCRIPTION
- ORAonline implements full or partial backup of Oracle tablespaces while the database is running.
- Initially ORAonline sends a request to Oracle to check whether the database is running and whether it is in ARCHIVELOG mode. If one of these conditions is not true Oracle online backup does not run.
- ORAonline first obtains the oldest archived sequence log number (SLN). Then it obtains the list of tablespaces in the database and the files which are to be backed up, and backs up one tablespace at a time by putting the tablespace in backup mode, backing up all files of this tablespace and releasing the tablespace back to normal mode.
- When all tablespaces are backed up, ORAonline sends a request to the database to perform a log switch and obtains the next SLN to archive, and all relevant archive logs are backed up. Then ORAonline sends a request to the Oracle server to back up the control files by running the ‘alter database backup controlfile …’ command, and they are then backed up. ORAonline will then attempt to save the parameter and configuration files from ORACLE_HOME/admin/$SID. If this directory does not exist the job will give a warning and return an error status 1 on completion. Finally any additional files (see the -s flag) are backed up.
- Each tablespace data file is backed up as multi-part image backup (FSmimage). Each archive log and control file is backed up as a single part cpio backup (FScpio(1)).
OPTIONS
- -v
- Verbose mode. List the tablespaces, their current status and the files to be backed up in the backup log.
- -n
- Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link.
- -r
- Backup read only tablespaces. This is the default.
- -R
- Do not backup, that is, skip read only tablespaces.
- -p <params_pattern>
- Specifies the directory and file pattern for the Oracle configuration files of this SID which should be backed up along with Oracle backup. Note that the –p flag can only be specified once. If -p is not supplied, one of the directories $ORACLE_BASE/admin/$SID, $ORACLE_HOME/dbs, or $ORACLE_HOME/admin is backed up.
- -s <file-pattern>
- Specifies additional files which should be backed up together with Oracle backup.
- -t <tablespace-list>
- A space-separated list of tablespace names which are to be backed up. If the option is omitted all tablespaces are backed up.
- -x <tablespace-list>
- A space-separated list of tablespace names which should not be backed up. The -t and -x options must not be supplied together.
- -u <logname>
- The Oracle user login name. If -u is not supplied, the login name will be picked up from the environment variable ORA_LOGNAME or will default to oracle7.
- <host>
- The Oracle host.
- <sid>
- The Oracle SID.
EXAMPLES
ORAonline wombat ORCL- Performs an online backup of all tablespaces of the ORCL database on host wombat.
ORAonline -t "SYSTEM TEMP" wombat ORCL- Performs an online backup of tablespaces SYSTEM and TEMP.
ORAonline -x "SYSTEM TEMP" wombat ORCL- Performs an online backup of all tablespaces except SYSTEM and TEMP.
FILES
- orafiles
- The temporary backup table with a list of data files and corresponding tablespaces, archive logs and control files.
SEE ALSO
COPYRIGHT
- Copyright © 1990-2024 Functional Software. All rights reserved.
[edit]
ORAarch
NAME
- ORAarch — Backup Oracle archive logs
SYNOPSIS
ORAarch [-v] [-n] [-k <num_logs_to_keep>] [-u <logname>] <host> <sid>
DESCRIPTION
- ORAarch implements a full backup of Oracle archived log files. ORAarch backs up all logs in the Oracle archive destination directory using multi-part cpio.
OPTIONS
- -v
- Verbose mode. List the files to be backed up in the backup log.
- -n
- Do not follow symbolic links. The default is to follow symbolic links and backup the target file rather than the symbolic link.
- -k <num_logs_to_keep>
- Specifies the number of latest archive log files which should be left on disk. All others are removed.
- -u <logname>
- The Oracle user login name. If -u is not supplied the login name will be picked up from the environment variable ORA_LOGNAME or will default to oracle7.
- <host>
- The Oracle host.
- <sid>
- The Oracle SID.
EXAMPLES
ORAarch wombat ORCL- The archive log files for the Oracle SID ORCL on host wombat are located in /usr/opt/oracle/arch:
- arch_233.log, arch_234.log, …, arch_256.log
- The next log sequence number to archive is 260. ORAarch will switch the archive logs, then back up all files from /usr/opt/oracle/arch
SEE ALSO
COPYRIGHT
- Copyright © 1990-2024 Functional Software. All rights reserved.
[edit]
ORAexport
NAME
- ORAexport — Create oracle export file and back it up
SYNOPSIS
ORAexport -f|-i|-t <tables>|-o <owner> -l <username/password> [-p <params_file>] [-P <export_params>] [-u <ora_logname>] [-d <tmpdir>] <host> <sid>
DESCRIPTION
- ORAexport performs an Oracle export of tables in a database. You may perform a full or incremental database export, or an export of select tables or of the tables owned by specified users. All exports are first performed to a temporary file, and then this file is backed up to a removable media using the multi-part image backup method.
OPTIONS
- -f
- Perform a full (complete) Oracle export.
- -i
- Perform an incremental Oracle export. Only tables modified since the last full export are saved. Note that Oracle calls this type of export cumulative.
- -t <tables>
- Perform an Oracle export of the space-separated list of tables.
- -o <owners>
- Perform Oracle export of tables which belong to the spaceseparated list of owners.
- -l <username/password>
- Perform the export as the user username.
- -d <tmpdir>
- Use the given temporary directory to store the exported data prior to being copied to the removable medium. Default is /tmp.
- -p <params_file>
- Use the given file to specify all the export parameters.
- -P <export_params>
- Use the additional specified export parameters. The specified export parameters must be enclosed by a single set of double quotes.
- -u <logname>
- Use the specified Oracle login name. This is the UNIX login name for the Oracle user; it is NOT a user of the Oracle database. If -u is not supplied, the login name will be picked up from the environment variable ORA_LOGNAME which is set in the Oracle backup profile.
- <host>
- The host where the database resides.
- <sid>
- The Oracle SID of the database.
EXAMPLES
ORAexport -t ’finance dept’ -l scott/tiger wombat ORCL- Create an Oracle export file of tables finance and dept of the Oracle database ORCL on host wombat. Perform the Oracle export as user scott (password tiger).
SEE ALSO
COPYRIGHT
- Copyright © 1990-2024 Functional Software. All rights reserved.
[edit]
ORArestre
NAME
- ORArestre — Restore from Oracle backup
SYNOPSIS
ORArestre [Directory]
DESCRIPTION
- ORArestre restores files which have been backed up by ORAofflne or ORAonline to their original places or to a new directory. The list of files to restore is passed from runrec as an environment variable ORALIST. If ORALIST is null, all files in the chosen media set will be restored.
- Directory specifies where the files should be restored. If directory is null, the original database is restored.
WARNINGS
- If two or more data files of the same or different tablespaces have different paths but the same names, their contents could be lost if they are restored to the same directory. In this case, un-check Collapse dirs?
- Note that ORArestre performs only UNIX file restore and does not check the database status.
SEE ALSO
COPYRIGHT
- Copyright © 1990-2024 Functional Software. All rights reserved.