Search Blog Post

Saturday, August 31, 2013

Patch Analysis


                                         Patch Analysis

 Accessing Patch Wizard

To access Patch Wizard, log in to Oracle Applications Manager (OAM) and choose Patch Wizard from the Navigator pane.
1.      Enter the following URL in your browser: 
2.  http://<HTTP hostname>.<domain>:<HTTP port>/OA_HTML/AppsLogin
The Welcome page appears.
Oracle E-Business Suite Welcome Page











Enter your user name and password, and click Login. The Oracle E-Business Suite Home page appears. Click the System Administration link in the Navigator pane. Another Navigator pane appears to the right.

1.      Go to the Patch Wizard main page.
Scroll down to the Oracle Applications Manager section of the right-hand Navigator pane, and click Patch Wizard to go to the main page.

 

 Patch Wizard Main Page

Use the main page to access all features of Patch Wizard and to view the results of your requests for recommended patches. The Select Feature drop-down list at the top of the page provides access to the Applied Patches, File History, Timing Reports, and Register Flagged Files features.
Patch Wizard Main Page

 

 

 

 

 

 

 

 

 

 

 

 Patch Wizard Preferences

The site-specific information you set on the Patch Wizard Preferences page applies to other functions of Patch Wizard, such as Recommend/Analyze, Download Patches, and Codelevels Summary. From the Patch Wizard main page, click the Tasks icon for Patch Wizard Preferences.
The top portion of the page contains these sections: Staging Directory, Merge Option Defaults, and Language and Platform Details.

 

 

 

 

 

 

 

 

 

 

 

Recommend/Analyze Patches

After setting up the Patch Wizard staging area (and optionally creating custom filters) on the main page, you can submit requests for processing. Click the Tasks icon for Recommend/Analyze Patches.
Recommend Patches Page - Top

 

 

 

 

 

 

 

On this window choose a patch to be analyzed and press "OK".

 

 

 

 

 

 

 

In Results tab,  click on Details to see more about this patch.

 


 

 

 

 

 

 

 Patch Impact Analysis

From the Recommended Patches Results page, click an icon in the Impact column to view the Patch Impact Analysis page for that patch.


 

 

 

 

 


The Patch Impact Analysis looks like:

On the underlined field we can click to get more information:

For instance, if I click on "1" from "Direct Impact Summary", "Applications Patched" I will get the following window:



 









For instance, if I click on "9" from "Direct Impact Summary", " File Types Installed" I will get the following window:

 



Posted by at No comments:

Friday, August 30, 2013

CLONING THE TARGET DATABASE USING RMAN


How RMAN Duplication works..??
EXAMPLE OF CLONING USING RMAN..!!
EXAMPLE OF CLONING FROM A PREVIOUS BACKUP..!!



                   CLONING THE TARGET DATABASE USING RMAN

HOW RMAN DUPLICATION WORKS?

The duplication process of the RMAN can be broken into its distinct pieces:

●    RMAN determines the nature and location of the backups.
●    RMAN allocates an auxiliary channel at the auxiliary instance.
●    RMAN restores the datafiles to the auxiliary instance.
●    RMAN builds a new auxiliary control file.
●    RMAN restores archive logs from backup and performs any necessary recovery.
●    RMAN resets the DBID for the auxiliary instance and opens the database with open resetlogs.


Before starting with the cloning steps add the following entries in the .bash_profile of the user

vi .bash_profile

add the following entries

export ORACLE_SID=robin
export ORACLE_BASE=/vol1/robin
export ORACLE_HOME=$ORACLE_BASE/10.2.0
export PATH=$ORACLE_HOME/bin:$PATH

save and exit and then source the environment

before proceeding further please check whether you have a valid online backup along with the archive logs if not then execute the following on the target database before proceeding with the RMAN duplication.

[diana@rac2 dbs]$ rman target=rman_admin/rman_admin catalog=rman/rman@rman

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jan 21 21:40:26 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DIANA (DBID=925397895)
connected to recovery catalog database

RMAN> backup database plus archivelog;


