Oracle control files

oracle control files[@more@]

Oracle Control Files

Version 10.2

General Information Current Control Files SELECT value FROM gv$parameter WHERE name = 'control_files'; SELECT RPAD(SUBSTR(name,1,50),51,' ') "CONTROL FILE NAME" FROM gv$controlfile; Dependent Objects V_$CONTROLFILE V_$CONTROLFILE_RECORD_SECTION Create Control File Reuse previously existing control file(s) if they exist CREATE CONTROLFILE [REUSE] DATABASE ; STARTUP NOMOUNT; CREATE CONTROFILE REUSE SET DATABASE orabase RESETLOGS; ALTER DATABASE OPEN RESETLOGS; Reuse previously existing control file(s) if they exist CREATE CONTROLFILE [REUSE] DATABASE ; STARTUP NOMOUNT; CREATE CONTROFILE REUSE SET DATABASE orabase NORESETLOGS; Move Control Files Relocate Control Files conn / as sysdba show parameter control_files shutdown immediate host $ cp /control files $ vi / $ exit create spfile from pfile='/oracle/product/ora102/dbs/init.ora'; startup show parameter control_files host $ rm /control files Backup Control Files To Trace ALTER DATABASE BACKUP CONTROLFILE TO TRACE; To Binary File ALTER DATABASE BACKUP CONTROLFILE TO 'c:tempcontrol.bkp';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/330796/viewspace-871354/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/330796/viewspace-871354/