Backing Up Control Files

最新推荐文章于 2024-11-17 21:23:36 发布
最新推荐文章于 2024-11-17 21:23:36 发布
阅读量433 收藏
点赞数
分类专栏： oracle 学习点滴 文章标签： up database archive file filenames oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/stonewoodren/article/details/5831224
版权

Backing Up Control Files

Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options:

  1. Back up the control file to a binary file (duplicate of existing control file) using the following statement:

    ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp';

  2. Produce SQL statements that can later be used to re-create your control file:

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

    This command writes a SQL script to the database trace file where it can be captured and edited to reproduce the control file.

 


SQL> alter database backup controlfile to trace;

Database altered.

SQL> @/u01/gettrcname

TRACE_FILE_NAME
--------------------------------------------------------------------------------
/u01/oracle/admin/stone/udump/stone_ora_8291.trc

 

 

 

[oracle@localhost udump]$ more stone_ora_8291.trc
/u01/oracle/admin/stone/udump/stone_ora_8291.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/oracle/product/10.2.0
System name:    Linux
Node name:      localhost.localdomain
Release:        2.6.9-78.ELsmp
Version:        #1 SMP Wed Jul 9 15:39:47 EDT 2008
Machine:        i686
Instance name: stone
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 8291, image: oracle@localhost.localdomain (TNS V1-V3)

*** SERVICE NAME:(SYS$USERS) 2010-08-23 09:08:47.191
*** SESSION ID:(159.3) 2010-08-23 09:08:47.191
*** 2010-08-23 09:08:47.191
-- The following are current System-scope REDO Log Archival related
-- parameters and can be included in the database initialization file.
--
-- LOG_ARCHIVE_DEST=''
-- LOG_ARCHIVE_DUPLEX_DEST=''
--
-- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf
--
-- DB_UNIQUE_NAME="stone"
--
-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'
-- LOG_ARCHIVE_MAX_PROCESSES=2
-- STANDBY_FILE_MANAGEMENT=MANUAL
-- STANDBY_ARCHIVE_DEST=?/dbs/arch
-- FAL_CLIENT=''
-- FAL_SERVER=''
--
-- LOG_ARCHIVE_DEST_10='LOCATION=USE_DB_RECOVERY_FILE_DEST'
-- LOG_ARCHIVE_DEST_10='OPTIONAL REOPEN=300 NODELAY'
-- LOG_ARCHIVE_DEST_10='ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC'
-- LOG_ARCHIVE_DEST_10='REGISTER NOALTERNATE NODEPENDENCY'
-- LOG_ARCHIVE_DEST_10='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'
-- LOG_ARCHIVE_DEST_10='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'
-- LOG_ARCHIVE_DEST_STATE_10=ENABLE
--
-- Below are two sets of SQL statements, each of which creates a new
-- control file and uses it to open the database. The first set opens
-- the database with the NORESETLOGS option and should be used only if
-- the current versions of all online logs are available. The second
-- set opens the database with the RESETLOGS option and should be used
-- if online logs are unavailable.
-- The appropriate set of statements can be copied from the trace into
-- a script file, edited as necessary, and executed when there is a
-- need to re-create the control file.
--
--     Set #1. NORESETLOGS case
--
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- Additional logs may be required for media recovery of offline
-- Use this only if the current versions of all online logs are
-- available.
-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "STONE" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 3
    MAXDATAFILES 200
    MAXINSTANCES 6
    MAXLOGHISTORY 584
LOGFILE
  GROUP 1 '/u01/oracle/oradata/stone/redo01.log'  SIZE 50M,
  GROUP 2 '/u01/oracle/oradata/stone/redo02.log'  SIZE 50M,
  GROUP 3 '/u01/oracle/oradata/stone/redo03.log'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/u01/oracle/oradata/stone/system01.dbf',
  '/u01/oracle/oradata/stone/undotbs01.dbf',
  '/u01/oracle/oradata/stone/sysaux01.dbf',
  '/u01/oracle/oradata/stone/users01.dbf',
  '/u01/oracle/oradata/stone/example01.dbf'
CHARACTER SET WE8ISO8859P1
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/u01/oracle/flash_recovery_area/STONE/archivelog/2010_08_23/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
-- Database can now be opened normally.
ALTER DATABASE OPEN;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/stone/temp01.dbf'
     SIZE 20971520  REUSE AUTOEXTEND OFF;
-- End of tempfile additions.
--
--     Set #2. RESETLOGS case
--
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- be invalidated. Use this only if online logs are damaged.
-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "STONE" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 3
    MAXDATAFILES 200
    MAXINSTANCES 6
    MAXLOGHISTORY 584
LOGFILE
  GROUP 1 '/u01/oracle/oradata/stone/redo01.log'  SIZE 50M,
  GROUP 2 '/u01/oracle/oradata/stone/redo02.log'  SIZE 50M,
  GROUP 3 '/u01/oracle/oradata/stone/redo03.log'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/u01/oracle/oradata/stone/system01.dbf',
  '/u01/oracle/oradata/stone/undotbs01.dbf',
  '/u01/oracle/oradata/stone/sysaux01.dbf',
  '/u01/oracle/oradata/stone/users01.dbf',
  '/u01/oracle/oradata/stone/example01.dbf'
CHARACTER SET WE8ISO8859P1
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/u01/oracle/flash_recovery_area/STONE/archivelog/2010_08_23/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/stone/temp01.dbf'
     SIZE 20971520  REUSE AUTOEXTEND OFF;
-- End of tempfile additions.
--
[oracle@localhost udump]$
[oracle@localhost udump]$

