I have successfully configured TDP2.1.1 and RMAN ,tested backups and
restore (delete tablespace -restore tablespace using TDP and RMAN -
Oracle 8.1.7 .works great .. hushhhhhhh.. requires some knowledge of
oracle .
I became Oracle DBA for some time :-)
Ok back to the oracle v9.2 : I am about to start configuration of RMAN
and TDP2.1.1 with oracle 9.2 , Are you saying that TDP 2.1.1 is not
supported with oracle 9.2 ?
Grant succeeded.
SQL> connect bkuptest/bkuptest
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> @demobld.sql
SP2-0310: unable to open file "demobld.sql"
SQL> @/d01//app/oracle/product/8.1.7.2.0/sqlplus/demo/demobld.sql
Building demonstration tables. Please wait.
Demonstration table build is complete.
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 -
Production
JServer Release 8.1.7.0.0 - Production
f2n17 /d01/app/oracle/product/8.1.7 >
SQL> c/*/table_name
1* select table_name from user_tables
SQL> /
TABLE_NAME
------------------------------
BONUS
DEPT
DUMMY
EMP
SALGRADE
SQL> select * from emp
2 /
SQL>
SQL> drop table emp;
Table dropped.
SQL> connect system/manager
Connected.
SQL> alter tablespace bkup_data offline
2 /
Tablespace altered.
f2n17 /d01/app/oracle > sqlplus bkuptest/bkuptest
SQL*Plus: Release 8.1.7.0.0 - Production on Sun Nov 17 22:15:41 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
SQL> select * from dept;
select * from dept
*
ERROR at line 1:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: '/d10/bkupdata/bkup01.db'
SQL> connect system/manager
Connected.
SQL> alter tablespace bkup_data offline
2 /
Tablespace altered.
SQL> alter tablespace bkup_data online;
alter tablespace bkup_data online
*
ERROR at line 1:
ORA-01113: file 7 needs media recovery
ORA-01110: data file 7: '/d10/bkupdata/bkup01.db'
SQL> recover tablespace bkup_data;
Media recovery complete.
SQL> alter tablespace bkup_data online;
Tablespace altered.
SQL> c/all/user
1* select table_name from user_tables
SQL> /
TABLE_NAME
------------------------------
BONUS
DEPT
DUMMY
SALGRADE
RMAN> list
2> backupset
3> ;
RMAN-03022: compiling command: list
RMAN-03024: performing implicit full resync of recovery catalog
RMAN-03023: executing command: full resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete
List of Backup Sets
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ----------
-------------
1 /d10/oradata/v8iback/system.dbf 0 Full 43778 17-NOV-02
4 /d10/oradata/v8iback/user_data.dbf 0 Full 43778 17-NOV-02
6 /d11/ora/rcv01.dbf 0 Full 43778 17-NOV-02
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
104 6 478216959 0 478216942 6 17-NOV-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
106 1 1 AVAILABLE 17-NOV-02 df_478216942_6_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ----------
-------------
2 /d10/oratemp/v8iback/temp01.dbf 0 Full 43779 17-NOV-02
3 /d10/orarbs/v8iback/rbs01.dbf 0 Full 43779 17-NOV-02
5 /d10/oraidx/v8iback/user_index.dbf 0 Full 43779 17-NOV-02
7 /d10/bkupdata/bkup01.db 0 Full 43779 17-NOV-02
f2n17 /d01/app/oracle > rman target / rcvcat rman/rman
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: V8IBACK (DBID=3101863237)
RMAN-06008: connected to recovery catalog database
RMAN> list incarnation of database v8iback;
RMAN-03022: compiling command: list
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 2 V8IBACK 2147483647 YES 1 24-OCT-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
106 1 1 AVAILABLE 17-NOV-02 df_478216942_6_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ----------
-------------
2 /d10/oratemp/v8iback/temp01.dbf 0 Full 43779 17-NOV-02
3 /d10/orarbs/v8iback/rbs01.dbf 0 Full 43779 17-NOV-02
5 /d10/oraidx/v8iback/user_index.dbf 0 Full 43779 17-NOV-02
7 /d10/bkupdata/bkup01.db 0 Full 43779 17-NOV-02
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
124 7 478271987 0 478271902 7 18-NOV-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
126 1 1 AVAILABLE 18-NOV-02 df_478271902_7_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ----------
-------------
1 /d10/oradata/v8iback/system.dbf 0 Full 43864 18-NOV-02
4 /d10/oradata/v8iback/user_data.dbf 0 Full 43864 18-NOV-02
6 /d11/ora/rcv01.dbf 0 Full 43864 18-NOV-02
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
125 8 478272006 0 478271987 8 18-NOV-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
127 1 1 AVAILABLE 18-NOV-02 df_478271987_8_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ----------
-------------
2 /d10/oratemp/v8iback/temp01.dbf 0 Full 43865 18-NOV-02
3 /d10/orarbs/v8iback/rbs01.dbf 0 Full 43865 18-NOV-02
5 /d10/oraidx/v8iback/user_index.dbf 0 Full 43865 18-NOV-02
7 /d10/bkupdata/bkup01.db 0 Full 43865 18-NOV-02
RMAN>
deleted and restored test tablespace ;;;;
f2n17 /tmp > more redb.log
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: V8IBACK (DBID=3101863237)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms
3> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> restore tablespace bkup_data;
5> recover tablespace bkup_data;
6> release channel t1;
7> }
8>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=11 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 2.2.1.0
(RMAN and TDP are communicating to restore data )
RMAN-03022: compiling command: restore
RMAN-03024: performing implicit full resync of recovery catalog
RMAN-03023: executing command: full resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=6 set_stamp=478216942 creation_time=17-NOV-02
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00007 to /d10/bkupdata/bkup01.db
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=df_478216942_6_1 tag=null params=NULL
RMAN-08024: channel t1: restore complete
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-08055: media recovery complete
RMAN-03022: compiling command: recover(4)
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
Recovery Manager complete.
Thank You and Best regards.
^^^^^^^^^^^^^^^^^^^^^^^^
Shekhar Dhotre
Midrange Engineer.
lend lease Inc , Atlanta - 30346
PH: 1+404-846-7483
FAX:1+404-848-2887
Email :[EMAIL PROTECTED]
visit Us at www.lendlease.com
This E-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended only
for the use of the Individual(s) named above. If you are not the intended
recipient of this E-mail, or the employee or agent responsible for
delivering it to the intended recipient, you are hereby notified that any
dissemination or copying of this E-mail is strictly prohibited. If you
have
received this E-mail in error, please immediately notify us .
"Wholey, Joseph (TGA\\MLOL)" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
11/18/2002 12:24 PM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Oracle v9.2 and TDP for Oracle
Anyone know when or if there are plans for TDP to support Oracle v9.2?
