Friday 30 October 2015

How to start ENQUEUE and DEQUEUE in Oracle 

-- Start a queue and enable both enqueue and dequeue
EXECUTE dbms_aqadm.start_queue (
   queue_name         => 'msg_queue');





-- Start a previously stopped queue for dequeue only
EXECUTE dbms_aqadm.start_queue ( 
   queue_name         => 'msg_queue', 
   dequeue            => TRUE, 
   enqueue            => FALSE);



-- Start enqueue after dequeue also
EXECUTE dbms_aqadm.start_queue ( 
   queue_name         => 'msg_queue', 
   dequeue            => FALSE,  -- dequeue won't be stopped even if this is FALSE
   enqueue            => TRUE);
Posted by at No comments:

Saturday 10 October 2015

Password Less Connectivity in Unix

PASSWORD LESS CONNECTIVITY BETWEEN SOURCE and TARGET SYSTEM
1.       As the oracle user on source system
$cd ~
2.       Check if a DSA key pair already exist or not.

$ ls -l ~/.ssh/id_dsa*
-rw-------   1 oracle   dba          668 Aug 12 13:37 /export/home/oracle/.ssh/id_dsa
-rw-r--r--   1 oracle   dba          612 Aug 12 13:37 /export/home/oracle/.ssh/id_dsa.pub

3.       In this case they do, but if not create them as follows. DON’T enter a passphrase when prompted, just carriage return.
$ ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/export/home/oracle/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /export/home/oracle/.ssh/id_dsa.
Your public key has been saved in /export/home/oracle/.ssh/id_dsa.pub.
The key fingerprint is:
77:82:79:d0:5d:8g:d3:52:16:35:fc:47:8d:cd:0c:a8 oracle@targetserver

4.       You will now have a public/private key pair in ~/.ssh
~/.ssh/id_dsa
~/.ssh/id_dsa.pub

5.       Appended the contents of the to the id_dsa.pub file to the destination Target server named  ~.ssh/authorized_keys  file. If authorised_keys does not exist create it.

6.       You need to make sure permissions of ~/.ssh is 700 and ~.ssh/authorized_keys  600.

oracle@ Targetserver$ cat .ssh/authorized_keys
ssh-dss AAAAB3NzaC1kc3MAAACBAP9ocz3cl3Ykx3BYjWN9Zyz44nHTggwkVsqK+dsdfdsfdsf+sWNFpD3bwAAAIBw+/BQm60zOk24PQnvCiNKdfcsdfds+rS9lpgT66tfHe3mCZRjj9+USCNt4Vw2BbmVvVazapx/NTAnoESLcAI+cvsddsf+I+FosFhrblvDqYmzRRdllbmqVoG4JGysjqEepKxhHaGlPtkYu/E15yFa4lfPg== oracle@sourceservername

7.  oracle@Targetserve$ ls -ld .ssh
drwx------   2 oracle   oinstall       6 Aug 12 13:37 .ssh

oracle@Targetserve$ ls -l .ssh/authorized_keys
-rw-------   1 oracle   oinstall     612 Aug 12 13:37 .ssh/authorized_keys

8. Test  SSH without a password.
Posted by at No comments:

Friday 2 October 2015

RMAN ACTIVE DATABSE DUPLICATION/NETWORK BASED DUPLICATION

Creation of Database same as it in source DB by using Active database duplication.
Prerequisite:-
1. Oracle_home is already created.
2. Oracle Binary already copied.
SOurce DB:- Amer(192.168.1.111)
Target DB:-euro(192.168.1.112)
On source DB perform.
[oracle@amer 11.2.0]$ . oraenv
ORACLE_SID = [oracle] ? amer
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@amer 11.2.0]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 10:10:13 2015
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Enter user-name: /as sysdba
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
SQL> select name from V$database;
NAME
---------
AMER


SQL> select name from V$controlfile;
NAME
--------------------------------------------------------------------------------
/u02/amer/redologcontrol/control01.ctl
/u02/amer/redologcontrol/control02.ctl


