PeopleSoft: Restore command for HRDVLP

 Run PT_CONFIG_TABLE_EXP.DMS to capture tools tables from target environment - hrdvlp


From hrprod:

>rman target / catalog hrprod19/bkup_123@rmprod auxiliary sys/cZQwV3EqQy9K_M@hrdvlp


Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 5 11:43:09 2019


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


connected to target database: HRPROD (DBID=3413199007)

connected to recovery catalog database

connected to auxiliary database (not started)

RMAN> spool log to /usr/local/oracle/restorehrdvlpMarch26th.txt;

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 124671915310;

DUPLICATE target database to hrdvlp 

nofilenamecheck

db_file_name_convert = (

'hrprod','hrdvlp'

);

}

spool log off




Not working. Need to get correct syntax.

log_file_name_convert =('/usr/opt/app/oracle/admin/hrprod/redo01', '/usr/opt/app/oracle/admin/hrdvlp/redo01'

'/usr/opt/app/oracle/admin/hrprod/redo02', '/usr/opt/app/oracle/admin/hrdvlp/redo02');

}

spool log off;




It is preferred that you use 'set until . . . ' else rman will look for most recent archive logs if you don't use that clause,

and you can get these errors while restoring: RMAN-06053 and RMAN-06025


On HRPROD:

oracle-pshrdb602.tmw.com:hrprod:/usr/opt/app/dbdump/hot_backup/HRPROD>rman target / catalog  hrprod19/bkup_123@rmprod


Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 09:34:28 2024

Version 19.23.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


connected to target database: HRPROD (DBID=3518093084)

connected to recovery catalog database


RMAN> list backup of controlfile completed before '27-MAR-2025';

list backup of controlfile completed before '27-MAR-2025';


List of Backup Sets

===================



BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1727966 Full    26.73M     DISK        00:00:01     26-MAR-25

        BP Key: 1727968   Status: AVAILABLE  Compressed: NO  Tag: TAG20250326T024316

        Piece Name: /usr/opt/app/dbdump/hot_backup/HRPROD/HRPROD_AutoCTL_c-3518093084-20250326-00.bak

  Control File Included: Ckp SCN: 124670931015   Ckp time: 26-MAR-25


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1728021 Full    26.73M     DISK        00:00:01     26-MAR-25

        BP Key: 1728025   Status: AVAILABLE  Compressed: NO  Tag: TAG20250326T093146

        Piece Name: /usr/opt/app/dbdump/hot_backup/HRPROD/HRPROD_AutoCTL_c-3518093084-20250326-01.bak

  Control File Included: Ckp SCN: 124671915310   Ckp time: 26-MAR-25


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1728050 Full    26.73M     DISK        00:00:00     26-MAR-25

        BP Key: 1728052   Status: AVAILABLE  Compressed: NO  Tag: TAG20250326T133047

        Piece Name: /usr/opt/app/dbdump/hot_backup/HRPROD/HRPROD_AutoCTL_c-3518093084-20250326-02.bak

  Control File Included: Ckp SCN: 124673191364   Ckp time: 26-MAR-25



RMAN>








********

DUPLICATE target DATABASE TO 'HRDVLP' BACKUP LOCATION '/usr/opt/app/dbdump/hot_backup/HRPROD' NOFILENAMECHECK;


For example:

up to 2016 August 23rd


RMAN> spool log to /usr/local/oracle/restorehrdvlpFeb23rd.txt;

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 45590403829;

set newname for datafile 96 to '/usr/opt/app/oracle/admin/hrdvlp/data02/psimage_01.dbf';

set newname for datafile 97 to '/usr/opt/app/oracle/admin/hrdvlp/data02/psimage_02.dbf';

set newname for datafile 211 to '/usr/opt/app/oracle/admin/hrdvlp/data02/psimage_03.dbf';

DUPLICATE target database to hrdvlp 

nofilenamecheck