stonewoodren
关注
专栏目录
Oracle 12c 12.1.0.1.0管理控制文件官方文档翻译说明（一抹曦阳）
08-05
#### 五、备份控制文件（Backing Up Control Files） - **使用SQL备份控制文件**：可以通过SQL语句来备份控制文件并获取创建控制文件的脚本。 #### 六、使用当前副本来恢复控制文件（Recovering a Control File ...
Oracle Security
06-12
Chapter 12 Backing Up and Recovering the Database What Are the Backup Options? What’s New for Oracle8? What Are the Recovery Options? Chapter 13 Using the Oracle Enterprise Manager What Is the ...
Solaris 10 System Administration Essentials
04-06
5.2.2 Backing Up and Restoring UFS File Systems 107 5.2.3 Using Quotas to Manage Disk Space 108 5.2.4 Checking File System Integrity 110 5.2.5 Using Access Control Lists 112 5.2.6 Using UFS Logging ...
BSD HACKS -- 100个业界最尖端的技巧和工具
11-03
Backing Up Introduction Section 35. Back Up FreeBSD with SMBFS Section 36. Create Portable POSIX Archives Section 37. Interactive Copy Section 38. Secure Backups Over a Network...
Turbo C++ 3.0[DISK]
08-05
If you're backing up the 5 1/4 inch 1.2 Mb disk set, use only blank 5 1/4 inch 1.2 Mb disks for backup, etc. The installation will not work correctly if you do not use the same media type for ...
不知道alter database close 有什么用？
stonewoodren的专栏
08-16 2027
不知道alter database close 有什么用？SQL> select status from v$instance;STATUS------------OPENSQL> alter database close;alter database close*ERROR at line 1:ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected##还有别的session，断掉之后再执行SQL> alter da
alter system set control_files =
stonewoodren的专栏
08-22 1590
To add a multiplexed copy of the current control file or to rename a control file:Shut down the database.Copy an existing control file to a new location, using operating system commands.Edit the CONTROL_FILES parameter in the database initialization parame
Shutting Down a Database
stonewoodren的专栏
08-16 1365
Shutting Down a Database<br />To initiate database shutdown, use the SQL*Plus SHUTDOWN command. Control is not returned to the session that initiates a database shutdown until shutdown is complete. Users who attempt connections while a shutdown is in progr
dispatcher
stonewoodren的专栏
08-21 395
SQL> select name,network from v$dispatcher; NAME NETWORK ---- -------------------------------------------------------------------------------------------------------------------------------- D000 (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(POR
共享服务器进程对应得服务器进程是ora_s???_SID 吗？
stonewoodren的专栏
08-21 369
<br />共享服务器进程对应得服务器进程是ora_s???_SID 吗？<br /> <br />SQL> show parameters shared_servers;<br />NAME                                 TYPE        VALUE<br />------------------------------------ ----------- ------------------------------<br />max_shared_servers 
常用的文件系统、存储类型小整理
Hehuyi_In的博客
02-07 3511
最近接触到了五花八门的文件系统、存储类型，名词听得头大，趁假期整理学习一番~
sql注入之二次注入（sqlilabs-less24）
CSDNRomance的博客
11-13 609
二阶注入相对隐蔽，因为其恶意代码不会在第一步直接执行，所以在开发和测试时，务必要考虑输入数据在不同阶段的调用方式，以避免此类攻击。
【DBA攻坚指南：左右Oracle，右手MySQL-学习总结】
qianxunsiyue的博客
11-13 440
从用户提交会话开始，LGWR进程将redo缓存中的信息写入redo日志文件后，LGWR进程通知用户写操作完成，到用户会话接受到LGWR进程通知为止，这整个过程就是可能出现log file sync等待事件的地方。在LGWR写入日志过程中，还包括了控制文件修改操作，对于RAC节点，可能还存在节点之间的scn同步、节点之间cr块的同步。
如何准备 PostgreSQL 中级认证考试？
cqsizhuang的博客
11-14 292
准备PostgreSQL中级认证考试（PGCE）需要系统的学习和实践。
如何在 SQL Server 中新增账户并指定数据库权限
最新发布
huaqianzkh的专栏
11-17 713
创建新用户账户为用户授予登录权限添加用户到指定数据库设置用户的数据库角色确认用户权限。
问：SQL优化，七条实践总结？
技术铺掌柜
11-14 1191
SQL语句优化是提升数据库性能的关键，包括优化Where子句顺序、用EXISTS替代IN、避免在索引列上计算和判断NULL值、建立索引、避免在where子句中对字段进行null值判断和表达式操作等。通过综合应用这些优化方法，如使用JOIN代替子查询、日期范围查询代替函数计算、建立相关索引等，可以显著提升查询性能，特别是在处理大数据时。
sql文件
weixin_47420447的博客
11-13 558
sql文件通常包含SQL语句，用于数据库的创建、修改和数据操作。根据内容的不同，.sql文件的使用方式也有所不同。
MySQL数据库：SQL语言入门 【3】（学习笔记）
2301_81819439的博客
11-14 1235
TCL事务控制语言：事务概念，事务并发问题，事务的隔离等级，jdbc对事务的操作 ，视图，存储过程
backing up mysql database
03-16
MySQL数据库的备份可以通过以下方法实现： 1. 使用mysqldump命令：该命令可以将MySQL数据库的内容导出为SQL脚本文件，然后可以使用该文件进行恢复。 2. 使用phpMyAdmin：如果您使用的是phpMyAdmin，可以通过该工具...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值