SQL> select member from V$logfile;
MEMBER
--------------------------------------------------------------------------------
/u02/amer/redologcontrol/redo01.log
/u02/amer/redologcontrol/redo02.log
/u02/amer/redologcontrol/redo03.log
SQL> select name from V$datafile;
NAME
--------------------------------------------------------------------------------
/u05/amer/oradata/amer/system01.dbf
/u05/amer/oradata/amer/sysaux01.dbf
/u05/amer/oradata/amer/undotbs01.dbf
/u05/amer/oradata/amer/users01.dbf
SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                /dbhome_1/dbs/spfileamer.ora
SQL> create pfile from spfile;
File created.
SQL> 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@amer 11.2.0]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
[oracle@amer dbs]$ ls -lrth
total 36K
-rw-r--r-- 1 oracle oinstall 2.8K May 15  2009 init.ora
drwx------ 2 oracle oinstall 4.0K Sep 27 23:43 peshm_DBUA0_0
-rw-rw---- 1 oracle oinstall 1.6K Sep 27 23:43 hc_DBUA0.dat
drwx------ 2 oracle oinstall 4.0K Sep 27 23:56 peshm_amer_0
-rw-r----- 1 oracle oinstall   24 Sep 27 23:56 lkAMER
-rw-rw---- 1 oracle oinstall 1.6K Sep 28 23:49 hc_amer.dat
-rw-r----- 1 oracle oinstall 1.5K Sep 28 23:50 orapwamer
-rw-r----- 1 oracle oinstall 2.5K Oct  2 10:08 spfileamer.ora
-rw-r--r-- 1 oracle oinstall  973 Oct  2 10:11 initamer.ora
[oracle@amer dbs]$ scp initamer.ora oracle@192.168.1.112:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
oracle@192.168.1.112's password:
initamer.ora                                                   100%  973     1.0KB/s   00:00    
[oracle@amer dbs]$
[oracle@amer dbs]$


On TARGET DB
===========
1. Create all the directories structure

mkdir -p /u02/euro/redologcontrol ---- For Redo log file and Control file
mkdir -p /u03/euro/archivelog -- for archive log file
mkdir -p /u04/euro/backup -- for Backup
mkdir -p /u05/euro/oradata/ -- for database file
chown -R oracle:oinstall /u02 /u03 /u04 /u05
chmod -R 0775 /u01 /u02 /u03 /u04 /u05
mkdir -p /u01/app/oracle/admin/euro/adump
mkdir -p /u01/app/oracle/flash_recovery_area/


2. change the amer database parameter file according to euro database.


[oracle@euro ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
[oracle@euro dbs]$ ls -lrth
total 36K
-rw-r--r-- 1 oracle oinstall 2.8K May 15  2009 init.ora
drwx------ 2 oracle oinstall 4.0K Sep 27 23:43 peshm_DBUA0_0
-rw-r----- 1 oracle oinstall 1.6K Sep 27 23:43 hc_DBUA0.dat
-rw-r--r-- 1 oracle oinstall  973 Oct  2 10:12 initamer.ora
[oracle@euro dbs]$ cp initamer.ora initeuro.ora
[oracle@euro dbs]$ rm -r *amer*---------------------TO delet file related to amer DB
[oracle@euro dbs]$ ls -lrth
total 20K
-rw-r--r-- 1 oracle oinstall 2.8K May 15  2009 init.ora
drwx------ 2 oracle oinstall 4.0K Sep 27 23:43 peshm_DBUA0_0
-rw-r----- 1 oracle oinstall 1.6K Sep 27 23:43 hc_DBUA0.dat
-rw-r--r-- 1 oracle oinstall  973 Oct  2 10:17 initeuro.ora
3.Edit initeuro.ora file
*.audit_file_dest='/u01/app/oracle/admin/euro/adump'
*.control_files='/u02/euro/redologcontrol/control01.ctl','/u02/euro/redologcontrol/control02.ctl'
*.db_name='euro'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=euroXDB)'
*.log_archive_dest_1='LOCATION=/u03/euro/archivelog'
DB_FILE_name_CONVERT=('/u05/amer/oradata/amer', '/u05/euro/oradata')
LOG_FILE_NAME_CONVERT=( '/u02/amer/redologcontrol','/u02/euro/redologcontrol')
4. create sid and password file
[oracle@euro admin]$ export oracle_sid=euro
[oracle@euro admin]$ . oraenv
ORACLE_SID = [oracle] ? euro
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome_1/
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/ is /u01/app/oracle
SCP password file from source /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ to target server /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
$mv orapwamer orapwweuro
5.>Startup database in nomount
[oracle@euro admin]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 10:34:47 2015
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area  828608512 bytes
Fixed Size                  1339684 bytes
Variable Size             490737372 bytes
Database Buffers          331350016 bytes
Redo Buffers                5181440 bytes
SQL>
6>Creation of Listener .
cle@euro bin]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/bin
[oracle@euro bin]$ netmgr
click plus button






7> startup listener
[oracle@euro admin]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 10:46:39
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/euro/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.112)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.112)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                02-OCT-2015 10:46:40
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/euro/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.112)(PORT=1521)))
Services Summary...
Service "euro" has 1 instance(s).
 Instance "euro", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>








8>Make entries of euro and amer databases in tnsnames.ora file
[oracle@euro admin]$ vi tnsnames.ora
[oracle@euro admin]$ cat tnsnames.ora
EURO =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.112)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = euro)
   )
 )
