-
asmcmd batch scripting
Environment: Windows 2003, Oracle 10gR2 standard, ASM, RMAN
Question: How can we execute asmcmd commands (like rm) in batch. I am trying to write a script that I can schedule on windows to clear old archive logs from asm database.
Any help is appreciated.
-----------------
I am not sure, what value should I set for RMAN's RETENTION POLICY. The plan is to do daily full backup of many 5-10 gb dbs to tape.
This is what I am planning to use for my PROD environment:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '\tape0\_SID__%F';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2000 M;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\oracle\product\10g\admin\TST01\DBA\RMAN\Temp\SNAPCTL.ORA';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE DEFAULT DEVICE TYPE TO sbt;
--rman backup script
Crosscheck backup;
Crosscheck archivelog all;
Backup database plus archivelog;
list backup summary;
Report unrecoverable;
Report obsolete orphan;
spool log off
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
|