Oracle教程：基於使用者管理的備份與恢複－備份其它檔案

備份歸檔日誌

--查看第一個歸檔位置過去一天以來產生的歸檔日誌,dest_id代表歸檔日誌存放位置，對應到v$archive_dest中1～10的destination欄位值，0代表不可用

SQL> select name from v$archived_log where dest_id=1 and first_time>=sysdate-1;

NAME
------------------------------------------------------------------------------------------------------------------------
/Oracle/10g/oracle/log/archive_log/archive_1_23_757801926.arclog
/oracle/10g/oracle/log/archive_log/archive_1_24_757801926.arclog

SQL> select name from v$archived_log where dest_id=10 and first_time>=sysdate-1;

NAME
------------------------------------------------------------------------------------------------------------------------
/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_01/o1_mf_1_23_73fljh3f_.arc
/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_02/o1_mf_1_24_73hwlry6_.arc

SQL> select destination from v$archive_dest;

DESTINATION
------------------------------------------------------------------------------------------------------------------------
/oracle/10g/oracle/log/archive_log
/oracle/10g/oracle/log/archive_log2

USE_DB_RECOVERY_FILE_DEST

10 rows selected.
--拷貝歸檔日誌到指定的備份目錄
cp

備份參數檔案
1)如果使用文本參數檔案(pfile)，使用OS命令拷貝到備份目錄
2)如果使用spfile,使用create pfile 進行備份
3)如果使用pfile,使用create spfile進行備份
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /oracle/10g/oracle/product/10.
                                                 2.0/db_1/dbs/spfileoralife.ora
--建立pfile，相當於備份spfile為pfile
SQL> create pfile = '/oracle/10g/oracle/bakup/database/pfileoralife.ora'
  2  from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
--使用pfile啟動資料庫到nomount狀態，也可以直接startup pfile='pfile全路徑名'
SQL> startup nomount pfile='/oracle/10g/oracle/bakup/database/pfileoralife.ora';
ORACLE instance started.

Total System Global Area  528482304 bytes
Fixed Size                  1220360 bytes
Variable Size             146800888 bytes
Database Buffers          373293056 bytes
Redo Buffers                7168000 bytes
SQL> show parameter pfile;--當用pfile啟動資料庫時,spfile參數為空白

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
spfile                               string
SQL> show parameter spfile;

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
spfile                               string

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

1 2 下一頁