How to login on Oracle Cloud Console?

Login Steps for Oracle Cloud Console

• To sign in to Oracle Cloud Console, We need to open up the corresponding region console URL for Free Tier Account, This basically depends upon what region we are currently located to, For this tutorial we would be using Mumbai as the console location and respective location to login to Oracle Cloud.
• https://console.ap-mumbai-1.oraclecloud.com

        

  Provide the Tenancy Name to which you need to login

Provide the Username/Email and Password to login to Oracle Console

    Oracle Cloud Console Home Page

• After Successful login we are good to go ahead with deploying our First Compute Instance and connecting it via putty or any ssh agent. Our Page on How to Deploy Compute Instance has step by step guide with snippets.

    

                                    

How to Move/Rename Datafile in Oracle Database 12C,11G Standby Database

How to move datafile from one mountpoint to another in Standby Database???

Steps to move a datafile in standby database;

MRP Process needs to be shutdown.

alter database managed standby database cancel;

Need to defer log archive destination from primary,Here we had archive destination at location 2.

alter system set log_archive_dest_state_2='DEFER';

Shut Down the Database(Standby)

shut immediate

Change  sql_file_management parameter to manual from Automatic;

alter system set sql_file_management='MANUAL';

Fetch the Datafile details.

select name from v$datafile;

Check for the file which is to be moved from above query output.

Move the datafile manually on OS and rename in the database to new location

For Linux--Use mv command

For Windows-- Copy paste can be done and later file can be deleted.

alter system rename datafile '/old path/name' to '/newpath/name';

Check if the files are renamed or not.

select name from v$datafiles;

Change the sql file management parameter

alter system set sql_file_management='AUTO';

Start MRP

alter database managed standby database disconnect from session;

Open Reset Logs

Below commands can be used to open a database in reset logs mode.

SQL> connect / as sysdba

SQL> shutdown immediate

SQL> startup mount

SQL> recover database until cancel using backup controlfile;

SQL> cancel

SQL> alter database open resetlogs;

FLEX ASM

What is Flex ASM? Why we require Flex ASM?

In Earlier Version of Oracle, Database Instance and ASM Instance reside on same Local Server.
Which mainly had below risks:

• If ASM  Fails,Database Client must Fail.
•  Resources are consumed by Oracle and ASM on same local Server.

With FLEX ASM:

ASM Client that is Database Instance can use network connection to access ASM which is clustered separately. This provide below benefits:

• If ASM Fails,Its Client(Database) can connect to other Instance of ASM.
• Resources are saved because ASM is no required on every Database Server,that is now Database Instance count and ASM Instance count is not equal and can be configured as per requirement.

How to check Oracle Database Backup??

RMAN Backup Status.


col STATUS format a9
col hrs format 999.99
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

How to flush shared Pool and buffer Cache??

Below command has no Harm to production systems,Can be used in case of performance degradation as this can help in refreshing Shared Pool and Buffer Cache and Database will reload both of these with new stats.


alter system flush buffer_cache;


alter system flush shared_pool; 

ASM Disk Location on Linux

Below is the location of disks stored in Linux OS.

/dev/oracleasm/disks

There may be situations where after reboot(OS) ASM is not able to mount disk.
Please look in above location and check for desired permissions and ownership.