Showing posts with label Backup & Recovery. Show all posts
Showing posts with label Backup & Recovery. Show all posts

Sunday, May 25, 2014

Change Flash Recovery Area Location

Due to insufficient space on some drives/mount point, you need to change the location of fast/flash recovery area.

Old Location: D:\flash_recovery_area
New Location: E:\flash_recovery_area

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='E:\flash_recovery_area' SCOPE=BOTH SID='*';

After change this parametr, all new archive log will create on the new location and then database going to remove old archive log files once aged out.

In the case that you need to your old files (archive log, backupset, datafile image copy) do the following:


for archivelog transmission:

RMAN> BACKUP AS COPY ARCHIVELOG ALL DELETE INPUT;

 for backupset transmission:

RMAN> BACKUP DEVICE TYPE DISK BACKUPSET ALL DELETE INPUT;

for datafile image copy transmission:


RMAN> BACKUP AS COPY DATAFILECOPY ALL DELETE INPUT;

Tuesday, April 29, 2014

How to Get the DBID when Instance in NOMOUNT State

The Arup Nanda Blog: How to Get the DBID when Instance in in NOMOUNT St...: You lost your controlfile and the catalog. To restore the controlfile, you must know the DBID. Did you follow the advise to write down the D...