db_file_name_convert = ('/usr/opt/app/oracle/admin/hrprod/data01', '/usr/opt/app/oracle/admin/hrdvlp/data01'

'/usr/opt/app/oracle/admin/hrprod/ndx01', '/usr/opt/app/oracle/admin/hrdvlp/ndx01'

'/usr/opt/app/oracle/admin/hrprod/flash01', '/usr/opt/app/oracle/admin/hrdvlp/flash01'

'/usr/opt/app/oracle/admin/hrprod/redo01', '/usr/opt/app/oracle/admin/hrdvlp/redo01'

'/usr/opt/app/oracle/admin/hrprod/redo02', '/usr/opt/app/oracle/admin/hrdvlp/redo02'

'/usr/opt/app/oracle/admin/hrprod/system01/system01.dbf', '/usr/opt/app/oracle/admin/hrdvlp/system01/system01.dbf'

'/usr/opt/app/oracle/admin/hrprod/system01/control03.ctl', '/usr/opt/app/oracle/admin/hrdvlp/system01/control03.ctl'

'/usr/opt/app/oracle/admin/hrprod/system01/sysaux01.dbf', '/usr/opt/app/oracle/admin/hrdvlp/system02/sysaux01.dbf'

'/usr/opt/app/oracle/admin/hrprod/temp01', '/usr/opt/app/oracle/admin/hrdvlp/temp01'

'/usr/opt/app/oracle/admin/hrprod/undo01', '/usr/opt/app/oracle/admin/hrdvlp/undo01'

'/usr/opt/app/oracle/admin/hrprod/arch', '/usr/opt/app/oracle/admin/hrdvlp/arch');

}

spool log off;



up to 2016 Feb 23rd

RMAN> spool log to /usr/local/oracle/restorehrdvlpMarch4th.txt;

RMAN> run {

2> startup clone nomount;

3> allocate auxiliary channel aux1 device type disk;

4> DUPLICATE target DATABASE TO 'HRDVLP' BACKUP LOCATION '/usr/opt/app/dbdump/hot_backup/HRPROD' NOFILENAMECHECK

5> db_file_name_convert = ('/usr/opt/app/oracle/admin/hrprod/data01', '/usr/opt/app/oracle/admin/hrdvlp/data01'

6> '/usr/opt/app/oracle/admin/hrprod/ndx01', '/usr/opt/app/oracle/admin/hrdvlp/ndx01'

7> '/usr/opt/app/oracle/admin/hrprod/flash01', '/usr/opt/app/oracle/admin/hrdvlp/flash01'

8> '/usr/opt/app/oracle/admin/hrprod/system01/system01.dbf', '/usr/opt/app/oracle/admin/hrdvlp/system01/system01.dbf'

9> '/usr/opt/app/oracle/admin/hrprod/system01/control03.ctl', '/usr/opt/app/oracle/admin/hrdvlp/system01/control03.ctl'

10> '/usr/opt/app/oracle/admin/hrprod/system01/sysaux01.dbf', '/usr/opt/app/oracle/admin/hrdvlp/system02/sysaux01.dbf'

11> '/usr/opt/app/oracle/admin/hrprod/temp01', '/usr/opt/app/oracle/admin/hrdvlp/temp01'

12> '/usr/opt/app/oracle/admin/hrprod/undo01', '/usr/opt/app/oracle/admin/hrdvlp/undo01'

13> '/usr/opt/app/oracle/admin/hrprod/arch', '/usr/opt/app/oracle/admin/hrdvlp/arch');

14> }




lesystem            Size  Used Avail Use% Mounted on

/dev/mapper/system-rootlv

                       20G  5.8G   13G  32% /

/dev/sda1             487M   21M  441M   5% /boot

tmpfs                  31G   19G   13G  60% /dev/shm

/dev/mapper/system-varlv

                      9.7G  4.2G  5.1G  46% /var

/dev/mapper/system-tmplv

                      4.9G  273M  4.4G   6% /tmp

/dev/mapper/system-homelv

                      4.9G  139M  4.5G   3% /export/home

/dev/mapper/uservg-usr_opt_app_lv

                       62G   49G  9.3G  85% /usr/opt/app

