Useful shortcuts for vi editor

Showing posts with label rman. Show all posts
Showing posts with label rman. Show all posts

Sunday 19 October 2014

How to connect into RMAN tool in Windows?

Press Windows button + R and press cmd then click "OK".
Write down "rman" and press enter

Lastly run that command to connect environment.

RMAN> connect target /

connected to target database: XE (DBID=2732638794)

Wednesday 15 October 2014

How to set DB ID in RMAN?

RMAN> set dbid=111111;
-- 111111 -> desired dbid

Tuesday 14 October 2014

How to delete archive log files until specific time in RMAN?

RMAN> delete archivelog until time ‘SYSDATE-10’;
i: it will delete them until 10 days ago

Also it has a no prompt option;
RMAN> delete noprompt archivelog until time ‘SYSDATE-10′;