Hi experts,

You have been a great source of my technical abilities ever since.

I do have a series of EXECUTION on Commands on various stages.

I just want to know whether I have MISSED or NOT in each step-wise serial execution numbered below. As I work on VERITAS CLUSTERING SOFTWARE.



1. Shutdown Oracle

# sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
SQL> exit
# lsnrctl stop

2. Enquire on problem Partition

# sqlplus /nolog
SQL> connect / as sysdba
SQL> Select Segment_Name, Segment_Type, Extend_Id, Block_Id, Partition_Name from DBA_Extents;
SQL> exit
# lsnrctl stop

3. Take a Before Backup

cd {the location of the datafile/affected partition}
copy *.dbf to /u02/oradata/BeforeBackup/
copy *.ctl to /u02/oradata/BeforeBackup/
copy *.log to /u02/oradata/BeforeBackup/

4. Export the Affected Data into a DMP file

exp userid/password file=special.dmp log= .log table = partitions= "CLOG_2005Q4"

5. Drop the broken Partition

SQL> connect / as sysdba
SQL> alter table Live_Log drop partition "CLOG_2005Q4"
SQL> alter table Proxy_Log drop partition "CLOG_2005Q4"
SQL> exit

6. Reduce the size of the affected datafile

SQL> connect / as sysdba
SQL> alter database datafile '/u02/oradata/CLOG/db02/CLOG_2005Q4.dbf' resize 1000M
SQL> exit

7. Recreate the affected partition

SQL> connect / as sysdba
SQL> alter table Live_Log, Proxy_Log
add partition "CLOG_2005Q4" values less than (to_date('2006-1-1', 'YYYY-MM-DD')) tablespace CLOG_2005Q4
SQL> exit

8. Take an After Backup

cd {the location of the datafile/affected partition}
copy *.dbf to /u02/oradata/AfterBackup/
copy *.ctl to /u02/oradata/AfterBackup/
copy *.log to /u02/oradata/AfterBackup/

9. Restart Oracle

# sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
# lsnrctl stop

Is it necessary to check the Database out of Veritas Clustering Software (VCS) control before doing any of the above?
__________________________________
PVKDBA
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width