EXAMPLE:
sql>alter database tempfile 'D:\APP\PRAMOTE.L\ORADATA\DW\TEMP01.DBF' offline;
copy tempfile to new location
sql>alter database rename file 'D:\APP\PRAMOTE.L\ORADATA\DW\TEMP01.DBF' to 'E:\oradata\dw\temp01.dbf';
sql>alter database tempfile 'E:\oradata\dw\temp01.dbf' online;
Friday, March 6, 2015
Thursday, March 5, 2015
Remove GlobalProtect
Error msg
"An instance of GlobalProtect is already present on the system. Uninstall the current version before attempting to install the new version of GlobalProtect"
- Remove the registry items within the following registry path (Windows OS):
HKEY_LOCAL_MACHINE\Software\Palo Alto Networks\GlobalProtect\PanGPS
- Run the following command as an administrator from the windows cmd line:
sc delete PanGPS
- Reboot the machine
"An instance of GlobalProtect is already present on the system. Uninstall the current version before attempting to install the new version of GlobalProtect"
- Remove the registry items within the following registry path (Windows OS):
HKEY_LOCAL_MACHINE\Software\Palo Alto Networks\GlobalProtect\PanGPS
- Run the following command as an administrator from the windows cmd line:
sc delete PanGPS
- Reboot the machine
Thursday, February 19, 2015
JAVA 7u45 EMC , NETAPP , Brocade
firefox
about:config
set
security.tls.version.min to 0
Java 7 u45
comment line:
jdk.certpath.disabledAlgorithms=MD2, DSA, RSA keySize < 2048
in
C:\Program Files (x86)\Java\jre7\lib\security\java.security file
about:config
set
security.tls.version.min to 0
Java 7 u45
comment line:
jdk.certpath.disabledAlgorithms=MD2, DSA, RSA keySize < 2048
in
C:\Program Files (x86)\Java\jre7\lib\security\java.security file
Friday, February 13, 2015
Ubuntu 14.0.4.1 “intel_rapl: no valid rapl domains” message upon boot
add
blacklist intel_rapl in file
/etc/modprobe.d/blacklist.conf
Wednesday, February 11, 2015
enable webtool Brocade DS300, JAVA 1.7
comment line:
jdk.certpath.disabledAlgorithms=MD2, DSA, RSA keySize < 2048
in
C:\Program Files (x86)\Java\jre7\lib\security\java.security file
jdk.certpath.disabledAlgorithms=MD2, DSA, RSA keySize < 2048
in
C:\Program Files (x86)\Java\jre7\lib\security\java.security file
Tuesday, October 14, 2014
Clear SBT_TAPE oracle
Configure Oracle Virtual TAPE DEVICE driver
==================================
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/Path_to_backup)';
Exaple:
=======
- RMAN configure with SBT_TAPE devices
RMAN configuration parameters for database with db_unique_name MEIS are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE 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 '/oracle/products/11.2.0.2.0/db_1/dbs/snapcf_MEIS.f'; # default
- Configure SBT_TAPE DEVICE and Config CHANNEL to Virtual Disk (load oracle tape device drivers)
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/Path_to_backup)';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- SHOW Backup and Copy Image
LIST BACKUP;
LIST COPY;
- Crosscheck Backup set for marking backup set to 'EXPIRED'
CROSSCHECK BACKUP;
- Delete expired backupset
DELETE EXPIRED BACKUP;
- Show Configuration
RMAN configuration parameters for database with db_unique_name NIDAREG are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS "SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u03)";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
- Clear SBT_TAPE CHANNEL and DEVICE
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
CONFIGURE DEVICE TYPE 'SBT_TAPE' CLEAR;
- Crosscheck Backup
CROSSCHECK BACKUP;
DELETE EXPIRED BACKUP;
-Set Device
-Clear Chanel----> Device
==================================
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/Path_to_backup)';
Exaple:
=======
- RMAN configure with SBT_TAPE devices
RMAN configuration parameters for database with db_unique_name MEIS are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE 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 '/oracle/products/11.2.0.2.0/db_1/dbs/snapcf_MEIS.f'; # default
- Configure SBT_TAPE DEVICE and Config CHANNEL to Virtual Disk (load oracle tape device drivers)
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/Path_to_backup)';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- SHOW Backup and Copy Image
LIST BACKUP;
LIST COPY;
- Crosscheck Backup set for marking backup set to 'EXPIRED'
CROSSCHECK BACKUP;
- Delete expired backupset
DELETE EXPIRED BACKUP;
- Show Configuration
RMAN configuration parameters for database with db_unique_name NIDAREG are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS "SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u03)";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
- Clear SBT_TAPE CHANNEL and DEVICE
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
CONFIGURE DEVICE TYPE 'SBT_TAPE' CLEAR;
- Crosscheck Backup
CROSSCHECK BACKUP;
DELETE EXPIRED BACKUP;
-Set Device
-Clear Chanel----> Device
Thursday, October 2, 2014
Multiplex ArchiveRedolog Using NFS on Solaris 10 x86
OS: Solaris 10 x86 by NFS file share
pri-db:10.100.101.101
stb-db:10.100.101.102
same env
NFS Server Setup Solaris 10 x86:
===============================
@stb-db
- check service nfs-server
stb-db# svcs network/nfs/server
STATE STIME FMRI
online 10:43:18 svc:/network/nfs/server:default
- create directory for share ( LOG_ARCHIVE_DEST_2 on pri-db)
mkdir -p /u02/share
- add to /etc/dfs/dfstab for sharing
stb-db# more dfstab
# Place share(1M) commands here for automatic execution
# on entering init state 3.
#
# Issue the command 'svcadm enable network/nfs/server' to
# run the NFS daemon processes and the share commands, after adding
# the very first entry to this file.
#
# share [-F fstype] [ -o options] [-d "<text>"] <pathname> [resource]
# .e.g,
# share -F nfs -o rw=engineering -d "home dirs" /export/home2
share -F nfs -o rw=10.100.101.101 -d "archive dest 2" /u02/share
allow client ip 10.100.101.101 to mount nfs file server
- enable share
stb-db# shareall
stb-db# share
- /u02/share rw=10.100.101.101 "archive dest 2"
stb-db#
@pri-db
- create mount point
mkdir -p /u02/ext-arc
- mount NFS
stb-db# mount -F nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,actimeo=0,vers=3,timeo=600 10.100.101.102:/u02/share /u02/ext-arc ; option for mount "binary file" in oracle
stb-db# mount -F nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,forcedirectio,vers=3,suid 10.100.101.102:/u02/share /u02/ext-arc ; option for mount "data file" in oracle
- /etc/mnttab
pri-db# more /etc/mnttab
/dev/dsk/c1t0d0s0 / ufs rw,intr,largefiles,logging,xattr,onerror=panic,dev=840000 1412215268
/devices /devices devfs dev=4c00000 1412215258
ctfs /system/contract ctfs dev=4c80001 1412215258
proc /proc proc dev=4c40000 1412215258
mnttab /etc/mnttab mntfs dev=4cc0001 1412215258
swap /etc/svc/volatile tmpfs xattr,dev=4d00001 1412215258
objfs /system/object objfs dev=4d40001 1412215258
sharefs /etc/dfs/sharetab sharefs dev=4d80001 1412215258
/usr/lib/libc/libc_hwcap1.so.1 /lib/libc.so.1 lofs dev=840000 1412215266
fd /dev/fd fd rw,dev=4f00001 1412215268
swap /tmp tmpfs xattr,dev=4d00002 1412215274
swap /var/run tmpfs xattr,dev=4d00003 1412215274
/dev/dsk/c1t0d0s7 /export/home ufs rw,intr,largefiles,logging,xattr,onerror=panic,dev=840007 1412215275
zhome/u01 /u01 zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50002 1412215276
zdata/u02 /u02 zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50003 1412215276
zdata /zdata zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50004 1412215276
zhome /zhome zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50005 1412215276
-hosts /net autofs nosuid,indirect,ignore,nobrowse,dev=4fc0001 1412215280
auto_home /home autofs indirect,ignore,nobrowse,dev=4fc0002 1412215280
pri-db:vold(pid554) /vol nfs ignore,noquota,dev=4f80001 1412215280
10.100.101.102:/u02/share /u02/ext-arc nfs rw,bg,hard,nointr,rsize=32768,wsize=32768,actimeo=0,vers=3,timeo=600,xattr,dev=4f80005 1412225176
CLONE TO STB
============
@pri-db
:create pfile
=============
SQL> create pfile='/export/home/oracle/pfile.ora' from spfile;
(ORCL) /u01/oracle/product/11.2.0.2/dbhome_1/dbs $ more initORCL.ora
ORCL.__db_cache_size=264241152
ORCL.__java_pool_size=4194304
ORCL.__large_pool_size=4194304
ORCL.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
ORCL.__pga_aggregate_target=373293056
ORCL.__sga_target=700448768
ORCL.__shared_io_pool_size=0
ORCL.__shared_pool_size=411041792
ORCL.__streams_pool_size=4194304
*.audit_file_dest='/u01/oracle/admin/ORCL/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u02/ORCL/control01.ctl','/u01/oracle/fast_recovery_area/ORCL/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ORCL'
*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=5368709120
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.log_archive_dest_2='LOCATION=/u02/arc2'
*.log_archive_format='arc_%t_%s_%r.arc'
*.memory_target=1073741824
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
:ADD LOG_ARCHIVE_DEST_2 to NFS mount path (/u02/ext-arc)
@ORCL connect as sysdba
alter system set log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST';
alter system set log_archive_dest_2 = 'LOCATION=/u02/ext-arc';
- Flush Archive log
alter system archive log current; 3 time (redolog group)
RMAN BACKUP script; catalog dest = /u01/backup
(ORCL) /export/home/oracle/script $ more rmanbackup.script
RUN {
ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
ALLOCATE CHANNEL ch02 TYPE DISK;
ALLOCATE CHANNEL ch03 TYPE DISK;
BACKUP
TAG ORCL_DB_BACKUP
FORMAT '/u01/backup/ORCL_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
TAG ARCHIVELOG_BACKUP
FORMAT '/u01/backup/arc_ORCL_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE DISK;
BACKUP
TAG CONTROLFILE_BACKUP
FORMAT '/u01/backup/cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EXIT;
COPY Backupset to stb-db:
(ORCL) /u01/backup $ ls -rtl
total 3222869
-rw-r----- 1 oracle oinstall 9895936 Oct 2 11:49 ORCL_49_1_859895276
-rw-r----- 1 oracle oinstall 624304128 Oct 2 11:49 ORCL_47_1_859895275
-rw-r----- 1 oracle oinstall 98304 Oct 2 11:49 ORCL_50_1_859895388
-rw-r----- 1 oracle oinstall 75309056 Oct 2 11:49 ORCL_48_1_859895275
-rw-r----- 1 oracle oinstall 928931840 Oct 2 11:50 ORCL_46_1_859895275
-rw-r----- 1 oracle oinstall 55296 Oct 2 11:50 arc_ORCL_51_1_859895426
-rw-r----- 1 oracle oinstall 2560 Oct 2 11:50 arc_ORCL_52_1_859895426
-rw-r----- 1 oracle oinstall 9895936 Oct 2 11:50 cntrl_53_1_859895428
(ORCL) /u01/backup $ scp * oracle@10.100.101.102:/u01/backup
(ORCL) /export/home/oracle $ scp pfile.ora oracle@10.100.101.102:/u01/backup
========================================================================================================================================
@stb-db
=======
create OS env:
- .bash_profile
#!/bin/bash
export PS1='($ORACLE_SID) $PWD $ '
export ORACLE_BASE=/u01/oracle
export ORACLE_OWNER=oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2/dbhome_1
export PATH=$PATH:/usr/openwin/bin:$ORACLE_HOME/bin:/usr/sbin:/usr/bin
export ORACLE_SID=ORCL
- create directory for oracle datafile, fast recovery are, audit path;
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 730 SYSTEM *** /u02/test/system01.dbf
2 770 SYSAUX *** /u02/ORCL/sysaux01.dbf
3 360 UNDOTBS1 *** /u02/ORCL/undotbs01.dbf
4 450 USERS *** /u02/ORCL/users01.dbf
5 345 EXAMPLE *** /u02/test/exp.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /u02/ORCL/temp01.dbf
RMAN>
mkdir -p /u02/test/
mkdir -p /u02/ORCL/
mkdir -p /u01/oracle/admin/ORCL/adump <-----------audit path
mkdir -p /u01/oracle/fast_recovery_area <-----------fast_recovery_area
- add project
(ORCL) /export/home/oracle $ more /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::project.max-shm-memory=(priv,4294967295,deny)
Check ORACLE env:
ORACLE_BASE=/u01/oracle
ORACLE_OWNER=oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2/dbhome_1
RECOVERY:
=========
- start with pfile
SQL> startup pfile='/export/home/oracle/pfile.ora' nomount;
- create spfile
SQL> create spfile from pfile='/export/home/oracle/pfile.ora';
- restart database and startup nomount
SQL> shutdown immediate
SQL> startup nomount
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2230968 bytes
Variable Size 796919112 bytes
Database Buffers 264241152 bytes
Redo Buffers 5545984 bytes
SQL>
- connect to RMAN restore controlfile from backupset
(ORCL) /u01/backup $ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Oct 2 16:16:33 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (not mounted)
RMAN> restore controlfile from '/u01/backup/cntrl_53_1_859895428';
Starting restore at 02-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u02/ORCL/control01.ctl
output file name=/u01/oracle/fast_recovery_area/ORCL/control02.ctl
Finished restore at 02-OCT-14
RMAN>
- mount datafile
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN>
-check LOG_ARCHIVE_DEST_2 and set log archive destination to /u02/share (NFS share path)
SQL> show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string LOCATION=/u02/share
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string arc_%t_%s_%r.arc
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 5275648
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
SQL>
SQL> alter system set log_archive_dest_2 = 'LOCATION=/u02/share'; <---------- set LOG ARCHIVE DEST
- restart DATABASE and startup mount
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2230968 bytes
Variable Size 796919112 bytes
Database Buffers 264241152 bytes
Redo Buffers 5545984 bytes
Database mounted.
SQL>
- catalog backup set
(ORCL) /u01/backup $ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Oct 2 16:27:08 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1378426121, not open)
RMAN> catalog start with '/u01/backup';
Starting implicit crosscheck backup at 02-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
Crosschecked 7 objects
Finished implicit crosscheck backup at 02-OCT-14
Starting implicit crosscheck copy at 02-OCT-14
using channel ORA_DISK_1
Crosschecked 3 objects
Finished implicit crosscheck copy at 02-OCT-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/oracle/fast_recovery_area/ORCL/autobackup/2014_10_02/o1_mf_s_859890781_b2skvftz_.bkp
File Name: /u01/oracle/fast_recovery_area/ORCL/autobackup/2014_10_02/o1_mf_s_859889245_b2sjcg4f_.bkp
searching for all files that match the pattern /u01/backup
List of Files Unknown to the Database
=====================================
File Name: /u01/backup/cntrl_53_1_859895428
Do you really want to catalog the above files (enter YES or NO)? Y
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/backup/cntrl_53_1_859895428
RMAN>
- restore database(datafile);
RMAN> restore database;
Starting restore at 02-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u02/ORCL/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/ORCL_47_1_859895275
channel ORA_DISK_1: piece handle=/u01/backup/ORCL_47_1_859895275 tag=ORCL_DB_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /u02/ORCL/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u02/test/exp.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/ORCL_48_1_859895275
channel ORA_DISK_1: piece handle=/u01/backup/ORCL_48_1_859895275 tag=ORCL_DB_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u02/test/system01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u02/ORCL/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/ORCL_46_1_859895275
channel ORA_DISK_1: piece handle=/u01/backup/ORCL_46_1_859895275 tag=ORCL_DB_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 02-OCT-14
RMAN>
- recover database; apply transection log from archive log
RMAN> recover database;
Starting recover at 02-OCT-14
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=159
channel ORA_DISK_1: reading from backup piece /u01/backup/arc_ORCL_51_1_859895426
channel ORA_DISK_1: piece handle=/u01/backup/arc_ORCL_51_1_859895426 tag=ARCHIVELOG_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u02/share/arc_1_159_850645387.arc thread=1 sequence=159
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=160
channel ORA_DISK_1: reading from backup piece /u01/backup/arc_ORCL_52_1_859895426
channel ORA_DISK_1: piece handle=/u01/backup/arc_ORCL_52_1_859895426 tag=ARCHIVELOG_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u02/share/arc_1_160_850645387.arc thread=1 sequence=160
archived log file name=/u02/share/arc_1_161_850645387.arc thread=1 sequence=161
archived log file name=/u02/share/arc_1_162_850645387.arc thread=1 sequence=162
archived log file name=/u02/share/arc_1_163_850645387.arc thread=1 sequence=163
archived log file name=/u02/share/arc_1_164_850645387.arc thread=1 sequence=164
archived log file name=/u02/share/arc_1_165_850645387.arc thread=1 sequence=165
archived log file name=/u02/share/arc_1_166_850645387.arc thread=1 sequence=166
archived log file name=/u02/share/arc_1_167_850645387.arc thread=1 sequence=167 <----------------------------------------- last change#
unable to find archived log
archived log thread=1 sequence=168
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/02/2014 16:31:46
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 168 and starting SCN of 4393749
RMAN>
(ORCL) /u01/backup $ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 2 16:32:43 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/share
Oldest online log sequence 159
Next log sequence to archive 161
Current log sequence 161<------------------------------------------------------------------------------------------- first change#
SQL>
note: RMAN applied transection log no.161 to log no.167 from archive log
- open database resetlogs
SQL> alter database open resetlogs;
Database altered.
SQL
note: database must open resetlogs b'coz datafile inconsistent (datafile , redolog, controlfile, archivelog)
- LOG will be reset
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/share
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
SQL>
Check data:
==========
@stb-db
(ORCL) /u01/backup $ sqlplus aaa
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 2 16:39:10 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
B TABLE
C TABLE
D TABLE
E TABLE
SQL> select count(*) from E;
COUNT(*)
----------
1170304
SQL>
@pri-db
(ORCL) /export/home/oracle $ sqlplus aaa
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 2 16:42:57 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
B TABLE
C TABLE
D TABLE
E TABLE
SQL> select count(*) from E;
COUNT(*)
----------
1170304
SQL>
ref:http://solaris10commands.blogspot.com/2010/09/configuring-network-file-system-in.html
pri-db:10.100.101.101
stb-db:10.100.101.102
same env
NFS Server Setup Solaris 10 x86:
===============================
@stb-db
- check service nfs-server
stb-db# svcs network/nfs/server
STATE STIME FMRI
online 10:43:18 svc:/network/nfs/server:default
- create directory for share ( LOG_ARCHIVE_DEST_2 on pri-db)
mkdir -p /u02/share
- add to /etc/dfs/dfstab for sharing
stb-db# more dfstab
# Place share(1M) commands here for automatic execution
# on entering init state 3.
#
# Issue the command 'svcadm enable network/nfs/server' to
# run the NFS daemon processes and the share commands, after adding
# the very first entry to this file.
#
# share [-F fstype] [ -o options] [-d "<text>"] <pathname> [resource]
# .e.g,
# share -F nfs -o rw=engineering -d "home dirs" /export/home2
share -F nfs -o rw=10.100.101.101 -d "archive dest 2" /u02/share
allow client ip 10.100.101.101 to mount nfs file server
- enable share
stb-db# shareall
stb-db# share
- /u02/share rw=10.100.101.101 "archive dest 2"
stb-db#
@pri-db
- create mount point
mkdir -p /u02/ext-arc
- mount NFS
stb-db# mount -F nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,actimeo=0,vers=3,timeo=600 10.100.101.102:/u02/share /u02/ext-arc ; option for mount "binary file" in oracle
stb-db# mount -F nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,forcedirectio,vers=3,suid 10.100.101.102:/u02/share /u02/ext-arc ; option for mount "data file" in oracle
- /etc/mnttab
pri-db# more /etc/mnttab
/dev/dsk/c1t0d0s0 / ufs rw,intr,largefiles,logging,xattr,onerror=panic,dev=840000 1412215268
/devices /devices devfs dev=4c00000 1412215258
ctfs /system/contract ctfs dev=4c80001 1412215258
proc /proc proc dev=4c40000 1412215258
mnttab /etc/mnttab mntfs dev=4cc0001 1412215258
swap /etc/svc/volatile tmpfs xattr,dev=4d00001 1412215258
objfs /system/object objfs dev=4d40001 1412215258
sharefs /etc/dfs/sharetab sharefs dev=4d80001 1412215258
/usr/lib/libc/libc_hwcap1.so.1 /lib/libc.so.1 lofs dev=840000 1412215266
fd /dev/fd fd rw,dev=4f00001 1412215268
swap /tmp tmpfs xattr,dev=4d00002 1412215274
swap /var/run tmpfs xattr,dev=4d00003 1412215274
/dev/dsk/c1t0d0s7 /export/home ufs rw,intr,largefiles,logging,xattr,onerror=panic,dev=840007 1412215275
zhome/u01 /u01 zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50002 1412215276
zdata/u02 /u02 zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50003 1412215276
zdata /zdata zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50004 1412215276
zhome /zhome zfs rw,devices,setuid,nonbmand,exec,rstchown,xattr,atime,dev=2d50005 1412215276
-hosts /net autofs nosuid,indirect,ignore,nobrowse,dev=4fc0001 1412215280
auto_home /home autofs indirect,ignore,nobrowse,dev=4fc0002 1412215280
pri-db:vold(pid554) /vol nfs ignore,noquota,dev=4f80001 1412215280
10.100.101.102:/u02/share /u02/ext-arc nfs rw,bg,hard,nointr,rsize=32768,wsize=32768,actimeo=0,vers=3,timeo=600,xattr,dev=4f80005 1412225176
CLONE TO STB
============
@pri-db
:create pfile
=============
SQL> create pfile='/export/home/oracle/pfile.ora' from spfile;
(ORCL) /u01/oracle/product/11.2.0.2/dbhome_1/dbs $ more initORCL.ora
ORCL.__db_cache_size=264241152
ORCL.__java_pool_size=4194304
ORCL.__large_pool_size=4194304
ORCL.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
ORCL.__pga_aggregate_target=373293056
ORCL.__sga_target=700448768
ORCL.__shared_io_pool_size=0
ORCL.__shared_pool_size=411041792
ORCL.__streams_pool_size=4194304
*.audit_file_dest='/u01/oracle/admin/ORCL/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u02/ORCL/control01.ctl','/u01/oracle/fast_recovery_area/ORCL/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ORCL'
*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=5368709120
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.log_archive_dest_2='LOCATION=/u02/arc2'
*.log_archive_format='arc_%t_%s_%r.arc'
*.memory_target=1073741824
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
:ADD LOG_ARCHIVE_DEST_2 to NFS mount path (/u02/ext-arc)
@ORCL connect as sysdba
alter system set log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST';
alter system set log_archive_dest_2 = 'LOCATION=/u02/ext-arc';
- Flush Archive log
alter system archive log current; 3 time (redolog group)
RMAN BACKUP script; catalog dest = /u01/backup
(ORCL) /export/home/oracle/script $ more rmanbackup.script
RUN {
ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
ALLOCATE CHANNEL ch02 TYPE DISK;
ALLOCATE CHANNEL ch03 TYPE DISK;
BACKUP
TAG ORCL_DB_BACKUP
FORMAT '/u01/backup/ORCL_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
TAG ARCHIVELOG_BACKUP
FORMAT '/u01/backup/arc_ORCL_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE DISK;
BACKUP
TAG CONTROLFILE_BACKUP
FORMAT '/u01/backup/cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EXIT;
COPY Backupset to stb-db:
(ORCL) /u01/backup $ ls -rtl
total 3222869
-rw-r----- 1 oracle oinstall 9895936 Oct 2 11:49 ORCL_49_1_859895276
-rw-r----- 1 oracle oinstall 624304128 Oct 2 11:49 ORCL_47_1_859895275
-rw-r----- 1 oracle oinstall 98304 Oct 2 11:49 ORCL_50_1_859895388
-rw-r----- 1 oracle oinstall 75309056 Oct 2 11:49 ORCL_48_1_859895275
-rw-r----- 1 oracle oinstall 928931840 Oct 2 11:50 ORCL_46_1_859895275
-rw-r----- 1 oracle oinstall 55296 Oct 2 11:50 arc_ORCL_51_1_859895426
-rw-r----- 1 oracle oinstall 2560 Oct 2 11:50 arc_ORCL_52_1_859895426
-rw-r----- 1 oracle oinstall 9895936 Oct 2 11:50 cntrl_53_1_859895428
(ORCL) /u01/backup $ scp * oracle@10.100.101.102:/u01/backup
(ORCL) /export/home/oracle $ scp pfile.ora oracle@10.100.101.102:/u01/backup
========================================================================================================================================
@stb-db
=======
create OS env:
- .bash_profile
#!/bin/bash
export PS1='($ORACLE_SID) $PWD $ '
export ORACLE_BASE=/u01/oracle
export ORACLE_OWNER=oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2/dbhome_1
export PATH=$PATH:/usr/openwin/bin:$ORACLE_HOME/bin:/usr/sbin:/usr/bin
export ORACLE_SID=ORCL
- create directory for oracle datafile, fast recovery are, audit path;
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 730 SYSTEM *** /u02/test/system01.dbf
2 770 SYSAUX *** /u02/ORCL/sysaux01.dbf
3 360 UNDOTBS1 *** /u02/ORCL/undotbs01.dbf
4 450 USERS *** /u02/ORCL/users01.dbf
5 345 EXAMPLE *** /u02/test/exp.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /u02/ORCL/temp01.dbf
RMAN>
mkdir -p /u02/test/
mkdir -p /u02/ORCL/
mkdir -p /u01/oracle/admin/ORCL/adump <-----------audit path
mkdir -p /u01/oracle/fast_recovery_area <-----------fast_recovery_area
- add project
(ORCL) /export/home/oracle $ more /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::project.max-shm-memory=(priv,4294967295,deny)
Check ORACLE env:
ORACLE_BASE=/u01/oracle
ORACLE_OWNER=oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2/dbhome_1
RECOVERY:
=========
- start with pfile
SQL> startup pfile='/export/home/oracle/pfile.ora' nomount;
- create spfile
SQL> create spfile from pfile='/export/home/oracle/pfile.ora';
- restart database and startup nomount
SQL> shutdown immediate
SQL> startup nomount
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2230968 bytes
Variable Size 796919112 bytes
Database Buffers 264241152 bytes
Redo Buffers 5545984 bytes
SQL>
- connect to RMAN restore controlfile from backupset
(ORCL) /u01/backup $ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Oct 2 16:16:33 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (not mounted)
RMAN> restore controlfile from '/u01/backup/cntrl_53_1_859895428';
Starting restore at 02-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u02/ORCL/control01.ctl
output file name=/u01/oracle/fast_recovery_area/ORCL/control02.ctl
Finished restore at 02-OCT-14
RMAN>
- mount datafile
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN>
-check LOG_ARCHIVE_DEST_2 and set log archive destination to /u02/share (NFS share path)
SQL> show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string LOCATION=/u02/share
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string arc_%t_%s_%r.arc
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 5275648
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
SQL>
SQL> alter system set log_archive_dest_2 = 'LOCATION=/u02/share'; <---------- set LOG ARCHIVE DEST
- restart DATABASE and startup mount
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2230968 bytes
Variable Size 796919112 bytes
Database Buffers 264241152 bytes
Redo Buffers 5545984 bytes
Database mounted.
SQL>
- catalog backup set
(ORCL) /u01/backup $ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Oct 2 16:27:08 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1378426121, not open)
RMAN> catalog start with '/u01/backup';
Starting implicit crosscheck backup at 02-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
Crosschecked 7 objects
Finished implicit crosscheck backup at 02-OCT-14
Starting implicit crosscheck copy at 02-OCT-14
using channel ORA_DISK_1
Crosschecked 3 objects
Finished implicit crosscheck copy at 02-OCT-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/oracle/fast_recovery_area/ORCL/autobackup/2014_10_02/o1_mf_s_859890781_b2skvftz_.bkp
File Name: /u01/oracle/fast_recovery_area/ORCL/autobackup/2014_10_02/o1_mf_s_859889245_b2sjcg4f_.bkp
searching for all files that match the pattern /u01/backup
List of Files Unknown to the Database
=====================================
File Name: /u01/backup/cntrl_53_1_859895428
Do you really want to catalog the above files (enter YES or NO)? Y
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/backup/cntrl_53_1_859895428
RMAN>
- restore database(datafile);
RMAN> restore database;
Starting restore at 02-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u02/ORCL/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/ORCL_47_1_859895275
channel ORA_DISK_1: piece handle=/u01/backup/ORCL_47_1_859895275 tag=ORCL_DB_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /u02/ORCL/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u02/test/exp.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/ORCL_48_1_859895275
channel ORA_DISK_1: piece handle=/u01/backup/ORCL_48_1_859895275 tag=ORCL_DB_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u02/test/system01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u02/ORCL/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/ORCL_46_1_859895275
channel ORA_DISK_1: piece handle=/u01/backup/ORCL_46_1_859895275 tag=ORCL_DB_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 02-OCT-14
RMAN>
- recover database; apply transection log from archive log
RMAN> recover database;
Starting recover at 02-OCT-14
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=159
channel ORA_DISK_1: reading from backup piece /u01/backup/arc_ORCL_51_1_859895426
channel ORA_DISK_1: piece handle=/u01/backup/arc_ORCL_51_1_859895426 tag=ARCHIVELOG_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u02/share/arc_1_159_850645387.arc thread=1 sequence=159
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=160
channel ORA_DISK_1: reading from backup piece /u01/backup/arc_ORCL_52_1_859895426
channel ORA_DISK_1: piece handle=/u01/backup/arc_ORCL_52_1_859895426 tag=ARCHIVELOG_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u02/share/arc_1_160_850645387.arc thread=1 sequence=160
archived log file name=/u02/share/arc_1_161_850645387.arc thread=1 sequence=161
archived log file name=/u02/share/arc_1_162_850645387.arc thread=1 sequence=162
archived log file name=/u02/share/arc_1_163_850645387.arc thread=1 sequence=163
archived log file name=/u02/share/arc_1_164_850645387.arc thread=1 sequence=164
archived log file name=/u02/share/arc_1_165_850645387.arc thread=1 sequence=165
archived log file name=/u02/share/arc_1_166_850645387.arc thread=1 sequence=166
archived log file name=/u02/share/arc_1_167_850645387.arc thread=1 sequence=167 <----------------------------------------- last change#
unable to find archived log
archived log thread=1 sequence=168
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/02/2014 16:31:46
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 168 and starting SCN of 4393749
RMAN>
(ORCL) /u01/backup $ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 2 16:32:43 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/share
Oldest online log sequence 159
Next log sequence to archive 161
Current log sequence 161<------------------------------------------------------------------------------------------- first change#
SQL>
note: RMAN applied transection log no.161 to log no.167 from archive log
- open database resetlogs
SQL> alter database open resetlogs;
Database altered.
SQL
note: database must open resetlogs b'coz datafile inconsistent (datafile , redolog, controlfile, archivelog)
- LOG will be reset
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/share
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
SQL>
Check data:
==========
@stb-db
(ORCL) /u01/backup $ sqlplus aaa
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 2 16:39:10 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
B TABLE
C TABLE
D TABLE
E TABLE
SQL> select count(*) from E;
COUNT(*)
----------
1170304
SQL>
@pri-db
(ORCL) /export/home/oracle $ sqlplus aaa
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 2 16:42:57 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
B TABLE
C TABLE
D TABLE
E TABLE
SQL> select count(*) from E;
COUNT(*)
----------
1170304
SQL>
ref:http://solaris10commands.blogspot.com/2010/09/configuring-network-file-system-in.html
Subscribe to:
Posts (Atom)