Starting backup at 21-JAN-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=17 recid=29 stamp=708179244
input archive log thread=1 sequence=18 recid=30 stamp=708903962
channel ORA_DISK_1: starting piece 1 at 21-JAN-10
channel ORA_DISK_1: finished piece 1 at 21-JAN-10
piece handle=/vol1/diana/backup/diana/diana_1rl4210r_1_1.bak tag=TAG20100121T214603 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 21-JAN-10

Starting backup at 21-JAN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/vol1/diana/oradata/diana/system01.dbf
input datafile fno=00003 name=/vol1/diana/oradata/diana/sysaux01.dbf
input datafile fno=00005 name=/vol1/diana/oradata/diana/admin01.dbf
input datafile fno=00002 name=/vol1/diana/oradata/diana/undotbs01.dbf
input datafile fno=00004 name=/vol1/diana/oradata/diana/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-JAN-10
channel ORA_DISK_1: finished piece 1 at 21-JAN-10
piece handle=/vol1/diana/backup/diana/diana_1sl4210v_1_1.bak tag=TAG20100121T214607 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-JAN-10
channel ORA_DISK_1: finished piece 1 at 21-JAN-10
piece handle=/vol1/diana/backup/diana/diana_1tl4211p_1_1.bak tag=TAG20100121T214607 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JAN-10

Starting backup at 21-JAN-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=19 recid=31 stamp=708903995
channel ORA_DISK_1: starting piece 1 at 21-JAN-10
channel ORA_DISK_1: finished piece 1 at 21-JAN-10
piece handle=/vol1/diana/backup/diana/diana_1ul4211s_1_1.bak tag=TAG20100121T214636 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JAN-10

Archive the current online redo log file too and then archive all the archive logs for once.

RMAN> sql 'alter system archive log current';

sql statement: alter system archive log current

RMAN> backup archivelog all;

Starting backup at 21-JAN-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=17 recid=29 stamp=708179244
input archive log thread=1 sequence=18 recid=30 stamp=708903962
input archive log thread=1 sequence=19 recid=31 stamp=708903995
input archive log thread=1 sequence=20 recid=32 stamp=708904018
input archive log thread=1 sequence=21 recid=33 stamp=708904031
channel ORA_DISK_1: starting piece 1 at 21-JAN-10
channel ORA_DISK_1: finished piece 1 at 21-JAN-10
piece handle=/vol1/diana/backup/diana/diana_1vl42130_1_1.bak tag=TAG20100121T214712 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JAN-10


STEPS to clone a database using RMAN

STEP:1 Create the respective directory structure on the auxiliary instance once the Oracle binaries are installed. Assuming that all the oracle binaries are installed in the                                       /vol1/robin/10.2.0

cd /vol1/robin
[robin@rac2 ~]$ mkdir -p oradata/robin
[robin@rac2 ~]$ mkdir -p oradata/arch
[robin@rac2 ~]$ mkdir -p admin/robin/adump
[robin@rac2 ~]$ mkdir -p admin/robin/bdump
[robin@rac2 ~]$ mkdir -p admin/robin/cdump
[robin@rac2 ~]$ mkdir -p admin/robin/udump
[robin@rac2 ~]$ mkdir -p admin/robin/pfile
[robin@rac2 ~]$ mkdir -p admin/robin/dpdump

final directory structure looks like as follows:

[robin@rac2 ~]$ cd /vol1/robin
[robin@rac2 ~]$ ls -lrt
total 12
drwxr-x---  54 robin dba 4096 Jan 21 19:59 10.2.0  <-- oracle binaries
drwxr-xr-x   4 robin dba 4096 Jan 21 20:38 oradata <-- oracle data
drwxr-xr-x   3 robin dba 4096 Jan 21 20:41 admin   <-- alert log files etc...

STEP:2 Copy the init.ora of the target to the auxiliary instance and make changes to the file as needed.

remove all references of the target in the init.ora and change then to the auxiliary

ex:
Open the init.ora in vi editor
vi init.ora
and then enter the command in normal mode (not in insert mode)
:%s?diana?robin?g

once done add the following for the filename conversion from the target to the auxiliary database during the cloning

