Backup3G/DA-Oracle/Commands
From Documentation
Revision as of 01:18, 12 April 2006 Moff (Talk | contribs) ← Previous diff |
Revision as of 02:35, 18 April 2006 Moff (Talk | contribs) (→Oracle Online) Next diff → |
||
Line 6: | Line 6: | ||
FSoracle <oracle_user> -h /tmp/oradata$$ -n oldest <SID> -f /tmp/oralog$$ | FSoracle <oracle_user> -h /tmp/oradata$$ -n oldest <SID> -f /tmp/oralog$$ | ||
- | <em>-h implies HOT backup | + | ''-h implies HOT backup''<br> |
- | -n oldest archive log</em> | + | ''-n oldest archive log'' |
<pre>svrmgrl { | <pre>svrmgrl { | ||
connect / as sysdba; | connect / as sysdba; | ||
Line 19: | Line 19: | ||
FSoracle <oracle_user> -b <tablespace> <SID> | FSoracle <oracle_user> -b <tablespace> <SID> | ||
- | <em>-b start backup mode</em> | + | ''-b start backup mode'' |
<pre>svrmgrl { | <pre>svrmgrl { | ||
connect / as sysdba; | connect / as sysdba; | ||
Line 29: | Line 29: | ||
FSoracle <oracle_user> -e <tablespace> <SID> | FSoracle <oracle_user> -e <tablespace> <SID> | ||
- | <em>-e end backup mode</em> | + | ''-e end backup mode'' |
<pre>svrmgrl { | <pre>svrmgrl { | ||
connect / as sysdba; | connect / as sysdba; | ||
Line 39: | Line 39: | ||
FSoracle <oracle_user> -w <oldest_log> -f /tmp/oralog$$ <SID> | FSoracle <oracle_user> -w <oldest_log> -f /tmp/oralog$$ <SID> | ||
- | <em>-w implies switch logs</em> | + | ''-w implies switch logs'' |
<pre>svrmgrl { | <pre>svrmgrl { | ||
connect / as sysdba; | connect / as sysdba; | ||
Line 49: | Line 49: | ||
FSoracle <oracle_user> -l “<oldest_log> <last_log>” -f /tmp/oralog$$ <SID> | FSoracle <oracle_user> -l “<oldest_log> <last_log>” -f /tmp/oralog$$ <SID> | ||
- | <em>-l implies list log files</em> | + | ''-l implies list log files'' |
<pre>svrmgrl { | <pre>svrmgrl { | ||
connect / as sysdba; | connect / as sysdba; | ||
Line 62: | Line 62: | ||
FSoracle <oracle_user> -t <control_file> <SID> | FSoracle <oracle_user> -t <control_file> <SID> | ||
- | <em>-t implies save control file</em> | + | ''-t implies save control file'' |
<pre>svrmgrl { | <pre>svrmgrl { | ||
connect / as sysdba; | connect / as sysdba; | ||
Line 70: | Line 70: | ||
FSoracle <oracle_user> -p <param_dir> <SID> | FSoracle <oracle_user> -p <param_dir> <SID> | ||
- | <em>-p implies misc Oracle files in <param_dir></em> | + | ''-p implies misc Oracle files in <param_dir>'' |
- | + | ||
- | + | ||
== Oracle Offline == | == Oracle Offline == |
Revision as of 02:35, 18 April 2006
Following are the SVRMGRL/SQLPLUS commands used by DA-Oracle. The FSoracle commands are the shell commands called from ORAonline, ORAofflne and ORAexport respectively. Code boxes are the svrmgrl/sqlplus (and exp) commands called from do_oracle according to FSoracle flags (eg -c, -x etc). Italics are comments.
Contents |
Oracle Online
FSoracle <oracle_user> -h /tmp/oradata$$ -n oldest <SID> -f /tmp/oralog$$
-h implies HOT backup
-n oldest archive log
svrmgrl { connect / as sysdba; select dba_data_files.file, dba_data_files.tablespace_name, ENABLED, dba_data_files.status, dba_data_files.file_id, dba_data_files.bytes/(1024*1024) from dba_data_files, v$datafile where dba_data_files.file_id = v$datafile.file#; select name from v$controlfile; archive log list; }
FSoracle <oracle_user> -b <tablespace> <SID>
-b start backup mode
svrmgrl { connect / as sysdba; alter tablespace <tablespace> begin backup; select d.file_id, d.tablespace_name, v.status, v.file# from dba_data_files d, v$backup v where (d.file_id = v.file#) and (d.tablespace_name = <tablespace>); }
FSoracle <oracle_user> -e <tablespace> <SID>
-e end backup mode
svrmgrl { connect / as sysdba; alter tablespace <tablespace> end backup; select d.file_id, d.tablespace_name, v.status, v.file# from dba_data_files d, v$backup v where (d.file_id = v.file#) and (d.tablespace_name = <tablespace>); }
FSoracle <oracle_user> -w <oldest_log> -f /tmp/oralog$$ <SID>
-w implies switch logs
svrmgrl { connect / as sysdba; archive log list; alter system archive log current; archive log list; }
FSoracle <oracle_user> -l “<oldest_log> <last_log>” -f /tmp/oralog$$ <SID>
-l implies list log files
svrmgrl { connect / as sysdba; select value from v$parameter where (Name = ‘log_archive_dest’) or (Name = ‘log_archive_dest_1’) or (Name = ‘log_archive_dest_2’) or (Name = ‘log_archive_dest_3’) or (Name = ‘log_archive_dest_4’) or (Name = ‘log_archive_dest_5’) or (Name = ‘log_archive_dest_6’) or (Name = ‘log_archive_dest_7’) or (Name = ‘log_archive_dest_8’) or (Name = ‘log_archive_dest_9’) or (Name = ‘log_archive_dest_10’); }
FSoracle <oracle_user> -t <control_file> <SID>
-t implies save control file
svrmgrl { connect / as sysdba; alter database backup control file to ‘<save_file>’; }
FSoracle <oracle_user> -p <param_dir> <SID>
-p implies misc Oracle files in <param_dir>
Oracle Offline
FSoracle <oracle_user> -c /tmp/oradata$$ <SID>
-c implies COLD backup
svrmgrl { connect / as sysdba; shutdown immediate; (if shutdown fails, shutdown abort;) startup exclusive; select tablespace_name from dba_data_files; select file_name from dba_data_files; select member from v$logfile; select name from v$controlfile; shutdown immediate; }
FSoracle <oracle_user> -p <param_dir> <SID>
-p implies misc Oracle files in <param_dir>
FSoracle <oracle_user> -s open <SID>
-s implies start mode = open
svrmgrl { connect / as sysdba; startup open; }
Oracle Export
FSoracle <oracle_user> -x "<export_user> direct full=y file=<device_nr>" <SID>
-x implies export as <export_user>
svrmgrl { connect / as sysdba; shutdown immediate; (if shutdown fails shutdown abort;) startup restrict open; } exp <export_user> direct full=y file=<device_nr>
FSoracle <oracle_user> -u <SID>
-u implies unrestrict user access to <SID>
svrmgrl { connect / as sysdba; alter system disable restricted session; }
Oracle Archive Logs
FSoracle <oracle_user> -v <SID>
-v implies switch archive logs
svrmgrl { connect / as sysdba; archive log list; alter system archive log current; archive log list; }
FSoracle <oracle_user> -d -f /tmp/oralog$$ <SID>
-d implies list log directories
svrmgrl { connect / as sysdba; select value from v$parameter where (Name = ‘log_archive_dest’) or (Name = ‘log_archive_dest_1’) or (Name = ‘log_archive_dest_2’) or (Name = ‘log_archive_dest_3’) or (Name = ‘log_archive_dest_4’) or (Name = ‘log_archive_dest_5’) or (Name = ‘log_archive_dest_6’) or (Name = ‘log_archive_dest_7’) or (Name = ‘log_archive_dest_8’) or (Name = ‘log_archive_dest_9’) or (Name = ‘log_archive_dest_10’); }