catalog备份数据库

使用catalog备份数据库

要备份51上的数据库（目标数据库），在52（catalog  database）上操作：
SQL> create tablespace rmanct datafile '/db/oracle11g/oradata/peak/rmanct01.dbf' size 50m;

Tablespace created.
SQL> grant connect , resource ,recovery_catalog_owner to rmanct identified by rmanct;

Grant succeeded.
创建catalog tablespace:
[oracle@centos1152 ~]$ rman catalog rmanct/rmanct

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jun 10 01:02:20 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN>
RMAN> create catalog tablespace rmanct;

recovery catalog created

RMAN>

在目标数据库51上操作，需要配置好TNSNAMES，确保能连到catalog database 上：
[oracle@node51 admin]$cat tnsnames.ora
# tnsnames.ora Network Configuration File: /db/oracle10g/product/10.2.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


1152 =
        (DESCRIPTION =
                (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = TCP )(HOST = 192.168.11.52)(PORT = 1521))
                )
                (CONNECT_DATA =
                        (SERVER = DEDICATED)
                        (ORACLE_SID = peak)
                )
        )
[oracle@node51 admin]$
[oracle@node51 ~]$ rman target / catalog rmanct/rmanct@1152

Recovery Manager: Release 10.2.0.4.0 - Production on Fri May 18 18:46:54 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: PEAK (DBID=1833158544)
connected to recovery catalog database

RMAN>
注册数据库：
RMAN>register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>
RMAN> backup database;

Starting backup at 18-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=310 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/db/oracle10g/oradata/peak/system01.dbf
input datafile fno=00002 name=/db/oracle10g/oradata/peak/undotbs01.dbf
input datafile fno=00003 name=/db/oracle10g/oradata/peak/sysaux01.dbf
input datafile fno=00005 name=/db/oracle10g/oradata/test/test01.dbf
input datafile fno=00004 name=/db/oracle10g/oradata/peak/users01.dbf
channel ORA_DISK_1: starting piece 1 at 18-MAY-12
channel ORA_DISK_1: finished piece 1 at 18-MAY-12
piece handle=/data/backup/PEAK_1_1_126 tag=TAG20120518T184748 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06
Finished backup at 18-MAY-12

Starting Control File and SPFILE Autobackup at 18-MAY-12
piece handle=/data/backup/c-1833158544-20120518-1c comment=NONE
Finished Control File and SPFILE Autobackup at 18-MAY-12


RMAN>list backup;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
193     Full    162.08M    DISK        00:00:50     18-MAY-12      
        BP Key: 197   Status: AVAILABLE  Compressed: YES  Tag: TAG20120518T102600
        Piece Name: /data/backup/PEAK_1_1_122
  List of Datafiles in backup set 193
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1491573    18-MAY-12 /db/oracle10g/oradata/peak/system01.dbf
  2       Full 1491573    18-MAY-12 /db/oracle10g/oradata/peak/undotbs01.dbf
  3       Full 1491573    18-MAY-12 /db/oracle10g/oradata/peak/sysaux01.dbf
  4       Full 1491573    18-MAY-12 /db/oracle10g/oradata/peak/users01.dbf
  5       Full 1491573    18-MAY-12 /db/oracle10g/oradata/test/test01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
195     17.50K     DISK        00:00:01     18-MAY-12      
        BP Key: 198   Status: AVAILABLE  Compressed: NO  Tag: TAG20120518T102658
        Piece Name: /data/backup/PEAK_1_1_124

  List of Archived Logs in backup set 195
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       1491514    18-MAY-12 1491623    18-MAY-12
  1    8       1491623    18-MAY-12 1491628    18-MAY-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
196     Full    7.08M      DISK        00:00:00     18-MAY-12      
        BP Key: 199   Status: AVAILABLE  Compressed: NO  Tag: TAG20120518T102701
        Piece Name: /data/backup/c-1833158544-20120518-1b
  Control File Included: Ckp SCN: 1491634      Ckp time: 18-MAY-12
  SPFILE Included: Modification time: 18-MAY-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
257     Full    699.72M    DISK        00:00:58     18-MAY-12      
        BP Key: 260   Status: AVAILABLE  Compressed: NO  Tag: TAG20120518T184748
        Piece Name: /data/backup/PEAK_1_1_126
  List of Datafiles in backup set 257
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1522488    18-MAY-12 /db/oracle10g/oradata/peak/system01.dbf
  2       Full 1522488    18-MAY-12 /db/oracle10g/oradata/peak/undotbs01.dbf
  3       Full 1522488    18-MAY-12 /db/oracle10g/oradata/peak/sysaux01.dbf
  4       Full 1522488    18-MAY-12 /db/oracle10g/oradata/peak/users01.dbf
  5       Full 1522488    18-MAY-12 /db/oracle10g/oradata/test/test01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
