1
vote
1answer
217 views

Why we need auxiliary instance in TSPITR

Need help! I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr. We can do complete recovery of tablespace within same ...
0
votes
1answer
5k views

db_recovery_file_dest_size issue

RMAN gives me this error how should i resolve this issue: ORA-19815: WARNING: db_recovery_file_dest_size of 7516192768 bytes is 100.00 used, and has 0 remaining bytes available. Thanks in ...
1
vote
1answer
3k views

Delete Archive log file

I am using oracle database 11g. Some day's back we have deleted our Archivelog Manually, and now it's getting full and due to that we are not able to connect to our database. So how should i delete ...
1
vote
1answer
958 views

How can I change default backup location for oracle11g using RMAN?

I want to change to another drive due to lack of disk space. How can I change the default location of backup files used by oracle to another drive using RMAN? By default it's in the folder ...
2
votes
2answers
658 views

Oracle 11.1.0 Autobackup going to wrong location

I am running Oracle 11.1.0 on Win Server 2008. My autobackups used to go to flash_recovery_area\myDB\autobackup\*yyyy_mm_dd*. Then I added a prefix to the file name in front of %F and they started ...