Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 760
  • Last Modified:

DELETE archivelog until time '(sysdate -1/10)' backed up 1 times to device type disk;

Can i use the below command in 8i.
0
dba1234
Asked:
dba1234
2 Solutions
 
slightwv (䄆 Netminder) Commented:
I don't know.  Can you?

I suggest you try it on a test system and see.

From the docs I was able to find:
http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67773/toc.htm

I don't see a straight 'delete' command.

From the little I searched for, looks that might be a 9i feature.
0
 
Wasim Akram ShaikCommented:
got this info from one of the forums, seems that you have to do sequence of steps in 8i to do this task...

$ cat /u01/scripts/cleanup_rman_arch_test2.sh
#!/bin/ksh
ORACLE_SID=TEST2; export ORACLE_SID
ORACLE_HOME=/u01/oracle8i/product/8.1.7; export ORACLE_HOME
PATH=$ORACLE_HOME/bin; export PATH
$ORACLE_HOME/bin/rman target username/password@TEST2 catalog rman/rman@rcat log=/u01/logs/cleanup_rman_arch_test2_log @/u01/scripts/cleanup_rman_arch_test2.rcv
exit

$ cat /u01/scripts/cleanup_rman_arch_test2.rcv
allocate channel for delete type disk;
change archivelog until time 'SYSDATE-7' delete;
release channel;

this is copied from here..
http://www.dbasupport.com/forums/archive/index.php/t-32982.html
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now