admin 1 test review
admin 2 복습 및 정리
backup set은 used block만 백업하는 것
Fast recovery area 관련 두가지 파라미터
db_recovery_file_dest
db_recovery_file_dest_size
===============실습========================
SYS@orcl>!ps -ef |grep arch
oracle 5702 5685 0 15:34 pts/4 00:00:00 /bin/bash -c ps -ef |grep arch
oracle 5704 5702 0 15:34 pts/4 00:00:00 grep arch
SYS@orcl>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk6
Oldest online log sequence 218
Next log sequence to archive 222
Current log sequence 222
SYS@orcl>alter system switch logfile;
System altered.
SYS@orcl>!ps -ef | grep arch
oracle 5717 5685 0 15:34 pts/4 00:00:00 /bin/bash -c ps -ef | grep arch
oracle 5719 5717 0 15:34 pts/4 00:00:00 /bin/bash -c ps -ef | grep arch
SYS@orcl>rman target /
SP2-0734: unknown command beginning "rman targe..." - rest of line ignored.
SYS@orcl>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lnx04 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 1 16:11:06 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
show alconnected to target database: ORCL (DBID=1418332348)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f'; # default
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 ~]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 1 16:15:02 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 1 16:16:05 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1418332348)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area 619360256 bytes
Fixed Size 1338280 bytes
Variable Size 469763160 bytes
Database Buffers 142606336 bytes
Redo Buffers 5652480 bytes
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 ~]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 1 16:16:32 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: ORCL (DBID=1418332348)
log_archive_min_succeed_dest integer 1
SYS@orcl>show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
SYS@orcl>show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 3852M
recovery_parallelism integer 0
SYS@orcl>
SYS@orcl>show parameter retention
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 1440
undo_retention integer 5400
[oracle@lnx04 ~]$ rman target / log=~/fullbu.log
RMAN> show all;
RMAN> exit
[oracle@lnx04 ~]$ cat fullbu.log
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 1 19:58:44 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1418332348)
RMAN>
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f'; # default
RMAN>
Recovery Manager complete.
Admin c2-27
'스터디북' 카테고리의 다른 글
[10/02] Admin2 C3-2 (0) | 2015.10.02 |
---|---|
[10/02] Admin2 C3-1 (0) | 2015.10.02 |
[09/30] Admin 1 C 16 Admin 2 C 1 (0) | 2015.09.30 |
[09/23] Expert Oracle Database 16장 데이터 암호화 (0) | 2015.09.23 |
[09/22] Expert Oracle Database 5장 오라클 프로세스 (0) | 2015.09.23 |