*.db_file_name_convert=('/vol1/diana/oradata/diana','/vol1/robin/oradata/robin')
*.log_file_name_convert=('/vol1/diana/oradata/diana','/vol1/robin/oradata/robin')

STEP:3 Create the password file for the auxiliary instance

[robin@rac2 dbs]$ orapwd file=orapwrobin password=sysadmin entries=5
[robin@rac2 dbs]$ ls -lrt
total 40
-rw-r-----  1 robin dba  8385 Sep 11  1998 init.ora
-rw-r-----  1 robin dba 12920 May  3  2001 initdw.ora
-rw-r--r--  1 robin dba   997 Jan 21 21:04 initdiana.ora
-rw-r--r--  1 robin dba   989 Jan 21 21:06 initrobin.ora
-rw-r-----  1 robin dba  2048 Jan 21 21:07 orapwrobin

STEP:4  Now start the auxiliary instance in nomount state as we do not have the control files we can mount the auxiliary instance at time point.

[robin@rac2 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 21 21:29:23 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/vol1/robin/10.2.0/dbs/initrobin.ora';
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1218532 bytes
Variable Size              71305244 bytes
Database Buffers          130023424 bytes
Redo Buffers                7168000 bytes

SQL> exit

STEP:5 Configure the listener for the auxiliary instance

now execute netca and configure the listener

once done make the respective changes into the tnsnames.ora and listener.ora
Also add the tns entries of rman and the target instance to auxiliary instance tnsnames.ora.

STEP:6 Now execute the duplicate command to start with the cloning of the RMAN.
connect to the RMAN as follows:

[robin@rac2 dbs]$ rman catalog rman/rman@rman target rman_admin/rman_admin@diana auxiliary sys/sysadmin

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jan 21 21:30:48 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DIANA (DBID=925397895)
connected to recovery catalog database
connected to auxiliary database: ROBIN (not mounted)

RMAN> duplicate target database to robin
2> pfile=/vol1/robin/10.2.0/dbs/initrobin.ora;

Starting Duplicate Db at 21-JAN-10
using channel ORA_AUX_DISK_1 <-- an auxiliary channel is allocated in here

contents of Memory Script:
{
   set until scn  587547;       <-- SCN to which the incomplete recovery needs to be perfomed -->
   set newname for datafile  1 to   <-- setting new names to the datafiles on auxiliary end -->
 "/vol1/robin/oradata/robin/system01.dbf";
   set newname for datafile  2 to
 "/vol1/robin/oradata/robin/undotbs01.dbf";
   set newname for datafile  3 to
 "/vol1/robin/oradata/robin/sysaux01.dbf";
   set newname for datafile  4 to
 "/vol1/robin/oradata/robin/users01.dbf";
   set newname for datafile  5 to
 "/vol1/robin/oradata/robin/admin01.dbf";
   restore <-- actual datafiles are restored from the backup of the target database -->
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 21-JAN-10
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /vol1/robin/oradata/robin/system01.dbf
restoring datafile 00002 to /vol1/robin/oradata/robin/undotbs01.dbf
restoring datafile 00003 to /vol1/robin/oradata/robin/sysaux01.dbf
restoring datafile 00004 to /vol1/robin/oradata/robin/users01.dbf
restoring datafile 00005 to /vol1/robin/oradata/robin/admin01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /vol1/diana/backup/diana/diana_1sl4210v_1_1.bakchannel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/vol1/diana/backup/diana/diana_1sl4210v_1_1.bak tag=TAG20100121T214607
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 21-JAN-10

<-- Now the actual part of the control file creation starts here -->
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ROBIN" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/vol1/robin/oradata/robin/redo01.log' ) SIZE 50 M  REUSE,
  GROUP  2 ( '/vol1/robin/oradata/robin/redo02.log' ) SIZE 50 M  REUSE,
  GROUP  3 ( '/vol1/robin/oradata/robin/redo03.log' ) SIZE 50 M  REUSE
 DATAFILE
  '/vol1/robin/oradata/robin/system01.dbf'
 CHARACTER SET WE8ISO8859P1


contents of Memory Script:
{
   switch clone datafile all;<-- this statement is equivalent to alter database rename datafile                                                     statement -- >
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=708904091 filename=/vol1/robin/oradata/robin/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=708904091 filename=/vol1/robin/oradata/robin/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=708904091 filename=/vol1/robin/oradata/robin/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=708904091 filename=/vol1/robin/oradata/robin/admin01.dbf

contents of Memory Script:
{
   set until scn  587547;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause  <-- datafiles are recovered to the SCN value 587547 -->

Starting recover at 21-JAN-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=159 devtype=DISK

starting media recovery

archive log thread 1 sequence 19 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_19_703254218_1.arc
archive log thread 1 sequence 20 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_20_703254218_1.arc
archive log thread 1 sequence 21 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_21_703254218_1.arc
archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_19_703254218_1.arc thread=1 sequence=19
archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_20_703254218_1.arc thread=1 sequence=20
archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_21_703254218_1.arc thread=1 sequence=21
media recovery complete, elapsed time: 00:00:03
Finished recover at 21-JAN-10

contents of Memory Script:
{
   shutdown clone;
   startup clone nomount pfile= '/vol1/robin/10.2.0/dbs/initrobin.ora';
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     209715200 bytes

Fixed Size                     1218532 bytes
Variable Size                 71305244 bytes
Database Buffers             130023424 bytes
Redo Buffers                   7168000 bytes

<-- before this statement is executed somehow oracle resets the DBID (may be it is run silently) so that when the control file script is run again it figures that the DBID is zero generates a new DBID for the cloned database-->
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ROBIN" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/vol1/robin/oradata/robin/redo01.log' ) SIZE 50 M  REUSE,
  GROUP  2 ( '/vol1/robin/oradata/robin/redo02.log' ) SIZE 50 M  REUSE,
  GROUP  3 ( '/vol1/robin/oradata/robin/redo03.log' ) SIZE 50 M  REUSE
 DATAFILE
  '/vol1/robin/oradata/robin/system01.dbf'
 CHARACTER SET WE8ISO8859P1


contents of Memory Script:
{
   set newname for tempfile  1 to
 "/vol1/robin/oradata/robin/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/vol1/robin/oradata/robin/undotbs01.dbf";
   catalog clone datafilecopy  "/vol1/robin/oradata/robin/sysaux01.dbf";
   catalog clone datafilecopy  "/vol1/robin/oradata/robin/users01.dbf";
   catalog clone datafilecopy  "/vol1/robin/oradata/robin/admin01.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /vol1/robin/oradata/robin/temp01.dbf in control file

cataloged datafile copy
datafile copy filename=/vol1/robin/oradata/robin/undotbs01.dbf recid=1 stamp=708904106

cataloged datafile copy
datafile copy filename=/vol1/robin/oradata/robin/sysaux01.dbf recid=2 stamp=708904106

cataloged datafile copy
datafile copy filename=/vol1/robin/oradata/robin/users01.dbf recid=3 stamp=708904106

cataloged datafile copy
datafile copy filename=/vol1/robin/oradata/robin/admin01.dbf recid=4 stamp=708904106

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=708904106 filename=/vol1/robin/oradata/robin/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=708904106 filename=/vol1/robin/oradata/robin/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=708904106 filename=/vol1/robin/oradata/robin/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=708904106 filename=/vol1/robin/oradata/robin/admin01.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 21-JAN-10

RMAN>



EXAMPLE OF CLONING FROMA PREVIOUS BACKUP

RMAN> run
2> {
3> set until time "to_date('27-01-2010 16:42:48','dd-mm-yyyy hh24:mi:ss')";
4> duplicate target database to patty;
5> }

executing command: SET until clause

Starting Duplicate Db at 27-JAN-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:
{
   set until scn  641245;
   set newname for datafile  1 to
 "/vol1/patty/oradata/patty/system01.dbf";
   set newname for datafile  2 to
 "/vol1/patty/oradata/patty/undotbs01.dbf";
   set newname for datafile  3 to
 "/vol1/patty/oradata/patty/sysaux01.dbf";
   set newname for datafile  4 to
 "/vol1/patty/oradata/patty/users01.dbf";
   set newname for datafile  5 to
 "/vol1/patty/oradata/patty/admin01.dbf";
   restore
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 27-JAN-10
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /vol1/patty/oradata/patty/system01.dbf
restoring datafile 00002 to /vol1/patty/oradata/patty/undotbs01.dbf
restoring datafile 00003 to /vol1/patty/oradata/patty/sysaux01.dbf
restoring datafile 00004 to /vol1/patty/oradata/patty/users01.dbf
restoring datafile 00005 to /vol1/patty/oradata/patty/admin01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /vol2/backup/diana/diana_2ml4h9g8_1_1.bak
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/vol2/backup/diana/diana_2ml4h9g8_1_1.bak tag=TAG20100127T164247
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 27-JAN-10
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PATTY" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/vol1/patty/oradata/patty/redo01.log' ) SIZE 50 M  REUSE,
  GROUP  2 ( '/vol1/patty/oradata/patty/redo02.log' ) SIZE 50 M  REUSE,
  GROUP  3 ( '/vol1/patty/oradata/patty/redo03.log' ) SIZE 50 M  REUSE
 DATAFILE
  '/vol1/patty/oradata/patty/system01.dbf'
 CHARACTER SET WE8ISO8859P1


contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=709405660 filename=/vol1/patty/oradata/patty/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=709405660 filename=/vol1/patty/oradata/patty/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=709405660 filename=/vol1/patty/oradata/patty/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=709405660 filename=/vol1/patty/oradata/patty/admin01.dbf

contents of Memory Script:
{
   set until time  "to_date('27-01-2010 16:42:48','dd-mm-yyyy hh24:mi:ss')";
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 27-JAN-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=159 devtype=DISK

starting media recovery

archive log thread 1 sequence 34 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_34_703254218_1.arc
archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_34_703254218_1.arc thread=1 sequence=34
media recovery complete, elapsed time: 00:00:03
Finished recover at 27-JAN-10

contents of Memory Script:
{
   shutdown clone;
   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     209715200 bytes

Fixed Size                     1218532 bytes
Variable Size                 71305244 bytes
Database Buffers             130023424 bytes
Redo Buffers                   7168000 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PATTY" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/vol1/patty/oradata/patty/redo01.log' ) SIZE 50 M  REUSE,
  GROUP  2 ( '/vol1/patty/oradata/patty/redo02.log' ) SIZE 50 M  REUSE,
  GROUP  3 ( '/vol1/patty/oradata/patty/redo03.log' ) SIZE 50 M  REUSE
 DATAFILE
  '/vol1/patty/oradata/patty/system01.dbf'
 CHARACTER SET WE8ISO8859P1


contents of Memory Script:
{
   set newname for tempfile  1 to
 "/vol1/patty/oradata/patty/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/vol1/patty/oradata/patty/undotbs01.dbf";
   catalog clone datafilecopy  "/vol1/patty/oradata/patty/sysaux01.dbf";
   catalog clone datafilecopy  "/vol1/patty/oradata/patty/users01.dbf";
   catalog clone datafilecopy  "/vol1/patty/oradata/patty/admin01.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /vol1/patty/oradata/patty/temp01.dbf in control file

cataloged datafile copy
datafile copy filename=/vol1/patty/oradata/patty/undotbs01.dbf recid=1 stamp=709405672

cataloged datafile copy
datafile copy filename=/vol1/patty/oradata/patty/sysaux01.dbf recid=2 stamp=709405672

cataloged datafile copy
datafile copy filename=/vol1/patty/oradata/patty/users01.dbf recid=3 stamp=709405672

cataloged datafile copy
datafile copy filename=/vol1/patty/oradata/patty/admin01.dbf recid=4 stamp=709405672

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=709405672 filename=/vol1/patty/oradata/patty/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=709405672 filename=/vol1/patty/oradata/patty/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=709405672 filename=/vol1/patty/oradata/patty/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=709405672 filename=/vol1/patty/oradata/patty/admin01.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 27-JAN-10

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