Some useful info for rebuilding database

01、 ORACLE_Collect_Some useful info for rebuilding database

--- 1.Backup the pfile;

#su - oracle

$sqlplus / assysdba

SQL>show parameter spfile;

SQL>CREATEPFILE='$ORACLE_HOME/dbs/init<SID>tmp.ora'FROMSPFILE;

--- 2.Backup the controlfile;

SQL> show parameter control;

SQL> alter session settracefile_identifier='trace_controlfile';

SQL> ALTERDATABASEBACKUPCONTROLFILETOTRACE;

--- Findout the recent *.trc file in the$ORACLE_BASE/diag/rdbms/<DATABASE_NAME>/<ORACLE_SID>/trace;

--- 3. Backupsome information of the tablespaces and datafiles;

SELECT tablespace_name, status, CONTENTSFROM DBA_TABLESPACES ORDERBY TABLESPACE_NAME;

SELECT file_name, file_id, tablespace_name, bytes,status, autoextensible, online_status FROM DBA_DATA_FILES ORDERBY TABLESPACE_NAME;

SELECT file_name, file_id, tablespace_name, bytes,status, autoextensible FROM DBA_TEMP_FILES ORDERBY TABLESPACE_NAME;

SELECT file#, status, ENABLED,bytes, NAMEFROM V$TEMPFILE ORDERBYNAME;

SELECT file#, status, ENABLED,bytes, NAMEFROM V$DATAFILE ORDERBYNAME;

SELECT group#, status, TYPE,MEMBER, is_recovery_dest_file FROMV$LOGFILE ORDERBYMEMBER;

SELECT * fromv$log;

--- 4. Get the scripts of the tablespace and the user

$sqlplus / assysdba

set long999999999

set linesize 400

set pagesize20000

set feedback ON

set heading off

spool/tmp/tablespace_user_script.txt

SELECTDBMS_METADATA.GET_DDL('TABLESPACE', tablespace_name)||';' FROM DBA_tablespaces;

SELECT DBMS_METADATA.GET_DDL('USER', USERNAME) || ';'

  FROM DBA_USERS T

 WHERE T.USERNAME NOTIN ('SYS','SYSTEM','DBSNMP','SYSMAN','OUTLN','MDSYS',

                          'ORDSYS','EXFSYS','DMSYS','WMSYS','CTXSYS','ANONYMOUS',

                          'XDB','ORDPLUGINS','OLAPSYS','PUBLIC')

 ORDERBYt.created;

Spool off;

--- 5. Backup theOCR  (For RAC )

# $ORA_CRS_HOME/bin/ocrconfig -export /oracle/db/ocrbak.ocr                 

# su - oracle

$ ocrcheck

--- 6. Backup theVOTE  (For RAC )

# $ORA_CRS_HOME/bin/crsctl query css votedisk                                               

# dd if=/dev/raw/raw2 of=/oracle/db/voting.bak