270     Full    7.14M      DISK        00:00:01     18-MAY-12      
        BP Key: 276   Status: AVAILABLE  Compressed: NO  Tag: TAG20120518T184856
        Piece Name: /data/backup/c-1833158544-20120518-1c
  Control File Included: Ckp SCN: 1522586      Ckp time: 18-MAY-12
  SPFILE Included: Modification time: 18-MAY-12

RMAN>


在52上catalog database可查询备份的信息：

[oracle@centos1152 ~]$sqlplus  rmanct/rmanct

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 10 01:29:39 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production

SQL>
SQL>desc rc_database;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DB_KEY                                    NOT NULL NUMBER
 DBINC_KEY                                          NUMBER
 DBID                                      NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(8)
 RESETLOGS_CHANGE#                         NOT NULL NUMBER
 RESETLOGS_TIME                            NOT NULL DATE

SQL>
SQL> select * from rc_database;

    DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS
---------- ---------- ---------- -------- ----------------- ---------
         1          2 1833158544 PEAK               1488136 18-MAY-12

SQL>
SQL>desc rc_tablespace;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DB_KEY                                    NOT NULL NUMBER
 DBINC_KEY                                 NOT NULL NUMBER
 DB_NAME                                   NOT NULL VARCHAR2(8)
 TS#                                       NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(30)
 CREATION_CHANGE#                          NOT NULL NUMBER
 CREATION_TIME                                      DATE
 DROP_CHANGE#                                       NUMBER
 DROP_TIME                                          DATE
 INCLUDED_IN_DATABASE_BACKUP               NOT NULL VARCHAR2(3)
 BIGFILE                                   NOT NULL VARCHAR2(3)
 TEMPORARY                                 NOT NULL VARCHAR2(3)
 ENCRYPT_IN_BACKUP                                  VARCHAR2(3)

SQL>set line 170
SQL>select * from rc_tablespace;

    DB_KEY  DBINC_KEY DB_NAME    TS# NAME     CREATION_CHANGE# CREATION_ DROP_CHANGE# DROP_TIME INC BIG TEM ENC
---------- ---------- -------- ---------- ------------------------------ ---------------- --------- ------------ --------- --- --- --- ---
         1          2 PEAK              6 TEST                                     466429 12-MAY-12                        YES NO  NO
         1          2 PEAK              4 USERS                                     10566 30-JUN-05                        YES NO  NO
         1          2 PEAK              3 TEMP                                     446142 09-MAY-12                        NO  NO  YES
         1          2 PEAK              2 SYSAUX                                     6609 30-JUN-05                        YES NO  NO
         1          2 PEAK              1 UNDOTBS1                                 444079 30-JUN-05                        YES NO  NO
         1          2 PEAK              0 SYSTEM                                        9 30-JUN-05                        YES NO  NO

6 rows selected.

SQL>



在目标数据库51上操作：
RMAN> unregister database;

database name is "PEAK" and DBID is 1833158544

Do you really want to unregister the database (enter YES or NO)? yes
database unregistered from the recovery catalog

RMAN>

#强烈建议不要将catalog database放在目标数据库中。

#对于注册到恢复目录，是否就必须或只能以CATALOG模式进行备份或恢复操作了呢？当然不是，恢复目录只是RMAN中的一个可选项，而不是必选项，备份信息是否记入CATALOG取决于执行RMAN操作时是否连接到了CATALOG，也就是说，即使目标数据库已经注册到恢复目录中，但连接时没有以CATALOG模式连接，则备份信息仍然是只存入目标数据库的控制文件中，相当于NOCATALOG模式。

更多参考：

the specified nodes are not clusterable

根据rowid删除表中重复的行

Agent process exited abnormally during initialization

一次字符乱码的解决过程

rman实验（一）

rman实验（二）

ORA-00600: internal error code, arguments: [keltnf

ORA-00600: ORA-12012 ORA-08102解决

linux下完全删除oracle

INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory

centos4.8_64上安装oracle10201建库报ORA-12547

EM乱码解决

ORA-31613 Master process DM00 failed during startup

ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

ORA-24324 ORA-01041 ORA-03113

centos5.3升级oracle

pdksh-5.2.14-36.el5.i386.rpm

使用rman进行数据库迁移

oracle10.2.0.1升级到10.2.0.4报错

Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)

改oracle的name和dbid

修改oracle实例名

Solaris8上迁移oracle8i---上

Solaris8上迁移oracle8i---下

未备份归档日志导致数据丢失的实验

使用NBU进行数据库迁移

catalog备份数据库

RMAN FORMAT字符串格式化

Error: can not register my instance state - -1

not all alterations performed

The ASM instance configured on the local node is a single-instance ASM

/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared

Initializing the Oracle ASMLib driver: [FAILED]

ORA-00245: control file backup operation failed

WARNING: failed to read mirror side 1 of virtual extent 229 logical extent

模拟恢复参数文件

Interface eth0 checked failed

import server uses ZHS16GBK character set (possible charset conversion)