AMER =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = amer)
   )
 )
9>Make the entry of euro database in soure DB
[oracle@amer admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EURO =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.112)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = euro)
   )
 )
10>Check command tnsping command on both the server.
TNSPING FROM AMER SERVER
[oracle@amer admin]$ tnsping euro
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 10:58:40
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 = 192.168.1.112)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = euro)))
OK (0 msec)



[oracle@amer admin]$ tnsping amer
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 10:58:43
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 = 192.168.1.111)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = amer)))
OK (0 msec)



TNSPING FROM EURO SERVER
[oracle@euro admin]$ tnsping euro
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 10:58:26
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 = 192.168.1.112)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = euro)))
OK (0 msec)


[oracle@euro admin]$ tnsping amer
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-OCT-2015 10:58:30
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 = 192.168.1.111)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = amer)))
OK (0 msec)
11.Run RMAN Active duplication command
[oracle@euro admin]$ rman target sys/oracle@amer auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 11:09:22 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: AMER (DBID=1314861233)
connected to auxiliary database (not started)


RMAN> DUPLICATE TARGET DATABASE  TO 'euro' FROM ACTIVE DATABASE ;
Starting Duplicate Db at 02-OCT-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
contents of Memory Script:
{
  sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
  shutdown clone immediate;
  startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area     828608512 bytes
Fixed Size                     1339684 bytes
Variable Size                490737372 bytes
Database Buffers             331350016 bytes
Redo Buffers                   5181440 bytes
contents of Memory Script:
{
  sql clone "alter system set  db_name =
''AMER'' comment=
''Modified by RMAN duplicate'' scope=spfile";
  sql clone "alter system set  db_unique_name =
''EURO'' comment=
''Modified by RMAN duplicate'' scope=spfile";
  shutdown clone immediate;
  startup clone force nomount
  backup as copy current controlfile auxiliary format  '/u02/euro/redologcontrol/control01.ctl';
  restore clone controlfile to  '/u02/euro/redologcontrol/control02.ctl' from
'/u02/euro/redologcontrol/control01.ctl';
  alter clone database mount;
}
executing Memory Script
sql statement: alter system set  db_name =  ''AMER'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set  db_unique_name =  ''EURO'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area     828608512 bytes
Fixed Size                     1339684 bytes
Variable Size                490737372 bytes
Database Buffers             331350016 bytes
Redo Buffers                   5181440 bytes
Starting backup at 02-OCT-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=74 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_amer.f tag=TAG20151002T114719 RECID=1 STAMP=892036040
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 02-OCT-15
Starting restore at 02-OCT-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 02-OCT-15
database mounted
contents of Memory Script:
{
  set newname for datafile  1 to
"/u05/euro/oradata/system01.dbf";
  set newname for datafile  2 to
"/u05/euro/oradata/sysaux01.dbf";
  set newname for datafile  3 to
"/u05/euro/oradata/undotbs01.dbf";
  set newname for datafile  4 to
"/u05/euro/oradata/users01.dbf";
  backup as copy reuse
  datafile  1 auxiliary format
"/u05/euro/oradata/system01.dbf"   datafile
2 auxiliary format
"/u05/euro/oradata/sysaux01.dbf"   datafile
3 auxiliary format
"/u05/euro/oradata/undotbs01.dbf"   datafile
4 auxiliary format
"/u05/euro/oradata/users01.dbf"   ;
  sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 02-OCT-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u05/amer/oradata/amer/system01.dbf
output file name=/u05/euro/oradata/system01.dbf tag=TAG20151002T114729
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:52
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u05/amer/oradata/amer/sysaux01.dbf
output file name=/u05/euro/oradata/sysaux01.dbf tag=TAG20151002T114729
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:49
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u05/amer/oradata/amer/undotbs01.dbf
output file name=/u05/euro/oradata/undotbs01.dbf tag=TAG20151002T114729
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u05/amer/oradata/amer/users01.dbf
output file name=/u05/euro/oradata/users01.dbf tag=TAG20151002T114729
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:04
Finished backup at 02-OCT-15
sql statement: alter system archive log current
contents of Memory Script:
{
  backup as copy reuse
  archivelog like  "/u03/amer/archivelog/1_70_891561393.dbf" auxiliary format
"/u03/euro/archivelog/1_70_891561393.dbf"   ;
  catalog clone archivelog  "/u03/euro/archivelog/1_70_891561393.dbf";
  switch clone datafile all;
}
executing Memory Script
Starting backup at 02-OCT-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=70 RECID=5 STAMP=892036191
output file name=/u03/euro/archivelog/1_70_891561393.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 02-OCT-15
cataloged archived log
archived log file name=/u03/euro/archivelog/1_70_891561393.dbf RECID=5 STAMP=892036193
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=892036194 file name=/u05/euro/oradata/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=892036194 file name=/u05/euro/oradata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=892036194 file name=/u05/euro/oradata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=892036194 file name=/u05/euro/oradata/users01.dbf
contents of Memory Script:
{
  set until scn  650045;
  recover
  clone database
   delete archivelog
  ;
}
executing Memory Script
executing command: SET until clause
Starting recover at 02-OCT-15
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 70 is already on disk as file /u03/euro/archivelog/1_70_891561393.dbf
archived log file name=/u03/euro/archivelog/1_70_891561393.dbf thread=1 sequence=70
media recovery complete, elapsed time: 00:00:01
Finished recover at 02-OCT-15
contents of Memory Script:
{
  shutdown clone immediate;
  startup clone nomount;
  sql clone "alter system set  db_name =
''EURO'' comment=
''Reset to original value by RMAN'' scope=spfile";
  sql clone "alter system reset  db_unique_name scope=spfile";
  shutdown clone immediate;
  startup clone nomount;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area     828608512 bytes
Fixed Size                     1339684 bytes
Variable Size                490737372 bytes
Database Buffers             331350016 bytes
Redo Buffers                   5181440 bytes
sql statement: alter system set  db_name =  ''EURO'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area     828608512 bytes
Fixed Size                     1339684 bytes
Variable Size                490737372 bytes
Database Buffers             331350016 bytes
Redo Buffers                   5181440 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "EURO" RESETLOGS ARCHIVELOG
 MAXLOGFILES     16
 MAXLOGMEMBERS      3
 MAXDATAFILES      100
 MAXINSTANCES     8
 MAXLOGHISTORY      292
LOGFILE
 GROUP  1 ( '/u02/euro/redologcontrol/redo01.log' ) SIZE 50 M  REUSE,
 GROUP  2 ( '/u02/euro/redologcontrol/redo02.log' ) SIZE 50 M  REUSE,
 GROUP  3 ( '/u02/euro/redologcontrol/redo03.log' ) SIZE 50 M  REUSE
DATAFILE
 '/u05/euro/oradata/system01.dbf'
CHARACTER SET WE8MSWIN1252


contents of Memory Script:
{
  set newname for tempfile  1 to
"/u05/euro/oradata/temp01.dbf";
  switch clone tempfile all;
  catalog clone datafilecopy  "/u05/euro/oradata/sysaux01.dbf",
"/u05/euro/oradata/undotbs01.dbf",
"/u05/euro/oradata/users01.dbf";
  switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u05/euro/oradata/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u05/euro/oradata/sysaux01.dbf RECID=1 STAMP=892036279
cataloged datafile copy
datafile copy file name=/u05/euro/oradata/undotbs01.dbf RECID=2 STAMP=892036279
cataloged datafile copy
datafile copy file name=/u05/euro/oradata/users01.dbf RECID=3 STAMP=892036279
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=892036279 file name=/u05/euro/oradata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=892036279 file name=/u05/euro/oradata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=892036279 file name=/u05/euro/oradata/users01.dbf
contents of Memory Script:
{
  Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 02-OCT-15
RMAN>

RMAN>

RMAN> exit
12> Check location of Logfile,archive log file,data file,control file and redo log file
Recovery Manager complete.
[oracle@euro admin]$ . oraenv
ORACLE_SID = [euro] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@euro admin]$ sqplus
bash: sqplus: command not found
[oracle@euro admin]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 11:58:03 2015
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Enter user-name: /as sysdba
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
SQL> select name,open_mode from V$database;
NAME      OPEN_MODE
--------- --------------------
EURO      READ WRITE
SQL> select name from V$datafile;
NAME
--------------------------------------------------------------------------------
/u05/euro/oradata/system01.dbf
/u05/euro/oradata/sysaux01.dbf
/u05/euro/oradata/undotbs01.dbf
/u05/euro/oradata/users01.dbf
SQL> select name from V$controlfile;
NAME
--------------------------------------------------------------------------------
/u02/euro/redologcontrol/control01.ctl
/u02/euro/redologcontrol/control02.ctl
SQL> select member from V$logfile;
MEMBER
--------------------------------------------------------------------------------
/u02/euro/redologcontrol/redo03.log
/u02/euro/redologcontrol/redo02.log
/u02/euro/redologcontrol/redo01.log
SQL>     
SQL> select name from V$archived_log;
NAME
--------------------------------------------------------------------------------
/u03/euro/archivelog/1_1_892036280.dbf
SQL> show parameter archive
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=/u03/euro/archivelog
log_archive_format                   string      %t_%s_%r.dbf

Posted by at No comments:
Subscribe to: Posts (Atom)