RMAN Catalog?????????ú????
???????????? ???????[ 2015/10/20 14:51:18 ] ??????????????????
??????????RHEL6.4 + Oracle 11.2.0.4
????????????????catdb
????1.1 ??????????????
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/logs/my/redo01a.log'??'/u02/logs/my/redo01b.log') SIZE 100M BLOCKSIZE 512??
GROUP 2 ('/u01/logs/my/redo02a.log'??'/u02/logs/my/redo02b.log') SIZE 100M BLOCKSIZE 512??
GROUP 3 ('/u01/logs/my/redo03a.log'??'/u02/logs/my/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
????1.2 ?????????????????????
????sys_password -> oracle
????system_password -> oracle
????US7ASCII -> ZHS16GBK
????mynewdb -> catdb
????/u01/logs/my -> /u01/redologs/a
????/u02/logs/my -> /u01/redologs/b
????/u01/app/oracle/oradata -> /u01/oradata03
????????vi?????滻??????:%s#/u01/logs/my#/u01/redologs/a#g?滻????/u01/logs/my?/u01/redologs/a??
?????????????:
vi /home/oracle/create_db.sql
CREATE DATABASE catdb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/redologs/a/redo01a.log'??'/u01/redologs/b/redo01b.log') SIZE 100M BLOCKSIZE 512??
GROUP 2 ('/u01/redologs/a/redo02a.log'??'/u01/redologs/b/redo02b.log') SIZE 100M BLOCKSIZE 512??
GROUP 3 ('/u01/redologs/a/redo03a.log'??'/u01/redologs/b/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/oradata03/catdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/oradata03/catdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/oradata03/catdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oradata03/catdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oradata03/catdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11