【文章內(nèi)容簡介】 system/manager FILE= TABLES=()//備份分區(qū)exp system/manager FILE= TABLES=(:Part1)//輸入例子imp system/manager file= imp system/manager file= buffer=64000 mit=Y exp system/manager file= owner=thumper grants=N indexes=Y press=Y rows=Y imp system/manager file= FROMUSER=thumper TOUSER=flower rows=Y indexes=Y imp system/manager file= full=Y mit=Y buffer=64000 imp system/manager file= ignore=N rows=N mit=Y buffer=64000 //使用操作系統(tǒng)備份命令 REM TAR examples tarcvf /dev/rmt/0hc /db0[19]/oracle/CC1tarrvf /dev/rmt/0hc /orasw/app/oracle/CC1/pfile/ tarrvf /dev/rmt/0hc /db0[19]/oracle/CC1 /orasw/app/oracle/CC1/pfile/ //離線備份的shell腳本ORACLE_SID=cc1。export ORACLE_SID ORAENV_ASK=NO。export svrmgrl connect internal as sysdba shutdown immediate。exit EOF1 insert backup mands like the “tar” mands here svrmgrl connect internal as sysdba startup EOF2 //在Server Manager上設(shè)置為archivelog mode: connect internal as sysdba startup mount cc1。alter database archivelog。archive log start。alter database open。archive log list alter system set LOG_ARCHIVE_DEST_1=39。LOCATION=/oracle/oradata/szdb/archive39。alter system set log_archive_format=39。%t_%39。 scope=spfile。alter system set log_archive_start=true scope=spfile。//在Server Manager上設(shè)置為archivelog mode: connect internal as sysdba startup mount cc1。alter database noarchivelog。alter database open。archive log list select Name, Value from V$PARAMETER where Name like ’log_archive%’。//聯(lián)機備份的腳本 Sample Hot Backup Script for a UNIX File System database Set up environment variables: ORACLE_SID=cc1。export ORACLE_SIDORAENV_ASK=NO。export svrmgrl connect internal as sysdba REM REM 備份 SYSTEM tablespace REM alter tablespace SYSTEM begin backup。!tarcvf /dev/rmt/0hc /db01/oracle/CC1/ alter tablespace SYSTEM end backup。REM REM The SYSTEM tablespace has now been written to a REM tar saveset on the tape device /dev/rmt/ REM rest of the tars must use the “rvf” clause to append REM to that REM 備份 RBS tablespace REM alter tablespace RBS begin backup。!tarrvf /dev/rmt/0hc /db02/oracle/CC1/ alter tablespace RBS end backup。REM REM 備份 DATA tablespace REM For the purposes of this example, this tablespace REM will contain two files, and The * wildcard will be used in the alter tablespace DATA begin backup。!tarrvf /dev/rmt/0hc /db03/oracle/CC1/data0*.dbf alter tablespace DATA end backup。REM REM 備份 INDEXES tablespace REM alter tablespace INDEXES begin backup。!tarrvf /dev/rmt/0hc /db04/oracle/CC1/ alter tablespace INDEXES end backup。REM REM 備份 TEMP tablespace REM alter tablespace TEMP begin backup。!tarrvf /dev/rmt/0hc /db05/oracle/CC1/ alter tablespace TEMP end backup。REM REM Follow the same pattern to back up the restREM of the REM REM Step log stop REM REM Exit Server Manager, using the indicator set EOFarch1 Record which files are in the destination directory. Do this by setting an environment variable that is equal to the directory listing for the destination directory. For this example, the log_archive_dest is /db01/oracle/arch/CC1. FILES=`ls /db01/oracle/arch/CC1/arch*.dbf`。export FILES Now go back into Server Manager and restart the archiving an indicator(called EOFarch2 in this example). svrmgrl connect internal archive log start。exit EOFarch2 Now back up the archived redo logs to the tape device via the “tar” mand, then delete them from the destination device via the “rm” mand. You may choose to press them instead. tarrvf /dev/rmt/0hc $FILES rmf $FILES Step . svrmgrl connect internal alter database backup controlfile to ’db01/oracle/CC1/’。exit EOFarch3 備份控制文件到磁帶. tarrvf /dev/rmt/0hc /db01/oracle/CC1/ End of hot backup script.//自動生成開始備份的腳本set pagesize 0 feedback off select ’alter tablespace ’||Tablespace_Name||’ begin backup?！?from DBA_TABLESPACES where Status ’INVALID’ spool / spool off //自動生成備份結(jié)束的腳本set pagesize 0 feedback off select ’alter tablespace ’||Tablespace_Name||’ end backup?！?from DBA_TABLESPACES where Status ’INVALID’ spool / spool off // See text for alternatives. Step 1: Stop the archiving will keep additional archived redo log files from being written to the destination directory during this process. svrmgrl connect internal as sysdba archive log stop。REM REM Exit Server Manager using the indicator set EOFarch1 Step 2: Record which files are in the destination directory. Do this by setting an environment variable that is equal to the directory listing for the destination directory. For this example, the log_archive_dest is /db01/oracle/arch/CC1. FILES=`ls /db01/oracle/arch/CC1/arch*.dbf`。export FILES Step 3: Go back into Server Manager and restart the archiving an indicator(called EOFarch2 in this example). svrmgrl connect internal as sysdba archive log start。exit EOFarch2 Step up the archived redo logs to the tape device via the “tar” mand, then delete them from the destination device via the “rm” mand. tarrvf /dev/rmt/0hc $FILES Step those files from the destination directory. rmf $FILES End of archived redo log file backup 磁盤到磁盤的備份 REM REM Back up the RBS tablespacecreate EMPLOYEEselect * from EMPLOYEE//監(jiān)視器的管理 lsnrctl start lsnrctl start my_lsnr lsnrctl status lsnrctl status hq 檢查監(jiān)視器的進程psef | grep tnslsnr //在 lsnrctl 內(nèi)停止監(jiān)視器 set password lsnr_password stop //在lsnrctl 內(nèi)列出所有的服務(wù) set password lsnr_password services //啟動或停止一個NT的listener net start OracleTNSListener net stop OracleTNSListener // 文件的內(nèi)容 fld1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = T