Deleting Old data
su - trnadmcd /oracle/TRNrm -fR sapdaba*/*rm -fR mirrlog */*rm -fR origlog*/*
Change Owsener shipRootcd to /oracle/SIDchown -R orasid:dba *
create Control file
Login to SOURCE system and create ac control file
alter database backup controlfile to trace;
Edit file as followows. to Change the SID ********
root@glsaptrn # cat chsidTRN_sk2.sqlCREATE CONTROLFILE SET DATABASE "TRN" RESETLOGS ARCHIVELOG-- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 254 MAXLOGMEMBERS 3 MAXDATAFILES 1022 MAXINSTANCES 1 MAXLOGHISTORY 1815LOGFILE
****** '/oracle/TRN/sapdata11/undo_1/undo.data1', '/oracle/TRN/sapdata9/pcld_11/pcld.data11',chown '/oracle/TRN/sapdata11/pcld_13/pcld.data13', '/oracle/TRN/sapdata11/pcld_14/pcld.data14'CHARACTER SET WE8DEC;
Logon to DEST system...)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))**************************************************************************IF THE BACKUP IS ON LINE **********************************************************************************************
SQL> connect /as sysdbaConnected to an idle instance.SQL> startup nomountORACLE instance started.
Total System Global Area 777841256 bytesFixed Size 731752 bytesVariable Size 469762048 bytesDatabase Buffers 306012160 bytesRedo Buffers 1335296 bytes
SQL> @/oracle/TRN/saptrace/usertrace/chsidTRN_sk_1103.sql
Control file created.
SQL> recover database using backup controlfile until cancel;ORA-00279: change 732366259 generated at 09/06/2006 00:05:08 needed for thread
1ORA-00289: suggestion : /oracle/TRN/saparch/TRNarch1_4520.dbfORA-00280: change 732366259 for thread 1 is in sequence #4520
Specify log: {
Specify log: {
ORA-00279: change 732652014 generated at 09/06/2006 08:43:21 needed for thread1ORA-00289: suggestion : /oracle/TRN/saparch/TRNarch1_4525.dbfORA-00280: change 732652014 for thread 1 is in sequence #4525ORA-00278: log file '/oracle/TRN/saparch/TRNarch1_4524.dbf' no longer neededfor this recovery
Specify log: {
SQL> alter database open resetlogs;
Database altered.
SQL> shutdown;Database closed.Database dismounted.ORACLE instance shut down.
SQL> startup;ORACLE instance started.
Total System Global Area 777841256 bytesFixed Size 731752 bytesVariable Size 469762048 bytesDatabase Buffers 306012160 bytesRedo Buffers 1335296 bytesDatabase mounted.Database opened.
SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.4.0 - Production
**************************************************************************************))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))***************************************************************************************IF THE BACKUP IS OFF LINE ************************************************************************************************************
SQL> @/oracle/DSB/saptrace/usertrace/chsidDSB_sk.sql
Control file created.
SQL> alter database open resetlogs;
Database altered.
SQL> shutdown;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup;ORACLE instance started.
Total System Global Area 1180495016 bytesFixed Size 732328 bytesVariable Size 872415232 bytesDatabase Buffers 306012160 bytesRedo Buffers 1335296 bytesDatabase mounted.Database opened.SQL> exit
******************************************************************************************)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
glsaptrn:oratrn 3% lsnrctl start
LSNRCTL for Solaris: Version 9.2.0.4.0 - Production on 15-SEP-2006 12:17:14
Service "TRN" has 1 instance(s). Instance "TRN", status UNKNOWN, has 1 handler(s) for this service...The command completed successfullyglsaptrn:oratrn 4% exitglsaptrn:oratrn 5% logout
root@glsaptrn # su - trnadm****** Welcome to the World of UNIX. Have a very nice day. ****** Sun Microsystems Inc. SunOS 5.9 Generic May 2002You have mail.glsaptrn:trnadm 1% startsap r3
Checking TRN Database------------------------------ ABAP Database is running
Starting SAP-Collector Daemon ------------------------------12:17:29 15.09.2006 LOG: Effective User Id is root************************************************************************ This is Saposcol Version COLL 20.90 640 - V3.72 64Bit* Usage: saposcol -l: Start OS Collector * saposcol -k: Stop OS Collector * saposcol -d: OS Collector Dialog Mode* saposcol -s: OS Collector Status* The OS Collector (PID 2984) is already running ..... ************************************************************************ saposcol already running
Starting SAP Instance DVEBMGS00------------------------------ Startup-Log is written to /export/home/trnadm/startsap_DVEBMGS00.log Instance on host glsaptrn started
glsaptrn:trnadm 3% saplicense -deleteSpecify your SAP System ID: SAP SYSTEM ID = PRDSpecify your hardware key: HARDWARE KEY = V1957057123Specify the product ID(e.g. R3_BASIS, R3_ORA...) : PRODUCTID = R3_ORA saplicense: license deleted
glsaptrn:trnadm 19% saplicense -installSpecify your SAP System ID: SAP SYSTEM ID = TRNSpecify your unique System idenfification: If you have no systemnumber specified just press enter.SYSTEM-NR = Set unique System-ID to INITIAL_SYSTEM_IDX
Specify your hardware key: HARDWARE KEY = S0570080646Specify your installation number: INSTALLATION NO = 6520051917Specify your expiration date: EXPIRATION_DATE [YYYYMMDD] = 99991231Specify your license key: LICENSE_KEY 1...5....0....5....0...4LICENSE_KEY = GEPYAKVKGKSZBMPIKIFNVQ8Ssaplicense: License successfully installed
glsaptrn:trnadm 20% saplicese -showsaplicese: Command not foundglsaptrn:trnadm 21% sapcilese -showsapcilese: Command not foundglsaptrn:trnadm 22% saplicense -showLICENSE system: TRN hardware key: S0570080646 expiration_date: 99991231 installation no: 6520051917 key: GEPYAKVKGKSZBMPIKIFNVQ8S userlimit: 0 productid: R3_ORA system-nr: INITIAL_SYSTEM_IDX *** license useable ***glsaptrn:trnadm 23%
glsaptrn:trnadm 2%
Login to Client 000
Reconfigure DaTABASE
se06
SE06
No comments:
Post a Comment