이력서 수정
수업 내용 복습
[oracle@lnx04 admin]$ vi tnsnames.ora
[oracle@lnx04 admin]$ tnsping rcat
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 09:54:14
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (decription = (address_list = (address = (protocol=tcp)(host=lnx04.ocmkorea.com)(port=1523))) (connect_data = (sid=orcl) (service=dedicated)))
TNS-12533: TNS:illegal ADDRESS parameters
[oracle@lnx04 admin]$ vi tnsnames.ora
[oracle@lnx04 admin]$ tnsping rcat
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 09:54:39
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (description = (address_list = (address = (protocol=tcp)(host=lnx04.ocmkorea.com)(port=1521))) (connect_data = (sid=orcl) (service=dedicated)))
OK (0 msec)
[oracle@lnx04 admin]$ lsnrctl serv
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 09:54:43
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=lnx04.ocmkorea.com)(port=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:150 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@lnx04 admin]$ sqlplus system/oracle@rcat
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 09:55:01 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM@rcat>select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
SYSTEM@rcat>conn sys/oracle as sysdba
Connected.
SYS@orcl>grant sysdba to system;
Grant succeeded.
SYS@orcl>select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
SYSTEM TRUE FALSE FALSE
SYS@orcl>conn system/oracle@rcat as sysdba
Connected.
SYS@rcat>
SYS@rcat>create tablespace rman_tbs
datafile '/u01/app/oracle/oradata/orcl/rman_tbs01.dbf' size 100m
autoextend on next 10m maxsize 1g
segment space management auto;
Tablespace created.
SYS@rcat>ed
Wrote file afiedt.buf
create user rman_admin identified by oracle
default tablespace rman_tbs
temporary tablespace temp
quota unlimited on rman_tbs
SYS@rcat>/
User created.
SYS@rcat>grant connect, resource, recovery_catalog_owner to rman_admin;
Grant succeeded.
SYS@rcat>conn rman_admin/oracle@rcat
Connected.
RMAN_ADMIN@rcat>select * from rc_database;
select * from rc_database
*
ERROR at line 1:
ORA-00942: table or view does not exist
RMAN_ADMIN@rcat>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 admin]$ rman target system/oracle@orcl catalog rman_admin/oracle@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 10:01:07 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1418332348)
connected to recovery catalog database
RMAN> create catalog tablespace "RMAN_TBS";
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
2 27 ORCL 1418332348 PARENT 1 13-AUG-09
2 4 ORCL 1418332348 CURRENT 754488 16-SEP-15
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 admin]$ sqlplus rman_admin/oracle@rcat
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 10:02:57 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
RMAN_ADMIN@rcat>select * from rc_database;
DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS
---------- ---------- ---------- -------- ----------------- ---------
2 4 1418332348 ORCL 754488 16-SEP-15
RMAN_ADMIN@rcat>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 admin]$ cd
[oracle@lnx04 ~]$ vi .bashrc
[oracle@lnx04 ~]$ . .bashrc
[oracle@lnx04 ~]$ ss
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 10:04:12 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl>select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
8 SMALL_UNDO YES NO YES
18 RMAN_TBS YES NO YES
13 OLTP YES NO YES
14 USERS1 YES NO YES
16 TEMP1 NO NO YES
17 TEMP2 NO NO YES
12 rows selected.
SYS@orcl>drop tablespace SMALL_UNDO including contents and datafiles;
Tablespace dropped.
SYS@orcl>drop tablespace OLTP including contents and datafiles;
Tablespace dropped.
SYS@orcl>drop tablespace USERS1 including contents and datafiles;
Tablespace dropped.
SYS@orcl>drop tablespace TEMP1 including contents and datafiles;
Tablespace dropped.
SYS@orcl>drop tablespace TEMP2 including contents and datafiles;
Tablespace dropped.
[oracle@lnx04 ~]$ cd /BACKUP/
[oracle@lnx04 BACKUP]$ ls
close lost+found open rman rman_con
[oracle@lnx04 BACKUP]$ mkdir rman rman_con
[oracle@lnx04 BACKUP]$ rtc
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 10:07:05 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1418332348)
connected to recovery catalog database
RMAN> configure retention policy to recovery window of 7 days;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure default device type to disk;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure controlfile autobackup on;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure controlfile autobackup format for device type disk to '/BACKUP/rman_con/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/BACKUP/rman_con/%F';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure backup optimization on;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure device type disk parallelism 2;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure channel device type disk maxpiecesize 100m format '/BACKUP/rman/%d_%s_%p';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 100 M FORMAT '/BACKUP/rman/%d_%s_%p';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure maxsetsize to 1G;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 1 G;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> backup database plus archivelog;
Starting backup at 02-OCT-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=170 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=21 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=71 RECID=11 STAMP=891763227
input archived log thread=1 sequence=72 RECID=12 STAMP=891766856
input archived log thread=1 sequence=73 RECID=13 STAMP=891788605
i~
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:28
Finished backup at 02-OCT-15
Starting backup at 02-OCT-15
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf~
channel ORA_DISK_1: finished piece 11 at 02-OCT-15
piece handle=/BACKUP/rman/ORCL_5_11 tag=TAG20151002T115211 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:43
Finished backup at 02-OCT-15
Starting backup at 02-OCT-15
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=226 RECID=166 STAMP=892036555
channel ORA_DISK_1: starting piece 1 at 02-OCT-15
channel ORA_DISK_1: finished piece 1 at 02-OCT-15
piece handle=/BACKUP/rman/ORCL_7_1 tag=TAG20151002T115558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 02-OCT-15
Starting Control File and SPFILE Autobackup at 02-OCT-15
piece handle=/BACKUP/rman_con/c-1418332348-20151002-00 comment=NONE
Finished Control File and SPFILE Autobackup at 02-OCT-15
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
463 Full 721.59M DISK 00:02:04 02-OCT-15
List of Datafiles in backup set 463
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 3248207 02-OCT-15 /u01/app/oracle/oradata/orcl/system01.dbf
5 Full 3248207 02-OCT-15 /u01/app/oracle/oradata/orcl/example01.dbf
12 Full 3248207 02-OCT-15 /u01/app/oracle/oradata/orcl/rman_tbs01.dbf
Backup Set Copy #1 of backup set 463
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:02:04 02-OCT-15 NO TAG20151002T115211
List of Backup Pieces for backup set 463 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
528 1 AVAILABLE /BACKUP/rman/ORCL_6_1
529 2 AVAILABLE /BACKUP/rman/ORCL_6_2
530 3 AVAILABLE /BACKUP/rman/ORCL_6_3
531 4 AVAILABLE /BACKUP/rman/ORCL_6_4
532 5 AVAILABLE /BACKUP/rman/ORCL_6_5
533 6 AVAILABLE /BACKUP/rman/ORCL_6_6
534 7 AVAILABLE /BACKUP/rman/ORCL_6_7
535 8 AVAILABLE /BACKUP/rman/ORCL_6_8
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
464 Full 1.04G DISK 00:03:40 02-OCT-15
List of Datafiles in backup set 464
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 3248206 02-OCT-15 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 3248206 02-OCT-15 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 3248206 02-OCT-15 /u01/app/oracle/oradata/orcl/users01.dbf
Backup Set Copy #1 of backup set 464
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:03:40 02-OCT-15 NO TAG20151002T115211
List of Backup Pieces for backup set 464 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
536 1 AVAILABLE /BACKUP/rman/ORCL_5_1
537 2 AVAILABLE /BACKUP/rman/ORCL_5_2
538 3 AVAILABLE /BACKUP/rman/ORCL_5_3
539 4 AVAILABLE /BACKUP/rman/ORCL_5_4
540 5 AVAILABLE /BACKUP/rman/ORCL_5_5
541 6 AVAILABLE /BACKUP/rman/ORCL_5_6
542 7 AVAILABLE /BACKUP/rman/ORCL_5_7
543 8 AVAILABLE /BACKUP/rman/ORCL_5_8
544 9 AVAILABLE /BACKUP/rman/ORCL_5_9
545 10 AVAILABLE /BACKUP/rman/ORCL_5_10
546 11 AVAILABLE /BACKUP/rman/ORCL_5_11
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 BACKUP]$ rm /BACKUP/close/*
[oracle@lnx04 BACKUP]$ cp /u01/app/oracle/oradata/orcl/* /BACKUP/close/
[oracle@lnx04 BACKUP]$ sqlplus sys/oracle as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 10:30:06 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SYS@orcl>startup
ORACLE instance started.
Total System Global Area 619360256 bytes
Fixed Size 1338280 bytes
Variable Size 469763160 bytes
Database Buffers 142606336 bytes
Redo Buffers 5652480 bytes
Database mounted.
Database opened.
SYS@orcl>alter tablespace rman_tbs begin backup;
Tablespace altered.
SYS@orcl>!cp /u01/app/oracle/oradata/orcl/rman_tbs01.dbf /BACKUP/open
SYS@orcl>alter tablespace rman_tbs end backup;
Tablespace altered.
[oracle@lnx04 dbs]$ sqlplus system/oracle@prodo
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 12:11:22 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM@prodo>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 dbs]$ tns
[oracle@lnx04 admin]$ vi tnsnames.ora
[oracle@lnx04 admin]$ tnsping rcat_r
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 12:11:49
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = lnx04cat)(PORT = 1521))) (CONNECT_DATA = (service = DEDICATED) (sid = RCATDB)))
OK (30 msec)
[oracle@lnx04 admin]$ sqlplus system/oracle@rcat_r
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 12:11:55 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM@rcat_r>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 admin]$ sqlplus system/oracle@rcat_r
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 12:12:23 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM@rcat_r>select instance_name from v$instance;
INSTANCE_NAME
----------------
RCATDB
SYSTEM@rcat_r>conn sys/oracle as sysdba
Connected.
SYS@prodo>grant sysdba to system;
Grant succeeded.
SYS@prodo>selec * from v%pwfile_users;
SP2-0734: unknown command beginning "selec * fr..." - rest of line ignored.
SYS@prodo>select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
SYSTEM TRUE FALSE FALSE
SYS@prodo>conn system/oracle@rcat_r as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
@>exit
[oracle@lnx04 admin]$ sqlplus / as sysdba@rcat_r
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 12:13:23 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@prodo>select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME
--------------- ---------------- ----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU
----------------- --------- ------------ --- ---------- ------- --------------- ---------- ---
DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
----------------- ------------------ --------- ---
1 prodo lnx04
11.2.0.1.0 02-OCT-15 OPEN NO 1 STOPPED ALLOWED NO
ACTIVE PRIMARY_INSTANCE NORMAL NO
SYS@prodo>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 admin]$ sqlplus system/oracle@rcat_r
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 12:14:18 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM@rcat_r>conn system/oracle@rcat_r as sysdba
Connected.
SYS@rcat_r>create tablespace rman_tbs
2 datafile '/u01/app/oracle/oradata/rcatdb/rman_tbs01.dbf' size 100m
3 autoextend on next 10m maxsize 1g
segment space management auto; 4
create tablespace rman_tbs
*
ERROR at line 1:
ORA-01119: error in creating database file '/u01/app/oracle/oradata/rcatdb/rman_tbs01.dbf'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory
SYS@rcat_r>
SYS@rcat_r>ed
Wrote file afiedt.buf
1 create tablespace rman_tbs
2 datafile '/u01/app/oracle/oradata/RCATDB/rman_tbs01.dbf' size 100m
3 autoextend on next 10m maxsize 1g
4* segment space management auto
SYS@rcat_r>/
Tablespace created.
SYS@rcat_r>create user rman_admin identified by oracle
default tablespace rman_tbs
temporary tablespace temp
quota unlimited on rman_tbs 2 3 4
5 ;
User created.
SYS@rcat_r>grant connect, resource, recovery_catalog_owner to rman_admin;
Grant succeeded.
SYS@rcat_r>conn rman_admin/oracle@rcat_r
Connected.
RMAN_ADMIN@rcat_r>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 admin]$ rman target system/oracle@prodo rman_admin/oracle@rcat_r
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01008: the bad identifier was: rman_admin
RMAN-01007: at line 2 column 1 file: command line arguments
[oracle@lnx04 admin]$ echo $ORACLE_SID
prodo
[oracle@lnx04 admin]$ cd /
[oracle@lnx04 /]$ ls -l
total 212
drwxr-xr-x 3 oracle oinstall 12288 Sep 30 22:55 ARC
drwxr-xr-x 7 oracle oinstall 4096 Oct 2 11:37 BACKUP
drwxr-xr-x 2 root root 4096 Sep 16 08:22 bin
drwxr-xr-x 4 root root 3072 Aug 7 19:11 boot
drwxr-xr-x 11 root root 4740 Oct 2 11:31 dev
drwxr-xr-x 2 oracle oinstall 4096 Sep 30 23:44 disk1
drwxr-xr-x 2 oracle oinstall 4096 Oct 2 11:39 disk2
drwxr-xr-x 2 oracle oinstall 4096 Oct 2 11:39 disk3
drwxr-xr-x 2 oracle oinstall 4096 Sep 30 22:34 disk4
drwxr-xr-x 2 oracle oinstall 4096 Sep 30 23:13 disk5
drwxr-xr-x 2 oracle oinstall 4096 Oct 2 11:55 disk6
drwxr-xr-x 101 root root 12288 Oct 2 11:31 etc
drwxr-xr-x 3 root root 4096 Sep 13 09:44 home
drwxr-xr-x 15 root root 12288 Sep 16 08:21 lib
drwx------ 2 root root 16384 Aug 7 18:59 lost+found
drwxr-xr-x 2 root root 4096 Oct 2 11:31 media
drwxr-xr-x 2 root root 0 Oct 2 11:31 misc
drwxr-xr-x 3 root root 4096 Aug 7 10:33 mnt
drwxr-xr-x 2 root root 0 Oct 2 11:31 net
drwxr-xr-x 3 root root 4096 Sep 16 07:36 opt
dr-xr-xr-x 205 root root 0 Oct 2 11:30 proc
drwxr-x--- 15 root root 4096 Oct 2 11:23 root
drwxr-xr-x 2 root root 12288 Sep 16 08:22 sbin
drwxr-xr-x 2 root root 4096 Aug 7 18:59 selinux
drwxr-xr-x 2 root root 4096 Feb 17 2010 srv
drwxr-xr-x 11 root root 0 Oct 2 11:30 sys
drwxr-xr-x 3 root root 4096 Aug 7 19:10 tftpboot
drwxrwxrwt 14 root root 4096 Oct 2 12:07 tmp
drwxr-xr-x 4 oracle oinstall 4096 Sep 16 16:40 u01
drwxr-xr-x 14 root root 4096 Aug 7 19:03 usr
drwxr-xr-x 24 root root 4096 Aug 7 19:15 var
drwxr-xr-x 3 root root 4096 Aug 7 10:31 vm
[oracle@lnx04 /]$ rman target system/oracle@prodo
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 12:20:10 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODO (DBID=1526960402)
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 /]$ rman target system/oracle@prodo rman_admin/oracle@rcat_r
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01008: the bad identifier was: rman_admin
RMAN-01007: at line 2 column 1 file: command line arguments
[oracle@lnx04 /]$ tnsping rcat_r
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 12:20:42
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = lnx04cat)(PORT = 1521))) (CONNECT_DATA = (service = DEDICATED) (sid = RCATDB)))
OK (0 msec)
[oracle@lnx04 /]$ rman target system/oracle@rcat_r
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 12:22:06 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCATDB (DBID=544690848)
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 /]$ rman target system/oracle@prodo rman_admin/oracle@rcat_r
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01008: the bad identifier was: rman_admin
RMAN-01007: at line 2 column 1 file: command line arguments
[oracle@lnx04 /]$ rman target system/oracle@prodo catalog rman_admin/oracle@rcat_r
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 12:22:47 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODO (DBID=1526960402)
connected to recovery catalog database
RMAN> create catalog tablespace "RMAN_TBS";
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
2 19 PRODO 1526960402 PARENT 1 13-AUG-09
2 4 PRODO 1526960402 CURRENT 754488 02-OCT-15
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 /]$ cd
[oracle@lnx04 ~]$ vi .bashrc
[oracle@lnx04 ~]$ . .bashrc
[oracle@lnx04 ~]$ rtcr
-bash: rtcr: command not found
[oracle@lnx04 ~]$ vi .bashrc
[oracle@lnx04 ~]$ rctr
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 12:27:47 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODO (DBID=1526960402)
connected to recovery catalog database
RMAN> exit
Recovery Manager complete.
[oracle@lnx04 ~]$ mkdir -p /BACKUP/prod/
[oracle@lnx04 ~]$ mkdir -p /ARC/prod/
[oracle@lnx04 ~]$ cd /
[oracle@lnx04 /]$ ls -al
total 228
drwxr-xr-x 34 root root 4096 Oct 2 11:31 .
drwxr-xr-x 34 root root 4096 Oct 2 11:31 ..
~
drwxr-xr-x 3 root root 4096 Aug 7 19:10 tftpboot
drwxrwxrwt 14 root root 4096 Oct 2 12:07 tmp
drwxr-xr-x 4 oracle oinstall 4096 Sep 16 16:40 u01
drwxr-xr-x 14 root root 4096 Aug 7 19:03 usr
drwxr-xr-x 24 root root 4096 Aug 7 19:15 var
drwxr-xr-x 3 root root 4096 Aug 7 10:31 vm
[oracle@lnx04 /]$ cd ARC/
[oracle@lnx04 ARC]$ ls
lost+found orcl_1_180_890551615.arc
orcl_1_100_890551615.arc orcl_1_181_890551615.arc
orcl_1_101_890551615.arc orcl_1_182_890551615.arc
orcl_1_102~
orcl_1_179_890551615.arc
[oracle@lnx04 ARC]$ ls -l
total 6039664
drwx------ 2 oracle oinstall 16384 Aug 7 18:59 lost+found
-rw-r----- 1 oracle oinstall 50630144 Sep 30 15:13 orcl_1_100_890551615.arc
-rw-r----- 1 oracle oinstall 50627584 Sep 30 15:13 orcl_1_101_890551615.arc
~51615.arc
-rw-r----- 1 oracle oinstall 50629120 Sep 30 15:11 orcl_1_98_890551615.arc
-rw-r----- 1 oracle oinstall 42748416 Sep 30 15:12 orcl_1_99_890551615.arc
drwxr-xr-x 2 oracle oinstall 4096 Oct 2 12:28 prod
[oracle@lnx04 ARC]$ exit
logout
Connection closed by foreign host.
Disconnected from remote host(sol1) at 12:28:45.
Type `help' to learn how to use Xshell prompt.
[c:\~]$
Connecting to 192.168.137.100:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
Last login: Fri Oct 2 12:07:48 2015 from 192.168.137.1
[oracle@lnx04 ~]$ echo $ORACLE_SID
orcl
[oracle@lnx04 ~]$ . oraenv
ORACLE_SID = [orcl] ? prodo
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@lnx04 ~]$ ss
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 12:29:00 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@prodo>rtcr
SP2-0042: unknown command "rtcr" - rest of line ignored.
SYS@prodo>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 ~]$ rtcr
-bash: rtcr: command not found
[oracle@lnx04 ~]$ rctr
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 12:29:16 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODO (DBID=1526960402)
connected to recovery catalog database
RMAN> show all;
RMAN configuration parameters for database with db_unique_name PRODO 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_prodo.f'; # default
RMAN> configure retention policy to recovery window of 7 days;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure default device type to disk;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure controlfile autobackup on;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure controlfile autobackup format for device type disk to '/BACKUP/prod/rman_con/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/BACKUP/prod/rman_con/%F';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure backup optimization on;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure device type disk parallelism 2;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN>
RMAN> configure channel device type disk maxpiecesize 100m format '/BACKUP/prod/%d_%s_%p';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 100 M FORMAT '/BACKUP/prod/rman/%d_%s_%p';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure maxsetsize to 2G;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 2 G;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
SYS@prodo>alter system set log_archive_format = 'prodo_%t_%s_%r.arc'scope=spfile;
System altered.
SYS@prodo>alter system set log_archive_dest_1 = 'location=/ARC/prod/' scope=spfile;
System altered.
SYS@prodo>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@prodo>ss
SP2-0042: unknown command "ss" - rest of line ignored.
SYS@prodo>startup mount
ORACLE instance started.
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 989858148 bytes
Database Buffers 704643072 bytes
Redo Buffers 11608064 bytes
Database mounted.
SYS@prodo>alter database archivelog;
Database altered.
SYS@prodo>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ARC/prod/
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5
SYS@prodo>alter database open;
Database altered.
SYS@prodo>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 ~]$ rctr
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 12:35:16 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODO (DBID=1526960402)
connected to recovery catalog database
RMAN> backup database plus archivelog;
Starting backup at 02-OCT-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=20 device type=DISK
skipping archived log file /ARC/prod/prodo_1_5_892037334.arc; already backed up 1 time(s)
skipping archived log file /ARC/prod/prodo_1_6_892037334.arc; already backed up 1 time(s)
skipping archived log file /ARC/prod/prodo_1_7_892037334.arc; already backed up 1 time(s)
skipping archived log file /ARC/prod/prodo_1_8_892037334.arc; already backed up 1 time(s)
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=5 STAMP=892039388
channel ORA_DISK_1: starting piece 1 at 02-OCT-15
channel ORA_DISK_1: finished piece 1 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_16_1 tag=TAG20151002T124309 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-OCT-15
Starting backup at 02-OCT-15
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prodo/system01.dbf
channel ORA_DISK_1: starting piece 1 at 02-OCT-15
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/prodo/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/prodo/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 02-OCT-15
channel ORA_DISK_1: finished piece 1 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_17_1 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_1: starting piece 2 at 02-OCT-15
channel ORA_DISK_2: finished piece 1 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_18_1 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_2: starting piece 2 at 02-OCT-15
channel ORA_DISK_1: finished piece 2 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_17_2 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_1: starting piece 3 at 02-OCT-15
channel ORA_DISK_2: finished piece 2 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_18_2 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_2: starting piece 3 at 02-OCT-15
channel ORA_DISK_1: finished piece 3 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_17_3 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_1: starting piece 4 at 02-OCT-15
channel ORA_DISK_2: finished piece 3 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_18_3 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_2: starting piece 4 at 02-OCT-15
channel ORA_DISK_1: finished piece 4 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_17_4 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_1: starting piece 5 at 02-OCT-15
channel ORA_DISK_2: finished piece 4 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_18_4 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_2: starting piece 5 at 02-OCT-15
channel ORA_DISK_2: finished piece 5 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_18_5 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:31
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/prodo/users01.dbf
channel ORA_DISK_2: starting piece 1 at 02-OCT-15
channel ORA_DISK_2: finished piece 1 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_19_1 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: finished piece 5 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_17_5 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_1: starting piece 6 at 02-OCT-15
channel ORA_DISK_1: finished piece 6 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_17_6 tag=TAG20151002T124311 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
Finished backup at 02-OCT-15
Starting backup at 02-OCT-15
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=6 STAMP=892039439
channel ORA_DISK_1: starting piece 1 at 02-OCT-15
channel ORA_DISK_1: finished piece 1 at 02-OCT-15
piece handle=/BACKUP/prod/PRODO_20_1 tag=TAG20151002T124400 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-OCT-15
Starting Control File and SPFILE Autobackup at 02-OCT-15
piece handle=/BACKUP/prod/rman_con/c-1526960402-20151002-01 comment=NONE
Finished Control File and SPFILE Autobackup at 02-OCT-15
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
75 Full 419.34M DISK 00:00:59 02-OCT-15
List of Datafiles in backup set 75
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 803645 02-OCT-15 /u01/app/oracle/oradata/prodo/sysaux01.dbf
3 Full 803645 02-OCT-15 /u01/app/oracle/oradata/prodo/undotbs01.dbf
Backup Set Copy #1 of backup set 75
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:59 02-OCT-15 NO TAG20151002T123640
List of Backup Pieces for backup set 75 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
81 1 AVAILABLE /BACKUP/prod/PRODO_9_1
82 2 AVAILABLE /BACKUP/prod/PRODO_9_2
83 3 AVAILABLE /BACKUP/prod/PRODO_9_3
84 4 AVAILABLE /BACKUP/prod/PRODO_9_4
85 5 AVAILABLE /BACKUP/prod/PRODO_9_5
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
76 Full 1.30M DISK 00:00:05 02-OCT-15
BP Key: 86 Status: AVAILABLE Compressed: NO Tag: TAG20151002T123640
Piece Name: /BACKUP/prod/PRODO_10_1
List of Datafiles in backup set 76
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 803668 02-OCT-15 /u01/app/oracle/oradata/prodo/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
77 Full 584.18M DISK 00:01:08 02-OCT-15
List of Datafiles in backup set 77
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 803644 02-OCT-15 /u01/app/oracle/oradata/prodo/system01.dbf
Backup Set Copy #1 of backup set 77
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:08 02-OCT-15 NO TAG20151002T123640
List of Backup Pieces for backup set 77 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
87 1 AVAILABLE /BACKUP/prod/PRODO_8_1
88 2 AVAILABLE /BACKUP/prod/PRODO_8_2
89 3 AVAILABLE /BACKUP/prod/PRODO_8_3
90 4 AVAILABLE /BACKUP/prod/PRODO_8_4
91 5 AVAILABLE /BACKUP/prod/PRODO_8_5
92 6 AVAILABLE /BACKUP/prod/PRODO_8_6
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
145 Full 419.34M DISK 00:00:30 02-OCT-15
List of Datafiles in backup set 145
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 803922 02-OCT-15 /u01/app/oracle/oradata/prodo/sysaux01.dbf
3 Full 803922 02-OCT-15 /u01/app/oracle/oradata/prodo/undotbs01.dbf
Backup Set Copy #1 of backup set 145
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:30 02-OCT-15 NO TAG20151002T124311
List of Backup Pieces for backup set 145 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
150 1 AVAILABLE /BACKUP/prod/PRODO_18_1
151 2 AVAILABLE /BACKUP/prod/PRODO_18_2
152 3 AVAILABLE /BACKUP/prod/PRODO_18_3
153 4 AVAILABLE /BACKUP/prod/PRODO_18_4
154 5 AVAILABLE /BACKUP/prod/PRODO_18_5
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
146 Full 1.30M DISK 00:00:02 02-OCT-15
BP Key: 155 Status: AVAILABLE Compressed: NO Tag: TAG20151002T124311
Piece Name: /BACKUP/prod/PRODO_19_1
List of Datafiles in backup set 146
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 803936 02-OCT-15 /u01/app/oracle/oradata/prodo/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
147 Full 584.18M DISK 00:00:44 02-OCT-15
List of Datafiles in backup set 147
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 803921 02-OCT-15 /u01/app/oracle/oradata/prodo/system01.dbf
Backup Set Copy #1 of backup set 147
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:44 02-OCT-15 NO TAG20151002T124311
List of Backup Pieces for backup set 147 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
156 1 AVAILABLE /BACKUP/prod/PRODO_17_1
157 2 AVAILABLE /BACKUP/prod/PRODO_17_2
158 3 AVAILABLE /BACKUP/prod/PRODO_17_3
159 4 AVAILABLE /BACKUP/prod/PRODO_17_4
160 5 AVAILABLE /BACKUP/prod/PRODO_17_5
161 6 AVAILABLE /BACKUP/prod/PRODO_17_6
'스터디북' 카테고리의 다른 글
| [10/03] ocp 문제 풀이 및 sol11g 설치 (0) | 2015.10.03 |
|---|---|
| [10/02] Admin2 C3-2 (0) | 2015.10.02 |
| [10/01] admin1 test admin c2 (0) | 2015.10.01 |
| [09/30] Admin 1 C 16 Admin 2 C 1 (0) | 2015.09.30 |
| [09/23] Expert Oracle Database 16장 데이터 암호화 (0) | 2015.09.23 |