/dev/mapper/system-oraclenew_lv

                       40G   27G   11G  72% /usr/opt/app/oracle

/dev/mapper/uservg-uservg--timecards_lv

                      6.0G  141M  5.5G   3% /usr/opt/app/timecards

/dev/mapper/system-system--app_track_lv

                       20G  1.8G   17G  10% /usr/opt/app/apptrack

/dev/mapper/dbdumpvg-dbdump_lv

                      276G   96G  166G  37% /usr/opt/app/dbdump

/dev/mapper/uservg-psreports_lv

                       58G   29G   26G  54% /usr/opt/app/psoft/psreports

/dev/mapper/h4r5datavg-data100_lv

                      776G  711G   27G  97% /rd100

/dev/mapper/h4r5datavg-index200_lv

                      446G  368G   57G  87% /rd200

/dev/mapper/h4r5datavg-redo300_lv

                       20G  5.3G   14G  29% /rd300

/dev/mapper/h4r5datavg-undo320_lv

                       50G   35G   13G  74% /rd320

/dev/mapper/h4r5datavg-temp340_lv

                      108G   36G   66G  36% /rd340

/dev/mapper/h4r5datavg-system400_lv

                       20G   14G  5.6G  71% /rd400

/dev/mapper/h4r5datavg-arch500_lv

                       15G  238M   14G   2% /rd500

/dev/mapper/h4r5datavg-flash600_lv

                      9.9G  840M  8.6G   9% /rd600

/dev/mapper/h4psupgtemp_vg-rd900_lv

                      650G  529G   89G  86% /rd900

kira:/vol/vol4/interdev

                      704G  552G  153G  79% /interfaces2

/dev/mapper/h4temprd800vg-rd800_lv

                      419G  292G  107G  74% /rd800



oracle-pshrtstdb01:hrdvlp:/usr/opt/app/oracle/admin/hrdvlp>ls -lrt

total 52

drwxr-xr-x 2 oracle dba  4096 Jul 14  2010 dpdump

drwxr-xr-x 2 oracle dba  4096 Jul 14  2010 scripts1120

drwxr-xr-x 2 oracle dba  4096 May 18  2011 scripts

lrwxrwxrwx 1 oracle dba    28 Mar 12 20:43 undo01 -> /rd320/oradata/hrdvlp/undo01

lrwxrwxrwx 1 oracle dba    28 Mar 12 20:43 temp01 -> /rd340/oradata/hrdvlp/temp01

lrwxrwxrwx 1 oracle dba    30 Mar 12 20:43 system03 -> /rd900/oradata/hrdvlp/system03

lrwxrwxrwx 1 oracle dba    30 Mar 12 20:43 system02 -> /rd300/oradata/hrdvlp/system02

lrwxrwxrwx 1 oracle dba    30 Mar 12 20:43 system01 -> /rd400/oradata/hrdvlp/system01

lrwxrwxrwx 1 oracle dba    28 Mar 12 20:43 redo02 -> /rd300/oradata/hrdvlp/redo02

lrwxrwxrwx 1 oracle dba    28 Mar 12 20:43 redo01 -> /rd300/oradata/hrdvlp/redo01

lrwxrwxrwx 1 oracle dba    27 Mar 12 20:43 ndx01 -> /rd200/oradata/hrdvlp/ndx01

lrwxrwxrwx 1 oracle dba    29 Mar 12 20:43 flash01 -> /rd600/oradata/hrdvlp/flash01

lrwxrwxrwx 1 oracle dba    28 Mar 12 20:43 data02 -> /rd800/oradata/hrdvlp/data02

lrwxrwxrwx 1 oracle dba    28 Mar 12 20:43 data01 -> /rd100/oradata/hrdvlp/data01

lrwxrwxrwx 1 oracle dba    26 Mar 12 20:43 arch -> /rd500/oradata/hrdvlp/arch

drwxr-xr-x 2 oracle dba  4096 Aug 24 12:07 pfile

drwxr-xr-x 2 oracle dba 36864 Aug 24 12:10 adump


Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more