DROP RESTORE POINT AND DELETING ALL THE ARCHIVE LOGS USING RMAN IN ORACLE AND TURN OFF FLASHBACK AND ARCHIVE LOG MODE
SQL> select name from v$database;
NAME
---------
PMITCKU
SQL> column NAME format a40;
SQL> SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE
FROM V$RESTORE_POINT
WHERE GUARANTEE_FLASHBACK_DATABASE='YES'
ORDER BY TIME; 2 3 4 5
NAME SCN
---------------------------------------- ----------
TIME
---------------------------------------------------------------------------
DATABASE_INCARNATION# GUA STORAGE_SIZE
--------------------- --- ------------
FEB09_2011 2.2071E+10
09-FEB-11 02.08.02.000000000 PM
1 YES 382599168
SQL> SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE='YES' ORDER BY TIME;
NAME
----------------------------------------
FEB09_2011
SQL> DROP RESTORE POINT FEB09_2011;
Restore point dropped.
irutdbapvn1.back.tickets.com@/home/oracle: $ORACLE_HOME/bin/rman
RMAN> connect target /
connected to target database: PMITCKU (DBID=2999848811)
RMAN> delete noprompt archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=132 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 722 A 09-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_09/thread_1_seq_722.12683.742659745
2 1 723 A 09-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_09/thread
3 1 724 A 09-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_09/thread
4 1 725 A 09-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_09/thread
5 1 726 A 09-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_10/thread
6 1 727 A 10-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_10/thread
7 1 728 A 10-FEB-11 +FLASHBACK/pmitcku/archivelog/2011_02_10/thread
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_09/thread_1_seq_722.1
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_09/thread_1_seq_723.1
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_09/thread_1_seq_724.5
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_09/thread_1_seq_725.4
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_10/thread_1_seq_726.6
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_10/thread_1_seq_727.2
deleted archive log
archive log filename=+FLASHBACK/pmitcku/archivelog/2011_02_10/thread_1_seq_728.9
Deleted 7 objects
RMAN> exit
Recovery Manager complete.
SQL> select name from v$database;
NAME
---------
PMITCKU
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 1273900 bytes
Variable Size 251662292 bytes
Database Buffers 1308622848 bytes
Redo Buffers 15499264 bytes
Database mounted.
SQL> alter database flashback off;
Database altered.
SQL> alter database noarchivelog;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> select name from v$database;
NAME
---------
PMITCKU
SQL>
Comments
Post a Comment