FS
Documentation

Backup3G/DA-Oracle/Commands

From Documentation

(Difference between revisions)
Jump to: navigation, search
Revision as of 07:03, 11 April 2006
Daniels (Talk | contribs)

← Previous diff
Revision as of 07:29, 11 April 2006
Moff (Talk | contribs)

Next diff →
Line 8: Line 8:
<em>-h implies HOT backup <em>-h implies HOT backup
-n oldest archive log</em> -n oldest archive log</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> select dba_data_files.file, dba_data_files.tablespace_name, ENABLED,<br> dba_data_files.status, dba_data_files.file_id, dba_data_files.bytes/(1024*1024)<br> from dba_data_files, v$datafile where dba_data_files.file_id = v$datafile.file#;<br> select name from v$controlfile;<br> archive log list;<br>}</code></pre>+<pre>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;
 +}</pre>
FSoracle &lt;oracle_user&gt; -b &lt;tablespace&gt; &lt;SID&gt; FSoracle &lt;oracle_user&gt; -b &lt;tablespace&gt; &lt;SID&gt;
<em>-b start backup mode</em> <em>-b start backup mode</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> alter tablespace &lt;tablespace&gt; begin backup;<br> select d.file_id, d.tablespace_name, v.status, v.file# from dba_data_files d, v$backup v<br> where (d.file_id = v.file#) and (d.tablespace_name = &lt;tablespace&gt;);<br>}</code></pre>+<pre>svrmgrl {
 + connect / as sysdba;
 + alter tablespace &lt;tablespace&gt; 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 = &lt;tablespace&gt;);
 +}</pre>
FSoracle &lt;oracle_user&gt; -e &lt;tablespace&gt; &lt;SID&gt; FSoracle &lt;oracle_user&gt; -e &lt;tablespace&gt; &lt;SID&gt;
<em>-e end backup mode</em> <em>-e end backup mode</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> alter tablespace &lt;tablespace&gt; end backup;<br> select d.file_id, d.tablespace_name, v.status, v.file# from dba_data_files d, v$backup v<br> where (d.file_id = v.file#) and (d.tablespace_name = &lt;tablespace&gt;);<br>}</code></pre>+<pre>svrmgrl {
 + connect / as sysdba;
 + alter tablespace &lt;tablespace&gt; 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 = &lt;tablespace&gt;);
 +}</pre>
FSoracle &lt;oracle_user&gt; -w &lt;oldest_log&gt; -f /tmp/oralog$$ &lt;SID&gt; FSoracle &lt;oracle_user&gt; -w &lt;oldest_log&gt; -f /tmp/oralog$$ &lt;SID&gt;
<em>-w implies switch logs</em> <em>-w implies switch logs</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> archive log list;<br> alter system archive log current;<br> archive log list;<br>}</code></pre>+<pre>svrmgrl {
 + connect / as sysdba;
 + archive log list;
 + alter system archive log current;
 + archive log list;
 +}</pre>
FSoracle &lt;oracle_user&gt; -l “&lt;oldest_log&gt; &lt;last_log&gt;” -f /tmp/oralog$$ &lt;SID&gt; FSoracle &lt;oracle_user&gt; -l “&lt;oldest_log&gt; &lt;last_log&gt;” -f /tmp/oralog$$ &lt;SID&gt;
<em>-l implies list log files</em> <em>-l implies list log files</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> select value from v$parameter where (Name = ‘log_archive_dest’) or<br> (Name = ‘log_archive_dest_1’) or (Name = ‘log_archive_dest_2’) or<br> (Name = ‘log_archive_dest_3’) or (Name = ‘log_archive_dest_4’) or<br> (Name = ‘log_archive_dest_5’) or (Name = ‘log_archive_dest_6’) or<br> (Name = ‘log_archive_dest_7’) or (Name = ‘log_archive_dest_8’) or<br> (Name = ‘log_archive_dest_9’) or (Name = ‘log_archive_dest_10’);<br>}</code></pre>+<pre>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’);
 +}</pre>
FSoracle &lt;oracle_user&gt; -t &lt;control_file&gt; &lt;SID&gt; FSoracle &lt;oracle_user&gt; -t &lt;control_file&gt; &lt;SID&gt;
<em>-t implies save control file</em> <em>-t implies save control file</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> alter database backup control file to ‘&lt;save_file&gt;’;<br>}</code></pre>+<pre>svrmgrl {
 + connect / as sysdba;
 + alter database backup control file to ‘&lt;save_file&gt;’;
 +}</pre>
FSoracle &lt;oracle_user&gt; -p &lt;param_dir&gt; &lt;SID&gt; FSoracle &lt;oracle_user&gt; -p &lt;param_dir&gt; &lt;SID&gt;
Line 40: Line 73:
<em>-c implies COLD backup</em> <em>-c implies COLD backup</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> shutdown immediate;<code> (if this fails, shutdown abort;)</code> startup exclusive;<br> select tablespace_name from dba_data_files;<br> select file_name from dba_data_files;<br> select member from v$logfile;<br> select name from v$controlfile;<br> shutdown immediate;<br>}</code></pre>+<pre>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;
 +}</pre>
FSoracle &lt;oracle_user&gt; -p &lt;param_dir&gt; &lt;SID&gt; FSoracle &lt;oracle_user&gt; -p &lt;param_dir&gt; &lt;SID&gt;
Line 48: Line 91:
<em>-s implies start mode = open</em> <em>-s implies start mode = open</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> startup open;<br>}</code></pre>+<pre>svrmgrl {
 + connect / as sysdba;
 + startup open;
 +}</pre>
<strong>Oracle Export</strong> <strong>Oracle Export</strong>
Line 54: Line 100:
<em>-x implies export as &lt;export_user&gt;</em> <em>-x implies export as &lt;export_user&gt;</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> shutdown immediate;<code> (if this fails shutdown abort;)</code> startup restrict open;<br>}<br>exp &lt;export_user&gt; direct full=y file=&lt;device_nr&gt;</code></pre>+<pre>
 +svrmgrl {
 + connect / as sysdba;
 + shutdown immediate;
 + (if shutdown fails shutdown abort;)
 + startup restrict open;
 +}
 +exp &lt;export_user&gt; direct full=y file=&lt;device_nr&gt;</pre>
FSoracle &lt;oracle_user&gt; -u &lt;SID&gt; FSoracle &lt;oracle_user&gt; -u &lt;SID&gt;
<em>-u implies unrestrict user access to &lt;SID&gt;</em> <em>-u implies unrestrict user access to &lt;SID&gt;</em>
-<pre><code>svrmgrl {<br> connect / as sysdba;<br> alter system disable restricted session;<br>}</code></pre>+<pre>
 +svrmgrl {
 + connect / as sysdba;
 + alter system disable restricted session;
 +}</pre>

Revision as of 07:29, 11 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.


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;
}